Senior Programmer Analyst (Oracle)
Published Date: Jun 18, 2025
Location: US
Company: Los Angeles Unified School District
SALARY DETAILS
APPLICATION FILING DATES
Application Open Date: 6/18/2025
Application Close Date: To be determined
INFORMATION ABOUT LAUSD
We are LAUSD. We are at the forefront of innovation in public education, focused on a clear and inspiring vision of the future for all of our students as they venture forward on their journey as lifelong learners. Here, you will have the opportunity to exercise your potential in a role supporting the business of education. Our work directly contributes toward the goal of ensuring that our students graduate ready for the world – ready to thrive in college, career and life. LAUSD is the second largest school district in the nation with an enrollment of nearly 575,000 students. We serve an area totaling 710 square miles, with over 1,190 schools and educational centers, and we employ over 74,000 individuals, making us one of the largest employers in our city.
LAUSD Employees: Please be advised that all LAUSD employees must sign in to the GlobalProtect Virtual Private Network (VPN) in order to submit an application from an external network outside of an LAUSD location. For assistance with installing the GlobalProtect virtual network, please contact Information Technology Services at (213) 443-1300 or (213) 241-5200.
BENEFITS
Insurance: Paid premiums for your choice of several medical, dental, vision, and life insurance plans.
Retirement: Membership in the California Public Employee Retirement System (CalPERS).
Vacation: Full-time employees earn up to two weeks of paid vacation to start. Three weeks after five years of year-round paid service.
Paid Holidays: Up to 13 days.
JOB DUTIES/RESPONSIBILITIES
The following list includes the essential job duties/responsibilities of this classification:
- Conducts feasibility studies of highly specialized or unusually complex work processes and procedures to determine their adaptability to information technology.
- Designs information systems that require innovative and/or diversified approaches to the resolution of problems in the areas of data collection, data reduction and coding, systems controls, auditing, processing cycles, and inquiry and reporting.
- Uses full capability of micro, mini, and mainframe computers to assist in the design of information systems.
- Confers with management, operating unit personnel, and customers to define the scope of the information requirements, and evaluate alternative approaches to improving information systems.
- Formulates logical statements of business problems and develops systems designs detailing sequences of operation, systems block diagrams, flowcharts and instructions, and computer programming standards and specifications.
- Writes and maintains batch and on-line computer programs for mainframes, minicomputers, local area networks, and personal computers.
- Prepares tests for programs, audits results, and corrects errors in program logic.
- Analyzes existing systems and programming logic difficulties and takes corrective action.
- Creates job control language for batch operations.
- Supervises assigned programming personnel.
- Instructs assigned programming personnel in applying innovative and advanced analytical and programming techniques to the resolution of problems.
- May design, develop, and maintain web sites.
- May participate in the evaluation of new information technology equipment and software.
To see the complete class description for this position, visit us at https://careers.lausd.org/
MINIMUM REQUIREMENTS
Education and Experience:
Graduation from a recognized college or university with a bachelor’s degree in computer information systems, computer science, or a closely related field, and four years of experience in an Oracle-based environment with extensive experience in software development, programming, and systems analysis and design for business or data warehousing applications utilizing PL-SQL programming objects, Oracle database objects, and Java or Unix scripting and experience with one or more Oracle development tools such as Oracle Data Integrator, Oracle SQL Developer/Oracle SQL Developer Data Modeler, Oracle Business Intelligence Foundation Suite, Oracle Portal, Oracle WebCenter/WebCenter Portal, Oracle 11g or later, or Oracle forms and reports.
Experience beyond that required may be substituted for the required education on a year-for-year basis if proof of graduation from high school or evidence of equivalent educational proficiency is provided.
OR
Completion of a 30-semester unit certificate program or equivalent in computer information systems, computer science, or a closely related field, and six years of experience in an Oracle-based environment with extensive experience in software development, programming, and systems analysis and design for business or data warehousing applications utilizing PL-SQL programming objects, Oracle database objects, and Java or Unix scripting and experience with one or more Oracle development tools such as Oracle Data Integrator, Oracle SQL Developer/Oracle SQL Developer Data Modeler, Oracle Business Intelligence Foundation Suite, Oracle Portal, Oracle WebCenter/WebCenter Portal, Oracle 11g or later, or Oracle forms and reports.
Experience beyond that required may be substituted for the required education on a year-for-year basis if proof of graduation from high school or evidence of equivalent educational proficiency is provided.
OR
Four years of experience in LAUSD programming in an Oracle-based environment utilizing PL-SQL programming objects and Oracle database objects.
Experience with project/personnel management in a team environment and distributed systems is preferable.
Special:
Oracle certification is preferable.
Special Notes:
Employees in this class are subject to call at any hour.
DESIRABLE QUALIFICATIONS
The ideal candidate would have the knowledge of:
- Capabilities of mainframes, minicomputers, local area networks, and personal computers
- PL-SQL programming language and Java or Unix
- Fourth generation languages such as PowerBuilder
- Oracle relational database systems
- Web page design and development
- Principles of report, form, and screen design
- Information technology concepts and capabilities
- New trends in the field of information technology
- Principles of program documentation
- Systems analysis and design and data modeling techniques
- Principles of training and supervision
- Principles and practices of business and public administration
- English usage, punctuation, and spelling
The ideal candidate would also have the ability to:
- Analyze problems in information systems
- Analyze and adapt new information technology techniques
- Write and code difficult and complex programs
- Prepare clear and logical systems design
- Write clear and logical documentation
- Supervise and train personnel assigned to projects
- Communicate complex technical concepts both orally and in writing
- Work effectively and cooperatively with District personnel
- Learn the characteristics of new systems and update skills to adapt to changing technology
- Communicate effectively orally and in writing
- Conduct surveys and feasibility studies
EMPLOYMENT SELECTION PROCESS
The selection process for this position will tentatively consist of the following: Technical Project and Technical Interview.
Please be sure to include correspondence from @lausd.net and @successfactors.com as approved senders so that messages aren't accidentally placed into your spam/junk e-mail folder. For more information about the LAUSD employment assessment process, visit the 'My LAUSD Career' section of our website at http://www.lausdjobs.org. If you have any questions please contact Lewis Kwong at lapwai.kwong@lausd.net.
APPLICATION PROCESS
ADDITIONAL POSTING INFORMATION
The Los Angeles Unified School District is committed to providing a working and learning environment free from discrimination, harassment, intimidation, abusive conduct, or bullying. The District prohibits discrimination, harassment, intimidation, abusive conduct or bullying based on actual or perceived race or ethnicity, gender/sex (including gender identity, gender expression, pregnancy, childbirth, breastfeeding/lactation status and related medical conditions), sexual orientation, religion, color, national origin (including language use restrictions and possession of a driver’s license issued under Vehicle Code), ancestry, immigration status, physical or mental disability (including clinical depression and bipolar disorder, HIV/AIDS, hepatitis, epilepsy, seizure disorder, diabetes, multiple sclerosis, and heart disease), medical condition (cancer related and genetic characteristics), military and veteran status, marital status, registered domestic partner status, age (40 and above), genetic information, political belief or affiliation (unless union related), a person's association with a person or group with one or more of these actual or perceived characteristics, or any other basis protected by federal, state or local law, ordinance, or regulation in any program or activity it conducts or to which it provides significant assistance. For inquiries or complaints contact our Equal Opportunity Section, (213) 241-7685.
Selection and promotion are based on a competitive employment assessment process. Candidates who pass all parts of the assessment process are placed on a hiring (eligibility) list based on their assessment score. Hiring departments may make job offers to candidates on the top three ranks of the hiring list. Eligibility typically lasts for 12 months. The hiring list resulting from this assessment process may be used to fill open positions in related job classifications.
Follow us on:
https://x.com/LAUSDjobs
https://www.facebook.com/LAUSDjobs/
https://www.linkedin.com/groups/1997274
https://www.instagram.com/lausdjobs/