Database Developer

Design database schema tables, stored procedures, views, functions, triggers, and indices to meet the application performance requirement.Design, develop and maintain ETL solutions for the data warehouse.Design, develop and maintain business reports for other departments.Design and write queries to extract data for ad hoc requests from other departments.Optimise databases to improve performance.Develop, manage, and test database backup and recovery plans.Review code and advise and guide developers on best practices for database queries and procedures.Provide consultation on issues related to data in the production environment.Carry out capacity planning and cost optimisation.Write and maintain database design documents.Monitor Quality Acceptance testing and User Acceptance Testing of the database.Troubleshoot and provide root cause analysis of major incidents and problems.Internal team training on anything database related.Maintain and administer databases in the test and staging environment.Prepare database deployment scripts and assist with production deployment.Assist Developers and Testers with database activities.