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
