Database Admin Ii

Provide L2+ support for core database administration focused on SQL database.
Lead a team of L1 DBA'S
Responsible for delivering the DBA services to the customer.
Interacting with client over calls and provide details and reasoning of the deliverables.
Should groom the junior resources of the team to enhance their skills.
Should be able to lead the customer call and provide design level support to the client.
Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Provide escalated technical support for complex technical issues which may include leading problem management cases and providing management status.
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes.
Assist developers with complex query tuning and schema refinement.
Provide 24x7 support for critical production systems.
Perform scheduled maintenance and support release deployment activities after hours.
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Experience with enterprise administrative scripting using a major scripting language and experience with software deployment
Knowledge of network architecture and protocols.

**Requirements**:
Database Admin, with 4 -7 years on SQL Server2008 R2, 2012, 2014, 2016, 2017 ,2019 and 2022.
At least 2+ years of Development Experience
Experience in installing different SQL server versions as per customer requirement.
Experience in Upgrading and Migrating databases from lower to higher versions.
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 (Ex**: CommVault, Semantic NetBackup, LiteSpeed) will be plus.
Strong experience in Automating DB tasks, Health checks, blocking, disk space, Maintenance tasks etc.
Documentation skills for processes and procedures (creating KBs, runbooks etc.)
Experience in PowerShell scripting automation will be plus.
Experience in implementing operational automation.
Create and manage database reports, visualizations, and dashboards.
24 X 7 production support experience.
Be available for on-call support as needed.
Working knowledge in T-SQL, BCP, DTS and SSIS development.
Any cloud Architecture certification is preferable.
Knowledge and Hands-on expertise on Oracle, Postgre SQL, My SQL and Mongo DB would be additional value addition.
Worked in Managed Service Providers or supported multiple customers.
Has supported large enterprises with over 100 SQL Server instances.
Can converse with executive levels of management and user base.
Communicates clearly and pointedly.
MCTS, MCITP, and/or MVP certifications a plus.
Experience in supporting SQL Server IaaS and PaaS on OCI, AWS and Azure Clouds would be advantage
Experience in administrating other database services like SSAS, SSIS and SSRS would be advantage.