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
-
Associate Software Engineer - Data Science USD 129K-212KData Analysis | Data Preprocessing | Data Visualization | Exploratory Data Analysis | Feature EngineeringMid-level Full TimeLahore, Punjab, Pakistan1d ago
-
Associate Software Engineer - Data Science USD 129K-212KData Analysis | Data Preprocessing | Data Visualization | Exploratory Data Analysis | Feature EngineeringMid-level Full TimeIslamabad, Islamabad Capital Territory, Pakistan1d ago
-
Data Analyst/Data Architect USD 117K-165KAPI Integration | Anomaly Detection | Conceptual data modeling | Data Cleansing | Data GovernanceCompany-paid trips | Gym membership | Health insurance | Leaves | Maternity benefitsSenior-level Full TimeLahore, Punjab, Pakistan1d ago
-
Senior-level Full TimeLahore, Punjab, Pakistan2d ago
-
Senior-level Full TimeLahore, Punjab, Pakistan2d ago
-
Senior Analytics Engineer II - Teknosys USD 97K-130KAgile | Automation | BI | Cloud Platforms | Data LakeMid-level Full TimeIslamabad, Islamabad Capital Territory, Pakistan2d ago
-
Data Engineer USD 135K-165KAzure Data | Azure Data Factory | Azure Data Lake | Azure Data Lake Storage | Azure SynapseHealth insurance | Paid time off | Training and development | Work from homeSenior-level Full TimePakistan - Remote R2d ago
-
Senior-level Full TimeKarachi, Pakistan6d ago
-
Senior Data Engineer USD 133K-163KAirflow | Apache Spark | Cloud platform | Cost Optimization | DBTHealthcare benefits | Hybrid workSenior-level Full TimeLahore, Punjab, Pakistan7d ago
-
Senior ML Engineer I USD 153K-215KAWS | CI/CD | Cloud platform | Dash | DockerHealthcare benefits | Hybrid work | Learning opportunities | Local benefits | Work from home flexibilitySenior-level Full TimeLahore, Punjab, Pakistan7d ago
-
Mid-level Full TimePakistan - Remote R7d ago
-
Senior-level Full TimePakistan - Remote R7d ago
-
Senior Analytics/BI Developer CAD 120K-130KCause analysis | DAX | Data Modeling | Data Performance Optimization | Data QualityChild care facility | Conveyance allowance | Home internet subsidy | Leave encashment | Life benefitSenior-level Full TimePER - Lahore, PK, Pakistan8d ago
-
Advanced Analytics | Apache Airflow | Apache Kafka | Apache Spark | Artificial IntelligenceExecutive-level Full TimePakistan9d ago
-
Applied AI Scientist (PhD Required) USD 175K-230KAgentic Workflows | Anomaly Detection | Data Quality | Hypothesis Testing | LLM toolsSenior-level Full TimeLahore, Punjab9d ago
-
APIs | Amazon Redshift | Apache Spark | BigQuery | CTEEvening shift | Onsite workMid-level Full TimeLahore, Pakistan10d ago
-
ADF triggers | Azure | Azure Blob | Azure Blob Storage | Azure DataMid-level Full TimeKarachi, Pakistan10d ago
-
APIs | Azure Data | Azure Data Factory | Azure Databricks | Azure FabricFlexible working hours | Hybrid workMid-level Full TimeKarachi, Pakistan10d ago
-
Senior Data Engineer USD 100K-150KAPI Design | Advanced SQL | Apache | Big Data | C#Continuing education program | Continuous learning resources | Family-friendly perks | Generous time off | Health care coverageSenior-level Full TimePK - ISLAMABAD 101 W AL …14d ago
-
Senior Data Engineer USD 100K-150KAPI Design | Agile | Apache Hadoop | Apache Spark | BigQueryCompany-matched student loan contribution | Continuous learning resources | Family-friendly perks | Financial wellness programs | Flexible time offSenior-level Full TimePK - ISLAMABAD 101 W AL …14d ago
-
Senior Data Engineer INR 2000K-2000KACID transactions | Airflow | Apache Spark | Automated testing | BackfillingFull-time employment | Hybrid workSenior-level Full TimePakistan - Remote R14d ago
-
AVP - Data Solutions Architect.MGN Pak - Information Management - One Data.MIT - PAKCOE USD 120K-180KAI | Agile | BI reporting | Big Data | Big Data TechnologiesSenior-level Full TimePakistan16d ago
-
API Integration | AWS | Apps Script | CSS | Claude AIFlexible work hours | Opportunity to work on AI projectsMid-level Full TimeKarachi, Pakistan18d ago
-
Principal Data Engineer GBP 70K-95KAPIs | Analytics Platforms | Arrow | Azure | Azure SynapseBenefits | Career growth | Collaborative culture | Team developmentSenior-level Full TimeLahore, Pakistan21d ago
-
Cloud Data Integration | Data Modeling | Data Transformation | Data Warehousing | Data integrationMid-level Full TimeIslamabad, Federal Teritory25d ago