NEWPosted 8 hours ago
Job ID: JOB_ID_11203
Position Details:
We are seeking a Senior Oracle DBA with expertise in DB2 and Snowflake to join our team. This role involves performance fine-tuning of large database operations across 20+ applications. The ideal candidate will be a local DBA and an expert in DB2 & Snowflake for our global development teams. Snowflake experience is preferred but not essential.
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, scripting, Power, 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.
Requirements:
- 10+ Years of experience as Senior Database Administrator (Oracle, PostgreSQL, SQL Server(Knowledge), AWS)
- Experience with DB2 and Snowflake is required.
- Experience with performance fine-tuning of large database operations.
- Must be local to NYC or nearby for in-person interviews.
Special Requirements
In Person Interview (New York Need Only Locals or Nearby)
Compensation & Location
Salary: $65 – $75 per hour
Location: New York, NY
Recruiter / Company – Contact Information
Email: gurrammohansairam@gmail.com
Recruiter Notice:
To remove this job posting, please send an email from
gurrammohansairam@gmail.com with the subject:
DELETE_JOB_ID_11203