- SQL Server database administrator, with 3+ years on SQL Server 2005, 2008 and 2008 R2, 2012, 2014, 2016, 2017, 2019 and 2022.
- Experience in supporting SQL Server IaaS and PaaS, AWS and Azure Clouds.
- Experience in administrating other database services like SSAS, SSIS and SSRS.
- Experience in installing different SQL server versions as per customer requirement.
- Experience in Upgrading and Migrating databases from lower to higher versions.
- Experience in applying latest patches (SPCUGDRHotfixes) to fix vulnerabilities and strong troubleshooting skills on resolving patching issues.
- Well versed in database performance tuning, especially SQL tuning.
- Knowledge on Windows cluster will be plus and Experience in MSSQL cluster environments (Active-Active or Active-Passive).
- Supported SQL Server on LinuxWindows both migrations and on-going support.
- Experience in handling HADR environments (Log Shipping, ReplicationCDC, Mirroring and AOAG).
- Need strong troubleshooting skills on SQL Server Always on Availability Group and Replication issues.
- Skilled in Backups & Disaster Recovery.
- Knowledge on Backup tools (Eg: CommVault, Semantic NetBackup, LiteSpeed) will be plus.
- Strong experience in Automating DB tasks, Health checks, blocking ,disk space ,Maintenance tasks etc.
- Experience in PowerShell scripting automation will be plus.
- 24 X 7 production support experience.
- Knowledge of Windows Server 2003R2 and later editions.
- Working knowledge in T-SQL, BCP, DTS and SSIS development.
- Any cloud Architecture certification is preferable.
- Knowledge and Hands-on expertise on Sybase, Postgre SQL, My SQL and Mongo DB would be additional value addition.
Duties and responsibilities:
- SQL Server Database Administration.
- Microsoft SQL Server - (Version 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019).
- Database support, monitoring, troubleshooting, planning, and migration.
- Transact-SQL (T-SQL).
- Performance Tuning.
- SQL Azure.
- SQL Server Integration Services (SSIS).
