Database Developer

2 days ago

Shimla Himachal Pradesh India, Himachal Pradesh People Prime Worldwide Full time

Job Title: PostgreSQL Database Developer

Location: Shimla

Experience: 7+ Years (STRICTLY)

Employment Type: Permanent

Notice Period: Immediate Joiners Only


About the Company:


Our client is a trusted global innovator of IT and business services, present in 50+ countries. They specialize in digital & IT modernization, consulting, managed services, and industry-specific solutions. With a commitment to long-term success, they empower clients and society to move confidently into the digital future.


Job Description:


Must Have Skills:

  • PostgreSQL (Production Experience)
  • Advanced SQL
  • Query Optimization & Performance Tuning
  • PL/pgSQL
  • PostgreSQL Internals & Explain Plans
  • Indexes, Constraints & Transaction Isolation
  • Data Migration (COPY, FDW, Data Loaders)
  • ETL & Batch Processing


Minimum Qualifications:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).
  • 7+ years of hands-on experience working with PostgreSQL in production environments.
  • Strong experience in SQL query writing, optimization, and performance tuning.
  • Proficiency in writing PL/pgSQL functions, procedures, and triggers.
  • Solid understanding of PostgreSQL internals, indexing strategies, and execution plans.


Preferred Qualifications:

  • Experience with data migration from Oracle, DB2, MySQL, or other RDBMS to PostgreSQL.
  • Strong understanding of transaction isolation levels and concurrency control.
  • Experience with schema design, table partitioning, and materialized views.
  • Exposure to ETL processes, batch jobs, and data transformation pipelines.
  • Ability to proactively identify and resolve slow queries and long-running processes.


Responsibilities:

  • Design, develop, and maintain complex SQL queries, stored procedures, triggers, and functions in PostgreSQL.
  • Perform PostgreSQL performance tuning, query optimization, and indexing improvements.
  • Collaborate closely with application developers, data engineers, and architects to design efficient data models and access paths.
  • Handle data migration from legacy systems or other RDBMS into PostgreSQL.
  • Develop and maintain ETL scripts and batch jobs for data processing and transformation.
  • Assist in schema design, table partitioning strategies, and creation of materialized views.
  • Monitor database performance and proactively resolve slow-running queries and bottlenecks.



Important Note (Please Read Before Applying)

Do NOT apply if:

  • You have less than 7 years of PostgreSQL experience
  • You do not have hands-on PostgreSQL development in production environments
  • You are on a notice period longer than immediate availability
  • You are a fresher or from an unrelated background (e.g., support-only, testing-only roles)

✅ Apply ONLY if you meet ALL criteria above.

Random or irrelevant applications will not be processed.

  • Postgres Database Developer

    2 days ago

    Shimla, Himachal Pradesh, India, Himachal Pradesh People Prime Worldwide Full time

    Job Title: Postgres Database DeveloperEducation Qualification: BE/B. Tech/MCAExperience: 5+ yearsLocation: Shimla, Himachal PradeshJob SummaryWe are looking for a highly skilled PostgreSQL Database Developer to design, develop, optimize, and maintain our database systems. The candidate will work closely with software engineers, data analysts, and DevOps...

  • Postgres Database Developer

    4 days ago

    Shimla, Himachal Pradesh, India, Himachal Pradesh People Prime Worldwide Full time

    Job Title: Postgres Database DeveloperClient : QuantellaExperience: 5+ yearsLocation: Shimla, Himachal PradeshRequired Skills: • 5+ years of hands-on experience with PostgreSQL in a production environment.• Strong SQL skills, including query optimization and performance tuning.• Experience with PostgreSQL internals and explain plans.• Proficiency in...

  • PL/SQL Developer

    2 weeks ago

    Shimla, Himachal Pradesh, India Inscire Solutions Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Job Title: Database Migration Specialist (MySQL to Oracle PL/SQL)Project Type: BankingAbout the RoleWe are seeking a technical expert for a project to migrate a MySQL database to Oracle. The core of this job is writing the necessary Oracle PL/SQL functions and procedures to translate all existing business logic and ensure a seamless data transition.Core...

  • Laravel Developer

    3 days ago

    Shimla, Himachal Pradesh, India Eligo Creative Services Full time

    Job Description:–*Job Title: PHP-Laravel-Developer*Work Experience: 2 -3 Years*Work Type: On-Site*Work Location: Shimla, Himachal PradeshJob Description:The PHP Laravel Developer will be responsible for developing web applications using the Laravel framework, maintaining and enhancing existing web applications, and collaborating with cross-functional teams...

  • Digital Marketing Manager

    1 week ago

    Indore, Madhya Pradesh, India, Madhya Pradesh PAB Learn, Lead & Grow Private Limited Full time

    Company DescriptionPAB Learn, Lead & Grow Private Limited is an EdTech company and a pioneer in the executive education space, catering to top B-Schools. We offer Executive MBA, Online/Distance MBA, Online B.Com, BBA, Diploma, and Certification courses from India's leading B-Schools. Our mission is to provide quality education and professional development...

  • LSE / Associate Architect - Big Data

    2 weeks ago

    Indore, Madhya Pradesh, India, Madhya Pradesh Impetus Full time

    QualificationLead Software Engineer / Associate Architect with proficiency in design and implmentation of scalable and robust data engineering solutionsRoleIn-depth understanding of Big data concepts and distributed systemsProficiency in Python and writing code in PySparkShould possess good understanding of SQL concepts and must be proficient writing complex...

  • Data Engineer

    2 days ago

    Indore, Madhya Pradesh, India, Madhya Pradesh Engineer Master Labs Pvt. Ltd™ Full time

    Company DescriptionEngineer Master Labs Pvt. Ltd™ is an IT service provider located in Indore, India, specializing in a range of services including website development, logo designing, mobile app development for both hybrid and native platforms, and animation. The company is dedicated to delivering creative and innovative solutions to meet client needs....

  • Backend AI/ML Engineer

    2 weeks ago

    Indore, Madhya Pradesh, India, Madhya Pradesh TalentLynk Full time

    Position: Backend AI/ML Engineer (with Full Stack Expertise)Experience: 3–8 Type: Fulltime| HybridAbout the RoleThis role transcends traditional backend development. We’re seeking a highly skilled Backend AI/ML Engineer with strong Python expertise and a working understanding of Full Stack systems.You’ll architect and scale backend infrastructures that...

  • Librarian

    1 week ago

    Mathura, Uttar Pradesh, India, Uttar Pradesh GLA University Full time

    About companyGLA University Mathura is the 12th Private University in India to receive a 12B status and is counted among the recognized universities of Uttar Pradesh. GLA University has maintained a tradition of academic excellence for 26 years and is poised for achieving even greater heights in higher education. Its academic pool of over 1000 highly...

  • Sr. Executive – Procurement

    6 days ago

    Indore, Madhya Pradesh, India, Madhya Pradesh KAAPRO Full time

    Thorough knowledge of procurement of goods / services on Government E Marketplace portal, as per policy and guidelines.Preparation of tender & contract documents for works like civil & utility works/services etc., and also for procurement of imported equipment (if any).Thorough knowledge of floating of tender on CPPP Portal.Developing...