Migration SQL DBA

Job Description:

Experience: 8+ years of IT experience with minimum 5+ years of experience with SQL Server (versions 2012 through to 2022/2026).

Tools: Proficiency in SQL Server Migration Assistant (SSMA), SQL Server Profiler and SQL Server Management Studio SSMS.

Certifications: Preferred certifications include Microsoft Certified: SQL Server Database Administrator.

Troubleshooting: Secondary-level problem-solving for resolving connectivity, permission, or performance issues during and after migration.

Key Responsibilities:

Migration Planning & Assessment: Conduct comprehensive analysis of source environments to determine object compatibility and migration readiness specifically Logins, Jobs, Services (SSRS/SSAS/SSIS), Cluster Objects, Listeners, DB Objects (SPs, Triggers, Tables, Views etc) as well as DB Mails & Linked Servers.

External Integrations, Upstream/Downstream Flows: Analyse logs to find out integrations outside of the SQL Server DB/Instance specifically listing the Upstream & Downstream Data Flows from the SQL DB

Encryption / Certificates: Review encryptions & certificates to ensure seamless DB migrations during cutover.

Execution & Cutover: Perform data transfers using appropriate methodologies to minimize downtime during final cutovers.

Post-Migration Validation: Perform Data Validation checks & reports (DB Objects & Tables) Execute smoke tests, verify data integrity, and run performance baselines to ensure the target environment meets or exceeds original performance metrics.

Performance Tuning: Analyse execution plans and optimize queries, indexes, and server configurations (e.g., MaxDOP, Cost Threshold for Parallelism) along with SQL Cluster configurations following migration to ensure stability.

Environment Standardisation: Implement high availability (HA) and disaster recovery (DR) solutions like Always On Availability Groups in the new environment.

Location

Sydney

Job Function

TECHNOLOGY

Role

Engineer

Job Id

418489

Desired Skills

MS SQL Server