Senior DataBase Administrator (#5463)

Що робити

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

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.

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).

Знайдено через trackr.help/jobs · Канал: @trackrhelp · Бот для персональних сповіщень: @trackrhelpBot