Installing and configuring Microsoft SQL Server instances in stand-alone, clustered, and Always On environments along with database replication and mirroring configuration.
Experience in migrating databases to Azure SQL DB, Azure SQL DW, and Azure SQL Managed Instance.
Assisting with SQL Server Assessment PlanningMigration Upgrades Automation Performance Tuning, etc.
Troubleshooting, planning migration strategy, and DR planning of SSASSSISSSRS.
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 SQLT-SQL, partitioning, and filegroup.
Implementation and design database Indexes for high performance, as part of the migrationupgrade activities.
Work self-directly and in coordination with other application, developers to investigate, analyze and resolve issues.
Work with internal technical resources on project implementations and resolve business and technical issues.
Developing, managing, testing, and implementing database backup, recovery, and maintenance plans.
Performing database capacity management, Handling database incidents, and finding root cause analysis.
Recovering databases during Disaster Recovery testing and incidents.
Liaising with Project Managers, Developers, Application Support, Release, and infrastructure teams to ensure database integrity, security, and performance.
Required Skills and Abilities:
- Experience as SQL Database Administrator.
- Experience designing, implementing, and managing High Availability database solutions.
- Experience working in Azure.
- Experience in producing technical documentation.
- Exposure to migrating existing SQL Server (on-premises) data loads to Cloud (Azure).
- Expert knowledge of SQL scripting programming.
- Prior work experience with performance tuning, query plan analysis, and indexing.
- Knowledge of database auditing and performance monitoring solutions.
- Understanding of Databricks, Azure Synapse, ADLS, CICD Pipelines, and SSIS ETL packages.
- Knowledge of Data Storage: Delta Lake, Parquet, ORC, AVRO.
- Understanding of Azure Network, Security groups, Load balancing, and Storage layers.
- Oustanding working knowledge of IT Operations and support organizations would be an advantage.
- Ability to work self-directly with less supervision is required.
- Experience doing backups & restores using SQL LitespeedCommvault is a plus.
- Knowledge of ITIL processes and tools like Service Now, SILVA, and JIRA.
- Having Microsoft Certification is a plus.
Desired Skills and Abilities:
- Comprehensive knowledge of DBMS.
- Able to organize self and others including effective scheduling, prioritization, and time management skills, completing tasks to tight deadlines. Demonstrates a can do attitude.
- Proven track record of knowing what it takes to provide 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 of own work, identifying the need for action (using initiative) whilst working effectively within a team.
