Job Details

Senior Database Administrator

By Independent Recruiter on August 06, 2020
Job Type: Full Time
Job Category: Information Technology
Contract Type: Permanent

Sandton

Job Description

The Senior DBA is responsible for the implementation, maintenance, performance, integrity and security of all the company databases. The role includes the monitoring and improvement of database performance and capacity, and planning for future expansion requirements. The Senior DBA will also plan, coordinate and implement security measures to safeguard the databases. The Senior DBA will be a key player in the planning and implementation of the Disaster Recovery plan for the company.

Job Requirements

5+ years DBA experience (SQL 2012, SQL 2014, 2016) Microsoft Server products (Server OS, Hyper-V and Clustering) knowledge is important Expert knowledge of SQL Replication in a Production Environment. Solid experience in troubleshooting and resolving performance bottlenecks and optimising query plans Experience with setup and maintenance of High Availability Groups Good grasp of the T-SQL Language. Good grasp of “Codes of Good Practice” and “SQL Standards”. Good grasp of “SQL Security Practices”. Due to the creative nature of the work done, it is critical that the Database Administrator is able to lead by communicating ideas with Engineers, peers and leaders and are able to convince and influence others. Strong work ethic. Ability to work well independently. Excellent communication and negotiation skills.

Job Duties

Manage, document and test all backup and restore processes Design, manage and document replication processes Configure, manage and document all server hardware and software that houses the SQL Engines Ensure uptime and optimal health of MSSQL RDMS’s Schedule and monitor all SQL jobs. Alert the relevant parties of job failures Perform continual maintenance on all the databases, ensuring optimal index usage. Take the necessary corrective actions when necessary. Ensure that all the Engine and Database settings are optimal for the particular environment Ensure the integrity of all the databases Monitor and analyse performance trends on SQL Server and the host server and OS. Use the gathered information to ensure optimal resource usage, identify resource bottlenecks and trend capacity usage Design, maintain and audit all security aspects around the SQL Server, the logins and the associated applications Assist with definition and implementation of Disaster Recovery strategy Ensure that all technical documentation around the SQL implementation is kept up to date Assist with occasional ad-hoc queries Implement the SQL code received from Business Intelligence and Software Development on the production systems Provide 24/7 support to all database systems Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations Participate in technical research and development to enable continuing innovation within the infrastructure. Research and recommend innovative, and where possible automated approaches for database administration tasks