Role overview

Qualifications

Five (5) years’ combined experience in PostGRES and SQL Server database management, including 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 Oracle database management

Responsibilities

Create and maintain a PostGRES data warehouse on AWS
Migrate data to the data warehouse
Work with business to identify and create datasets for data analytics
Create, automate, and maintain ETL for data migrations and submissions

Key facts

Remote from: Anywhere
Fixed term
Senior (5-10 years)
Database Administrator
English

Hard skills

PostgreSQL Data Migration Amazon Web Services Database Administration Database Architecture Data Modeling Xplenty (ETL Tools) Database Schema Performance Analytics Database Security Advanced Design Systems

Other skills

Knowledge Transfer

About the company

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.

Company details

Company size2 - 10

Links

LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

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

Benefits

Remote work, Health, PTO

Salary: 70000