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
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
Aerospace • Artificial Intelligence • Machine Learning • Robotics • Software
Serve as the primary on-site customer-facing lead for Shield AI aircraft in Greece, managing integration, issue triage, cross-functional coordination, sustainment planning, logistics, and long-term customer adoption. Build trusted relationships, track customer health metrics, resolve technical and operational issues, and advocate field needs into product and sustainment priorities to ensure mission readiness and sustained use.
Top Skills:
CRMGroup 3-5 UasHivemindIssue Tracking ToolsLogistics And Sustainment ToolsV-BatX-Bat
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Lead end-to-end recruitment for Experienced Hires across Greece and Central Europe. Partner with hiring managers to define requirements, source and assess candidates, manage candidate experience, build talent pools, and drive continuous improvement with TA leads and coordinators.
Top Skills:
ExcelMS OfficePhenomWorkday
What you need to know about the Vancouver Tech Scene
Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.
