Posted:2 days ago|
Platform:
On-site
Full Time
Job Title: Postgres Database Developer
Education Qualification: BE/B. Tech/MCAExperience: 5+ yearsLocation: Shimla, Himachal Pradesh
Shift- 6 Days working (Monday to Saturday)
Job Summary We 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 teams to ensure database reliability, performance, and scalability for our applications.
Required 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 writing PL/pgSQL functions, procedures, and triggers.Exposure to data migration, including use of COPY, FDW, and data loaders. Understanding of indexes, constraints, and transaction isolation levels.
Knowledge of other databases (Oracle, MySQL) and migration strategies.
Key Responsibilities
Design and develop complex SQL queries, stored procedures, triggers, and functions in PostgreSQL.Perform performance tuning and optimization of PostgreSQL queries and indexing strategies.
Work closely with application developers, data engineers, and architects to implement efficient data structures and access paths.Migrate data from legacy systems or other RDBMS (e.g., Oracle, DB2) into PostgreSQL. Write ETL scripts and batch jobs for data processing and transformation.
Assist in schema design, table partitioning, and materialized view creation. Proactively address slow queries and long-running processes
Job Types: Full-time, Permanent
Pay: ₹881,163.43 - ₹1,497,303.05 per year
Benefits:
Schedule:
Supplemental Pay:
Work Location: In person
TechnoKraft
Upload Resume
Drag or click to upload
Your data is secure with us, protected by advanced encryption.
Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.
We have sent an OTP to your contact. Please enter it below to verify.
Instantly access job listings, apply easily, and track applications.
8.81163 - 14.97303 Lacs P.A.
5.81163 - 7.97303 Lacs P.A.
Shimla, Himachal Pradesh
8.81163 - 14.97303 Lacs P.A.
Shimla, Himachal Pradesh
5.81163 - 7.97303 Lacs P.A.
Noida, Shimla, Delhi / NCR
8.0 - 12.0 Lacs P.A.
8.81163 - 14.97303 Lacs P.A.
5.81163 - 7.97303 Lacs P.A.
