Senior Database Administrator
Independent Recruiter on August 06, 2020
Job Type: Full Time
Job Category: Information Technology
Contract Type: Permanent
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.
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.
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