JOB DETAILS:
The Database Administrator (DBA) is responsible for the performance, integrity, and security of the Lycamobile Uganda’s information systems’ databases. The DBA provides technical expertise in the design, implementation, and maintenance of database management systems that support institutional business applications. Additional responsibilities include reporting, data input and output, technology management, and end-user training and support.

ESSENTIAL JOB FUNCTIONS:
• Designs and documents database architecture.
• Install and maintain the performance of database servers.
• Set and maintain database standards.
• Performance tuning of database systems.
• Install, upgrade, and manage database applications.
• Diagnose and troubleshoot database errors.
• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboard.
• Create automation for repeating database tasks.
• Be available for on-call support as needed.
• Manage database access.
• Assesses malfunctions of software applications for the purpose of determining appropriate actions to maintain database operations.
• Build database scheme, tables, procedures, and permissions.

• Creates, tests, and executes data management languages.

• Analyses and sustains capacity and performance requirements.
• Monitors systems and platforms for availability.
• Oversees backup, clustering, mirroring, replication and failover.
• Performs maintenance operations daily, weekly and monthly on Oracle and SQL servers and databases, and information systems for the purpose of ensuring efficient program operations.

• Performs database backups and restorations and recovers corrupted databases.

• Evaluates and recommends new database technologies.
• Implements and maintains database security and encryption.
• Develops, manages and tests database and information system backup and recovery plans.
• Develops standards and policies for data entry and ensures compliance.

• Prepares written materials for the purpose of documenting activities, providing written reference, and/or conveying information.
• Prepares and distributes reports, including but not limited to weekly and monthly status reports to the IT Operations Head.

• Attends seminars, conferences, in-service training and staff meetings as required
• Other related duties, as assigned.

QUALIFICATIONS, SKILLS AND EDUCATION:
• Bachelor’s degree in computer science or a related field
• Experience with Linux and Windows Server environments
• Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
• Certifications such as MySQL DBA, MCSE DBA, Oracle Associate or equivalent experience are required.
• Minimum of Five years conducting general Oracle database administration tasks such as database implementations, backups, and account maintenance.
• Minimum of five years administering database platform specific advanced features (e.g. clustering, encryption, logical/physical standby, ETL, replication)
• Strong command of SQL and SQL server tools
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Understanding of relational and dimensional data modelling.
• PowerShell and Unix shell scripting skills
• Familiarity with SSAS, SSIS, SSRS
• Strong mathematical and statistical knowledge
• Excellent written and verbal communication skills
• Impeccable attention to detail

Other critical skills and abilities
• Experience in all MySQL Database Management Systems.
• Experience in Oracle Enterprise version 12c.
• Experience in Microsoft SQL Server 2008+.
• Proficiency in Unix/Linux with an emphasis on database and spreadsheet applications.
• Proficiency in Microsoft Windows and Microsoft Office applications with an emphasis on database and spreadsheet applications.
• Intermediate knowledge in hardware and networking.
• Experience managing databases. Proficiency in database administration, management, data imports and exports, and developing reports.
• Ability to provide excellent customer service and public relations outreach.
• Proven ability to effectively manage multiple priorities and meet deadlines.
• Ability to adapt to varied roles and job responsibilities and problem-solving skills.
• Demonstrated ability using a life cycle management process for implementation of changes in technology.
• Ability to performs a variety of professional tasks including, but not limited to, technology services representative on various committees or task forces
• Demonstrated ability to excel both independently and as a team member in a lively, collaborative environment.
• Excellent written and verbal communications skills with a demonstrated ability to make difficult concepts easy to understand