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. 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)