Job Description
- Application Deadline: Thu, 14 Sep 2023 00:00:00 GMT
- Position: Senior Database Administrator
- Job Type Full Time
- Qualification BA/BSc/HND
- Experience 5 - 8 years
- Location Lagos
- Job Field ICT / Computer 
Job Summary
- The Senior Database Administrator we need will play a critical role in designing (when necessary for new platforms), implementing, and maintaining Bankly's database systems.
- Their expertise will be essential in ensuring the availability, performance, security, and integrity of these databases.
- They will be collaborating with cross-functional teams and contribute to strategic decisions related to database architecture and management.
Key Responsibilities
Database Management:
- Oversee the installation, configuration, and maintenance of various database systems, including relational, NoSQL, and cloud-based databases.
- Ensure high availability, performance, and scalability of databases by implementing best practices, tuning parameters, and optimizing query performance.
- Monitor database systems regularly to proactively identify and address issues, ensuring minimal downtime and maximum system uptime.
Security and Compliance:
- Implement and enforce security measures to safeguard sensitive data and ensure compliance with industry regulations (e.g., GDPR, HIPAA) and organizational security policies.
- Manage access controls, user authentication, and data encryption to protect the confidentiality and integrity of the databases.
Backup and Recovery:
- Develop and maintain backup and recovery strategies to ensure data preservation and disaster recovery readiness.
- Regularly test backup and recovery procedures to verify their effectiveness and reliability in case of system failures.
Database Design and Architecture:
- Collaborate with application developers and data architects to design and optimize database schemas, ensuring efficient data storage and retrieval.
- Participate in capacity planning and scalability discussions to accommodate future data growth and system demands.
Performance Tuning and Optimization:
- Analyze and optimize SQL queries, indexes, and database configurations to enhance overall system performance and response times.
- Identify and resolve bottlenecks and performance issues through query optimization and system tuning.
Development Operations (DevOps):
- Familiarity with CI/CD concepts and tools such as Git, AWS CodePipeline and Azure DevOps especially in relation to database deployment and management.
Automation and Scripting:
- Develop scripts and automation tools to streamline routine database tasks, such as backups, maintenance, and monitoring.
- Implement proactive monitoring and alerting systems to detect and address potential issues before they impact users.
Qualifications
- Bachelor's Degree in Computer Science, Information Technology, or a related field (Master's preferred).
- 5 - 8 years relevant work experience.
- Proven experience as a Database Administrator, with a focus on managing and optimizing large-scale databases.
- In-depth knowledge of primarily Microsoft SQL Server, MongoDB and PostGreSQL.
- Familiarity with other database management systems will be an advantage.
- Proficiency in SQL query optimization, performance tuning, and troubleshooting.
- Familiarity with cloud database services (Primarily AWS RDS, Google Cloud SQL will confer an advantage).
- Experience in database security, backup and recovery strategies, and disaster recovery planning.
- Strong scripting skills (e.g., SQL, Python, PowerShell) for automation and maintenance tasks.
- Excellent problem-solving skills and the ability to work effectively in a collaborative team environment.
- Strong communication skills to interact with technical and non-technical stakeholders.
- Relevant certifications such as AWS Certified Database(Specialty), MongoDB Certified DBA, etc., are a plus.