Key Responsibilities:
- MSSQL Install, configure, maintain, and upgrade SQL Server (2016/2019/2022) instances in cloud/on-prem environments.
- Configure Always On Availability Groups, Log Shipping, Replication, and other HA/DR solutions.
- Conduct performance tuning, query optimization, and implement indexing strategies.
- Automate administrative tasks using T-SQL and PowerShell.
- Migrate databases to AWS RDS and EC2 using best practices.
- Implement and manage security, including access control, encryption, and auditing.
Oracle 19c
- Install, configure, and administer Oracle 19c databases (on-prem and AWS-hosted).
- Set up and manage Oracle Data Guard, RMAN backups, and tuning/diagnostics.
- Perform routine health checks, patching, schema changes, and space management.
AWS RDS (SQL Server & Oracle 19c)
- Manage provisioning, configuration, and maintenance of RDS SQL Server and Oracle 19c instances.
- Monitor RDS performance, configure backup retention, parameter groups, and apply patches.
- Handle snapshots, restore operations, and troubleshoot RDS-related issues.
Infrastructure tools such as:
WSFC, ASM, AWS Backup, AWS Snapshot, CV, S3 bucket, CloudWatch, Performance Insights
Required Skills and Experience:
- 5+ years of DBA experience with strong focus on Microsoft SQL Server.
- 2+ years of hands-on experience managing Oracle 19c databases.
- Experience with AWS RDS (SQL Server and Oracle), CloudWatch, and performance tuning in cloud environments.
- Strong scripting skills in T-SQL, PL/SQL, and PowerShell.
- Deep understanding of HA/DR, backup/restore strategies, and cloud migration approaches.
- Experience with monitoring, alerting, and automation tools.
Preferred Certifications:
- Microsoft Certified: SQL Server DBA or Azure Administrator Associate
- AWS Certified Database - Specialty
- Oracle Database 19c Administrator Certified Professional
Soft Skills:
- Excellent communication, problem-solving, and documentation skills
- Ability to work independently and collaboratively in a remote or hybrid environment
- Flexible to support critical issues and on-call rotations if required
Good to Have:
- Working knowledge of MySQL and PostgreSQL in cloud environments (especially AWS RDS)
- Exposure to DevOps tools, Terraform, CloudFormation, or CI/CD pipelines
- Experience with multi-region/multi-AZ deployments and cost optimization in AWS
