Offer summary

Qualifications:

At least 5 years of SQL Server administration and migration experience., Strong knowledge of SQL Server Always On Availability Groups and clustering., Proficiency with configuration management tools like Chef, Ansible, or Puppet., Experience with AWS EC2, EBS, RDS, and scripting languages such as PowerShell, Python, or Bash..

Key responsibilities:

Plan and execute migration of SQL Server databases to AWS EC2 instances.

Develop automation scripts and infrastructure configurations for SQL Server environments.

Coordinate migration activities with application teams and stakeholders.

Implement monitoring, backup, and disaster recovery solutions for migrated databases.

Job description

About us:

Working at Tech Holding isn't just a job, it's an opportunity to be a part of something bigger. We are a full-service consulting firm that was founded on the premise of delivering predictable outcomes and high-quality solutions to our clients. Our founders and team members have industry experience and have held senior positions in a wide variety of companies – from emerging startups to large Fortune 50 firms – and we have taken our combined experiences and developed a unique approach that is supported by the principles of deep expertise, integrity, transparency, and dependability.

About the Role:

Lead a complex RDS to EC2 migration initiative involving 44 SQL Server instances and 145 databases. This role combines database administration expertise with modern DevOps practices and cloud automation.

Key Responsibilities:

Database Migration Planning & Execution

Conduct a comprehensive discovery and assessment of existing RDS SQL Server instances
Design migration strategies using native backup/restore, Always On AG seeding, and log shipping
Plan and execute test migrations for critical databases with minimal downtime requirements
Coordinate complex cutover procedures with application teams and stakeholders

Infrastructure Automation & Configuration

Develop Chef cookbooks for automated EC2 SQL Server provisioning and configuration
Configure Always On Availability Groups and SQL Server clustering for high availability
Implement domain-joined, Kerberos-enabled SQL Server builds with NTLM disabled
Design and implement EBS volume configurations aligned with performance requirements

Monitoring & Data Protection Integration

Integrate New Relic monitoring and alerting for EC2-based SQL Server environments
Configure Commvault backup and disaster recovery for migrated SQL workloads
Implement comprehensive monitoring for SQL Agent jobs, linked servers, and server-level objects
Establish backup/restore policies and validate DR processes for AG and standalone deployments

DevOps Integration & CI/CD

Integrate infrastructure provisioning into migration workflows
Develop automated deployment pipelines for SQL Server infrastructure
Create comprehensive validation and testing frameworks for database migrations
Implement infrastructure drift detection and remediation processes

Required Skills & Experience:

5+ years of SQL Server administration and migration experience
Strong experience with SQL Server Always On Availability Groups and clustering
Proficiency with configuration management tools (Chef preferred, Ansible/Puppet acceptable)
Experience with AWS EC2, EBS, and RDS services
Strong scripting skills (PowerShell, Python, Bash)
Experience with database migration methodologies and tools
Knowledge of enterprise backup and recovery solutions (Commvault preferred)
Understanding of Active Directory integration and Kerberos authentication

Preferred Qualifications:

AWS Database Specialty or Solutions Architect certifications
Microsoft Certified: Azure Database Administrator or SQL Server certifications
Experience with Infrastructure as Code (OpenTofu/Terraform)
Knowledge of monitoring tools (New Relic, CloudWatch, SQL Server monitoring)
Experience with CI/CD pipelines and automated database deployments
Background in enterprise data protection and disaster recovery planning
Understanding of database performance tuning and optimization

Location:

Remote, Mexico

Tech Holding is proud to be an Equal Opportunity Employer and is committed to fostering a diverse and inclusive workplace. We welcome applicants from all backgrounds and experiences, and we consider qualified applicants without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, disability, veteran status, or any other legally protected characteristic. If you require accommodation in the application process, please contact our HR

Required profile