Database Engineer

2 weeks ago

Lahore, Punjab, Pakistan Clustox Inc. Full time
About the job Senior Database Developer (PostgreSQL / AWS Aurora)

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.

#J-18808-Ljbffr

  • Senior Database Engineer

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

  • Cloud Infrastructure and Database Operations Engineer

    3 weeks ago

    Lahore, Punjab, Pakistan Cinnova Technologies, LLC Full time

    We are looking for highly skilled Cloud Infrastructure and Database Operations Engineer. The purpose of the Cloud Infrastructure and Database Operations Engineer is to deliver a sustainable, high-quality, end-to-end cloud infrastructure hosting service that supports the Company's products and the Inspire platform. This role is responsible for continuously...

  • Database Administrator

    4 weeks ago

    Lahore, Punjab, Pakistan I.T. Path Full time

    Direct message the job poster from I.T. PathJob Description:We are seeking an experienced and highly motivated SQL Server Database Administrator (DBA) to join our growing technology team. The ideal candidate will be responsible for the performance, integrity, security, and high availability of our SQL Server environments across both Windows and Linux...

  • Senior Database Engineer

    2 weeks ago

    Lahore, Punjab, Pakistan Axiom World (Pvt) Ltd Full time

    Job Title: Senior Data Analyst / Data Solutions SpecialistLocation:Johar TownExperience Required: 7–8 yearsEmployment Type:ContractualAbout the Role:We are seeking an experienced and detail-oriented Senior Data Analyst / Data Solutions Specialist to lead our data initiatives. In this role, you will be responsible for managing large-scale databases,...

  • Database Administrator

    3 weeks ago

    Lahore, Punjab, Pakistan Burq, Inc. Full time

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

  • Database Administrator

    2 weeks ago

    Lahore, Punjab, Pakistan Burq Full time

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

  • Database Administrator

    2 weeks ago

    Lahore, Punjab, Pakistan I.T. Path Full time

    Get AI-powered advice on this job and more exclusive features.Direct message the job poster from I.T. PathJob Description:We are seeking an experienced and highly motivated SQL Server Database Administrator (DBA) to join our growing technology team. The ideal candidate will be responsible for the performance, integrity, security, and high availability of our...

  • Senior/Principal Database Developer

    4 weeks ago

    Lahore, Punjab, Pakistan Soliton Technologies Full time

    Join to apply for the Senior/Principal Database Developer role at Soliton Technologies1 day ago Be among the first 25 applicantsJoin to apply for the Senior/Principal Database Developer role at Soliton TechnologiesGet AI-powered advice on this job and more exclusive features.Job DescriptionWe are seeking experienced and skilled Database Developers with 3-7...

  • Senior Database Migration Expert

    3 weeks ago

    Lahore, Punjab, Pakistan Abacus Full time

    Join to apply for the Senior Database Migration Expert role at Abacus2 days ago Be among the first 25 applicantsJoin to apply for the Senior Database Migration Expert role at AbacusGet AI-powered advice on this job and more exclusive features.We are seeking a Senior Database Migration Expert with deep expertise in migrating complex, high-availability Oracle...

  • Senior Database Migration Expert

    2 weeks ago

    Lahore, Punjab, Pakistan Abacus Global Full time

    We are seeking a Senior Database Migration Expert with deep expertise in migrating complex, high-availability Oracle RAC environments to Google Cloud Platform (GCP) using PostgreSQL or AlloyDB. The ideal candidate will be responsible for planning, designing, and executing end-to-end database migration strategies for mission-critical systems, ensuring minimal...