Programmer Analyst

Job Description

• 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 Skills 

• 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 Skills

• 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 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