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
- Bachelor`s degree in a related field; master`s degree (or equivalent work experience) and Microsoft certifications are a plus. - Experience with Microsoft data analysis and Modelling tools (SSIS, SSAS) - Proven experience working with query languages including T-SQL, MDX, Power Shell and PL/SQL. - Having good experience of query optimization and performance tuning - Experience in using Source Control Software like Team Foundation Server - Experienced in using any Agile Project Management tool like JIRA - Experience in creating / maintaining as-built documentation owned jointly across a team. - Strong commitment to deadlines and to client service (internal and external) - Strong organizational skills and attention to detail - Ability to work well and deliver under pressure.
Register for free Use
and speed up job searching