Under the general direction of the Systems Software Specialist III Supervisor, the analyst will independently perform a range of programming, database administration and system analysis. The analyst will work independently to complete the software development life cycle consisting of requirements analysis, application design, code, testing, manipulation, integration, and maintenance to produce and implement properly designed and tested application solutions to meet CSLB business needs.
Serves as project lead to work with internal clients on application design projects and respond to requests to modify current applications. Independently develops project plans to schedule activities; assist end-users with the identification of system enhancement alternatives; identify business requirements; identify appropriate enhancement alternatives and recommend solutions to achieve required changes; identify programming specifications; document design specifications for new application programs and produce/write code to enhance existing program applications or modules; implement into production; and monitor system applications.
Prepare analysis of the potential impact; estimate programming time and decide programming changes required; analyze the current programming structure; apply advance application modeling techniques; implement multiple levels of data and database security requirements. Conduct detailed system analysis to determine impact of other application and/or system interfaces. Create Web pages using hypertext mark-up language(HTML); assist with the maintenance of Web pages; and applies other programming software to support Web functionality.
Serves as a Database Administrator for all resident application systems and tables resident on mainframe or PC based servers. Create data base control methodology and standards, manage the activities with all programmers use of the data base dictionaries, determine the optimum logical and physical file structure, conduct database maintenance by setting table size, monitoring multiple development and test, debug, optimize the functionality of applications and systems, environments, establish migration procedures and analyze programs to determine the best amount of storage space to be allocated for each program and application. Analyze security requirements, make recommendations and assist with administering application security. Ensure end user accounts are only granted the correct application screens based on authorized role.
Conducts formal training and instruction to other programming staff to transition knowledge of an applications functionality, logic and relationship used to build screens or reports. Teach other programmers on how to write code to do database queries, ad hoc reports, application/code structures, optimize program performance, and use of data library. Understand, prepare code and troubleshoot job control language (JCL) to execute offline batch jobs to produce datasets, reports and letters. Resolve Problems related to application interfaces and connectivity of multiple platforms, operating systems, database management systems and various other applications.
Prepare application documentation to record application build methodology, new application implemented, record date of program change/enhancement and reason for change. Prepare job aids and procedures for existing functionality, enhancements completed, and new applications implemented. Document application features to work with users to test features and prepare end user training materials. Plan, coordinate, develop and prepare test material, liaison with users and other contacts on testing activities, and schedule and prepare written and verbal summary of test results. Participate in CSLB’s annual disaster recovery drills and operational recovery planning process, including semi-annual mainframe application and database disaster recovery.
Assist in review of new programming software and development techniques such as object oriented programming and computer assisted system engineering tools. Attend training and seminars to learn the latest programming languages, web technology and development techniques. Evaluate new software programming languages and tools to determine applicability of usage at CSLB.
PERSONAL CONTACTS:The Staff Programmer Analyst (Specialist) has daily contact with all levels of the Information Technology Division Staff, consultants/vendors, CSLB staff, California Technology Agency, Office of Technology Services staff, Control Agency staff, DCA OIS staff and other government agencies.
ACTIONS AND CONSEQUENCES:The Staff Programmer Analyst (Specialist) makes decisions and program modifications impacting the direction and functionality of CSLB systems and client server applications. Poor technical decisions may result in an unstable, poorly performing or unusable system. Should the system become unusable, this could result in substantial workload backlogs, unavailable services to consumers, and cause harm to licensees and applicants.
OTHER INFORMATION:Incumbent must possess good communication skills, use good judgment in decision making, exercise creativity and flexibility in problem identification and resolution, manage time and resources effectively, and be responsive to CSLB management and staff needs. Regular and consistent attendance is required.
The incumbent has access to the Criminal Offender Record Information (CORI) and is subject to fingerprinting by the Department of Justice and clearance through the Department of Consumer Affairs. This position requires confidentiality and discretion due to the sensitivity of the documents handled.
WHO MAY APPLY: Eligible candidates who are current state employees with status in the above classification or lateral transfers from an equivalent class, former state employees who can reinstate into this class or persons who are reachable on a current employment list for this classification. All interested applicants must submit a standard State Application Form STD 678 (with original signature), REFERENCE RPA 622-150 FY 12/13, and must clearly indicate the basis of their eligibility on the explanation line of the STD 678. Candidates whose eligibility is based on an employment list should indicate their test score in the Explanation section of the STD 678. Only the most qualified candidates will be interviewed. Appointment is subject to SROA and State surplus policies. Surplus candidates must submit copy of surplus status letter. Through June 30, 2013, actual base pay will be reduced pursuant to the Personal Leave Program (PLP). Full-time employees' monthly pay will be reduced by 4.62% in exchange for eight (8) hours of leave. *FREE parking.*
If you are not a current or former State employee, you must first take an examination to obtain list eligibility. This does not apply to Student Assistant vacancies.
Learn all about it.
The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.