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.