Database Engineer

3 days ago

Lahore, Punjab, Pakistan Clustox Full time $90,000 - $120,000 per year

Database Developer and Administrator

Clustox is seeking a highly skilled and experienced Database Developer & Administrator with expertise in PostgreSQL and AWS Aurora to join our growing team in Lahore, Pakistan. As a Database Developer & Administrator, you will play a critical role in ensuring the performance, scalability, and security of our AWS Aurora PostgreSQL databases. Youll collaborate with engineers to design robust systems, optimize queries, and support our multi-tenant architecture, all while maintaining compliance with industry standards.

Responsibilities

  • Monitor real-time database performance, including blocked queries and database locks.
  • Manage and maintain user permissions, ensuring proper access control to schemas and tables.
  • Develop and execute custom Django migrations when standard migrations are inefficient or too slow.
  • Perform custom large-scale database edits to resolve data integrity issues or operational anomalies.

  • Implement blue/green table migration strategies for safe and seamless data structure changes.

  • Identify, analyze and optimize slow queries using EXPLAIN plans and index tuning.

  • Tune PostgreSQL settings (e.g., work_mem, shared_buffers, autovacuum) for optimal performance.
  • Actively optimize inefficient and eliminate stored procedures
  • Provide guidance on query optimization, transaction handling, and data modeling.
  • Assist in debugging production incidents and support root cause analysis (RCA).
  • Recommend scaling strategies, such as vertical or horizontal scaling, to meet demand.
  • Design and implement scalable multi-tenant customer schemas via Sharding to handle growing clients.
  • Collaborate with engineers to design efficient, normalized database schemas.
  • Review schema changes to ensure performance and scalability for future growth.
  • Maintain logs and controls to meet compliance requirements (e.g., SOC2, HIPAA, GDPR).
  • Support audits by providing traceable database activity records.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • 5+ years of experience in database administration or development, preferably with AWS Aurora PostgreSQL.
  • Proven expertise in Python, PostgreSQL, and AWS (e.g., Aurora RDS, EC2, S3).
  • Familiarity with Aurora Serverless, Django and React would be a plus.
  • Experience with compliance standards (e.g., SOC2, HIPAA, GDPR) is highly desirable.
  • Strong proficiency in analyzing and optimizing SQL queries using EXPLAIN plans and indexing.
  • Deep understanding of PostgreSQL configuration and performance tuning.
  • Ability to design scalable, normalized database schemas for multi-tenant systems.
  • Excellent problem-solving skills and experience with production incident debugging.
  • Strong communication skills to collaborate with cross-functional teams.
  • Knowledge of compliance requirements and audit processes.

  • Database Engineer

    4 weeks ago

    Lahore, Punjab, Pakistan Clustox Inc. Full time

    About the job Senior Database Developer (PostgreSQL / AWS Aurora)Database Developer and AdministratorClustox is seeking a highly skilled and experienced Database Developer & Administrator with expertise in PostgreSQL and AWS Aurora to join our growing team in Lahore, Pakistan. As a Database Developer & Administrator, you will play a critical role in ensuring...

  • Senior Database Engineer

    4 weeks ago

    Lahore, Punjab, Pakistan M365Connect Full time

    Manatal Database Sync ProjectSenior Database Engineer - Data Synchronization SpecialistCompany OverviewWe are seeking an experienced Database Engineer to architect and maintain our Manatal recruitment database synchronization infrastructure. This role is critical for maintaining data authority, overcoming API throttling limitations, and providing flexible...

  • AWS Database Engineer

    4 days ago

    Lahore, Punjab, Pakistan Cloudelligent Full time

    OverviewPosition Title: AWS Database EngineerJob Timings: 8:00 AM – 5:00 PM CST (6:00 PM- 3:00 AM PKT)Location: LahoreAbout CloudelligentCloudelligent is Cloud-native consultancy and AWS Advanced consulting partner We specialize in providing bespoke cloud solutions to Startups & SMBs. Being a next-gen cloud service provider, Cloudelligent helps businesses...

  • Senior Database Engineer

    3 days ago

    Lahore, Punjab, Pakistan M365Connect Full time $90,000 - $120,000 per year

    Manatal Database Sync ProjectSenior Database Engineer - Data Synchronization SpecialistCompany OverviewWe are seeking an experienced Database Engineer to architect and maintain our Manatal recruitment database synchronization infrastructure. This role is critical for maintaining data authority, overcoming API throttling limitations, and providing flexible...

  • AWS Database Engineer

    6 days ago

    Lahore, Punjab, Pakistan Cloudelligent Full time

    2 days ago Be among the first 25 applicantsJob Timings: 8:00 AM – 5:00 PM CST (6:00 PM- 3:00 AM PKT)Location:LahoreCloudelligent is Cloud-native consultancy and AWS Advanced consulting partner We specialize in providing bespoke cloud solutions to Startups & SMBs. Being a next-gen cloud service provider, Cloudelligent helps businesses to make the most out...

  • Implementation & Database Engineer

    3 days ago

    Lahore, Punjab, Pakistan MyHCM Full time $50,000 - $100,000 per year

    We are looking for a passionate and detail-oriented Database Engineer to join our team. This is a great opportunity for fresh graduates or junior professionals to gain hands-on experience in database development, stored procedures, function optimization, API integrations, and reporting. You will work closely with senior engineers and cross-functional teams...

  • Database Administrator

    3 days ago

    Lahore, Punjab, Pakistan Aitomation Pvt Ltd. Full time 85,000 per year

    Job Description:We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing...

  • Senior Database Specialist

    6 days ago

    Lahore, Punjab, Pakistan beBeeDatabase Full time $90,000 - $120,000

    Job DescriptionWe are seeking an experienced Database Engineer to join our team. The successful candidate will have a strong background in database administration and optimization in cloud environments, particularly on AWS.The ideal candidate will possess hands-on experience with both SQL and NoSQL databases on AWS, including Amazon RDS, Aurora, and...

  • Database Administrator

    3 days ago

    Lahore, Punjab, Pakistan Burq Full time $90,000 - $120,000 per year

    About BurqBurq started with an ambitious mission: how can we turn the complex process of offering delivery into a simple turnkey solution.We started with building the largest network of delivery networks, partnering with some of the biggest delivery companies. We then made it extremely easy for businesses to plug into our network and start offering delivery...

  • Associate Database Administrator

    3 days ago

    Lahore, Punjab, Pakistan Aitomation Pvt Ltd. Full time $60,000 - $120,000 per year

    We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations...