DELOITTE CONSULTING LLP – $157,144.00/Year

Masters degree or foreign equivalent in Business Administration, any STEM field, or a related field. Must have 3 years of related work experience in the job offered or in a related occupation. In the alternative, the employer will accept a Bachelors degree or foreign equivalent and 5 years of progressive related work experience.br br Position requires 3 years of related work experience in each of the followingbr Working in multidimensional data modeling including star schemas, Snowflake, and normalized and denormalized models, utilizing erwin Data Modeler;br Participating in major database administration tasks including root cause analysis, troubleshooting, optimizing, and monitoring connections by leveraging Oracle Enterprise Manager, Amazon Web Services AWS Relational Database Services RDS Performance Insights, and Oracle EXPLAIN PLAN;br Architecting, developing, testing, and documenting Data Integration and Migration ETL Extract, Transfer, Load solutions and frameworks built on platforms using PLSQL and PLpgSQL procedures and scripts;br Utilizing erwin Data Modeler for designing, reviewing, reverse engineering, and documenting logical and physical data models including Star and Snowflake schemas;br Working with client CIO organization and business teams to develop, review, finalize, and document Business Intelligence including reporting and dashboard requirements based on the identified key performance metrics, utilizing AWS RDS Performance Insights, CloudWatch alarms, and AWS Lambda and Glue;br Guiding database administration tasks using Oracle Recovery Manager RMAN and Oracle Data Pump for development and test databases, including planning, developing, testing, and documenting backup and recovery procedures, database version upgrades, and export and import procedures for data dumps; andbr Developing platform installation guides for Oracle, PostgreSQL, and Git and Bitbucket installations for database source code check in.br br Any suitable combination of education, training, or experience is acceptable.