Position Title
Application Database Administrator
Job Summary
We are looking for an experienced Application DBA to support, maintain, and optimize database environments that are closely integrated with business applications. The role is responsible for ensuring database availability, performance, security, and reliability while working closely with application, infrastructure, and project teams.
The Application DBA will act as the bridge between the application team and database team, supporting database-related activities for application deployment, troubleshooting, performance tuning, and production support.
Key Responsibilities1. Database Administration & Support
- Manage and support application databases across development, testing, staging, and production environments.
- Perform database health checks, monitoring, backup verification, and routine maintenance.
- Support database upgrades, patching, migration, and environment refresh activities.
- Ensure database availability, stability, and performance for business-critical applications.
2. Application Database Support
- Work closely with application teams to understand database requirements.
- Support application deployment activities involving database scripts, schema changes, stored procedures, triggers, indexes, and data changes.
- Review and validate SQL scripts before execution in production.
- Assist in troubleshooting application issues related to database connectivity, slow queries, locking, blocking, session issues, and transaction errors.
3. Performance Monitoring & Tuning
- Monitor database performance and identify bottlenecks.
- Analyze slow-running SQL queries and provide tuning recommendations.
- Optimize indexes, database objects, queries, and execution plans.
- Work with developers to improve SQL performance and database design.
4. Backup, Recovery & High Availability
- Ensure database backup jobs are running successfully.
- Perform database restore and recovery activities when required.
- Support disaster recovery, replication, clustering, Data Guard, RAC, or other high availability setups where applicable.
- Participate in DR drill and recovery testing activities.
5. Security & Compliance
- Manage database user access, roles, privileges, and password policies.
- Support audit requirements and ensure database activities follow internal security standards.
- Assist in implementing data protection controls such as encryption, masking, auditing, and access control.
- Ensure compliance with company IT policies, regulatory requirements, and audit guidelines.
6. Incident, Change & Problem Management
- Provide support for production incidents and service requests.
- Perform root cause analysis for recurring database or application-related issues.
- Prepare and execute database change requests following change management processes.
- Maintain proper documentation for changes, configurations, and operational procedures.
7. Documentation & Reporting
- Maintain database inventory, configuration documents, SOPs, and operational guides.
- Prepare database health check reports, incident reports, and performance analysis reports.
- Document lessons learned and improvement recommendations.
Required Skills & Experience
- Experience as a DBA, Application DBA, or Database Support Engineer.
- Hands-on experience with databases such as Oracle, Microsoft SQL Server, MySQL, or Mongo DB.
- Strong knowledge of SQL, database objects, indexing, stored procedures, and query tuning.
- Experience in database backup, restore, migration, patching, and performance monitoring.
- Familiar with application deployment support and database change management.
- Good understanding of database security, user access control, and audit requirements.
- Ability to troubleshoot application/database issues under pressure.
- Good communication skills and able to work with application, infrastructure, security, and business teams.
Preferred Skills
- Experience supporting banking, financial, government, or enterprise application environments.
- Knowledge of Oracle RAC, Data Guard, ASM, RMAN, AWR, and performance tuning.
- Familiar with Linux/Unix and Windows Server environments.
- Experience with monitoring tools, APM tools, database security tools, or log analysis tools.
- Relevant certifications such as Oracle OCA/OCP, Microsoft SQL Server.
Qualifications
- Diploma or Degree in Computer Science, Information Technology, Software Engineering, or related field.
- Minimum 3–5 years of experience in database administration or application database support.
Key Attributes
- Strong problem-solving and analytical mindset.
- Able to work independently and under pressure.
- Detail-oriented and careful when handling production databases.
- Good coordination skills between technical and business teams.
- Willing to support after-office hours, standby, or maintenance windows when required.
Pay: RM4,000.00 - RM10,000.00 per month
Work Location: Hybrid remote in Kuala Lumpur (Kuala Lumpur, 60000)