Database Managemaent - Oracle SME

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