Database Administrator at Risk Control Services Nigeria Limited

Job Description

• A Database Administrator (DBA) is responsible for managing and maintaining an organization's databases, ensuring they are secure, reliable, and efficient.
• The primary role of a DBA involves designing, implementing, and overseeing database structures to meet the organization's data storage, security and retrieval needs.

Responsibilities

• Database Installation and Configuration: Installing and setting up database management systems (DBMS) like MySQL, Oracle, SQL Server, or PostgreSQL, including the appropriate hardware and software configurations.
• Database Design: Designing and developing the database schema, tables, views, and stored procedures to ensure efficient data storage and retrieval.
• Data Security: Implementing security measures to protect sensitive data from unauthorized access, data breaches, and cyberattacks. This includes setting up user roles, permissions, and encryption.
• Data Backup and Recovery: Establishing backup and recovery procedures to safeguard data and ensure business continuity in case of system failures or disasters.
• Performance Monitoring and Optimization: Monitoring database performance and identifying and resolving performance issues, such as slow queries, to maintain optimal database efficiency.
• Database Upgrades and Patching: Keeping the database software up-to-date with the latest patches and updates to address security vulnerabilities and improve performance.
• Database Migration: Planning and executing database migrations when transitioning to new hardware or software versions.
• Database Troubleshooting: Identifying and resolving database-related problems, including data corruption, connectivity issues, and application integration errors.
• Data Integrity and Quality Assurance: Ensuring data accuracy, consistency, and integrity throughout the database system.
• Documentation: Maintaining comprehensive documentation of the database environment, including system configurations, data models, and operational procedures.

Requirements

• Bachelor’s Degree in Computer Science, Information Technology, or a related field with 3+ years relevant work experience.
• Previous experience working with database management systems and SQL languages.
• Proficiency in database management systems like SQL Server, MySQL, PostgreSQL,
• Strong knowledge of database design principles and best practices.
• Understanding of data security and encryption methods.
• Familiarity with database performance tuning and optimization techniques.
• Experience with data backup and recovery procedures.
• Strong knowledge of Microsoft cloud infrastructure.
• Strong communication skills to interact with team members, stakeholders, and end-users to understand requirements and provide support.
• Ability to collaborate with developers, system administrators, and other IT professionals to ensure seamless integration of database systems with applications and infrastructure.
• Capable of prioritizing tasks and managing time efficiently to meet deadlines and handle multiple projects simultaneously.