DATABASE ADMINISTRATOR (X1) GABORONE

Main purpose of the position

• To develop and design database strategies, monitor, and improve database performance and capacity, and plan for future expansion requirements while conforming to the set security measures & standards.

Job Responsibilities

• Plans, administers, acquires and install database systems for datacentre environment.
• Administers a variety of database systems specifically Microsoft SQL Server, Azure database and any other database systems that exist in the environment.
• Maintains and administers IIS and integration tools used to develop database systems and frameworks.
• Develops and enforces database administration and user standards and procedures.
• Audits, modifies, and amends data in systems using SQL commands, hand-editing, and bulk import
• Conducts system health checks to determine system abnormalities & degradation
• Analyse system abnormalities & take appropriate action.
• Collects data from various data sources, analyse & produce a report detailing the trends.
• Conducts daily backups to ensure data security and recovery.
• Coverts data from different data
• Merges corporate databases & recommends appropriate optimisation for business intelligence.
• Analyse various data objects & data sources.
• Supports teams on technical matters.
• Assess scalability options for database growth.
• Designs & implements high availability & data replication options.
• Configures software utilized on databases
• Applies relevant system upgrades & hot fixes.
• Manage relationships with customers & stakeholders and act as their business partner to ensure client satisfaction.
• Monitors implementation of Service Level Agreements to ensure compliance
• Provides escalated support and troubleshooting to resolve issues
• Provides support in the creation of database reports and exhibits
• Trains and provides technical direction to staff as needed
• Assists staff in developing procedures, forms, exhibits, and database documentation.
• Assesses & provides permission access to database driven applications.
• Follows existing procedures and precedents in determining the correct course of action for routine functional enquiries.
• Evaluates new database requirements to determine compatibility with existing infrastructure.
• Works within current compliance processes, systems and procedures and reports shortcomings
• Monitors & ensure compliance with the BPC ICT Policy.
• Develops and enforce database administration and user standards and procedures.
• Modifies and amends configurations in systems in compliance with audit findings.
• Reviews identified shortcomings in current compliance processes & recommend solutions.
• Benchmark best practices on ICT Database Services & recommend to Management
• Provides information and clarification on existing procedures, processes and precedents.
• Provide advice to BPC on ways to optimise database environment.
• Implements prescribed SHE initiatives & provides support services by using the Corporation’s safety, health and environment systems and protocols.

Qualifications

•    A minimum of a Degree in Computer Science, Engineering or equivalent is required
•    SQL certification is required
•    Oracle certification would be an added advantage
 

Experience

• Minimum of five (5) years’ experience in a computer environment, three of which should have been served as a database designer/information systems analyst, database manager or database administrator
• Knowledge of administering and maintaining management information systems; server hardware and software technologies; standard computer hardware and software.

Competencies