-
Job Description
job description
The Los Angeles Department of Water and Power, ITS is filling two Database Architect positions. he positions will be responsible for the support, installation, configuration, and replication of Oracle databases pertaining to the following Power System operations: Electric Trouble Outage Management System (OMS), Work Management Information System (WMIS), Power Engineering ProjectWise System (Drafting), Critical Infrastructure Protection System (CIP), and other smaller application databases pertaining to Power System. The position will be located at 233 S. Beaudry Ave., Los Angeles, CA 90012. Available schedule is 5/40 or 9/80 with a start time between 6:30am to 8:00 am. The duties include, but are not limited to, the following:- Designing, developing, implementing, and managing policies and procedures to ensure the integrity, security and availability of databases and their accompanying software;
- Working with application development staff to develop database architectures, SQL coding standards, and quality assurance policies and procedures;
- Performing database creation, data loading, data conversion, performance troubleshooting, and SQL Query development;
- Implementation of database backup and recovery job streams, review and evaluate database design, and applying best practices to maximize database performance;
- Supporting Oracle 12c/19c (or newer) and Microsoft SQL Server
- 2008/2012/2016/2019/2022;
- Utilizing the NERC CIP rules and Information Technology Infrastructure Library (ITIL) processes for change, release and problem management as they relate to databases management;
- Performs other related duties, as necessary.
Candidates will be evaluated for the following work related skills, knowledge, abilities:- Experience supporting Oracle 12c and above.
- Experience supporting Microsoft SQL Server 2008/2012/2016/2019/2022.
- Unix/Linux Operating system experience, especially experience with Oracle Linux and Oracle Database Appliance (ODA).
- Knowledge of database system management tools such as SQL Server Management Studio and Oracle Enterprise Manager, as well as working knowledge of Oracle Dataguard replication and Oracle container databases.
- Experience working with SQL Developer and Transact-SQL, database creation, data loading, data conversion, data migration views, triggers, and stored procedures logic, backup and recovery, version migrations, and security patching.
- Understand the importance of change, configuration, problem, release, and incident management procedures.
- Understand disaster recovery and security concepts, create and execute disaster recovery strategies.
- Strong ability to troubleshoot and resolve database related problems.
The evaluation of candidates for this position may be based on a review of training and experience as presented on the resume/application and an interview. Due consideration will be given to attendance records. A written skills test may be administered.
Please be advised that the LADWP Retirement Plan has changed. It is recommended you review information available on Tier 1 and Tier 2 benefits at https://retirement.ladwp.com/at2retire.html if considering employment with the LADWP.
How to apply
Resumes with City Application will be accepted by email at
ITSPersonnel@LADWP.com. Please reference 25J-4132-101 on email when applying.
Accepting City applications until sufficient application is received.
Transfer
These positions are only available for City employees. Please do not respond if you do not currently work for the City of Los Angeles.
Closing Date/Time: 9/4/25 -
ABOUT THE COMPANY
-
-
City of Los Angeles
Show moreLos Angeles is the second largest city in the United States and has a multi-ethnic population of
approximately four million. It is truly a world-class city that offers a diversified economy and an unparalleled quality of life. Los Angeles continues to maintain its position as an economic power-
house, the entertainment capital of the world, and a major trendsetter in virtually every field of human endeavor.Los Angeles is a charter city and is governed by a Mayor and City Council. The City Council serves
full time and has fifteen members elected by district for four-year terms. Boards of Commissioners, appointed by the Mayor and confirmed by the City Council, oversee several
of the City’s departments and bureaus.The City has 44 departments, bureaus, and offices for which funds are budgeted annually by the
Mayor and City Council. Within those, the City has three departments (the Departments of Water &
Power, Harbor, and Airports) that are financed solely by revenue generated from their operations,
which are governed by Commissions, as well as two distinctly separate pension systems (Los
Angeles Fire & Police Pensions and the Los Angeles City Employees’ Retirement System). -