Application DBA (ADBA)
- Nairobi
- Permanent
- Full-time
- Install, Configure, upgrade and maintain database systems
- Manage database backups, recovery, and disaster recovery plans
- Database object reviews
- Tuning database performance for individual applications.
- Working with application developers on database design and implementation.
- Monitor database performance
- SQL tuning, query optimization, and troubleshoot PL/SQL issues
- Review app-related DB logs and trace files for errors or anomalies
- Monitor DB jobs, batch processes, and scheduled procedures (e.g., using DBMS_SCHEDULER)
- Validate schema integrity, check object growth, and perform clean-ups
- Monitor table/index growth, segment usage, temp space usage, etc.
- Capacity monitoring and reporting
- Refresh lower environments (UAT/OAT) from Production as needed.
- Support UAT, regression testing, and performance/load testing efforts
- Assist in rolling out new application versions that include schema/data changes.
- Maintain schema documentation, change logs, and configuration baselines
- Maintain and review audit logs to track database access and changes for compliance and security purposes.
- Participate in project planning and implementation phases that involve database changes or new application rollouts.
- Bachelor’s degree in computer science, Information Technology, or a related field
- Strong experience with database management systems specifically oracle and Postgres
- Proficiency in SQL and database scripting languages
- Familiarity with application development processes and methodologies
- Excellent analytical troubleshooting and problem-solving skills
- Strong communication and collaboration skills
- At least 4years of experience in oracle database support in a financial sector