Principal Database Architect & Optimization Engineer - I
Karachi, Sindh, Pakistan
USD 120K-174K (estimate) Senior-level Full Time
Tasks
- Collaborate on schema standards
- Define data models for reporting
- Define indexing and join practices
- Design ETL/ELT processes
- Develop archiving and retention strategies
- Ensure data governance compliance
- Ensure data standards and definitions
- Guide data normalization and relationships
- Implement archiving without disrupting applications
- Maintain enterprise data dictionary
- Review SQL queries for performance
- Review and improve schemas
- Support data pipeline creation
- Work with DBAs on infrastructure
Perks/Benefits
Skills/Tech-stack
BI tools | Data Catalog | Data Governance | Data Modeling | Database Design | ETL | Indexing | Join strategies | Metadata Management | OLAP | OLTP | Performance Tuning | Query Performance Tuning | Query performance | SQL | Schema optimization
Education
Related jobs
-
Data Intelligence Analyst (PhD Required) USD 152K-228KAI | Data Analysis | Data Quality | Machine Learning | Prompt engineeringSenior-level Full TimeLahore, Punjab1d ago
-
APIs | CI/CD | Cloud Data | Cloud Data Warehouses | Data PipelinesFlexible working hours | Remote workSenior-level Full TimePakistan - Remote R2d ago
-
Airflow | BigQuery | CloudFormation | DBT | DagsterFlexible hours | Professional development opportunities | Remote workMid-level Full TimePakistan - Remote R2d ago
-
APIs | Data Analysis | Data Modeling | Data Pipelines | Data WarehousingContinuous learning | Employee discounts | Family benefits | Flexible time off | Health insuranceEntry-level Full Time InternshipPK - ISLAMABAD 101 W AL …2d ago
-
Cloud Data Integration | Data Modeling | Data Transformation | Data Warehousing | Data integrationMid-level Full TimeIslamabad, Federal Teritory5d ago
-
Cloud Data Integration | Data Modelling | Data Transformation | Data Warehousing | Data integrationMid-level Full TimeKarachi, Karachi5d ago
-
Cloud Data Integration | Data Governance | Data Modelling | Data Transformation | Data WarehousingMid-level Full TimeLahore, Punjab5d ago
-
Senior Data Engineer – AWS & Snowflake USD 134K-187KAWS | AWS Glue | AWS Lambda | Amazon S3 | Apache AirflowSenior-level Full TimeIslamabad, Lahore or Karachi6d ago
-
AI Solution Engineer (Agentic & Prompt) USD 80K-145KAutomation | Data Modeling | ETL | FastAPI | FlaskMid-level Full TimeLahore, Pakistan7d ago
-
Reporting & Data Management Specialist USD 117K-165KAnalytics | Data Architecture | Data Governance | Data Modeling | Data WarehousingSenior-level Full TimeLahore, Punjab, Pakistan9d ago
-
BAR | BTEQ | FastLoad | HDFS | HadoopSenior-level Full TimeLahore, Pakistan R9d ago
-
Senior Data & AI Engineer USD 160K-244KARIMA | Airflow | Anthropic Claude | Anthropic Claude SDK | BigQuerySenior-level Full TimeLahore, PK10d ago
-
Data Engineer USD 110K-140KData Analysis | Data Pipeline Development | Data Processing | Data Quality | Data ValidationCollaborative environment | Global client exposure | Impactful projects | Ownership culture | Professional growthMid-level Full TimeLahore, Punjab, Pakistan10d ago
-
Database Engineer (Azure Databricks) INR 1500K-2000KAzure Data | Azure Data Factory | Azure Data Lake | Azure Databricks | Azure DevOpsCollaborative culture | Compensation | Flexible environment | Large-scale data platform projects | Learning SupportMid-level Full TimeLahore, PK14d ago
-
Senior-level Full TimeLahore, Punjab, Pakistan14d ago
-
Senior-level Full TimeKarachi or Lahore17d ago
-
Data Engineer USD 100K-200KAPI Integration | Azure Data | Azure Data Factory | Azure Databricks | Azure SQLEOBI | Gym | Health insurance | Life insurance | MealsMid-level Full TimePakistan18d ago
-
Senior Data Engineer USD 117K-238KApache Spark | Azure Data | Azure Data Factory | Azure Synapse | Big DataSenior-level Full TimeLahore, Pakistan21d ago
-
CI/CD | DBT | Data Architecture | Data Governance | Data ModelingSenior-level Full TimeLahore, Karachi, Islamabad22d ago
-
Mid-level Full TimeLahore, Punjab, Pakistan23d ago
-
Sr. Databricks Azure Data Engineer USD 139K-237KApache Spark | Apache Spark internals | Azure DevOps | Azure Security | Azure ecosystemSenior-level ContractPakistan - Remote R24d ago
-
Data Architect – AWS USD 122K-184KAWS DataZone | AWS Glue | AWS Lambda | Agile SAFE | Amazon CloudWatchSenior-level Full TimeLahore, Punjab24d ago
-
Senior-level Full TimeIslamabad, Federal Territory24d ago
-
Data Architect – AWS USD 122K-184KAWS DataZone | AWS Glue | AWS Lambda | Agile SAFE | Amazon CloudWatchSenior-level Full TimeKarachi, Sindh24d ago
-
Mid-level Full TimeLahore, PK25d ago