Senior Data Architect / Data Architect

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