Database Administrator

5 months ago
Employment Information

The current vacancy will be working in an ORACLE environment. We are

seeking candidates who have strong experience in ORACLE database

management. The salary for this position is projected to increase

incrementally on 7/1/2024 and subsequently on 1/1/2025. The starting

salary for external candidates is based on their qualifications for the job.

Hybrid and/or work from home options are currently unavailable for this

vacancy.

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.

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.

Department or School Site The District has 600+ staff members, including programmers, network

engineers, and administrative staff - all of whom provide support to the

Schools and most District offices in a professional, forward thinking, and

challenging environment. Technologies supported range from personal

systems to enterprise-wide systems and applications.

Project A Database Administrator plans, coordinates, and directs the

configuration, development and implementation of Oracle and/or SQL

Server relational database infrastructure and serves as liaison between

the applications and the database staff.

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: 24 vacation days.

Paid Holidays: Up to 13 days.

Job Duties/Responsibilities TYPICAL DUTIES

  • Supervises and participates in the development of Oracle and/or SQL
Server databases.
  • Defines and supervises work related to development, modification,
testing, and installation of Oracle and/or SQL Server databases.
  • Provides support to the District’s SQL Server application programmers.
  • Designs and implements database backup and recovery strategies and
procedures.
  • Resolves problems related to database software or application
programs.
  • Defines and supervises database security and/or access strategies
and procedures.
  • Consults with vendors, contractors, application programming staff, and
consultants relative to the establishment of and adherence to industry

best practices and technical standards.

  • Reviews and revises Physical Data Models.
  • Develops and implements change management procedures including
version control.
  • Writes and reviews documentation for system procedures and
guidelines.
  • Reviews, recommends changes in and approves methodology for
evaluating database performance.
  • Defines and implements technical processes to improve database
productivity.
  • Monitors and forecasts system resources. Creates database
dictionaries.

  • Performs related duties as assigned.

Minimum Requirements EDUCATION:

Graduation from a recognized college or university, preferably with a

major in computer or information science, or business data processing.

Graduate level courses in computer or information science, operations

research or database techniques is desirable. Qualifying experience in

addition to that required below may be substituted for the required

education on a year-for-year basis.

EXPERIENCE:

Five years of experience in the design, development, modification,

improvement, and implementation of relational database management

systems that includes access methods, definition languages, and

teleprocessing software in an installation utilizing third-generation

systems that support batch, teleprocessing, database, and real time

applications. Experience with physical and logical database design, data

security, development of plans for the conversion of existing systems to

database systems, database recovery and backup techniques, on-line

CICS data inquiry and updating, and optimum processing techniques

also is required. Two years of this experience must have included using

Oracle, SQL Server, or CICS. Two years of this experience must have

been in a supervisory or project leader capacity.

SPECIAL:

A valid California Driver License.

Use of an automobile.

SPECIAL NOTES:

1. Management class.

2. Exempt from FLSA.

3. An employee in this class may be subject to the reporting

requirements of the District’s Conflict
of Interest Code.

This class description is not a complete statement of essential functions,

responsibilities, or requirements. Requirements are representative of the

minimum level of knowledge, skill, and/or abilities. Management retains

the discretion to add or change typical duties of a position at any time.

Desirable Qualifications The ideal candidate for this position will have extensive hands-on

professional experience with ORACLE (12c or higher) Database

Management. They will be a problem solver, with strong analytical skills,

take initiative to lead various complex projects and have the ability to

work independently. The ideal candidate will also have knowledge or


experience with ORACLE GoldenGate, Real Application Clusters (RAC)

and Automatic Storage Management (ASM).

Knowledge of:

  • Relational database management principles and tools
  • Functions and use of EDP hardware, software, and services
  • Complex EDP operating and applications systems
  • Data and data warehousing systems analysis and design
  • Business and educational data processing applications
  • Relational databases
  • Various higher-level programming languages, including CICS, SQL

and PL/SQL

  • Principles and techniques of database administration and

programming

  • Project management techniques, including work planning, scheduling,

supervision, and reporting

  • Forecasting and resource planning techniques

Ability to:

  • Develop long and short range plans
  • Diagnose problems in relational database based software systems
  • Prepare work plans, time and cost estimates, and reports
  • Read, interpret, and apply technical information
  • Evaluate and adapt new data processing techniques
  • Formulate and express difficult technical concepts clearly and

effectively in written and oral presentations

  • Establish and maintain effective working relationships with

administrators, representatives of vendors, and Information Technology

Division employees

  • Monitor, analyze, and forecast system resources and plan for future

growth

  • Supervise technical personnel effectively

Employment Selection Process The selection process for this position will tentatively consist of the

following: Technical Project and Technical Interview.

This is a competitive process as we anticipate a number of well qualified

candidates for this recruitment. Please make sure that you describe in

DETAIL, your experience, education, and training that most closely

relates to this position in the on-line application.

In your application you may include a professional resume, but it will

NOT be in lieu of a detailed application. Additionally, please attach your

unofficial college transcript demonstrating you meet the EDUCATION

requirement (refer to the Minimum Requirements section).


Please be sure to include correspondence from @lausd.net as an

approved sender 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 .

Application Process DO YOU NEED TECHNICAL ASSISTANCE WITH THE ON-LINE

APPLICATION?

Email us at helpmeapply@lausd.net

To find out whether the application deadline has been extended, visit the

website at: http://www.lausdjobs.org .

The Los Angeles Unified School District intends that all qualified persons

shall have equal opportunities for employment and promotion.

Reasonable accommodations in completing an application and testing

are available to individuals with disabilities. Please call (213) 241-3455

for more information.

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.

New Things Will Always
Update Regularly