Specialist: Database Administration at Alphabeta Consulting LLP – Ikeja, Lagos

Alphabeta Consulting LLP is recruiting a Database Administration Specialist in Ikeja, Lagos, to manage Microsoft SQL Server platforms, optimise T-SQL code and maintain secure, reliable data services.

Role overview

Department: Technology

Alphabeta Consulting LLP is seeking an experienced and technically proficient Specialist: Database Administration to join its Technology Department.

The successful candidate will be responsible for designing, implementing, securing, monitoring, and maintaining database systems, with a primary focus on Microsoft SQL Server.

The role combines database administration with hands-on SQL development, including writing, testing, debugging and optimising stored procedures.

The successful candidate will ensure database availability, performance, security and data integrity while developing efficient database solutions to support business applications and organisational objectives.

Key responsibilities

• Design, develop and implement database structures in line with business, application and end-user requirements.
• Install, configure, upgrade, administer and maintain Microsoft SQL Server database management systems.
• Develop, write, test, debug, maintain and optimise T-SQL queries and stored procedures to implement business logic, automate database operations and support application functionality.
• Develop and maintain database objects, including views, functions and triggers, in accordance with approved technical requirements and coding standards.
• Analyse query execution plans, optimise SQL queries and stored procedures, and implement appropriate indexing strategies to improve performance.
• Monitor database performance, identify bottlenecks and implement optimisation measures to ensure high availability, reliability and efficient resource utilisation.
• Manage database backup, recovery, storage, archiving and disaster recovery procedures to minimise the risk of data loss.
• Implement database security controls, including user access management, permissions and privileges, based on approved authorisations.
• Maintain data integrity, consistency, accuracy and reliability across database systems.
• Troubleshoot database errors, investigate incidents and resolve user-reported issues promptly.
• Conduct routine database maintenance, performance tuning and capacity planning.
• Monitor the performance of database-hosting hardware and software and address identified issues.
• Ensure that stored procedures and other database objects comply with established security standards, data integrity requirements and performance benchmarks.
• Collaborate with IT Project Managers, Scrum Masters, and application development teams to support project implementation, database integration, and application development.
• Translate business and application requirements into efficient, secure, and maintainable database solutions.
• Prepare weekly and monthly reports on database usage, performance, availability, security, and maintenance activities.
• Identify opportunities to improve database architecture, operational efficiency, security, and service delivery.
• Maintain accurate technical documentation and comply with established database administration processes and procedures.
• Handle confidential and sensitive information ethically and in accordance with applicable data protection requirements.
• Database uptime, availability and performance.
• Effectiveness of database maintenance and performance optimisation.
• Reliability of database backup, recovery and disaster recovery processes.
• Quality, efficiency and performance of developed stored procedures and SQL queries.
• Timely development, testing, debugging and deployment of database objects in line with approved requirements.
• Database security posture and risk assessment outcomes.
• Accuracy, consistency and integrity of stored data.
• Compliance with applicable data protection requirements and internal database administration procedures.
• Timeliness of incident resolution and response to user-reported errors.
• Successful delivery of assigned application development projects requiring database administration and SQL development support.

Requirements

• Bachelor’s degree or HND in Computer Science, Information Technology, Software Engineering, Computer Engineering, or another relevant discipline.
• 7–10 years of relevant professional experience in database administration, with substantial hands-on experience in Microsoft SQL Server.
• Demonstrable experience writing, debugging, testing, and optimising T-SQL queries and stored procedures in a production environment.
• Proven experience in database design, installation, configuration, administration, performance tuning, troubleshooting, and maintenance.
• Practical experience with query execution plans, indexing, transaction management, and SQL performance optimisation.
• Strong knowledge of database security, backup and recovery, access management, high availability and disaster recovery.
• Experience supporting application development projects and collaborating with cross-functional technology teams.
• Relevant professional certification in Database Administration will be an advantage.
• Added Advantage: Working knowledge of Oracle, MySQL, or PostgreSQL database management systems.
• Strong technical expertise in Microsoft SQL Server administration and T-SQL development.
• Proficiency in developing and maintaining stored procedures, complex queries, views, functions and triggers.
• Ability to analyse and optimise SQL execution plans, queries and stored procedures for improved performance.
• Sound understanding of database architecture, indexing, transaction management, concurrency and data integrity.
• Strong knowledge of database security, performance monitoring, backup and recovery strategies.
• Excellent analytical, critical-thinking and problem-solving skills.
• Meticulous attention to detail and a systematic approach to troubleshooting.
• Ability to translate business requirements into effective, secure and maintainable database solutions.
• Excellent written and verbal communication skills.
• Effective organisational, interpersonal and time-management skills.
• Ability to prioritise competing tasks and work effectively under pressure.
• Ability to work independently with minimal supervision and take ownership of technical issues.
• Strong collaboration skills and the ability to work effectively with technical and non-technical stakeholders.
• Good business awareness and the ability to align database solutions with organisational requirements.
• Commitment to continuous professional development and emerging database technologies.