Assistant Lead Engineer - DBA, SQL, Oracle (Cluster Office)

Overall Summary:

This position will assume responsibility for the existing portfolio of tasks and projects currently managed by the departing team member to ensure seamless business continuity. The role involves maintaining established workflows, client relationships, and operational responsibilities that are critical to the team's ongoing performance.

The Associate Database Support Engineer identifies, tests and deploys all database technologies and support tools. He/She ensures system improvements are successfully implemented and is responsible for verifying all data to be entered into database meets set standards and requirements as well as installing, configuring and maintaining the database infrastructure within assigned span-of-control. Assists in project planning by establishing work plans, estimates, milestones and schedules. He/She is required to be on standby with on-call availability to resolve database related incidents. Works in a team setting and is proficient in database administration, database management-related tools and techniques. Familiar with the relevant software platforms on which the database is deployed. The Associate Database Support Engineer is able to quickly and effectively solve issues as they arise. Able to methodically identify the cause of the issue, evaluate it and develop a solution in collaboration with the team. 

Roles & Responsibilities:
Oversee database administration
• Maintain development, production and multiple testing environments
• Assist in upgrades of databases, new structures or elements
• Assist in installation, configuration and maintenance of database management systems software
• Implement database back-up and recovery procedures

Design and develop new database
• Assist in business needs analysis for database design
• Assist with testing of new database procedures and protocols
• Assist in establishing database system flows
• Maintain data documentation and metadata models
• Code, edit and install stored procedures and functions for accessing, maintaining and populating databases

Optimise database perfomance
• Perform ongoing optimisation of database components to ensure availability, reliability, scalability, and security
• Assist with database audits and maintenance activities
• Maintain documentation of database optimisation activities
• Track key operational metrics, performance, utilisation, throughput and capacity for reporting
• Ensure optimal database performance and availability

Resolve Database Incidents
• Identify and resolve database issues
• Determines appropriate course of action for resolving database issues, identify and mitigate risks
• Escalate unresolved database issues
• Ensure adherence to organisational database procedures, policies and protocols

Manage databse security
• Implement database security and data integrity controls
• Control privileges and permissions to database users
• Adhere to information security policies, procedures and protocols in all tasks

Security and Compliance
• Ensure systems meet top security standards and comply with regulations.
• Conduct security audits and implement corrective actions.

Qualifications/ Requirements:

• Bachelor in Computer Science or equivalent
• At least 3-5 years in the relevant field 
• Strong experience in SQL query and Oracle 
• Additional advantage is to have experience to have AWS experience, RDS (Amazon Relational Database Service) and Unix experience 
• Able to communicate effectively and displays high service level standards.
• Open to support 24/7 standby
• 2 years Direct Contract