Job Title:
Database Administrator
Overview: (Summary of the role)
The DBA resource(s) personnel assigned must be a certified MS SQL/Oracle DB/DB2 Administrator in administration and troubleshooting, in a 24x7 enterprise setting (inclusive of manual discovery or post actions from automatic alerts). He/she is/are expected to cover level 1 and level 2 database related problems and must be an experienced DBA in the following areas but not limited to the following competencies:
Responsibilities:
(Describe the important end results of the job, i.e., what has to be achieved and why. Start with the most important and number each one separately)
• Experienced with Oracle DB and Microsoft SQL Server.
• Experienced with Microsoft Windows Server, Unix system and Linux system.
• Responsible for the day-to-day operational aspects of database administration to meet the business needs and service level.
• Manage database changes through change request process & provide status reports to the relevant parties.
• Provide 1st and 2nd level operational database support.
• Assist and respond promptly to incident, investigate & provide temporary &/or permanent resolution of incidents escalated. Provide timely status updates to relevant parties.
• Monitor & measure the performance & availability of databases proactively; implement corrective actions identified to improve performance & availability.
• Monitor the agreed service level, document & maintain the configuration of the databases; provide regular reporting to relevant parties.
• Ensure service level meet requirement. Propose and implement action plan when required. Monitor databases according to standard operations procedures.
• Involve in the implementation of service continuity measures, i.e., backup/restore procedures & disaster
recovery plan, to ensure continuous operation of the business.
Requirements:
(Indicate the qualifications, education, associated training, background knowledge, skills and attributes to perform the job competently)
• Diploma/Degree in Information Technology/Computer Science or equivalent.
• At least 2 years of experience in Oracle/MS SQL database administration.
•
Good knowledge in Database design and implementation.
•
Good knowledge on backup and recovery (RMAN, expdp/impdp etc)
•
Experience on RAC, ASM and data guard
•
Experience in MS SQL Server administration
•
Experience supporting Singapore government agencies with security clearance.