Lead and execute a near-zero-downtime migration of active OLTP SQL Server databases to Amazon RDS for SQL Server. Provision and configure RDS, validate feature compatibility, define and rehearse cutover/rollback runbooks, diagnose and fix DB-layer issues during parallel runs, and establish monitoring, alerting, and backup/recovery. Collaborate with backend, DevOps, client DBAs, and QA to ensure HA/DR, performance baselining, and operational readiness.
Project: HR SaaS for the public sector. We are looking for a Senior Database Engineer to execute a production database migration from on-premises Microsoft SQL Server to Amazon RDS for a large HR/Learning SaaS platform serving public-sector and government agencies. You will own the migration mechanism end-to-end: moving multiple active OLTP databases with a near-zero-downtime cutover and a verified rollback path. This is a hands-on delivery role embedded in a cross-functional team (Backend, DevOps, and the client's existing DBA and QA teams). Beyond the migration itself, you will diagnose and resolve database-layer issues that surface during parallel run and cutover (latency, connection routing, read-only replica behavior). The platform's longer-term direction includes introducing PostgreSQL alongside SQL Server, so experience with a polyglot estate is a strong plus.
Key Responsibilities:
- Execute the migration of the OLTP database from on-prem SQL Server to Amazon RDS for SQL Server (Multi-AZ) for dependent products.
- Provision and configure RDS instances (Enterprise Edition for AG support), parameter groups, option groups, backups, and Multi-AZ HA across all environments.
- Validate RDS feature compatibility: Change Tracking (required for downstream ETL) and CLR SAFE assemblies; prepare and cost the fallback path
- Diagnose and fix database-layer issues during parallel run and cutover: Transit Gateway / cross-network latency, connection-string and read-only routing, command timeouts, and accidental writes to read replicas.
- Define and rehearse cutover and rollback runbooks (failover/failback timings, RPO/RTO targets, validation steps); support QA parity testing and performance baselining
- Establish monitoring, alerting, and backup/recovery (CloudWatch, Performance Insights, point-in-time recovery) for the migrated databases.
Tools and skills you will use in this role:
- Microsoft SQL Server (T-SQL, Always-On Availability Groups, Change Tracking, CLR)
- Amazon RDS for SQL Server (Multi-AZ), AWS DMS
- AWS (VPC/Transit Gateway, S3, CloudWatch, Performance Insights, IAM)
- Nice to have: Infrastructure-as-Code (AWS CDK)
- Nice to have: PostgreSQL / Amazon RDS / Aurora PostgreSQL
Requirements:
- 5+ years as a DBA / Database Engineer in production environments.
- Deep Microsoft SQL Server administration expertise: Always-On Availability Groups, replication, backup/restore, log shipping, Change Tracking, performance tuning, and T-SQL.
- Proven experience migrating SQL Server workloads to AWS, ideally Amazon RDS for SQL Server, including AG-based and/or DMS-based approaches.
- Strong understanding of HA/DR, RPO/RTO, cutover, and rollback planning for active production systems.
- Hands-on AWS experience: RDS, networking (VPC, Transit Gateway), S3, monitoring, IAM.
- Ability to troubleshoot database connectivity, latency, and routing issues in hybrid (on-prem + cloud) topologies.
- Experience working alongside a client-side DBA team and coordinating phased, multi-environment rollouts.
- English: Upper-Intermediate or higher.
Nice to have:
- PostgreSQL administration and SQL Server-to-PostgreSQL migration experience (schema, stored procedures, data-type mapping, dual-write/cutover).
- Familiarity with EF Core / Npgsql and .NET application data layers.
- Experience with AWS DMS for heterogeneous migrations.
- Infrastructure-as-Code with AWS CDK; CI/CD-driven database migrations.
- Exposure to regulated/compliance environments (e.g. FedRAMP).
We offer*:
- Flexible working format - remote, office-based or flexible
- A competitive salary and good compensation package
- Personalized career growth
- Professional development tools (mentorship program, tech talks and trainings, centers of excellence, and more)
- Active tech communities with regular knowledge sharing
- Education reimbursement
- Memorable anniversary presents
- Corporate events and team buildings
- Other location-specific benefits
*not applicable for freelancers
Similar Jobs
Fintech • Financial Services
Lead enterprise database administration across on-prem and cloud environments. Architect HA/DR and zero-downtime migrations, optimize performance, implement automation, ensure security/compliance, mentor DB team, coordinate tasks, and support business-critical projects.
Top Skills:
Aws RdsAzureLinuxMongoDBMssqlMySQLOracleOracle CloudPostgresRedshiftShellSQLWindows
Payments
Own and architect the data layer for payment and AI-agent platforms: administer and optimize PostgreSQL databases, design backup/recovery and DR strategies, automate provisioning with Terraform, execute data migrations, build monitoring and alerts, mentor engineers, and drive performance, scalability, security, and high availability for production systems on AWS.
Top Skills:
AWSCdcEc2IamPostgresPythonRdsS3TerraformVpc
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Lead clinical site monitoring to ensure patient safety and regulatory compliance. Mentor CRAs, perform SCP duties for small projects, drive process improvements, support inspections and audits, manage site performance including investigational product oversight, safety monitoring, and data query resolution, and collaborate with study teams and clinicians globally.
What you need to know about the Calgary Tech Scene
Employees can spend up to one-third of their life at work, so choosing the right company is crucial, not just for the job itself but for the company culture as well. While startups often offer dynamic culture and growth opportunities, large corporations provide benefits like career development and networking, especially appealing to recent graduates. Fortunately, Calgary stands out as a hub for both, recognized as one of Startup Genome's Top 100 Emerging Ecosystems, while also playing host to a number of multinational enterprises. In Calgary, job seekers can find a wide range of opportunities.
