Search Architecture jobs

37 Architecture Jobs

37 jobs found Jobs found Email me jobs like this
Load More

  • DATABASE ARCHITECT

    Los Angeles, California United States City of Los Angeles Jul 04, 2025
    City of Los Angeles Employer:

    City of Los Angeles

    Los Angeles is the second largest city in the United States and has a multi-ethnic population ofapproximately 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 servesfull 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 severalof the City’s departments and bureaus. The City has 44 departments, bureaus, and offices for which funds are budgeted annually by theMayor 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 (LosAngeles Fire & Police Pensions and the Los Angeles City Employees’ Retirement System).

    Apply Now View job Employer Profile

    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
    Apply Now View job Employer Profile

    Please mention you found this employment opportunity on the CareersInGovernment.com job board.

LATEST JOBS