[Skip to main content](#main-content) [OpenNash Jobs](https://jobs.opennash.com/) [Hiring report](/reports/hiring/) · [All Tata Consultancy Services jobs](https://jobs.opennash.com/companies/tata-consultancy-services/) · [Search jobs](/search/) Tata Consultancy Services · Sydney # Migration SQL DBA Sydney Last seen on Tata Consultancy Services’s official careers site on August 1, 2026; it may have closed since. [Apply on Tata Consultancy Services’s careers site →](https://ibegin.tcsapps.com/candidate/jobs/418489J) [OpenNash Jobs](https://jobs.opennash.com/) / [Tata Consultancy Services](https://jobs.opennash.com/companies/tata-consultancy-services/) / Migration SQL DBA ## Job description ### 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.