Working Title: Senior Database Administrator
Job Class: Information Technology Specialist 5
Agency: Minnesota IT Services
- Who May Apply: Open to all qualified job seekers
- Date Posted: 09/06/2023
- Closing Date: 09/19/2023
- Hiring Agency/Seniority Unit: Minnesota IT Services
- Division/Unit: Department of Natural Resources
- Work Shift/Work Hours: Day Shift
- Days of Work: Monday – Friday
- Travel Required: No
- Salary Range: $35.50 – $60.70 / hourly; $74,124 – $126,741 / annually
- Job Class Option: Data Systems
- Classified Status: Classified
- Bargaining Unit/Union: 214 – MN Assoc of Professional Empl/MAPE
- FLSA Status: Exempt – Professional
- Telework Eligible: Yes – #LI-Hybrid
- Designated in Connect 700 Program for Applicants with Disabilities: Yes
Make a difference in the lives of Minnesotans.
The work you’ll do is more than just a job. Join the talented, engaged and inclusive workforce dedicated to creating a better Minnesota.
Join the 2,500+ professionals of Minnesota IT Services (MNIT) who connect Minnesotans to services that will improve their lives. This position serves our partners at the Minnesota Department of Natural Resources (DNR). MNIT DNR provides comprehensive IT operations and support services, custom application development, and dedicated support functions to an organization that manages and conserves the state’s natural resources in a way that creates a sustainable quality of life for all Minnesotans.
Job Summary
As a Senior Database Administrator, you will provide leadership and technical expertise for the design, development, security, backup and recovery, operation, and performance tuning of all DNR Oracle, PostgreSQL, Microsoft SQL Server and MySQL databases and related infrastructure. The position is a focal point for all database development, and advises application developers and data managers in the department on database development standards, data integrity and accessibility, and. This position is also responsible for coordinating and administering DNR data warehouses.
This position is currently eligible for full-time telework:
- Telework for Minnesota IT Services allows an employee to perform work from a telework location and an employee may be required to be in the office based on business needs and other dependencies in Minnesota.
- Only candidates located in Minnesota and bordering states (Iowa, North Dakota, South Dakota, or Wisconsin) are telework eligible.
Location negotiable. The following DNR Office locations for consideration are:
- St Paul
- Bemidji
- Brainerd
- Duluth
- Grand Rapids
- New Ulm
- Rochester
Qualifications
Minimum Qualifications
Candidates must clearly demonstrate all of the following qualifications in their resume.
This position requires four (4) years of relational database design and management experience.
Experience must include:
- In-depth knowledge of Oracle RDMS and PostgreSQL RDMS
- In-depth knowledge of spatial database extensions including Oracle Spatial, ESRI SDE and PostGIS
- Strong knowledge of working with RDMS-related tools such SQL Developer, Toad, PgAdmin
- In depth knowledge of Linux scripting using shell scripts and languages such as Python or Perl
- Relational database design and development
*A master’s degree in Information Technology or a related field substitutes for three (3) years of experience, OR a related bachelor’s degree substitutes for two (2) years, OR a related associate’s degree substitutes for one (1) year.*
Preferred Qualifications
- Working knowledge of MySQL/MariaDB and Microsoft SQL Server RDMS
- Experience with enterprise Linux distributions (RedHat, SuSE, Oracle Enterprise Linux (OEL))
- Geographic Information Systems (GIS)
- Enterprise reporting environments
- Experience with cloud databases in Azure and/or Amazon Web Services (AWS)
Additional Requirements
*It is the policy of Minnesota IT Services that a successful candidate must pass all legally required checks prior to employment which may consist of the following:
- SEMA4 Records Check (applies to current and past state employees only)
- Criminal History Check
- Reference Check
- Social Security and Address Verification
- Education Verification
- Other legally required checks
Minnesota IT Services will not sponsor applicants for work visas. All applicants must be legally authorized to work in the United States.
