KEY JOB FUNCTIONS
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
Performance tuning techniques
Years of experience: 5min years of experience
Desired 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 formats
•
Last updated on Jul 22, 2021