Act as a team member, providing essential support to the Data Services Lead in the day-to-day operations of the Data Services team. This support aims to ensure the consistent delivery of high-quality services, uninterrupted system uptime, and round-the-clock accessibility of data services to support the University's diverse business systems.
Responsibilities:
- Act as the Subject Matter Expert for data services-related products (Oracle, MSSQL, MySQL, WebLogic, WebSphere, JBoss, IIS, ASP.NET)
- Manage daily BAU operation of database and middleware (DB&MW) related services.
- Provide Level 2/3 support for DB&MW service-related queries.
- Monitor DB&MW services availability and performance; proactively fine-tune its configurations to meet RTO.
- Monitor and plan the capacity to meet the demands of the application workload.
- Monitor and plan the backup schedules to meet RPO and comply with the data retention policy.
- Create and maintain documentation of standard operating procedures (SOPs) for DB&MW administration, contributing to the knowledge base and facilitating knowledge transfer.
- Create and implement automation scripts using tools such as PowerShell, Ansible, Python, etc to streamline deployment processes and reduce manual intervention.
- Review and implement security best practices and apply regular ad-hoc security patches to ensure compliance with IT security policy.
- Coordinate/Support with the application support teams for scheduled downtime such as DB&MW patching and upgrade.
- Perform incident escalation in accordance with escalation procedures.
- Coordinate with other functional teams and product support in incident handling, and ensure incidents are resolved or workaround within stipulated SLAs.
- Provide input and finding for root-cause analysis.
Implementation of IT Initiatives and Solutions
- Provide consultancy on data infra design for new systems.
- Lead and drive data services initiatives and manage project deliverables.
- Identify and drive the optimal solution for NTU and manage the implementation of these solutions.
- Lead migration projects to transition applications to new DB&MW platforms, ensuring smooth transitions and minimal impact on operations.
Requirements:
- A recognized degree in IT, Computer Science or related fields
- Hand-on technical skills and know-how in administering database products (e.g., Oracle, MSSQL, MySQL database, and PostgreSQL) and related high availability technologies (e.g. RAC, Data Guard, AG).
- Hands-on technical skills and know-how in administering middleware products (e.g., WebLogic, WebSphere, JBoss, IIS, ASP etc).
- At least 6 years of hands-on experience in database and middleware administration in an enterprise or campus environment.
- Experience in Windows, and Linux variants, preferably Red Hat and Ubuntu.
- Possess relevant DevOps skillset and scripting skills for system automation, e.g., PowerShell, Ansible, Python etc.
- Familiar with high-availability technologies and solutions
- Proven track record of troubleshooting and resolving complex technical issues.
- Experience in system, database and application performance tuning.
- Experience in capacity planning, availability management and business continuity management
Skills & Competencies
- Project management skills.
- Outsourcing vendor management skills.
- Documentation skills and ability to create clear and comprehensive SOPs.
- Collaboration and communication skills, with the ability to work effectively in cross-functional teams.
The following certifications while not necessary, will be an added advantage:
- Data, Analytics, AI&ML Literacy
- Cloud Literacy and Administration
- Database Certified Professional
- Red Hat Certified System
- ITIL Foundation Level
The suitable candidate should demonstrate the following characteristics:
Independence: The candidate must possess a strong ability to work autonomously, showing initiative and self-motivation. They should be comfortable taking ownership of tasks and projects and be capable of working effectively without constant supervision.
Resourcefulness: The candidate should have a knack for resourcefulness, being adept at independently locating the necessary materials or information required to complete tasks and make informed decisions. This involves proficient research and information-gathering skills.
Inquisitiveness: The candidate should exhibit a keen curiosity and willingness to ask questions when faced with ambiguity or uncertainty. They should actively seek out answers and engage in effective communication to clarify doubts and find the right solutions.
Interpersonal Skills: Possessing excellent interpersonal skills is vital for working collaboratively with diverse personalities within the organization. The candidate should foster positive working relationships and be adaptable to different communication styles and team dynamics.
Problem-Solving Proficiency: Strong problem-solving skills are a must. The candidate should demonstrate the ability to analyze complex issues, break them down into manageable components, and develop innovative solutions. Their analytical mindset should contribute positively to our organization's growth and development.
