Key Facts

Remote From:

Anywhere

Fixed term

Senior (5-10 years)

English

Hard Skills

Other Skills

•
Communication
•
Teamwork
•
Knowledge Transfer
•
Problem Solving

Roles & Responsibilities

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

Requirements:

Create and maintain a PostGRES data warehouse on Amazon Web Services (AWS)
Migrate data to the data warehouse
Create, automate, and maintain ETL (Extraction, Translate, Load) for data migrations and submissions
Perform performance tuning and optimization as applicable

The Contingent Plan

About The Contingent Plan

The Contingent Plan helps real people land the right jobs to advance their careers. Our method was developed after studying, using, and testing methods built from the ATS. Our proprietary approach is also grounded in the knowledge of recruiters about the market, insights from employers, and technology-powered messaging to stand out at each step of your job search and career. We provide resume writing, cover letters, LinkedIn profiles, coaching and more. Our methods are grounded in technology, tested continuously, and proven to work. We help people ready to land their dream job to navigate the ever-changing talent acquisition technology landscape to achieve results. The results speak for themselves. Claim your free consult today to find out if our team can help you stand out.

Founded: 2018

Company size: 2 - 10

LinkedIn See all jobs →

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