Job Description

The Database and Data Warehouse Specialist requires specific technical knowledge about the administration and control of the data warehouse environment, including the database, operating systems and tools. Responsibilities include Installation, Maintenance, and Design, Development and Management of OLTP / OLAP databases in Microsoft or Oracle environments. - Installation, Development and management for new data warehouse. - Prepare plans for all ETL procedures and architectures. - Analyze various data warehouse objects. - Evaluate all codes and ensure quality of all project deliverables. - Working closely with the Basic Software Group (BSG) manager and internal customers to design, develop and maintain reports / analytics capability. - Managing the database aspects of the reporting and analytics platform(s) to ensure that reporting jobs are successfully run and analytics data aligns to timeliness / completeness requirements. - Creating, modifying the database structure, as necessary, from information given by application developers - Working on database to ensure that the database and data warehouse is tuned for optimal performance. - Working with business analysts and project managers to develop and refine reporting and analytics requirements. - Ensure that the physical designs for the data warehouse and its data structures align with IT strategies, architecture frameworks and logical data models. - Planning for backup and recovery of database information - Troubleshooting technical issues, finding the root cause and designing, proposing, and implementing solutions