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

Karachi, Sindh, Pakistan -

Full Time

Start Date

Immediate

Expiry Date

25 Dec, 25

Salary

0.0

Posted On

26 Sep, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Relational Database Design, Schema Design, Query Optimization, Performance Tuning, Data Governance, Metadata Management, Data Catalog Tools, OLTP, OLAP, ETL, BI Tools, Collaboration, Communication, Agile Environment, Self-Motivated

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

The Principal Database Architect & Optimization Engineer will maintain and evolve the enterprise-wide data dictionary while ensuring consistent use of data definitions across applications and services. They will collaborate with developers and DBAs to optimize database performance and enforce best practices for query design and data management.