Senior IT Application Developer (DPS #17794) State of New Mexico Santa Fe - NM - US Salary: USD39 - USD62 Apply here: https://www.indeed.com/viewjob?jk=2b9c60c60b30a1ec Posting Details The New Mexico Department of Public Safety (DPS) is looking for an experienced application developer with knowledge and abilities in Oracle Forms and Reports, .Net Core and Angular frameworks interfacing with Oracle and Microsoft SQL servers, including APIs and Database stored procedures. DPS houses the New Mexico State Police (NMSP) and provides many services to the entire law enforcement community throughout New Mexico. DPS is the FBI designated Criminal Justice Information Services (CJIS) Systems Agency (CSA) for the State of New Mexico. As such, DPS is the exclusive entity in New Mexico that provides access to CJIS for all federal, state, local and tribal law enforcement agencies. The DPS ITD provides a portfolio of services to the entire law enforcement community in New Mexico in addition to being the key technology partner of NMSP and the other statewide law enforcement support divisions of DPS. The ITD Leadership Team is committed to helping everyone on our team grow professionally and personally through training, mentor ship, and challenging work assignments. DPS has one of the most complex networks in the State of New Mexico consisting of over 50 physical offices including the DPS headquarters, the NM Law Enforcement Academy, three forensic labs, three 911 communications / dispatch centers, 12 NMSP district offices, and a significant number of permanent and transitory sub-stations in key locations throughout the state including the Governor's Mansion. In addition to these physical locations, the network consists of 650 NMSP patrol units, the NMSP helicopter and several mobile command centers. The network is accessed 24 hours per day, 7 days per week with no tolerance for downtime by DPS civilian staff, NMSP, and all federal, state, local and tribal law enforcement agencies (LEAs) to receive mission-critical CJIS and to access many other systems. These systems are essential to law enforcement statewide. DPS ITD provides the time, resources and encouragement for its staff to participate in ongoing training and mentor ship. We are looking for employees who want to grow their skills, develop as individuals, be reliable teammates and enjoy challenging work assignments. The significant number of our employees who have been promoted into higher positions is evidence of our success. ITD enjoys a close working relationship with the NMSP, law enforcement agencies across New Mexico and our federal partners such as the FBI and the Cybersecurity and Infrastructure Security Agency (CISA). ITD and its employees are valued by the leadership of DPS as an essential part of the public safety services in New Mexico. If you become a member of the DPS ITD family, you will quickly become integrated into the law enforcement community statewide. Why does the job exist? This position is integral in supporting one of the most complex organizations in the State of New Mexico. DPS houses many in-house and vendor supported applications with back-end Oracle and Microsoft SQL Server databases that support DPS's mission. The Senior IT Application Developer exists to ensure that these applications remain available 24/7/365 and perform in a manner that allows to be available to criminal justice agencies. This position may require duties for occasional nights and weekends. How does it get done? **The Senior IT Application Developer works on the functions:** 1. Lead the full Software Development Life Cycle (SDLC) with a primary focus on Oracle-based application development, from requirements analysis through deployment, collaborating with stakeholders to ensure solutions align with business needs. 2. Design, develop, code, unit test, and independently deploy complex Oracle Forms and Reports applications, building robust, scalable solutions that interface directly with Oracle databases. 3. Develop and maintain Oracle Forms (12.2.1.4.0 and higher) modules - including triggers, program units, and libraries - ensuring high performance, accuracy, and adherence to established coding standards. 4. Build and maintain Oracle Reports, creating complex parameterized, summary, and matrix reports that deliver actionable business intelligence from Oracle database sources. 5. Write advanced PL/SQL code including stored procedures, functions, packages, triggers, and dynamic SQL to support Oracle Forms/Reports and back-end Oracle database operations. 6. Tune and optimize Oracle database queries, execution plans, indexes, and schemas to ensure peak performance of Oracle Forms and Reports applications. 7. Manage Oracle application environments - development, test, and production - including deployment to Oracle Application Server or WebLogic, and support integration with external systems via SOAP/RESTful web services, database links, and file-based interfaces. 8. Supplement Oracle development with .NET Core and Angular full-stack development as needed, building backend APIs, T-SQL database interactions using Microsoft SQL Server, and frontend UI components for modernization or integration projects. 9. Accountable for application security across Oracle and .NET environments, including role-based access controls, data validation, Oracle schema management, and compliance with organizational security policies. 10. Translate functional and business requirements into detailed technical specifications, with emphasis on Oracle Forms/Reports architecture, data flow design, and PL/SQL logic, ensuring alignment with business needs. 11. Create and maintain comprehensive technical documentation including design specs, PL/SQL module documentation, data dictionaries, test plans, and user guides; develop, execute, and document test plans and assist QA with regression testing. 12. Assess client operational needs through a structured requirements process - gathering, analyzing, documenting, and managing changes - and lead or participate in project planning by providing realistic development estimates and timelines. 13. Engage in Agile or JAD-style design workshops; coordinate with business analysts, project managers, architects, and vendors to ensure Oracle application deliverables align with ITD's long-term technology strategy. 14. Mentor junior developers in PL/SQL best practices, review technical design specifications, provide technical direction to team members, and may serve as team lead on Oracle-centric projects. 15. Participate in disaster recovery planning for Oracle application environments, provide structured data extracts from Oracle repositories to support reporting and executive presentations, and independently propose and implement solutions for complex, cross-functional application challenges. Who are the customers? DPS including NMSP and all Law Enforcement and criminal justice agencies within the state of New Mexico. Ideal Candidate DPS including NMSP and all Law Enforcement and criminal justice agencies within the state of New Mexico. Minimum Qualification Bachelor's degree in Computer Science, Management Information Systems (MIS), Information Technology, Engineering, or similar technical degree and three (3) years of experience in software programming. Any combination of education from an accredited college or university in a related field and/or direct experience in this occupation totaling seven (7) years may substitute for the required education and experience. Employment Requirements Employment is subject to a pre-employment background investigation and fingerprinting in accordance with all terms and conditions of federal and state law, rules and regulations; and is conditional pending results. Continued employment is contingent upon remaining felony free, per Section 5.12.1.1 of the Criminal Justice Information Systems Security Policy. In addition, the selected candidate must possess and maintain a valid driver's license and obtain a Defensive Driving Certificate from the State of New Mexico. Working Conditions This position is classified as essential personnel within the Department of Public Safety and requires on-site presence to maintain the security and integrity of mission-critical database systems. Remote work is not available for this position. Work is performed primarily in an office setting with exposure to Visual/Video Display Terminal (VDT) and extensive personal computer usage with extended periods of sitting. The ability to lift to 25 lbs. Some occasional travel may be required. Supplemental Information Do you know what Total Compensation is? Click here **Agency Contact Information:** Anupama Kodali (505) 637-9001 Email For information on Statutory Requirements for this position, click the Classification Description link on the job advertisement. Bargaining Unit Position This position is not covered by a collective bargaining agreement.