What will your essential responsibilities include
- Installing and configuring Microsoft SQL Server instances in a stand-alone, clustered and Always On environments along with database replication and mirroring.
- Experience working in Azure SQL DB, Azure SQL DW and other Azure DB Platforms.
- Assisting with SQL Server Assessment / Planning / Migration / Upgrades / Automation / Performance Tuning, etc.
- Plan and Execute the On-Prem Database / Analysis Services / Reporting Services / Integration Services Migration to Azure SQL DB / Azure PostgreSQL / Azure MySQL / SQL Server 2016 / 2019.
- SQL DB Automation for DB Deployments working with PowerShell, ARM Templates, etc. using DB Versioning tools like Azure DevOps SSDT, Liquibase, etc.
- Expertise in database troubleshooting, performance tuning, query tuning of SQL / T-SQL, partitioning, file group implementation and design database Indexes for high performance, as part of the migration / upgrade activities.
- Work self-directedly and in coordination with other application developers to investigate, analyze and resolve issues.
- Work with internal technical resources on project implementations and to resolve business and technical issues.
- Good verbal and written communication skills with the ability to articulate technical issues in simple terms.
- Developing, managing, testing and implementing database back-up, recovery and maintenance plans.
- Performing database capacity management, Handling database incidents and root cause analysis.
- Recovering databases during Disaster Recovery testing and incidents.
- Liaising with Project Managers, Developers, Application Support, Release, infrastructure teams to ensure database integrity, security and performance. You will report to GT SDC Operations Lead.
Required Skills and Abilities :
Relevant years of experience managing Relational Database Management Systems (DBMS) - SQL Server.Relevant years of experience designing, implementing and managing High Availability database solutions.Hands-On experience working in Azure Platform : SQL DB, ADLS, Azure Synapse, Azure Databricks, Azure Data Factory, CosmosDB.Knowledge of CI / CD Pipelines : Harness.Exposure to migrating existing SQL Server (on-premis) data loads to Cloud (Azure).Excellent working knowledge of SQL scripting / programming.Effective working knowledge of IT Operations and support organisations would be an advantage.Ability to work self-directedly with less supervision is required.Knowledge of third party database auditing and performance monitoring solutions.Relevant years of Erwin or similar DM tools is a plus.Relevant years of producing technical documentation.Prior work experience with performance tuning, query plan analysis, and indexing.Experience doing backups & restores using SQL Litespeed / CommVault is a plus.Desired Skills and Abilities :
Comprehensive knowledge of DBMS.Able to organise self and others including effective scheduling, prioritisation and time management skills, completing tasks to tight deadlines. Demonstrates a can do attitude.Proven track record of knowing what it takes to provide a consistently first class customer service internally and / or externally.Ability to build effective working relationships (Internally / Externally), establishing credibility amongst a wide and demanding client group.Comfortable taking ownership for own work, identifying the need for action (using initiative) whilst working effectively within a team.Skills Required
Azure Synapse, Database Administration, Dbms, Sql