Job ID: JOB_ID_9365
Job Summary:
We are seeking a highly experienced Senior Oracle DBA to oversee end-to-end administration of Oracle, PostgreSQL, and SQL Server database environments. The primary goal is to ensure high availability, robust security, and optimal performance across all database systems, including on-premises and cloud environments. This role requires expertise in installation, configuration, patching, upgrades, and migration of database systems. You will be responsible for designing and implementing comprehensive backup and recovery strategies, conducting proactive monitoring, capacity planning, and performance tuning using advanced tools and techniques.
Key Responsibilities:
- Oversee end-to-end administration of Oracle, PostgreSQL, and SQL Server database environments, ensuring high availability, security, and optimal performance.
- Perform installation, configuration, patching, upgrades, and migration of database systems across on-prem and cloud environments.
- Design and implement backup and recovery strategies, leveraging RMAN, pgBackRest, native SQL Server backup tools, and AWS Backup.
- Conduct proactive monitoring, capacity planning, and performance tuning using AWR, OEM, pg_stat views, DMVs, and cloud-native monitoring tools.
- Diagnose and resolve complex database performance issues involving SQL tuning, indexing strategies, execution plans, database parameters, and storage optimization.
- Optimize large-scale OLTP and OLAP workloads for reliability and efficiency across multi-database platforms.
- Manage and support AWS RDS (Oracle, PostgreSQL, SQL Server) instances, including provisioning, scaling, monitoring, and security.
- Deploy and maintain AWS Aurora PostgreSQL/SQL Server where applicable.
- Implement automation using AWS services such as CloudWatch, Lambda, Systems Manager, IAM, KMS, and CloudFormation/Terraform.
- Support cloud migrations including schema conversion, data migration, and cutover planning.
- Implement and enforce database security standards including user management, roles, auditing, encryption, and patching.
- Maintain compliance with corporate and industry standards (e.g., access controls, data retention policies).
- Conduct regular vulnerability assessments and remediation.
- Architect and maintain HA/DR solutions such as Data Guard, Oracle RAC, Always On Availability Groups, PostgreSQL replication, and AWS multi-AZ replication.
- Develop and regularly test DR playbooks and failover procedures.
- Automate repetitive DBA tasks using Python, Shell scripting, PowerShell, or PL/SQL.
- Develop and maintain database maintenance scripts and automated alerts.
- Provide advanced troubleshooting for production incidents with strong root cause analysis.
- Support 24×7 on-call rotation for critical systems.
- Collaborate with application teams to support database-related development, deployments, and performance improvements.
- Partner with engineering, DevOps, and application teams on designing scalable, cloud-ready data solutions.
- Lead database modernization initiatives, cloud migrations, and cross-platform upgrades.
- Provide technical guidance and mentorship to junior DBAs and engineers.
- Maintain accurate and up-to-date documentation for database configurations, standards, and operational procedures.
- Advocate for continuous improvement in database architecture, automation, and operational workflows.
Experience Required:
- 8+ Years of experience as Senior Database Administrator (Oracle, PostgreSQL, SQL Server (Knowledge), AWS) Database Administration & Management
- DB2 and Snowflake experience is a plus.
- Experience with performance fine-tuning of large database operations.
- Expertise in Oracle, PostgreSQL, and SQL Server database administration.
- Proficiency in cloud environments, particularly AWS (RDS, Aurora, CloudWatch, Lambda, etc.).
- Strong understanding of database security principles and implementation.
- Experience with High Availability (HA) and Disaster Recovery (DR) solutions.
- Skilled in scripting languages (Python, Shell, PowerShell) for automation.
- Excellent troubleshooting and root cause analysis skills.
Special Requirements
In-person interview is a must. Need Locals. Experience with DB2 and Snowflake is preferred. Support 24×7 on-call rotation.
Compensation & Location
Salary: $145,600 – $187,200 per year (Estimated)
Location: NYC, NY
Recruiter / Company – Contact Information
Email: air@aptivacorp.com
Recruiter Notice:
To remove this job posting, please send an email from
air@aptivacorp.com with the subject:
DELETE_JOB_ID_9365