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 Engineer INR 2200K-2700KAWS | AWS Glue | AWS KMS | Amazon Athena | Amazon DynamoDBChild care facility | Company-provided lunch/dinner | Conveyance allowance | Friendly work environment | Home internet subsidyMid-level Full TimePER - Karachi, PK, Pakistan1d ago
-
Big Data Engineer INR 2000K-2000KApache Hadoop | Apache Hive | Apache Impala | Apache Kafka | Apache NiFiMid-level Full TimeKarachi, Sindh2d ago
-
Mid-level Full TimeLahore, Punjab2d ago
-
Senior Database Engineer USD 139K-205KAWS | Amazon Redshift | Data Modeling | Data Warehousing | ETLHybrid workSenior-level Full TimeKarachi, Sindh2d ago
-
Senior Database Engineer USD 139K-205KAWS | AWS Glue | AWS Lambda | Amazon Redshift | Amazon S3Hybrid workSenior-level Full TimeLahore2d ago
-
Senior Database Engineer USD 139K-205KAmazon Redshift | Amazon Web Services | Data Modeling | Data Warehousing | ETLHybrid workSenior-level Full TimeIslamabad, Islamabad Territory2d ago
-
Senior Data Scientist II EUR 54K-84KAB Testing | BigQuery | Data Mining | Deep learning | HadoopFitness reimbursements | Flexible work schedule | Healthcare benefits | Remote work days | Unlimited vacation daysSenior-level Full TimePakistan2d ago
-
Data Engineer USD 94K-145KCloud Data Integration | Data Modeling | Data integration | ETL | Oracle CloudMid-level ContractKarachi, Sindh3d ago
-
Data Engineer USD 94K-145KCloud Data Integration | Data Modeling | Data integration | ETL | Oracle CloudMid-level ContractLahore, Punjab3d ago
-
Data Engineer USD 151K-208KAWS Bedrock | Airflow | Amazon Kinesis | Amazon Redshift | BigQueryEducational courses | Medical | Time offSenior-level Full TimeLahore, Punjab, Pakistan3d ago
-
Data Engineer, Tech USD 100K-144KData Modeling | Data Quality | Data Warehousing | Database Indexing | ETLMid-level Full TimeLahore, Pakistan3d ago
-
Data Engineer / Senior Data Engineer USD 120K-180KAgile | Azure Data | Azure Data Factory | Azure Data Lake | Azure Data Lake StorageSenior-level Full TimeLahore, Punjab6d ago
-
Data Engineer / Senior Data Engineer USD 120K-180KAgile | Azure Data | Azure Data Factory | Azure Data Lake | Azure Data Lake StorageSenior-level Full TimeKarachi, Sindh6d ago
-
Senior Data Engineer (AWS) USD 139K-209KAWS Glue | AWS Lambda | AWS VPC | Amazon RDS | Amazon RedshiftCollaborative team | Continuous improvement | Remote workSenior-level Full TimeLahore, Punjab7d ago
-
Senior Data Engineer (AWS) USD 139K-209KAWS Glue | AWS Lambda | AWS VPC | Amazon RDS | Amazon RedshiftRemote workSenior-level Full TimeKarachi, Sindh7d ago
-
Data Engineer USD 98K-133KCloud Data Integration | Data Modeling | Data Quality | Data Warehousing | Data integrationMid-level ContractKarachi, Sindh7d ago
-
Data Engineer USD 98K-133KCloud Data Integration | Data Modeling | Data Warehousing | Data integration | DenormalizationOffshore delivery model collaborationMid-level ContractLahore, Punjab7d ago
-
AWS CloudFormation | AWS Glue | Amazon Kinesis | Amazon Redshift | Apache AirflowRemote workMid-level Full TimePakistan - Remote R8d ago
-
Senior Data Engineer (AWS / PLSQL / Oracle) INR 3750K-6250KAWS Lambda | Amazon Redshift | Amazon S3 | Amazon Web Services | Data ModelingHybrid workSenior-level Full TimeKarachi, Sindh8d ago
-
Senior Data Engineer (AWS / PLSQL / Oracle) INR 3750K-6250KAWS | Amazon Redshift | Data Processing | Data Transformation | Data WarehousingHybrid workSenior-level Full TimeLahore, Punjab8d ago
-
Lead Data Engineer (AWS / PLSQL / PL/PGSQL) INR 1500K-4000KAWS Glue | AWS Lambda | AWS Redshift | Amazon S3 | Amazon Web ServicesHybrid work | Technical leadershipSenior-level Full TimeIslamabad, Federal Capital8d ago
-
Lead Data Engineer (AWS / PLSQL / PL/PGSQL) INR 1500K-4000KAWS Glue | AWS Lambda | Amazon Redshift | Amazon S3 | CI/CDSenior-level Full TimeKarachi, Sindh8d ago
-
Senior Data Engineer (AWS / PLSQL / Oracle) INR 3750K-6250KAWS | AWS Lambda | AWS S3 | Amazon Redshift | Data ModelingHybrid workSenior-level Full TimeIslamabad, Federal Capital8d ago
-
Lead Data Engineer (AWS / PLSQL / PL/PGSQL) INR 1500K-4000KAWS Glue | AWS Lambda | Amazon Redshift | Amazon S3 | Amazon Web ServicesHybrid workSenior-level Full TimeLahore, Punjab8d ago
-
Data Architect USD 120K-179KAlation | Amazon Web Services | Apache Airflow | Apache Atlas | Apache KafkaSenior-level Full TimeIslamabad, Federal Teritory9d ago