In-Demand Sql server database Jobs

Other jobs to consider

Find your next job by exploring related positions.

Spot Fire Developer
Pyramid Global Technologies —South Australia
Minimum 4 years’ relevant experience on Spotfire and its components. Extensive experience working on Oracle, SQL server, any data warehouse.
Migration SQL DBA
Tata Consultancy Services —Sydney NSW
Experience: 8+ years of IT experience with minimum 5+ years of experience with SQL Server (versions 2012 through to 2022/2026).
11h

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

sql server database jobs near

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