Data Base Administrator

Job Qualification

• Bachelor's degree in information technology, Computer Science, Information Systems, or a related field.
• Proven experience as a Database Administrator or in a similar database management role.
• Strong knowledge of database management systems such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, or other relational databases deployed in Cloud and on-premises.
• Knowledge in Microsoft Fabric, Azure Data Factory, Azure Databricks is a plus.
• Experience in database installation, configuration, maintenance, backup, and recovery.
• Knowledge of database security, performance tuning, and optimization.
• Proficiency in SQL programming, queries, stored procedures, and database troubleshooting.
• Familiarity with operating systems such as Windows and Linux.
• Understanding of disaster recovery, high availability, and data replication technologies.
• Strong analytical, problem-solving, and organizational skills.
• Excellent communication and teamwork abilities.

Key Responsibilities

• Proficient in working with various types of databases such as but not limited to, Microsoft SQL, MySQL, Oracle, PostgreSQL, Amazon RDS and Aurora.
• Responsible for administrating databases hosted in both on-premises and cloud environment such as but not limited to Microsoft Azure, Amazon Web Service, Google Cloud Platform and Alibaba Cloud, in terms of provisioning and managing database instances, setting up replication and high availability, and monitor database performance.
• Inspect and confirm database backup is valid, database cronjobs and inform respective job owner on any job failure.
• Monitor and perform rectification to issues found in system logs, error logs and dump files, table spaces to detect those reaching threshold, objects reaching max extents and increase extents if required.
• Regular inspection on database objects, database schemas, database links, database users to verify if those inactive ones are required. Housekeeping of logs & dump files to control utilization of storage space.
• Monitor for database locks and remove invalid session threads, database and listeners to be up and running at high availability.
• Monitor for processes consuming CPU or virtual memory or with disk I/O higher than threshold values.
• Provide necessary assistance in shutting down and starting up databases for the periodic system maintenance done during off-peak hours.
• Perform database patching at indicated time, patching is to be tested successfully in test environment prior to applying in production.
• Assist with immediate critical security patching at indicated time, patching is to be tested successfully in test environment prior to applying in production.
• Provide investigation into reported issues suspected to be caused by database and perform remediation.
• Provide support such as execution of database scripts, object deployment, database user management.
• Perform database refresh from production to test environment.
• Conduct reporting on the database health check, growth, and activities with recommendation for tuning of database to improve performance.
• Provide listing on reported issues indicated with SLA compliances.
• Work with database supplier to rectify issues related to the core product.
• Test changes to database in a test environment prior to applying in production.
• Maintain proper, relevant, and updated documentation of managed databases including design, setup configuration, performance tuning changes, troubleshooting-specific procedures and required reports.