Database Administrator

Guardian Group is seeking to recruit a Database Administrator to manage, maintain, and optimize our database systems, ensuring high performance, availability, and security of critical data.

JOB OVERVIEW:
The Database Administrator is responsible for the management of the Production and Test databases across defined business units of the Group while ensuring high levels of data availability.

This is achieved by:
· Aligning with Group Solutions Delivery framework
· Conducting performance and capacity reviews on systems

JOB RESPONSIBILITIES:
1. Installation, Configuration, Consolidation and Upgrading of Database (SQL SERVER):
· Develop and provide database requirements to system administrators to ensure optimal performance and compatibility of the database systems.
· Ensure required security controls are designed around data and databases to protect the confidentiality, integrity, and availability of the information.
· Plan and perform upgrades of databases to keep them updated with the latest features and patches.
· Plan and execute DB consolidation strategy to reduce costs and complexity of the database infrastructure.
· Install, configure, and maintain the database management systems software to support the database operations and functions.

2. Performance and Capacity Management (SQL SERVER):
· Plan and monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
· Monitor, optimise, and allocate physical data storage for database systems to achieve optimum database performance.
· Monitor, analyse and calibrate Database Management System parameters so that the database is tuned for optimal performance.
· Build scripts automating the daily operations of database management.

3. Data Management (SQL SERVER):
· Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
· Assist with the development of tools and techniques that allow clients to access data in a secure environment.

4. Operational Management (SQL SERVER):
· Maintenance of Database components that includes periodic reviews against operational requirements such as patch management, upgrade strategies and security requirements.
· Assess and develop long-term strategic goals for production databases in conjunction with data and system owners.
· Develop, document, and implement a common set of database policies, standards and procedures to ensure the integrity and availability of databases inclusive of Disaster Recovery
· Ensure Disaster Recovery / Restore Testing is completed as per approved schedule.
· Respond to and resolve database access and performance issues.
· Plan and coordinate data migrations between systems.
· Ensure all modifications to the databases follow the change management process.
· Perform database transaction and security audits.
· Establish appropriate end-user database access control levels.
· Maintain development, production, and multiple testing environments.
· Communicate to the business process owners any maintenance requirements.
· Ensure optimal licensing at server and user end.

5. Work with Third party support for outsourced systems and is Subject matter expert in Third party agreements regarding support.

6. To perform any other job-related duties as assigned by the Team Leader or Manager.

EDUCATION & EXPERIENCE:
· B.Sc. Computer Science or a related area of study.
· Microsoft Certified Database Administrator
· Cloud Database Administrator
· 3-5 years’ experience in Database Administration, with a good understanding of logical and physical database design principles. 
· Familiarity with COBIT and ITIL Change Management standard. 
· Familiarity with relational databases, backup and recovery, and scripting. 
· Experience with enterprise resource planning. 
· Experience with SQL Server 
· Experience with Azure Database Maintenance