Database Specialist

Job Summary:

We are seeking an experienced Database Migration Specialist with deep expertise in migration workloads from DB2 databases to AWS RDS Aurora PostgreSQL . The ideal candidate will play a key role in modernizing our database infrastructure, leading large-scale migrations, and ensuring data integrity, performance, and scalability throughout the process.

Required Qualifications: Bachelor’s or master’s degree in computer science, Information Systems, or related field. 6+ 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.

A

DB Lead

(Database Lead) is a senior technical role responsible for overseeing all aspects of an organisation’s

database architecture, operations, performance, and strategy . 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).