...

Database administration, engineering and analytics

Scrambled Letters?

  • All aspects of database development and administration, specializing in Oracle.
    Administration
    Installation, configuration, upgrade and support high performance Oracle environments: Data Guard, RAC, GoldenGate, Streams, Partitioning.
    Automation
    Programming and Scripting (C, Shell, Perl, Python, PL/SQL) to automate processes and esential activities. Includes APEX and OEM development and customization to centralize metadata repositories.
    Backup/Restore
    Design, test, implement and administer complex backup strategies and storage integration to meet RPO and RTO objectives and simplify restoration procedures.
    Disaster Recovery
    Design, test, implement and administer DR infrastructures to provide resiliancy and mitigate risk of data loss.
    Replication
    Design, test, implement and administer (GoldenGate, Data Guard, Streams) to provide all aspects of data durability, extration and migration.
    Performance Analysis
    Monitor, identify and diagnose performance bottlenecks and implement solutions and strategies to improve database performance and accessibility.
    Development
    Application and backend database development using 3rd party and internal database tools (C/C++, Java, shell, Perl, Python, PL/SQL, APEX).
    Administration of additional databases and environments
    MySQL, PostgreSQL and the respective cloud versions; Informix, SQLserver; AWS, Docker, Kubernetes, OVS.
  • Custom Data Transformation
    External environments
    Design, test, implement and administer data pipelines to feed heterogenius environments for use with third-party and cloud tools for analytics, storage and visualization.
  • Data Transition
    Documentation
    Research procedures used by existing support teams, verify against existing documentation.
    Create and/or correct documentation as needed.
    Implementation
    Perform data transitions using proven methods.
    Provide administration of newly transitioned environments.