FIND_THE_RIGHTJOB.
Principal Database Architect & Optimization Engineer - I
Karachi, Pakistan
- 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
Similar jobs
Support & Implementation Engineer
INNOVATIVE PVT LTD
Karachi, Pakistan
about 20 hours ago
R&D Engineer
opl
Karachi, Pakistan
about 21 hours ago
Odoo System & IT Administrator
Optimum Advisory
Karachi, Pakistan
about 21 hours ago
Data Engineer - Junior
Squarera
Karachi, Pakistan
about 22 hours ago
Data Engineer
Xynotech
Karachi, Pakistan
about 22 hours ago
Microsoft Power Platform Developer Associate
Network Squad
Karachi, Pakistan
6 days ago
Freelance Data Architect – Offshore
BOS Balance of Storage Systems AG
Karachi, Pakistan
6 days ago
© 2025 Qureos. All rights reserved.