02792F Defines and analyzes functional business requirements for designing and developing programs for desktop and distributed environments which includes personal computers, client server environments, and browser-based or n-tier environments. Develops design specifications and/or translates detailed design specs into computer software. Tests, debugs, and refines the computer software to produce the required product. Prepares required documentation, including both program-level and user-level documentation. Troubleshoots and enhances software to reduce operating time or improve efficiency. Primary skill sets include knowledge of SOLARIS and Windows operating systems; Oracle and Microsoft SQL Server databases; Microsoft Visual Studio .NET and Oracle Internet Development tools and Oracle Application Server; J2EE and .NET architectural frameworks; Visual Basic, Java, and .NET programming languages; Visual Basic Script, JavaScript, JSPs, EJBs, XML, and HTML. Secondary skill sets include knowledge of Microsoft's Internet Information Server (IIS), Secure Socket Layers (SSL) to provide the functionality of encryption and decryption of data; Object Oriented and UML methodologies; knowledge of other State software standards for desktop and distributed systems. Requires a minimum of 2 years of current experience in this job class.
Minimum of two years of experience with Oracle PL/SQL and a relational database such as Oracle 19c. Proficient in writing and optimizing SQL queries, stored procedures, and indexing strategies to improve efficiency.Ability to diagnose and resolve database issues and errors. Ability to understand and implement measures to ensure data accuracy, consistency, and security
Type Category Qualification Description Competency Required Skills rchitecture GILE - Agile Development Methodology Novice (1-3 Years) Yes Skills Database Oracle Oracle Application Express (APEX) Novice (1-3 Years) Yes Skills Database Oracle 12c Preferred Oracle 19c Novice (1-3 Years) Yes Skills Languages HTML Novice (1-3 Years) Yes Skills Languages JavaScript Novice (1-3 Years) Yes Skills Languages PL/SQL Novice (1-3 Years) Yes Skills Languages SQL Novice (1-3 Years) Yes Skills Tools Crystal Reports Novice (1-3 Years) Yes Skills Tools MicrosoftOffice Novice (1-3 Years) No
