Posted on 06/05/2024
You may have heard the expression "data is the new oil." The digitization of the City of Los Angeles and the effective use of data that comes from this digitization is critical to a modern, "smart" Los Angeles. At the center of this effort is the ITA Database Support Services (DSS) team. This ITA Spotlight shines on this group.
The Database Support Services team has a core focus on all things data related. The team provides end-to-end support for database administration on platforms such as Oracle, MS SQL Server, MySQL/MariaDB, DB2, and more. This covers database operations on critical applications such as PAYSR, LATAX, and applications for City departments. The team has also been building out a citywide "data lake" and providing data reporting and analytics services on the Google Cloud Platform (GCP). The data lake is providing a secure and centralized repository for data across a portfolio of City applications as well as historical data from legacy apps.
The team had a productive 2023 and completed many projects, such as:
● LATAX migration from Oracle to AWS RDS Postgres
● Data migration and pipelines to the citywide data lake including:
● Data migration and pipelines to the citywide data lake including:
- PAYSR historical data from Oracle for HRP
- Homeless encampment data from LAPD, LAFD and 311 for Homeless Initiatives
- Workday data for the Personnel department to provide hiring dashboards
- Domestic Abuse Response Team data for the Mayor’s Office
- Tobacco Enforcement Operations data for the City Attorney
- ITA Phishing Exercise data for dashboards used by the ITA security team.
The need to securely centralize, store, access, and assess data is only growing in importance and the DSS team is doing great work to ensure that ITA has the capability and experience to facilitate data access for analytical work and data driven decision making!