Database Administrator (DBA)

Job Summary

Responsible for ensuring the availability, performance, security, and integrity of IBM Db2 and PostgreSQL databases in production and non-production environments. Collaborate with application, infrastructure teams, and vendors to maintain stable, recoverable databases that meet SLAs.

Responsibilities

• Install, configure, upgrade, and patch IBM Db2 and PostgreSQL database instances across on-premises, virtual, and cloud platforms such as AWS RDS and Aurora PostgreSQL
• Monitor database health, capacity, and performance; respond promptly to alerts to maintain system stability
• Manage database users, roles, privileges, and access controls to enforce security policies
• Perform routine database maintenance including reorganization, statistics updates, vacuuming, reindexing, and storage management to optimize performance
• Support L2 and L3 incident resolution and conduct root cause analysis to prevent recurrence
• Analyze and tune slow-running queries, indexes, execution plans, and configuration parameters to improve database efficiency
• Collaborate with developers on schema design, query optimization, and data model adjustments to support application requirements
• Plan database capacity and recommend scaling or archiving strategies to meet future demands
• Apply database security measures such as hardening, encryption (at rest and in transit), and audit logging to comply with policies
• Remediate vulnerabilities and apply security patches in accordance with organizational standards
• Support audit processes by providing required documentation and evidence for compliance
• Review and execute database changes and deployments following change management procedures
• Support data migration, version upgrades, and cloud migration activities to ensure seamless transitions
• Maintain runbooks, standard operating procedures, and comprehensive database documentation for operational consistency
• Coordinate with vendors, including IBM, on support cases and licensing issues to resolve technical challenges
• Report database performance, availability, and capacity metrics during service review meetings to inform stakeholders

Preferred competencies and qualifications

• Diploma or Bachelor’s degree in IT, Computer Science, or arelated field (or equivalent experience)
• 4-7 years of hands-on DBA experience in productionenvironments
• Strong experience with both IBM Db2 (LUW) and PostgreSQL
• Proven experience in backup and recovery, replication,HA/DR, and performance tuning
• Experience with Linux (RHEL preferred) and shell scripting
• Preferred certifications: IBM Certified DatabaseAdministrator (Db2), PostgreSQL certification (e.g. EDB), AWS CertifiedDatabase Specialty, ITIL 4 Foundation

Skills

• Strong SQL skills and database internals knowledge
• Scripting and automation (Bash, Python, Ansible) for routinetasks
• Familiarity with monitoring tools (e.g. Prometheus, Grafana,CloudWatch, pgAdmin, Db2 monitoring tools)
• Working knowledge of cloud platforms (AWS) and containerisedenvironments
• Familiarity with ITSM tools (e.g. ServiceNow) and changemanagement processes
• Strong troubleshooting skills, attention to detail, andclear communication
• Calm and effective under pressure during incidents

Skills

Security Controls, Monitoring Tools, Collaborating With Designers, Archiving, Amazon RDS, AWS, Root Cause Analysis, Storage Management, performance tuning of Queries, Python, Cloud-Based Platform, Alarm System Management, Two-Way Communications, ServiceNow, DB2 database administration, SQL Development