Key Facts

Remote From:

Fixed term

Senior (5-10 years)

English

Hard Skills

Oracle CRM PostgreSQL Microsoft SQL Server Data Engine (MSDE) Performance Systems Analysis Data Modeling Performance Analytics Data Migration Database Schema Database Design Database Administration Database Management Tableau (Business Intelligence Software) Data Warehouse Architectures Data Cleansing Analytical Procedures Amazon Web Services Internal Documentation

Other Skills

•
Consulting
•
Knowledge Transfer

Roles & Responsibilities

Five years combined experience in SQL Server, Oracle, and PostGRES DB management with at least 6 months in each
5+ years experience in database migration using ETL tools
5+ years experience with performance analysis tools
Prior consulting experience with at least 6 months in lead database administration; AWS experience preferred

Requirements:

Maintain SQL Server, Oracle, and PostGRES instances, schemas, and tables (cloud and on-premises)
Implement database best practices and perform performance tuning for SQL Server, Oracle, and PostGRES
Create and maintain ETL processes and data sets for Tableau; develop basic data models and documentation
Assist with data warehouse projects and transfer knowledge/documentation to staff

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 the client will move quickly with the right candidates. Compensation is competitive and depends on experience.

This is a temporary assignment that is expected to last 6 months. The assignment will likely be extended based on performance and the client's needs. The role is 40 hours/week and it may be performed remotely. There is a preference for candidates in the upper Midwest. But, the client will consider candidates outside of this region based on qualifications. Sorry, no sponsorship is available at this time.

Responsibilities:

Maintain SQL Server, Oracle, and PostGRES instances, schemas, and tables located on the Amazon Cloud
Maintain SQL Server instances, schemas, and tables hosted at the enterprise
Create basic data models and documentation
Identify unused or duplicate tables for deletion
Implement best practices for SQL Server, Oracle, and PostGRES
Respond to and carry out database work requests
Perform performance tuning and optimization as applicable
Create and maintain ETL (Extraction, Translate, Load) for data submissions
Create data sets for Tableau use
Assist with database aspect for projects including setting up a data warehouse and software rewrites
Create documentation for work completed and transfer knowledge to staff

Requirements

Five years combined experience in SQL Server, Oracle, and PostGRES database management including at least 6 months in each of these databases.
5+ years experience in database migration using ETL tools
5+ years experience with performance analysis tools
Prior consulting experience with at least 6 months each in lead database administration
Prior experience with AWS preferred
Experience with advanced analytical design and data modeling experience a plus
Able to pass all required background checks.
Capable of completing the entire engagement
Able to work remotely with reliable internet and attendance