Principal Database Architect & Optimization Engineer - I at Pakistan Single Window

Karachi, Sindh, Pakistan -

Full Time

Start Date

Immediate

Expiry Date

09 Jun, 26

Salary

0.0

Posted On

11 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Dictionary Maintenance, Schema Design, Query Optimization, Performance Tuning, Data Governance, Metadata Management, SQL Expertise, ETL/ELT Design, Data Modeling, Indexing, Data Archiving, Relational Databases, OLTP Systems, OLAP Systems, Agile Environment, Collaboration

Industry

IT Services and IT Consulting

Description

Maintain and evolve the enterprise-wide data dictionary. Ensure consistent use of data definitions across applications and services. Act as the custodian for data naming conventions, standards, and metadata. Review and suggest improvements to existing schemas for scalability and maintainability. Provide guidance on normalization, denormalization, and relationships between entities. Collaborate with developers to ensure new features adhere to enterprise schema standards. Review SQL queries from development teams for performance and standardization. Define and enforce best practices for query design, indexing, and joins. Work with DBAs to balance application needs with infrastructure constraints. Define strategies for data archiving, retention, and partitioning. Collaborate with development teams to implement archiving strategies without impacting applications. Ensure compliance with data governance and regulatory requirements. Support the BI/Data Engineering team in creating efficient data pipelines from OLTP to analytics systems. Provide input on ETL/ELT design, ensuring minimal impact on transactional systems. Help define data models for reporting and analytics use cases. At least 6-7 years of relevant experience. Bachelors Degree in Computer Science/Engineering or equivalent. Strong SQL expertise and deep understanding of relational database design. Experience in schema design, query optimization, and performance tuning. Familiarity with data governance practices, metadata management, and data catalog tools. Knowledge of OLTP vs OLAP systems, ETL pipelines, and BI tools. Strong collaboration skills with developers, DBAs, and data engineers. Strong interpersonal, written, and verbal communication skills. Ability to perform comfortably in a fast-paced, deadline-oriented, agile environment. Self-motivated, quick learner, and a responsive team player. Competitive salary Fuel Card Health benefits Professional development opportunities Inclusive work culture & much more

Responsibilities

This role involves maintaining and evolving the enterprise-wide data dictionary, enforcing data naming conventions, and reviewing schemas for scalability and maintainability. The architect will also guide development teams on query design, indexing, and collaborate on data archiving strategies while ensuring compliance.