Database Management- Oracle SME at GVA Partners

Job description

• Install, configure, and administer Oracle, MongoDB, MySQL, and Cassandra environments across dev/test/prod.
• Support solution implementation activities including database provisioning, schema setup, user creation, and role-based access control.
• Design and maintain backup and recovery strategies (full/incremental, snapshots, PITR), and execute recovery tests to meet RPO/RTO targets.
• Implement and manage high availability and disaster recovery configurations (e.g., clustering/replication, standby/replica sets, multi-node Cassandra).
• Perform database performance tuning: query optimization, indexing strategies, memory/IO tuning, and capacity planning.
• Monitor databases using enterprise or native tools; define and tune alerts, thresholds, and health checks.
• Manage patching and upgrades for database engines and supporting components with minimal downtime.
• Execute data migration and transformation tasks (export/import, replication-based migration, cutover planning and rollback).
• Enforce security controls: encryption (at rest/in transit), key management integration, auditing, least privilege access, and credential rotation.
• Create and maintain database standards and documentation: runbooks, build guides, operational procedures, architecture diagrams.
• Collaborate with application teams to ensure best practices for connection management, pooling, transaction handling, and resilience.
• Support integration with CI/CD pipelines for database changes (e.g., version-controlled schema changes, controlled deployments).
• Troubleshoot complex incidents including corruption, replication lag, locking/contention, disk/IO bottlenecks, and configuration drift.
• Participate in implementation workshops, readiness reviews, cutover execution, and hypercare/stabilization support.
• Ensure compliance with enterprise requirements for logging, retention, auditing, and change management.
• Provide knowledge transfer to operations/support teams and contribute to post-implementation lessons learned.

Requirements

• Minimum of 5+ years post-NYSC professional experience
• Experience working on MSAP DB & VAS programs
• Hands-on experience providing DBA support for MSAP database migration
• Strong experience with database optimization programs
• In-depth knowledge of database performance tuning and optimization
• Experience supporting efforts to consolidate and stabilize test restore environments