Lead Database Administrator

Job Summary:

DB2

Required Qualifications:

• Bachelor’s or master’s degree in computer science, Information Systems, or related field.
• 7+ years of experience in database development and management.
• Strong hands-on experience with IBM DB2 database architecture and administration.
• Proven experience in migrating DB2 databases to AWS RDS Aurora PostgreSQL.
• Expertise in PostgreSQL development, including stored procedures, functions, indexing, and performance tuning.
• Proficient in ETL tools, data transformation, and scripting languages (Python, Shell, or equivalent).
• Familiarity with AWS services such as DMS (Database Migration Service), Schema Conversion Tool, RDS, and Aurora.
• Strong understanding of data modelling, normalization, and database optimization techniques.
• Excellent problem-solving skills and attention to detail.
• Strong verbal and written communication skills.

DB Lead

1. Database Architecture & Design

• Define database models, schemas, and structures for applications.
• Ensure designs meet scalability, performance, and security requirements.
• Evaluate and choose the right database technologies.

2. Performance & Optimisation

• Monitor system performance (queries, indexes, workloads).
• Optimise queries, indexing strategies, and storage.
• Ensure high availability and low latency.

3. Database Operations & Maintenance

• Oversee backups, restores, patching, replication, failover strategies.
• Ensure disaster recovery plans are in place and tested.
• Manage data migrations and upgrades.

4. Data Governance & Security

• Implement access control, encryption, and compliance standards.
• Ensure data integrity, consistency, and auditability.

5. Leadership & Coordination

• Lead a team of DBAs (Database Administrators), data engineers, or developers.
• Work with application architects, project managers, and other technical leads.
• Communicate risks, design decisions, and strategies to stakeholders.

6. Cloud & Modernisation

• Especially in modern IT environments:
• Manage cloud database services.
• Plan and lead database modernisation efforts (e.g., migrating from on-prem to cloud).
• Oversee adoption of managed services, automation, and IaC (Infrastructure as Code).

Preferred Qualifications:

• AWS Certification (e.g., AWS Certified Database – Specialty, AWS Certified Solutions Architect).
• Experience with CI/CD practices and infrastructure as code (Terraform, CloudFormation).
• Familiarity with DevOps tools and concepts (e.g., Git, Jenkins, Ansible).