Note: The job is a remote job and is open to candidates in USA. Abrigo is a company that provides market-leading compliance, credit risk, and lending software solutions for financial institutions. They are seeking a highly skilled Senior Cloud Database Engineer to administer, automate, and optimize enterprise database platforms primarily hosted in Amazon Web Services (AWS). The role involves ensuring the availability, security, performance, and operational excellence of both relational and NoSQL databases supporting mission-critical business applications.
Responsibilities
- Administer, maintain, and support enterprise databases including:
- 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
- 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
- Design and maintain:
- Develop disaster recovery plans and regularly perform failover testing
- Maintain Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO)
- 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
- Develop automation using PowerShell, Python, Bash and AWS CLI
- Build Infrastructure as Code using: Terraform and AWS CloudFormation
- Support database deployments through CI/CD pipelines
- Use Amazon CloudWatch, AWS CloudTrail, Performance Insights, Grafana and Prometheus
- Monitor database health, replication, backup success, and capacity
- Create executive and operational reporting dashboards
- Manage IAM, database authentication, and least-privilege access
Skills
- 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
- 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
Benefits
- Full health benefits with an HSA option
- Flexible PTO and bank holidays
- 401(k) plan and company match
- Market competitive total rewards package
- The opportunity to Make Big Things Happen
- To be part of the Heart & SOUL of a winning company with an inspiring mission
Company Overview
Company H1B Sponsorship