Database Administrator
Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
The primary purpose of this role is to ensure the reliability availability performance and security of Oracle databases that support a missioncritical 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 ITILaligned 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 handson 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 highpressure productioncritical environment.
- Strong documentation reporting and analytical skills.
- Certifications:
- Oracle Certified Professional (OCP) Database Administration (Preferred)
- ITIL Foundation Certification (Preferred)
Remote Work :
No
Employment Type :
Fulltime
Employment Type
Full-time
