You own the administration, architecture, and operational integrity of Oracle and SQL Server databases.
Responsibilities
- Design, build, and maintain database architecture for Oracle and SQL Server on-premises and in the cloud.
- Execute database upgrades, quarterly patching, and migrations across platforms using zero/minimal downtime strategies.
- Perform advanced performance tuning, troubleshooting IO/CPU bottlenecks, and optimizing resource utilization using tools like AWR/ASH.
- Manage database governance, security, and compliance, including defining indexing strategies and plan baselines.
- Serve as the primary technical contact for application teams, managing L1/L2 escalations and maintaining SOPs.
Required Skills
- 10+ years of experience administering Oracle and SQL Server RDBMS.
- Expertise in deploying and managing Oracle on AWS (RDS, EC2) and Azure (IaaS/VMs).
- Proficiency in Shell Scripting for database automation and operations.
- Deep knowledge of backup, recovery, and high availability configurations for both Oracle and SQL Server.
- Experience integrating monitoring with AWS CloudWatch and Azure Monitor.
- Ability to manage cloud storage (EB S, Azure Disks) and network security (NACL, SGs).
- Skills in capacity planning, including forecasting CPU, memory, and IOPs.
- Experience with database migration strategies (e.g., Data Guard switchover or GoldenGate).
- Familiarity with core DBA concepts: Indexing, Wait Events, and Query Plan analysis.