Database Engineer - Patching and Vulnerability Management

HCL SINGAPORE PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

HCL SINGAPORE PTE. LTD. is seeking an experienced Database Administrator to manage patching and vulnerability management across Oracle, MSSQL, Postgres and MariaDB environments.

You will design and maintain DBs for development, testing and production, plan capacity, backups and recovery, and enforce security policies. The role requires 8–12 years in DB administration, working on RHEL, and strong troubleshooting skills. You’ll participate in DR planning and SLA-driven support in a dynamic team.

Qualifications

• 8-12 years of Experience in Database System Administration.
• Bachelor’s Degree in Computers Science or relevant.
• Database Administration of Oracle/MSSQL/Postgres/Maria DB.
• Working experience on RHEL Servers.
• Knowledge on DB HA/DR.
• Patch management and Vulnerability Management (Must Have)
• Troubleshooting skills in DB related issues (Must Have).
• Extensive Experience in DB patching. (Must Have).
• Experience on Patch management tools like BigFix, SCCM etc. (Must Have)
• Perform Patch assessment and recommend/plan deployment.
• Experience on Automation of Pre and Post patching tasks.
• Knowledge on DB management tools.
• Log monitoring/maintenance.
• Excellent Verbal and written communication skills.

Responsibilities

• Create and maintain all databases required for development, testing, and production usage including rollout and upgrade.
• Perform the capacity planning required to create and maintain the databases.
• Plan and implement backup and recovery of the databases.
• Execution of data migration jobs and scripts as required.
• Implement and enforce security for all of the Databases.
• Monitor and measure the performance and availability of database system proactively; daily check the scheduled database backups and jobs; implement corrective actions identified to improve performance and availability.
• Contribute to the creation and maintenance of disaster recovery plans.
• Determine and document DB policies, procedures and standards.
• Put standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
• Respond promptly to incidents, investigate and provide temporary &/or permanent solution of incidents escalated, provide timely status update to relevant parties.
• Participate in community sharing with other DBAs of IDEMIA Public Security division.
• All other database administration responsibilities as assigned.
• Participate in system integration test, system validation test, load and performance test, and high availability test.
• Investigate on the issues by analyzing logs during test execution, report incidents through configuration management tool and monitor them until closure.
• Produce documents related to installation, testing or operational and administration
• Provide training to customer and handover system to maintenance support team.
• Any other duties as assigned.

Skills

Patch management

Vulnerability management

DB maintenance

DB monitoring

Incident response

SLA adherence

Automation of patch tasks

Education

Bachelor's Degree in Computer Science

Tools

BigFix

SCCM

Job description

Main purpose of the role

To be responsible for the patching and vulnerability management of all Database like Oracle, MSSQL, Postgres and Maria.

Roles & Responsibilities

• Create and maintain all databases required for development, testing, and production usage including rollout and upgrade.
• Perform the capacity planning required to create and maintain the databases.
• Plan and implement backup and recovery of the databases.
• Execution of data migration jobs and scripts as required.
• Implement and enforce security for all of the Databases.
• Monitor and measure the performance and availability of database system proactively; daily check the scheduled database backups and jobs; implement corrective actions identified to improve performance and availability.
• Contribute to the creation and maintenance of disaster recovery plans.
• Determine and document DB policies, procedures and standards.
• Put standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
• Respond promptly to incidents, investigate and provide temporary &/or permanent solution of incidents escalated, provide timely status update to relevant parties.
• Participate in community sharing with other DBAs of IDEMIA Public Security division.
• All other database administration responsibilities as assigned.
• Participate in system integration test, system validation test, load and performance test, and high availability test.
• Investigate on the issues by analyzing logs during test execution, report incidents through configuration management tool and monitor them until closure.
• Produce documents related to installation, testing or operational and administration
• Provide training to customer and handover system to maintenance support team.
• Any other duties as assigned.

Requirement

• 8-12 years of Experience in Database System Administration.
• Bachelor’s Degree in Computers Science or relevant.
• Database Administration of Oracle/MSSQL/Postgres/Maria DB.
• Working experience on RHEL Servers.
• Knowledge on DB HA/DR.
• Patch management and Vulenrability Management (Must Have)
• Troubleshooting skills in DB related issues (Must Have).
• Extensive Experience in DB patching. (Must Have).
• Experience on Patch management tools like BigFix, SCCM etc. (Must Have)
• Perform Patch assessment and recommend/plan deployment.
• Experience on Automation of Pre and Post patching tasks.
• Knowledge on DB management tools.
• Log monitoring/maintenance.
• Excellent Verbal and written communication skills.
• Good interpersonal Skills.
• The candidate should have worked in a SLA driven environment.
• Ability to work in a flexible, team-oriented and constantly changing environment.
• Able to work on weekends as per Roster and perform On-call support (during weekdays) as and when needed.