The Role: Essential function:
- The senior SQL DBA should have a broad database administration competence and skill and will be responsible for monitoring, maintenance and operational support of a portfolio of databases – 70 instances and more.
- Maintain reliability, stability and data integrity of the databases.
- Provide support in the administration, backup, integrity and security of various SQL databases.
- Responsible for database tasks from SQL software upgrades and custom interfaces, to troubleshooting.
- Continually assess, improve, and optimize (or recommend improvements to) the current database environment.
Skills and Experience: Essential Qualification:
- MCSA: SQL server certification
- MCSE: SQL server certification
- More than five years?? experience as a database administrator in SQL Server environment
- More than four years?? experience in Transact SQL, DTS, SSIS package development
- More than three years of SQL Server database development / programming
- Experience and end-to-end knowledge of MS SQL server database technologies including MS SQL Clusters and Failover Cluster Instances (FCI) and of administering SQL Server [Phone Number Removed]; and 2017 databases
- Experience with Monitoring & Diagnostic tools
- Knowledge of ITIL IT Service Management processes, preferably certified.
- Participation and completion of Leadership Development Programmes an advantage.
- Experience working with Windows server, including Active Directory and disk configurations
- B.Tech, B.Com or B.Sc. Computer Science or Information Systems, or B.Eng. or equivalent combination of education and experience an advantage.
- Azure and Opensource experience/exposure will be an advantage
Experience required:Must be able to work with other DBAs (operations), IT teams and clients to ensure that Microsoft SQL Server (MSSQL) database maintenance tasks are performed in a highly visible, mission critical environment including, but not limited to the following:
- Monitor performance of database systems resources and query throughput
- Optimize SQL Code as necessary
- Monitor and maintain database storage resources, maintenance plans for backups, index rebuild/defragment, building of scheduled jobs, clearing locks, and database statistics
- SQL Server Installation, Upgrades, Migrations and Configuration
- Install database software service packs and cumulative updates as necessary
- Maintain database documentation as required
- Maintain and administer database security access
- Perform database Ad-hoc backups and restores
- Trouble shoot and resolve database connectivity issues
- Follow Change Management processes to implement database configuration changes
- Follow Problem Management processes to troubleshoot and resolve recurring issues
- Proactively monitor and respond to MSSQL database Alerts.
- On-call requirements to ensure 24 x 7 support of database operations
- Able to lead a team of junior and intermediate DBAs
- End-to-end knowledge of MS SQL server database technologies including MS SQL Clusters and Failover Cluster Instances (FCI)
- Experience with deploying and maintaining Enterprise Level SQL Server Farms and Failover Cluster Instances (FCI)
- Evaluate, implement and maintain Microsoft technology, security updates, hot fixes, upgrades and version releases to ensure architecture stability
- Configure and manage SQL Server [Phone Number Removed]; and perhaps even Azure, demonstrating how these technologies may be leveraged to impact the architecture’s overall design, security, availability and stability