Job description

St.Paul, MN (Remote): Database Administrator ($70K-$150K)

• Application deadline 05/16/2023, first come first serve

• Salary $70K-$150K with medical, dental, vision insurance

• This position is for the State of Minnesota government

• Accept OPT, H1B, H1B transfer, Green-card, US/Canadian citizen

• Support H1B and Green-card application

• OpenKnect is a prime vendor for the State of Minnesota government

• $1,000 Referral Reward

Job Description

Sample Tasks

· Maintain SQL Server, Oracle, and PostGRES instances, schemas, and tables located on the Amazon Cloud

· Maintain SQL Server instances, schemas, and tables hosted at MNIT

· 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

· Provide knowledge transfer to State staff

· Perform other related duties as assigned

Minimum Qualifications

· Five (5) years’ combined experience in SQL Server, Oracle, and PostGRES database management, which includes at least six (6) months of experience in each of these databases

· Five (5) years’ experience in database migration using ETL tool(s)

· Five (5) years’ experience with performance analysis tool(s)

· Two (2) engagements lasting at least six (6) months each in lead database administration roles

Desired Qualifications

· Experience with Amazon Web Services (AWS)

· Experience with data modeling

· Experience with advanced analytical design tools

· Experience with disaster and recovery planning

· Experience with cost benefit analysis

· Experience with three tier architecture concepts and configurations

Job Type: Full-time

Pay: $70,000.00 - $150,000.00 per year

Benefits:

• Dental insurance
• Health insurance
• Vision insurance

Schedule:

• 8 hour shift

Ability to commute/relocate:

• Saint Paul, MN 55155: Reliably commute or planning to relocate before starting work (Required)

Education:

• Bachelor's (Required)

Experience:

• SQL Server: 5 years (Preferred)
• Oracle: 5 years (Preferred)
• PostGRES: 5 years (Preferred)
• ETL: 5 years (Required)
• performance analysis tool(s): 5 years (Required)
• AWS: 5 years (Required)
• data modeling: 5 years (Required)

Work Location: Hybrid remote in Saint Paul, MN 55155

randomorbitinc.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, randomorbitinc.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, randomorbitinc.com is the ideal place to find your next job.