Principal Database Architect

2 days ago

Karachi, Sindh, Pakistan Pakistan Single Window Full time 1,200,000 - 3,600,000 per year
  • 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.
Requirements
  • 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

  • Principal Database Architect

    4 days ago

    Karachi, Sindh, Pakistan Pakistan Single Window Full time 1,200,000 - 3,600,000 per year

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

  • Database Architect

    4 days ago

    Karachi, Sindh, Pakistan Simpaisa Full time 1,500,000 - 2,500,000 per year

    Requirements:5+ years of experience in Database roles.Expertise in relational databases (MySQL, PostgreSQL) and NoSQL databases (MongoDB).Strong experience with data modeling tools (ERwin, dbt, Lucidchart).Hands-on experience with big data technologies: Hadoop, Spark, Hive, Presto.Proficiency in ETL/ELT frameworks (Apache NiFi, Talend, Airflow).Skilled in...

  • Principal Software Engineer

    9 hours ago

    Karachi, Sindh, Pakistan Creative Chaos Full time 1,200,000 - 3,600,000 per year

    A Principal Software Engineer for JAVA is an associate at Creative Chaos who is mainly responsible for developing server applications of various software platforms including but not limited to writing Restful APIs to be consumed by client applications. A Principal Software Engineer makes sure that the functionality, security and performance of the server...

  • Principal Software Engineer

    4 days ago

    Karachi, Sindh, Pakistan SOC Solutions LLC Full time 1,200,000 - 2,000,000 per year

    Location: Karachi, Pakistan (On-site)Timing: 11 AM – 8 PM (Mon–Fri)Company: Botmer InternationalWe're looking for an experienced Principal Software Engineer (Clouds) to lead cloud architecture, infrastructure automation, and large-scale deployment systems across our AI-driven software products.ResponsibilitiesArchitect and maintain scalable cloud...

  • Data Architect

    2 weeks ago

    Karachi, Sindh, Pakistan Simpaisa Full time 1,200,000 - 3,600,000 per year

    Job Summary:We are seeking an experienced and detail-oriented Data Architect to design and optimize our enterprise data systems. The ideal candidate will have at least 8 years of experience in data modeling, database architecture, and analytics infrastructure, with a strong background in SQL/NoSQL databases, data pipelines, cloud platforms, and data...

  • Solution Architect

    8 hours ago

    Karachi, Sindh, Pakistan KNOATIV Full time $125,000 - $175,000 per year

    Solutions Architect (Expert) Role DescriptionWe thrive on collaboration, innovation, and the drive to create meaningful connections between brands and their customers. Our technology-driven solutions empower businesses to enhance engagement, build loyalty, and deliver exceptional experiences.We are a team that values curiosity, creativity, and shared...

  • Associate Solution Architect

    8 hours ago

    Karachi, Sindh, Pakistan TenX Full time 1,500,000 - 2,500,000 per year

    Role DescriptionAssociate solution architect will be responsible for designing, mapping, documenting and creating the enterprise data warehouse and managing end-to-end Job mechanisms for data extraction, transformation and loading of data functions. Also, He should be able to analyse the business requirements and able to transform those requirements into ETL...

  • AI Architect

    2 weeks ago

    Karachi, Sindh, Pakistan WorkGarden Full time 1,200,000 - 3,600,000 per year

    One of our prestigious client is looking for a hands-on AI Architect who bridges software development, data engineering, and advanced AI/ML. You will design and code AI solutions that leverage large language models, embeddings and retrieval‑augmented generation while ensuring robust data pipelines and integration with our software products. This role...

  • Senior Software Architect

    4 days ago

    Karachi, Sindh, Pakistan SOC Solutions LLC Full time 900,000 - 1,200,000 per year

    Timings:11 AM – 9 PM (Mon – Fri)Company:Botmer InternationalLocation:Karachi, Pakistan (Hybrid / Remote)About UsBotmer International is an AI-first software company building next-generation products for global startups and enterprises. We specialize in AI, blockchain, and custom software development, delivering high-performance solutions with engineering...

  • Solutions Architect

    8 hours ago

    Karachi, Sindh, Pakistan Kamel Pay Full time 3,000,000 - 6,000,000 per year

    Company DescriptionKamelPay, founded in 2020, is the UAE's fastest-growing WPS agent specialising in salary processing. We provide businesses with secure, all-in-one salary processing solutions as a leading fintech solutions provider. Driven by a commitment to financial freedom, we enable companies and individuals to have instant access to essential...