Ms Sql Dba

MS SQL DBA Indianapolis, IN(Hybrid) 6+ months Note : Look for Senior resources(10 or 12 yrs exp) only. - Proven experience and competency managing SSAS environments (tabular and MOLAP) including knowledge of performance tuning and cube optimization.

• Senior IT Engineer , with 10+ years on SQL Server 2005, 2008 and 2008 R2, 2012, 2014, 2016, 2017 ,2019 and 2022.
• Experience in supporting SQL Server IaaS and PaaS on OCI, 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 (SP\CU\GDR\Hotfixes) 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 Linux\Windows both migrations and on-going support.
• Experience in handling HADR environments (Log Shipping, Replication\CDC, 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.