Senior Database Application Developer - Its4

Logo
Job Details
Working Title: Senior Database Application Developer
Job Class: Information Technology Specialist 4
Agency: Minnesota IT Services

• Who May Apply: Open to all qualified job seekers
• Date Posted : 10/28/2023
• Closing Date : 12/27/2023
• Hiring Agency/Seniority Unit : Minnesota IT Services
• Division/Unit : Minnesota Pollution Control Agency (MPCA)
• Work Shift/Work Hours : Not Applicable Shift
• Days of Work : Monday - Friday
• Travel Required : No
• Salary Range: $34.95 - $57.65 / hourly; $72,975 - $120,373 / annually
• Job Class Option : Application
• Classified Status : Classified
• Bargaining Unit/Union : 214 - MN Assoc of Professional Empl/MAPE
• FLSA Status : Exempt - Administrative
• 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 Pollution Control Agency (MPCA). The MNIT MPCA team provides technical expertise for the organization's applications and agency-specific support to ensure every Minnesotan has healthy air, sustainable lands, clean water, and a better climate.
**This position is eligible to receive a $3,000 Hiring Bonus! This bonus will be paid in two increments, with the first payment made after successfully passing the probationary period.
**A Referral Bonus is offered to MNIT staff to help recruit new talent for this position and be eligible to receive $1,000! This bonus is paid to current MNIT staff after candidate passes the probationary period. Email: MNITHR.Services@state.mn.us using subject line 'Employee Referral' and include candidate's name and this job posting ID, prior to candidate being selected. **In order to qualify as a referred candidate, the candidate must not currently work for the State of Minnesota.
Job Summary
This position will provide Database Application development leadership for new and existing system development projects. The scope of the projects will be broad-based undertakings that will have a high impact on agency-wide processes and procedures. Core development activities will be focused upon creating and implementing PostgreSQL's PL/pgSQL, procedures, and functions. The projects will require expertise in databases, systems and software analysis, design, development, troubleshooting and integration using PostgreSQL's PL/pgSQL and other tools or languages as appropriate. A high level of knowledge of the existing technologies, development standards, software development life cycle (SDLC) methodologies, and technical industry best practices will also be required. This position will be involved with the most complex and critical systems at the Minnesota Pollution Control Agency (MPCA).
This position is currently eligible for full-time telework:

• • Telework for Minnesota IT Services allows an employee to perform work from a remote telework location and an employee may be required to be in the office based on business needs and other dependencies.
  • Candidates residing outside of Minnesota and bordering states (Iowa, North Dakota, South Dakota, or Wisconsin) require additional review prior to telework approval upon becoming a finalist.
• • Candidates located in Minnesota, or a bordering state, do not require additional review.

Qualifications
Minimum Qualifications
Candidates must clearly demonstrate all of the following qualifications in their resume:
Position requires a minimum of four (4) years of experience programming in the following applications/systems: PostgreSQL, PL/pgSQL, with an emphasis on work with procedures and functions.
Experience must demonstrate the following:

• Experience with PostgreSQL development, with an emphasis of work on procedures, and functions.
• Experience with Postgres or Oracle relational database management systems.
• Expertise in writing and tuning SQL queries.
• Experience working on a development team as a data/database developer either in an Agile or Waterfall development methodology.

A Master's degree in Information Technology or a related field may substitute for three years of experience, OR a related Bachelor's degree may substitute for two years, OR a related Associate's may substitute for one year.
Preferred Qualifications

• Experience and competency with PostGIS, spatial data analysis and functions in SQL/P, and geospatial data management.
• Experience and competency in Oracle development, SQL, and PL/SQL.
• Developing applications that follow best practices in relation to secure coding and accessibility.
• Experience in database, systems, software analysis, design, development, troubleshooting, and integration.
• Experience documenting technical processes and procedures.
• Creating applications to work and integrate with Cloud environments such as Azure.
• Working knowledge of web services, especially RESTFUL services
• Experience working as a team member on complex application development projects.
• Knowledge of various methodologies such as MVC, SDLC, ITIL, Project Management roles, Change and Release Management, Technical Design, and Software Development Architecture.
• Experience working with version and source code management tools such as Git and GitLab.

Additional Requirements
This position is based in St. Paul, Minnesota. This position will require the employee to be in the office based on business needs and other dependencies.
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.
Application Details
How to Apply
Select "Apply for Job" at the top of this page. If you have questions about applying for jobs, contact the job information line at 651-259-3637 or email careers@state.mn.us . For additional information about the application process, go to http://www.mn.gov/careers .
Connect 700 Program
To receive consideration as a Connect 700 Program applicant, apply online, email the Job ID#, the Working Title and your valid Proof of Eligibility Certificate by the closing date to shanna.vah@state.mn.us
Veterans
To be considered for any Veteran's Status , you MUST indicate this on your application.
RECENTLY SEPARATED VETERANS (RSV) : Effective July 1, 2009, legislation provides that the top five RSV applicants who apply and meet the qualifications for a vacancy shall be granted an interview. You must:

1. Meet all Minimum Qualifications identified in this posting.
2. Meet all of the RSV criteria.
3. Submit a copy of your DD-214 form by the closing date to: MNIT.Recruitment@state.mn.us .

CERTAIN DISABLED VETERANS : Effective August 1, 2012, legislation provides state agencies with the option to appoint certain disabled veterans on a noncompetitive basis if you:

1. Meet service requirements and have a verified service-connected disability rating of at least 30%.
2. Provide qualifying documentation verifying the disability.
3. Meet all Minimum Qualifications identified in this posting.
4. You must submit all documentation by the closing date to: MNIT.Recruitment@state.mn.us .

Current State Employees

• Bidders: This vacancy is open for bids and all qualified applicants simultaneously. This vacancy will be filled in accordance with applicable union contract provisions. Current employees of Minnesota IT Services who are currently in anInformation Technology Specialist 4 - Applicationposition and who are eligible to bid and apply within the seven (7) day bidding period will be considered prior to filling the position via other means.
• Current State Employees: Please note that employment provisions (including but not limited to seniority and leave accrual) vary among the three branches of Minnesota State government. When considering a job with another branch of state government, you are highly encouraged to explore these differences. For assistance, please direct questions to your current or anticipated Human Resources office.

About Minnesota IT Services
Minnesota IT Services is the information technology agency for the State of Minnesota. MNIT partners with agencies, boards, councils, and commissions to deliver secure, reliable technology solutions as we set IT strategy, direction, policies, and standards statewide. Work for MNIT and be part of a nation-leading IT organization that helps to create an innovative government that works for everyone. Our culture promotes collaboration, demands agility, and encourages us to embrace change. Be a part of something bigger than yourself, something to be inspired by; come to work for MNIT.
Why Work for Us
Diverse Workforce
We are committed to continually developing a workforce that reflects the diversity of our state and the populations we serve. The varied experiences and perspectives of employees strengthen the work we do together and our ability to best serve the people of Minnesota.
A recent engagement survey of State of Minnesota employees found:

• 95% of employees understand how their work helps achieve their agency's mission
• 91% of employees feel trusted to do their jobs
• 88% of employees feel equipped to look at situations from other cultural perspectives when doing their job
• 87% of employees report flexibility in their work schedule

Comprehensive Benefits
Our benefits aim to balance four key elements that make life and work meaningful: health and wellness, financial well-being, professional development, and work/life harmony. As an employee, your benefits may include:

• Public pension plan
• Training and professional development
• Paid vacation and sick leave
• 11 paid holidays each year
• Paid parental leave
• Low-cost medical and dental coverage
• Prescription drug coverage
• Vision coverage
• Wellness programs and resources
• Employer paid life insurance
• Short-term and long-term disability
• Health care spending and savings accounts
• Dependent care spending account
• Tax-deferred compensation
• Employee Assistance Program (EAP)
• Tuition reimbursement
• Federal Public Service Student Loan Forgiveness Program

Programs, resources and benefits eligibility varies based on type of employment, agency, funding availability, union/collective bargaining agreement, location, and length of service with the State of Minnesota.
AN EQUAL OPPORTUNITY EMPLOYER
Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly employers. The State of Minnesota recognizes that a diverse workforce is essential and strongly encourages qualified women, minorities, individuals with disabilities, and veterans to apply.
We will make reasonable accommodations to all qualified applicants with disabilities. If you are an individual with a disability who needs assistance or cannot access the online job application system, please contact the job information line at 651-259-3637 or email careers@state.mn.us and indicate what assistance is needed.