Database Developer and Administrator

4 weeks ago

Islamabad, Islamabad, Pakistan VentureDive Private Limited Full time
Job Brief
As a Database Administrator (DBA)/Database Developer in our Technology/Engineering department, you will play a critical role in ensuring the performance, scalability, and security of our AWS Aurora PostgreSQL databases. You'll collaborate with engineers to design robust systems, optimize queries, and support our multi-tenant architecture, all while maintaining compliance with industry standards.
  • 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.
VentureDive Overview
Founded in 2012 by veteran technology entrepreneurs from MIT and Stanford, VentureDive is the fastest-growing technology company in the region that develops and invests in products and solutions that simplify and improve the lives of people worldwide. We aspire to create a technology organization and an entrepreneurial ecosystem in the region that is recognized as second to none in the world.

Key Responsibilities:
  • 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.
Required Experience & Qualification:
  • 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.
What we look for beyond required skills
In order to thrive at VentureDive, you
…are intellectually smart and curious
…have the passion for and take pride in your work
…deeply believe in VentureDive's mission, vision, and values
…have a no-frills attitude
…are a collaborative team player
…are ethical and honest

Are you ready to put your ideas into products and solutions that will be used by millions?
You will find VentureDive to be a quick pace, high standards, fun and a rewarding place to work at. Not only will your work reach millions of users world-wide, you will also be rewarded with competitive salaries and benefits. If you think you have what it takes to be a VenDian, come join us ... we're having a ball

#LI-Hybrid
#J-18808-Ljbffr

  • Database Administrator

    2 days ago

    Islamabad, Islamabad, Pakistan caresoft Full time $80,000 - $120,000 per year

    Database AdministratorPostgres, postgis, mongodb, oracle, sql, shell scriptingJob Type: Full-timeExperience:Postgres, postgis, mongodb, oracle, sql, shell scripting: 5 years (Preferred)Work Location: In person

  • Database Administrator

    2 days ago

    Islamabad, Islamabad, Pakistan SOFTOO Full time $125,000 - $175,000 per year

    OverviewWe are hiring aSenior Database Engineerto design, optimize, and manage the data storage layer of our data analytics platform. This role is critical in ensuring the performance, reliability, and scalability of our data infrastructure — which supports ingesting and processing over a terabyte of telemetry data daily from thousands of edge devices.You...

  • Junior Oracle Database Administrator

    6 days ago

    Islamabad, Islamabad, Pakistan PRAL, FBR Full time

    OverviewWe are seeking a certified Junior Oracle DBA (OCP) to assist in managing, maintaining, and securing our Oracle Database environments, including Exadata, Oracle Vault, and Database Firewall implementations. The ideal candidate will have foundational knowledge of Oracle database administration, performance tuning, and security best practices, with a...

  • Junior Oracle Database Administrator

    2 days ago

    Islamabad, Islamabad, Pakistan PRAL, FBR Full time $60,000 - $100,000 per year

    Job SummaryWe are seeking acertified Junior Oracle DBA (OCP)to assist in managing, maintaining, and securing ourOracle Database environments, includingExadata, Oracle Vault, and Database Firewallimplementations. The ideal candidate will have foundational knowledge of Oracle database administration, performance tuning, and security best practices, with a...

  • PostgreSQL Database Administrator

    2 days ago

    Islamabad, Islamabad, Pakistan HumeniQ Full time 3,600,000 per year

    Database Administrator (PostgreSQL)Location:Islamabad, PakistanWork Type:On-siteBudget:Up to PKR 300,000/monthExperience Required:Minimum 4 yearsKey Skill:PostgreSQL (mandatory)Job FunctionsInstall, configure, and upgrade PostgreSQL and MySQL on Linux (RHEL, Ubuntu, CentOS, Debian).Manage clustering, replication (streaming, logical, GTID-based), high...

  • Database Administrator

    1 day ago

    Islamabad, Islamabad, Pakistan Nobility Full time

    Build database systems of high availability and quality depending on each end user's specialized roleDesign and implement database in accordance to end users' information needs and viewsDefine users and enable data distribution to the right user, in appropriate format and in a timely mannerUse high-speed transaction recovery techniques and backup...

  • Database Administrator and develops engineer

    3 weeks ago

    Islamabad, Islamabad, Pakistan ieng Group Full time

    Database Administrator and Development EngineerGet AI-powered advice on this job and more exclusive features.Direct message the job poster from ieng GroupConnecting People with Purpose | Global Talent Acquisition | CSR | Employer BrandingGrade: DReports To: Lead DeveloperRole and ResponsibilitiesConfigure and maintain on-premises servers for development,...

  • Junior Database Specialist

    5 days ago

    Islamabad, Islamabad, Pakistan beBeeDatabaseAdministrator Full time 400,000 - 800,000

    Junior Oracle Database Administrator Job SummaryWe are seeking a certified Junior Oracle DBA (OCP) to assist in managing, maintaining, and securing our Oracle Database environments, including Exadata, Oracle Vault, and Database Firewall implementations. The ideal candidate will have foundational knowledge of Oracle database administration, performance...

  • Database Developer

    2 days ago

    Islamabad, Islamabad, Pakistan Teresol Pvt. Ltd. Full time 900,000 - 1,200,000 per year

    Position:Database DeveloperLocation:IslamabadCompany:TeReSol Pvt. Ltd.Job Type:Full-Time | Senior LevelAbout the RoleTeReSol Pvt. Ltd. is seeking a skilled Database Developer to join our growing team in Islamabad. If you have a strong background in database architecture and hands-on experience with Oracle and PostgreSQL, we would like to hear from youKey...

  • Database Engineer

    2 days ago

    Islamabad, Islamabad, Pakistan Teresol Pvt. Ltd. Full time 900,000 - 1,200,000 per year

    Join Our Team at TeReSol Pvt. Ltd.Position: Database EngineerDepartment: Software/ITLocation: Islamabad (DHA Phase II)Employment Type: Full-timeExperience Required: 3–5 YearsEducation: BS/MS in Computer Science, Software Engineering, or related fieldAbout the RoleTeReSol Pvt. Ltd. is looking for a skilled Database Engineer to support our enterprise...