Offer summary

Qualifications:

Five years of experience in PostGRES and SQL Server database management., Three years of experience in database migration using ETL tools., Experience with AWS data warehousing and data analytics support., Knowledge of database architecture and security implementation..

Key responsabilities:

Create and maintain a PostGRES data warehouse on AWS.

Migrate data to the data warehouse and automate ETL processes.

Work with business teams to identify datasets for analytics.

Perform database performance tuning and respond to work requests.

Job description

This is a remote position.

The Contingent Plan is actively recruiting an experienced database administrator for its client based in the Twin Cities. This is an immediate need and our client will move quickly with the right candidate.

This W2 role is a temporary assignment that is expected to last 6 months with a potential for renewal. The opening is fully remote, but the client has a preference for candidates in the upper Midwest. Compensation is competitive and depends on experience. Sorry, there is no sponsorship available at this time.

Responsibilities:

Create and maintain a PostGRES data warehouse on Amazon Web Services (AWS)
Migrate data to the data warehouse
Work with business to identify and create datasets for data analytics
Create, automate, and maintain ETL (Extraction, Translate, Load) for data migrations and submissions
Maintain PostGRES and SQL Server instances, schemas, and tables located on AWS
Create basic data models and documentation
Implement best practices for PostGRES and SQL Server
Respond to and carry out database work requests
Perform performance tuning and optimization as applicable
Implement database security as applicable
Provide knowledge transfer to internal staff
Perform other related duties as assigned

Requirements

Five (5) years’ combined experience in PostGRES and SQL Server database management, which includes at least one (1) year of experience in each of these databases
Three (3) years’ experience in database migration using ETL tool(s)
Three (3) years’ experience with data warehousing, including at least six (6) months of experience with AWS data warehouse
Experience with creating and supporting data repositories for data analytics
Experience with database architecture
Experience with Oracle database management
Experience with data modeling
Experience with advanced analytical design tools
Experience with disaster and recovery planning
Experience as a senior database administrator
Experience with performance analysis tool(s)
Experience with implementing database security