Senior Data Architect

Description of Services:

• We are seeking a Senior Data Architect to design, implement, and optimize both relational (SQL) and non-relational (NoSQL) database systems. The ideal candidate will ensure high availability, scalability, and performance of database environments while driving best practices in indexing, partitioning, query optimization, and storage management.
• Key responsibilities include writing and optimizing complex PL/SQL procedures, functions, triggers, and packages for large-scale transactional and analytical systems. You will perform performance tuning, debugging, and query optimization while collaborating closely with developers and DBAs to enforce coding standards.
• The role also involves designing conceptual, logical, and physical data models for OLTP, OLAP, and data warehouse systems, ensuring alignment with enterprise architecture standards. You will define and maintain data lineage to guarantee traceability from source to consumption and collaborate with data governance teams to enforce data quality, security, and compliance.
• Documentation of metadata and business rules for lineage and cataloging tools will be essential, as will ensuring efficient movement, transformation, and validation of large-scale datasets. Optimizing workflows for both batch and real-time streaming data is also a key focus