SQL DBA Admin

Zensar is a technology consulting and services company with 11, 500+ associates in 30+ global locations. More than 145 leading enterprises depend on our expertise to be more disruptive, agile, and competitive. We focus on conceptualizing, designing, engineering, marketing, and managing digital products and experiences for high-growth companies looking to disrupt through innovation and velocity.

Core Skills and Experience

10 + years of experience managing the SQL technologies below.
Server database engine:
installation and configuration
SQL 2016 to SQL 2022 preferable
Security best practice and administration
Database schema deployment and migration
Database maintenance, housekeeping and backups
Instance health-checks, troubleshooting and recovery
Performance, query plans and index tuning
SQL Server Agent
SQL Server replication
SQL Server Integration Services
SQL Server Analysis Services (hosting only)
SQL Server Reporting Services and Power BI (hosting only)
SQL Server Master Data Services (hosting only)
Transact-SQL

Desirable Skills
Azure platform: storage, networking, private endpoints and security
SQL on Azure VM
PowerShell
Ola Hallengren SQL housekeeping
Redgate SQL Backup
Redgate SQL Monitor
Sentry One monitoring
Azure Synapse – Synapse Studio, SQL dedicated pool and storage
Azure Devops deployment pipelines
solve, and correct issues in real time
suggestions for solutions
and automate regular processes, track issues, and document changes
developers with query tuning and schema refinement
24x7 support for critical production systems
scheduled maintenance and support release deployment activities after hours
of ownership and pride in your performance and its impact on company’s success
thinker and problem-solving skills
time-management skills
interpersonal and communication skills & Team player