Senior MS SQL Database Administrator
UST Global
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Benefits offered by this job
Job summary
UST Global is seeking a highly experienced Senior MS SQL Database Administrator to lead the migration of our core .NET databases to Google Cloud Platform. You will design migration strategies, implement replication across production and non-production regions, and develop automated scripts to minimize downtime.
You will optimize performance, ensure high availability and disaster recovery, enforce security controls, and collaborate with infra, DevOps, and .NET teams to align cutover timelines.
Qualifications
- 6+ years of experience as a Production MS SQL DBA in enterprise environments (SQL Server 2016+).
- Proven experience migrating MS SQL databases to Google Cloud Platform using DMS, Velostrata/Migrate for Compute Engine, or native methods.
- Deep understanding of SQL Server Replication (Transactional, Merge, Snapshot) and Always On Availability Groups.
- Strong scripting skills in T-SQL and PowerShell (or Python) to automate deployment and migration tasks.
Responsibilities
- Design and execute migration strategies to lift-and-shift/replatform MS SQL Server databases to GCP.
- Set up, configure, and maintain database replication across production and non-production regions.
- Write, test, and maintain SQL, PowerShell, or bash scripts to automate migration, schema deployment, data verification, and rollback procedures.
- Ensure high availability and disaster recovery across regions with Always On, mirroring, or log shipping.
- Collaborate with infrastructure, DevOps, and .NET teams to align migration with the lift-and-shift timeline.
Skills
Tools
Job description
We are seeking a highly experienced Senior MS SQL Database Administrator (DBA) with strong cloud migration expertise to drive the database transition of our core .NET application to Google Cloud Platform (GCP).
In this role, you will be responsible for replicating, migrating, and optimizing our existing MS SQL Server databases into GCP. The ideal candidate will possess deep expertise in database replication, hands-on experience with GCP data services, and the ability to write robust, automated scripts to ensure a seamless migration with minimal downtime.
- Database Migration: Design and execute the migration strategy to lift-and-shift/replatform MS SQL Server databases from on-premises/legacy hosting to GCP (e.g., Google Compute Engine or Cloud SQL for SQL Server).
- Multi-Environment Replication: Set up, configure, and maintain robust database replication from the existing source to the new GCP Production and Non-Production regions.
- Automation & Scripting: Author, test, and maintain all necessary SQL, PowerShell, or bash scripts required to automate the migration, schema deployment, data verification, and roll-back procedures.
- High Availability & DR: Implement and manage SQL Server Always On Availability Groups, mirroring, or log shipping to ensure high availability and disaster recovery across regions.
- Performance Tuning: Optimize database performance pre- and post-migration by analyzing execution plans, indexing, and resource utilization in the GCP environment.
- Security & Compliance: Ensure the new GCP database environments comply with enterprise security standards, implementing proper IAM controls, encryption at rest/in transit, and audit logging.
- Collaborate closely with the infrastructure, DevOps, and .NET application development teams to align database migration with the application lift-and-shift timeline.
- Conduct rigorous cutover testing and validate data integrity between legacy and new GCP environments.
- Provide detailed documentation of the migration scripts, architecture, and operational runbooks.
- MS SQL Server Expertise: 6+ years of experience as a Production MS SQL DBA supporting enterprise-level environments (SQL Server 2016 and above).
- GCP Migration Experience: Proven experience migrating MS SQL databases to Google Cloud Platform, using tools like GCP Database Migration Service (DMS), Velostrata/Migrate for Compute Engine, or native SQL backup/restore methods.
- Advanced Replication: Deep understanding of SQL Server Replication technologies (Transactional, Merge, Snapshot) and Always On Availability Groups across hybrid or multi-region setups.
- Strong Scripting: Exceptional proficiency in T-SQL and PowerShell (or Python) to automate database deployment and migration tasks.
- Infrastructure-as-Code (Bonus): Familiarity with Terraform for provisioning GCP database infrastructure is highly desirable.
- Flexible/hybrid working arrangements.
- Health insurance.
- Novated Car Lease
- Access to UST Perks (Reward Gateway), which offers discounts across major retailers.
Diversity and Inclusion are among the founding blocks of how UST as an organisation translates its values of Humility, Humanity, and Integrity into practice.
For more than 25 years, UST has worked side by side with the world's best companies to make a real impact through digital transformation. Together, with over 30,000 employees in 30+ countries, we build for boundless impact—touching billions of lives in the process.
#LI-BM
We are seeking a highly experienced Senior MS SQL Database Administrator (DBA) with strong cloud migration expertise to drive the database transition of our core .NET application to Google Cloud Platform (GCP).
In this role, you will be responsible for replicating, migrating, and optimizing our existing MS SQL Server databases into GCP. The ideal candidate will possess deep expertise in database replication, hands-on experience with GCP data services, and the ability to write robust, automated scripts to ensure a seamless migration with minimal downtime.
- Database Migration: Design and execute the migration strategy to lift-and-shift/replatform MS SQL Server databases from on-premises/legacy hosting to GCP (e.g., Google Compute Engine or Cloud SQL for SQL Server).
- Multi-Environment Replication: Set up, configure, and maintain robust database replication from the existing source to the new GCP Production and Non-Production regions.
- Automation & Scripting: Author, test, and maintain all necessary SQL, PowerShell, or bash scripts required to automate the migration, schema deployment, data verification, and roll-back procedures.
- High Availability & DR: Implement and manage SQL Server Always On Availability Groups, mirroring, or log shipping to ensure high availability and disaster recovery across regions.
- Performance Tuning: Optimize database performance pre- and post-migration by analyzing execution plans, indexing, and resource utilization in the GCP environment.
- Security & Compliance: Ensure the new GCP database environments comply with enterprise security standards, implementing proper IAM controls, encryption at rest/in transit, and audit logging.
- Collaborate closely with the infrastructure, DevOps, and .NET application development teams to align database migration with the application lift-and-shift timeline.
- Conduct rigorous cutover testing and validate data integrity between legacy and new GCP environments.
- Provide detailed documentation of the migration scripts, architecture, and operational runbooks.
- MS SQL Server Expertise: 6+ years of experience as a Production MS SQL DBA supporting enterprise-level environments (SQL Server 2016 and above).
- GCP Migration Experience: Proven experience migrating MS SQL databases to Google Cloud Platform, using tools like GCP Database Migration Service (DMS), Velostrata/Migrate for Compute Engine, or native SQL backup/restore methods.
- Advanced Replication: Deep understanding of SQL Server Replication technologies (Transactional, Merge, Snapshot) and Always On Availability Groups across hybrid or multi-region setups.
- Strong Scripting: Exceptional proficiency in T-SQL and PowerShell (or Python) to automate database deployment and migration tasks.
- Infrastructure-as-Code (Bonus): Familiarity with Terraform for provisioning GCP database infrastructure is highly desirable.
- Flexible/hybrid working arrangements.
- Health insurance.
- Novated Car Lease
- Access to UST Perks (Reward Gateway), which offers discounts across major retailers.
Diversity and Inclusion are among the founding blocks of how UST as an organisation translates its values of Humility, Humanity, and Integrity into practice.
For more than 25 years, UST has worked side by side with the world's best companies to make a real impact through digital transformation. Together, with over 30,000 employees in 30+ countries, we build for boundless impact—touching billions of lives in the process.
#LI-BM
AWS IAM, Application Migration, Cloud SQL, Data Validation
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
