Senior Cloud Database Operations Engineer
Abrigo · Raleigh, NC · Yesterday
EngineeringFull-time
What You’ll Do
- Database Administration
- Administer, maintain, and support enterprise databases including:
- Microsoft SQL Server
- MySQL
- PostgreSQL
- MongoDB
- Amazon DynamoDB
- Ensure high availability, performance, scalability, and security across all database platforms
- Perform database provisioning, upgrades, migrations, patching, and lifecycle management
- Develop and maintain database standards, operational procedures, and governance
- AWS Cloud Database Management
- Deploy, and manage AWS database services including:
- Amazon RDS
- Amazon Aurora
- Amazon EC2-hosted SQL Server
- DynamoDB
- DocumentDB
- Configure Multi-AZ deployments and cross-region disaster recovery
- Implement automated backup, restore, and recovery strategies
- Optimize AWS database infrastructure for performance, availability, and cost efficiency
- Support database modernization and migration initiatives to AWS
- High Availability & Disaster Recovery
- Design and maintain:
- SQL Server Always On Availability Groups
- SQL Server Failover Cluster Instances
- SQL Server Replication
- MySQL Replication
- PostgreSQL Streaming Replication
- MongoDB Replica Sets
- Develop disaster recovery plans and regularly perform failover testing
- Maintain Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO)
- Performance Tuning
- Monitor and optimize database performance
- Troubleshoot blocking, deadlocks, memory pressure, CPU bottlenecks, and slow queries
- Optimize indexes, execution plans, and storage utilization
- Perform capacity planning and workload forecasting
- Automation
- Develop automation using PowerShell, Python, Bash and AWS CLI
- Build Infrastructure as Code using:
- Terraform
- AWS CloudFormation
- Support database deployments through CI/CD pipelines
- Monitoring & Observability
- Use Amazon CloudWatch, AWS CloudTrail, Performance Insights, Grafana and Prometheus
- Monitor database health, replication, backup success, and capacity
- Create executive and operational reporting dashboards
- Security & Compliance
- Manage IAM, database authentication, and least-privilege access
What You’ll Need
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent experience
- 10+ years of enterprise database administration and managing production databases in AWS
- Experience supporting 24x7 mission-critical production environments
Required Technical Skills
- Microsoft SQL Server: SQL Server 2019–2022, AlwaysOn Availability Groups, Failover Clustering, Replication, Backup/Restore, T-SQL and Performance tuning.
- MySQL: Amazon RDS MySQL, MySQL Replication, Performance tuning and Parameter optimization
- PostgreSQL: Amazon RDS PostgreSQL, Aurora PostgreSQL, Streaming and Logical Replication
- MongoDB: Replica Sets, Sharding, Backup and recovery, Performance tuning, Document schema optimization
- DynamoDB: Global Tables, Auto Scaling, Performance optimization and Backup and Point-in-Time Recovery (PITR)
- Automation & DevOps: PowerShell, Python, Bash, GitHub Actions, Terraform, CloudFormation and Docker
- Monitoring & Performance Tools: SQL Server Management Studio (SSMS) , Redgate SQL Monitor, SolarWinds DPA, AWS Performance Insights, Amazon CloudWatch