Job Title: Senior Data Architect/Data Architect
Location: Burbank CA
Duration: 6 Months
Skills:
Senior Data Architect
Strong proficiency in SQL PL/SQL and experience with Oracle PostgreSQL MySQL or SQL Server.
Hands-on experience in data modeling.
Knowledge of ETL
Job Description:
- Design implement and optimize relational (SQL) and non-relational (NoSQL) databases.
- Ensure high availability scalability and performance of database systems.
- Drive best practices in indexing partitioning query optimization and storage management.
- Write and optimize complex PL/SQL procedures functions triggers and packages for large-scale transactional and analytical systems.
- Perform performance tuning debugging and query optimization.
- Collaborate with developers and DBAs to enforce coding standards.
- Design conceptual logical and physical data models for OLTP OLAP and data warehouse systems.
- Ensure data models align with enterprise architecture standards.
- Define and maintain data lineage ensuring traceability of data from source to consumption.
- Collaborate with data governance teams to enforce data quality security and compliance.
- Document metadata and business rules for lineage and cataloging tools.
- Ensure efficient movement transformation and validation of large-scale datasets.
- Optimize workflows for both batch and real-time streaming data.
Keywords: Data Architect ETL SQL PL/SQL OLTP OLAP