Database Administrator

The primary purpose of this role is to ensure the reliability, availability, performance, and security of Oracle databases that support a mission-critical, nationwide government application. The Oracle DBA will support daily operations and maintenance of Oracle environments utilizing Oracle Enterprise Manager (OEM), Audit Vault & Database Firewall (AVDF), and Oracle Data Guard for high availability and security compliance.

This role requires a highly skilled and consultative professional who can collaborate closely with infrastructure and application teams, engage directly with the customer, and adhere to ITIL-aligned processes. The DBA is also expected to support performance optimization, implement enhancements, respond to operational issues, and participate in a 24x7 standby support model to maintain uninterrupted services for a critical government platform

The DBA will manage Oracle RAC and standalone environments across Production, DR, UAT, and Development systems. The role involves ensuring high availability, disaster recovery readiness, performance tuning, patching, and compliance, while also supporting integration with storage, operating systems, and security platforms.

Key Responsibilities:

Operations and Maintenance Activities:

• Administer Oracle RAC, standalone databases, and Oracle Grid Infrastructure.
• Perform daily health checks, space monitoring, log review, and backup validation.
• Manage Oracle databases across all environments (Production, DR, UAT, Development).
• Administer Oracle Data Guard for high availability and DR (monitor, switchover, failover).
• Monitor databases using Oracle Enterprise Manager (OEM) and configure alerts.
• Configure and manage Oracle AVDF (Audit Vault and Database Firewall).
• Apply quarterly security patches and version upgrades using standardized change processes.
• Perform database cloning, refreshes, object deployments, and schema changes.
• Ensure reliable backup and recovery using RMAN; conduct periodic restore tests.
• Coordinate with OS and storage teams to troubleshoot performance and capacity issues.
• Review and tune SQL queries.

Support and Coordination:

• Work closely with Infra and Application teams to ensure integration, performance, and availability.
• Participate in Change meetings, deployment planning, and DR exercises.
• Investigate and resolve incidents and problems; perform root cause analysis and implement permanent fixes.
• Collaborate with security teams for audits and enforcement of database security controls.
• Engage directly with government customer representatives to capture and deliver evolving requirements.

Consultation and Optimization:

• Analyze application query performance; provide tuning recommendations.
• Propose and implement improvements to database design, indexing, and storage layout.
• Support new architecture or capacity expansion planning in consultation with stakeholders.
• Document all changes, configurations, and recovery plans as per project and audit requirements.

Qualifications

Requirements:

Technical Skills:

• 8 to 10 years of hands-on experience as an Oracle DBA in a 24x7 production environment.
• Strong experience with:
  • Oracle RAC (Real Application Clusters)
  • Oracle Enterprise Manager (OEM)
  • Oracle Data Guard (configuration, monitoring, switchover/failover)
  • Oracle AVDF (Audit Vault and Database Firewall)
  • Oracle RMAN and ASM
  • Performance tuning tools (AWR, ASH, SQL Tuning Advisor, TKPROF)
  • Shell scripting and PL/SQL
• Working knowledge of SAN storage interaction with Oracle ASM and database performance.

Soft Skills:

• Strong consultative and communication skills to interact with technical teams and government stakeholders.
• Ability to work independently in a high-pressure, production-critical environment.
• Strong documentation, reporting, and analytical skills.
• Certifications:
• Oracle Certified Professional (OCP) – Database Administration (Preferred)
• ITIL Foundation Certification (Preferred)