Overview:
We are seeking an experienced Senior Database Administrator with strong expertise in Oracle (including RAC, Data Guard, ASM, and GoldenGate) and Microsoft SQL Server. The ideal candidate will manage enterprise-scale databases, ensure high availability and security, optimize performance, and support mission-critical production systems with 24×7 readiness. Experience with AWS RDS is a plus.
Responsibilities:
Oracle Database Administration
- Install, configure, and upgrade Oracle Database and Grid Infrastructure software.
- Apply quarterly PSU/RU patches for Grid and Oracle Homes, ensuring minimal downtime.
- Configure, maintain, and monitor standby databases using Data Guard (physical/logical).
- Implement and tune RAC (Real Application Clusters) and administer RAC environments.
- Manage ASM and storage capacity planning; maintain tablespaces under threshold to prevent incidents.
- Monitor database performance, conduct AWR/ASH analysis, and implement optimization strategies.
- Ensure database security and compliance (RBAC, auditing, encryption, CIS/organizational standards).
- Perform regular backups and recovery (RMAN) and validate restore procedures.
- Set up Oracle GoldenGate (uni-directional and bi-directional), maintain synchronization with source/targets, troubleshoot lag/conflicts, and implement best practices.
- Collaborate with developers on schema design, indexing, partitioning, and query tuning.
- Troubleshoot and resolve database incidents promptly with solid root-cause analysis (RCA).
- Develop and maintain runbooks, SOPs, and standards, and contribute to automation.
- Plan and execute database migrations and upgrades (in-place and cross-platform).
Microsoft SQL Server Administration
- Install, configure, and manage SQL Server instances across environments (DEV/QA/PROD).
- Monitor system health and performance (wait stats, blocking, I/O, memory, CPU), and tune queries and indexes.
- Ensure high availability, performance, sustainability, and security (e.g., Always On AGs, clustering, backups, TDE).
- Analyze and resolve production issues in real time; provide actionable solutions and preventive measures.
- Refine and automate regular processes (backups, index maintenance, integrity checks), track issues, and document changes.
- Assist developers with query optimization and schema refinement
- Provide 24×7 support for critical production systems; perform scheduled maintenance and support release deployments after hours.
- Respond to alerts and incidents promptly; collaborate with L1/L2 and cross-functional teams for escalations.
Requirements:
Must-Have Skills
- Oracle DBA: Installation, patching (RU/PSU), RAC, ASM, Data Guard, RMAN, performance tuning (AWR/ASH/ADDM).
- Oracle GoldenGate: Setup (uni/bidirectional), monitoring, troubleshooting conflicts/lag, and best practices.
- SQL Server DBA: Installation, configuration, HA/DR (Always On/Clustering), backups/restores, performance tuning (wait stats, indexing), security.
- Strong backup & recovery expertise across Oracle and SQL Server.
- Solid understanding of database security, auditing, encryption (TDE), and compliance.
- Proficiency with Linux/Unix (for Oracle) and Windows (for SQL Server).
- Scripting for automation: Shell/PowerShell (Python is a plus).
- Experience with monitoring tools (OEM/Cloud Control, GoldenGate Monitor, SQL Sentry, SolarWinds, Dynatrace, Prometheus/Grafana, etc.).
- Excellent incident management, RCA, and documentation skills.
- Willingness to participate in on-call/24×7 support rotations.
Nice-to-Have
- AWS RDS hands-on (PostgreSQL/Oracle/SQL Server) and cloud operations.
- Experience with Exadata, PDB/CDB (Multitenant), and Data Pump.
- Knowledge of Kubernetes operators for databases (optional).
- Exposure to DevOps/CI-CD for database changes (Liquibase/Flyway).
- Observability integrations (CloudWatch, ELK, OpenTelemetry).
- Disaster Recovery drills and BCP planning experience.
Education & Certification
- Bachelor’s degree in Computer Science/Information Technology or equivalent experience.
- Preferred certifications: Oracle OCP/OCE, OCI, Microsoft Certified: Azure/SQL Server, AWS Associate/Professional.
Core Competencies
- Strong analytical and performance tuning mindset.
- Ownership and urgency in production support.
- Clear communication with technical and non-technical stakeholders.
- Collaboration across developers, infrastructure, and support teams.
- Process rigor with attention to security, compliance, and documentation.