Minnesota IT Services (MNIT) needs a Database Developer to provide application development leadership for new and existing system development projects that have a high impact on agency-wide processes and procedures for the Minnesota Pollution Control Agency (MPCA).
Requirements
- Minimum of four (4) years of IT related experience in Oracle procedural language (PL/SQL) development of functions and procedures.
- Expertise in Oracle PL/SQL development, with experience in developing, troubleshooting, and optimizing complex procedures and functions.
- Expertise in writing and tuning Oracle SQL queries.
- Experience in Oracle database optimization.
- Experience and competency in PostgreSQL PL/pgSQL development with expertise in developing, troubleshooting, and optimizing procedures and functions.
- Experience using version and source code management tools such as Git to support database development.
- Experience and competency with PostGIS spatial data analysis and functions in PostgreSQL/PostGIS.
Responsibilities
- Provide application development leadership for new and existing system development projects.
- Expertise in databases, systems and software analysis, design, development, troubleshooting and integration using PostgreSQL’s PL/pgSQL, Oracle’s PL/SQL, and other tools or languages as appropriate.
- Develop, troubleshoot, and optimize complex procedures and functions in Oracle PL/SQL.
- Write and tune Oracle SQL queries.
- Perform Oracle database optimization.
- Develop, troubleshoot, and optimize procedures and functions in PostgreSQL PL/pgSQL.
- Use version and source code management tools such as Git to support database development.
Other
- Work on a complex project development team as an Oracle database developer.
- Ability to deliver effective verbal or written messages that facilitate a mutual understanding on both parties.
- Customer service skills that include active listening, empathy, and problem-solving.
- Experience documenting technical processes and procedures.
- Demonstrated experience implementing secure coding best practices.
