Senior DBA

Introduction:

The Senior DBA will be responsible for overseeing end-to-end administration of Oracle, PostgreSQL, and SQL Server database environments, ensuring high availability, security, and optimal performance. They will also be responsible for performance tuning, capacity planning, and automation using AWS services.

Responsibilities:

• Perform installation, configuration, patching, upgrades, and migration of database systems across on-prem and cloud environments.
• Design and implement backup and recovery strategies utilizing RMAN, pgBackRest, native SQL Server backup tools, and AWS Backup.
• Conduct proactive monitoring, capacity planning, and performance tuning using various monitoring tools.
• Diagnose and resolve complex database performance issues involving SQL tuning, indexing strategies, execution plans, and storage optimization.
• Manage and support AWS RDS instances, including provisioning, scaling, monitoring, and security.
• 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.
• Architect and maintain HA/DR solutions such as Data Guard, Oracle RAC, Always On Availability Groups, PostgreSQL replication, and AWS multi AZ replication.
• Automate repetitive DBA tasks using Python, Shell scripting, PowerShell, or PL/SQL.
• Provide advanced troubleshooting for production incidents with strong root cause analysis.
• Support 24x7 on-call rotation for critical systems.
• Collaborate with application teams to support database related development, deployments, and performance improvements.
• 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:

Required Skills: DB2, Snowflake Schema, Snowflake, Oracle, Oracle RAC, Oracle Data Guard, PL/SQL, Shell Scripting, Scripting, Terraform, Microsoft SQL Server, IBM DB2, Data Migration, Amazon Web Services, Amazon RDS, Capacity Management

Preferred Skills: PostgreSQL, AWS Aurora, Python