Vacancy expired!
Description:
Physical Data Modeler/Application DBAKEY JOB FUNCTIONSDesign, structure, and maintain one or more Aurora PostgreSQL discrete databases used by Connect or Housing Data Exchange. Test, quality control, and performance tune data to ensure its integrity and reliability. Confer with business unit and technical staff regarding the extracting of data for reports or application components. Monitor or accomplish the migration of historical data in Netezza and Oracle to Aurora PostgreSQL and the DB performance of refreshing of data. Tune reporting queries and data stores to maximize the performance of operational and analytics reports being migrated to Aurora PostgreSQL. Create optimized SQL to pull data insights for Angular front end Confer with application development staff or project management staff regarding project planning, resource allocation, task definitions and schedules for substantial projects involving database(s). Plan and design database changes necessary for data conversion, tool configuration, data refresh or migration or other initiatives related to large application development project. Troubleshoot or confer with others troubleshooting errors or production problems involving databases to determine causes and proposed solutions. Document the application data model in enterprise modeling tools and record use of databases with objectives of data integrity, data security, efficient operation, audit requirements, and the like. Document the application dataset in accordance with enterprise data governance standards Communicate to others in development or database administration roles.Required Knowledge and Skills Relational and dimensional data modeling skills. Database design and implementation in AWS Aurora PostgreSQL Performance tuning techniques in an AWS Aurora PostgreSQL DevOps tool: Flyway Years of experience: 5min years of experienceDesired Knowledge and skills Experience using data modeling tools like ER Studio or ERWin Experience working with the AWS Glue Meta store Experience with S3 and file storage designs such as Parquet, Avro, CSV, etc. Experience working with JSON file formatsQualification RatingMust Have Specialized SkillsAWS CodebuildYesAWS CodeCommitYesAWS CodedeployYesAWS ElasticCache (Redis)YesAWS EMRYesFNMACompany Default Category1-5 years data modeling experience1 yearsAbility to translate high level business requirements into data flow diagramsBachelor degree in Computer Science, Information Systems, Mathematics, Engineering or related fieldYesKnowledge in data modeling tools, such as ERWINPost-graduate degree desired (for positions requiring 3+ years experience)YesStrong analytical skillsStrong communication skills (written and verbal)Strong knowledge of DBMSVacancy expired!