Work Setup and Location: On-Site, Arayat st., Mandaluyong, Metro Manila
Work Schedule: Morning or Mid-Shift, Monday-Friday (8-hour shift only)
Experience Level: 3-5 years
No. of employees required: 4
About the Role:
We are seeking a skilled Database Administrator (DBA) to join our team. As a DBA, you will be responsible for managing and maintaining databases to ensure their availability, performance, and security. You will work with other IT teams to ensure that the organization’s data is properly organized, protected, and accessible. Your expertise will help optimize database performance, support data-related applications, and ensure smooth database operations across the company.
Key Responsibilities:
Database Management and Maintenance
- Install, configure, and maintain databases (e.g., SQL Server, Oracle, MySQL, PostgreSQL, or other RDBMS).
- Perform routine database backups, restorations, and disaster recovery procedures to ensure data integrity.
- Monitor database performance, implementing optimization techniques to ensure high availability and fast response times.
- Perform database maintenance tasks, including index optimization, query tuning, and data cleanup.
- Troubleshoot and resolve database-related issues, ensuring minimal downtime and service disruptions.
Database Security and Access Control
- Manage database security by controlling user access and implementing role-based access control (RBAC).
- Regularly audit database systems to detect and mitigate security vulnerabilities and ensure compliance with data protection standards.
- Implement encryption, masking, and other security techniques to safeguard sensitive information stored in databases.
- Ensure compliance with industry standards and regulatory requirements (e.g., GDPR, HIPAA, etc.) related to database management.
Performance Tuning and Optimization
- Monitor database performance using performance monitoring tools and logs.
- Analyze and optimize queries, stored procedures, and database configurations to improve performance.
- Work with developers to identify and resolve performance bottlenecks, ensuring efficient use of database resources.
- Plan and execute database optimization strategies to improve scalability and resource utilization.
Database Backup and Recovery
- Develop and implement robust backup and recovery strategies to ensure business continuity and data protection.
- Regularly test backup and recovery procedures to ensure they are effective and reliable.
- Manage and monitor backup schedules, ensuring that all critical data is backed up and securely stored.
- Work with disaster recovery teams to ensure that data recovery processes are in place and ready for use in case of system failure.
Database Upgrades and Patches
- Plan and implement database upgrades, patches, and updates in a timely and efficient manner.
- Test and verify the impact of database updates and ensure that they do not disrupt existing operations.
- Collaborate with the development and operations teams to ensure that database environments are up-to-date and fully supported.
Troubleshooting and Support
- Provide ongoing support for database-related issues, troubleshooting and resolving complex problems.
- Respond to and resolve database incidents and service requests from internal teams.
- Work closely with other IT teams, such as developers and system administrators, to troubleshoot cross-system issues.
- Provide technical support during application deployments and database migrations.
Documentation and Reporting
- Maintain comprehensive documentation for database configurations, procedures, and architecture.
- Document database changes, updates, and incident resolutions for internal knowledge sharing.
- Generate regular reports on database health, performance, and security audits for management and compliance purposes.
Collaboration and Continuous Improvement
- Collaborate with application developers, system administrators, and network engineers to integrate databases with other IT systems.
- Contribute to the continuous improvement of database management processes, tools, and technologies.
- Stay up-to-date with the latest database technologies and industry trends, bringing new solutions to improve database performance and management.
Qualifications and Skills:
- Education: Bachelor’s degree in Computer Science, Information Technology, Database Management, or a related field.
- Experience:
- 3-5 years of experience as a Database Administrator, managing and maintaining large-scale databases.
- Strong experience with popular relational databases such as SQL Server, Oracle, MySQL, or PostgreSQL.
- Experience with cloud-based databases (e.g., AWS RDS, Azure SQL, Google Cloud SQL) is a plus.
- Familiarity with database replication, clustering, and high-availability technologies.
- Proven experience with database backup, recovery, and disaster recovery procedures.
- Technical Skills:
- In-depth knowledge of SQL, T-SQL, PL/SQL, and other database query languages.
- Familiarity with database management tools, monitoring systems, and performance tuning techniques.
- Experience with database security, access control, and encryption techniques.
- Understanding of indexing, query optimization, and caching techniques to improve database performance.
- Experience with data migration, data warehousing, and ETL processes.
- Knowledge of database monitoring tools (e.g., SolarWinds, Redgate, or similar).
- Familiarity with scripting languages (e.g., PowerShell, Python) for automation tasks is a plus.
- Soft Skills:
- Strong problem-solving skills and the ability to troubleshoot complex database issues.
- Excellent communication skills to work effectively with both technical and non-technical teams.
- Ability to manage time efficiently and prioritize multiple tasks in a fast-paced environment.
- Attention to detail and a strong commitment to data integrity and security.
- Ability to work independently and as part of a collaborative team.
- Certifications (preferred):
- Microsoft Certified Database Administrator (MCDBA), Oracle Certified Professional (OCP), or similar certifications.
- AWS Certified Database – Specialty or Google Cloud Professional Database Engineer is a plus.
- ITIL Foundation certification is beneficial.