Principal Database Architect & Optimization Engineer - I

Pakistan Single Window; Karachi Division; On-site; PKR 2,000,000 - 2,750,000; Full time

Job summary

A prominent governmental technology organization in Karachi is seeking a Data Architect with at least 6-7 years of experience. Responsibilities include maintaining a data dictionary, collaborating on schema standards, and ensuring compliance with data governance practices. Candidates should have strong SQL expertise, a degree in Computer Science, and the ability to thrive in an agile environment. This position offers competitive salary and health benefits.

Benefits

Competitive salary

Fuel Card

Health benefits

Professional development opportunities

Inclusive work culture

Qualifications

• At least 6-7 years of relevant experience.
• Experience in schema design, query optimization, and performance tuning.
• Knowledge of OLTP vs OLAP systems and ETL pipelines.

Responsibilities

• Maintain and evolve the enterprise-wide data dictionary.
• Provide guidance on normalization and relationships between entities.
• Collaborate with developers to ensure adherence to schema standards.

Skills

SQL expertise

Relational database design

Schema design

Query optimization

Data governance practices

Metadata management

Collaboration with developers

Agile environment adaptability

Education

Bachelor's Degree in Computer Science/Engineering or equivalent

Job description

Responsibilities

• 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.

Qualifications

• 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.

Benefits

• Competitive salary
• Fuel Card
• Health benefits
• Professional development opportunities
• Inclusive work culture & much more