Database Support Engineer

Oversee service level agreements and service improvements

• Manage the development of service-level objectives and targets
• Monitor service level objectives to ensure that requirements are met or exceeded
• Develop client satisfaction metrics and service procedures
• Propose recommendations to improve performance and client satisfaction

Oversee database administration

• Advise senior management on database concepts and functional capabilities and implementation procedures
• Perform upgrades of databases, new structures or elements
• Build scripts to automate the daily operations of database management
• Install, configure and maintain the database management systems software
• Manage the migration of databases

Design and develop new database

• Develop database requirements based on requirements and business needs analysis
• Conduct risk assessments and analysis of proposed database designs
• Interpret internal or external business issues and recommends solutions and/or best practices
• Test new databases to ensure performance and smooth operations during deployment
• Verify stored procedures and functions for accessing, maintaining and populating databases
• Lead research initiatives to explore advances and automated approaches for database administration
• Translate logical data models into physical database designs

Optimise database performance

• Explore opportunities to optimise the delivery of database services with emphasis on availability, reliability, scalability, and security
• Conduct database audits and maintenance
• Develop automated processes to define, measure, and report on service quality, stability and capacity
• Monitor, analyse and calibrate DBMS parameters to ensure database is tuned for optimal performance
• Forecast utilisation patterns and propose modifications or upgrades
• Conduct application transaction volume and traffic analysis, and interpret the impact on database performance

Resolve database incidents

• Investigate escalated of database issues to determine potential solutions
• Ensure 24 x 7 production support and/or database access
• Oversee adherence to organisational database procedures, policies and protocols

Manage database security

• Design security and data integrity controls
• Maintain and monitor database security, integrity and access control
• Recommend and implement database solutions to support data integrity efforts
• Implement required security controls designed around data and databases
• Provide audit trails to detect potential security violations

Business and Project Management

Implement business continuity and contingency procedures and exercises

Operations and User Support

Develop incident management procedures and synthesise incident-related analyses to distil key insights, resolve incidents and establish mitigating and preventive solutions

Operations and User Support

Determine the business need for data migration and plan data migration activities, establishing guidelines and strategies to minimise impact on daily business operations

Operations and User Support

Plan for installation, configuration and upgrading of databases and oversee database maintenance, troubleshooting, back up and recovery activities

Strategy Planning and Implementation

Generate insights to support strategic plans, systems and guidelines for IT, and evaluate the potential costs and value of new IT programmes

People Development

Support employees to develop their skills and facilitate learning opportunities and coaching junior management employees

Operations and User Support

Establish metrics and mechanisms to assess network, software or system performance, and determine Infocomm Technology (ICT) infrastructure components and parameters to be enhanced

Business and Project Management

Analyse and develop, review of plans for process improvement and optimisation

Business and Project Management

Plan and drive medium scale projects or programmes, including allocating resources to different parts, and engaging stakeholders on the project's progress and outcomes

Stakeholder and Contract Management

Develop a stakeholder engagement plan and negotiate with stakeholders to arrive at mutually-beneficial arrangements

Operations and User Support

Plan the administration and technical operationalisation of security programmes, and investigate security breaches in information, system and network access

Business and Project Management

Elicit and analyse business requirements from key stakeholders and assess relevant solutions and their potential impact

Development and Implementation

Develop and update a configuration management plan, determining systems and techniques to track changes and revisions

Development and Implementation

Implement data management processes and systems to map data sources, processes and relationships, and transform and process multiple streams of data

Operations and User Support

Diagnose, troubleshoot and provide end-to-end management of infrastructure disruptions or technical issues encountered by users, and plan infrastructure upgrade activities

Operations and User Support

Determine the IT assets to be procured and guidelines for proper handling, storage and maintenance, and manage the phase-in and phase-out of IT assets

People Development

Implement performance management programmes

Operations and User Support

Handle specific problems from diagnosis and prioritisation to the identification and implementation of solutions

Stakeholder and Contract Management

Prepare Requests for Proposals (RFP), and assess them against selection criteria and technical specifications, implementing security due diligence review in the vendor selection process

Strategy Planning and Implementation

Analyse strategies for critical business functions to ensure plans are within risk mitigation factors