Database Administrator

What will youressential 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.