Data & Analytics â?? Database Administrator

SUMMARY:
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 reliab...
  
  

  POSITION INFO:
  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 2000, 2005, 2008, 2012, 2014, 2016 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 2008/2012/2014/2016/2017/2019 and perhaps even Azure, demonstrating how these technologies may be leveraged to impact the architecture''s overall design, security, availability and stability 
  Other:

  Work environment:

  • Remote work until further notice.

  Physical demands:

  • Computer work

  Travel:

  • Not required unless asked by Client
  
  
  

   

  NB! This job is now closed. You can apply for other jobs by uploading your CV.

  
  

  ---

   

  New users - Upload your CV

  Existing users - Login here