Database Administrator at Smart Applications International Ltd

The key responsibility for this role is to ensure the optimal performance of Smart database and associated functionality and essentially ensure that the Smart databases meet user requirements.

Database Support & Operations

• Provide 24/7 support to ensure high availability, integrity, security, and performance of Smart’s databases.
• Assist with database maintenance, installations, configurations, upgrades, and patch management for Oracle, MSSQL, and MySQL environments.
• Perform daily backups, verify data integrity, and support restore processes.

Monitoring & Troubleshooting

• Monitor database logs, performance, and abnormal activities, escalating issues as necessary.
• Provide first-level troubleshooting for database incidents and support customer service inquiries under defined SLAs.

Documentation & Reporting

• Maintain accurate documentation of procedures, configurations, backup schedules, and incident resolutions.
• Generate regular database performance reports and ensure compliance with database standards.

Collaboration & Continuous Improvement

• Work closely with senior DBAs, internal teams, and other departments to support business systems.
• Stay updated on Smart solutions, current database trends, and attend training to enhance skills.

Requirements

 Qualifications

• Holder of a bachelor’s degree in lieu demonstrate experience in database administration and a professional qualification.
• An experience of 2 years working with PostgreSQL
• Strong PostgreSQL query writing, tuning skills, and shell scripting
• Hands-on knowledge of backup and recovery methods and tools
• Experience with high availability and disaster recovery including data replication
• Solid understanding of Linux and Windows Server environments.
• Familiarity with automation tools like Ansible, Terraform, or Kubernetes for DB deployment/management.