Database Support Engineer
The Database Support Engineer undertakes complex projects requiring additional technical knowledge and makes decisions on ambiguous administrative and support issues. He/ She applies highly developed specialist knowledge and skills in database administration. He implements database improvements and provide the necessary advice on setting up new databases, optimizing database performance, and resolving issues that arise during the set-up and update on databases. He is also responsible for resolving database related incidents and ensuring database security and integrity controls are in place. He works in a team setting and is proficient in database administration, database management-related tools and techniques required by the organization. He is also familiar with the relevant software platforms on which the database is deployed on. The Database Support Engineer is able to methodically identify causes of complex issues, evaluate it and develop solutions in collaboration with the team. He is able to communicate effectively and displays high service level standards.
Skills and Competencies
Technical Skills & Competencies
Generic Skills & Competencies
Critical Work Functions and Key Tasks
• 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
• 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
• Develop database requirements based on requirements and business needs analysis
• Conduct risk assessment and analysis of proposed database design
• Interpret internal or external business issues and recommends solutions and/or best practices
• Translate logical data models into physical database designs
• 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
• Translates logical data models into physical database designs
• 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
• Investigate escalated of database issues to determine potential solutions
• Ensure 24 x 7 production support and/or database access
• Oversee adherence to organizational database procedures, policies and protocols