PostgreSQL Database

7 days ago


Chennai Tamil Nadu, India Yaanar Technologies Pvt Ltd Full time

**Job Title**: PostgreSQL Consultant
**Experience**: 3-5 Years
**Location**: Chennai
**Employment Type**: Full-time

**Job Summary**

**Key Responsibilities**
- Analyze and understand business requirements to design scalable PostgreSQL database solutions.
- Install, configure, and upgrade PostgreSQL databases.
- Optimize database performance through query tuning, indexing strategies, and schema design.
- Perform regular database maintenance tasks, such as backups, restorations, and monitoring.
- Ensure database security by implementing best practices, such as access controls and encryption.
- Troubleshoot database-related issues, including performance bottlenecks and errors.
- Provide guidance on database migration and version upgrades.
- Write and maintain detailed documentation for database architecture, processes, and best practices.
- Conduct training sessions or workshops for team members or clients, as needed.

**Required Skills & Qualifications**
- **Technical Expertise**:

- Proficient in PostgreSQL database management, optimization, and administration.
- Strong knowledge of SQL, PL/pgSQL, and advanced PostgreSQL features like partitioning and replication.
- Experience with database monitoring and performance tools (e.g., pgAdmin, pg_stat_statements, or equivalent).
- Familiarity with backup and disaster recovery strategies.
- Understanding of database design, normalization, and indexing techniques.
- Experience with PostgreSQL extensions like PostGIS, pgRouting, or others is a plus.
- Familiarity with Linux environments and basic shell scripting.
- **Soft Skills**:

- Strong analytical and problem-solving skills.
- Excellent communication and interpersonal skills.
- Ability to manage multiple priorities and work independently or as part of a team.

**Preferred Qualifications**
- Experience with cloud-based PostgreSQL solutions (e.g., Amazon RDS, Google Cloud SQL, Azure Database for PostgreSQL).
- Knowledge of additional database systems or tools, such as MySQL, MongoDB, or Oracle.
- Familiarity with DevOps practices, CI/CD pipelines, and containerization tools like Docker.
- Basic understanding of programming languages like Python, Java, or PHP.

**Education**:

- Bachelor’s or Master’s degree in Computer Science, Information Technology, or related fields.

**Job Types**: Full-time, Permanent

Pay: ₹30,000.00 - ₹70,000.00 per year

**Benefits**:

- Health insurance
- Life insurance
- Provident Fund

Schedule:

- Day shift
- Monday to Friday

Work Location: In person



  • tamil nadu, India Softone HR Solutions Full time

    Dear All,We are hiring for PostgreSQL Database AdministratorRole : PostgreSQL AdministrationLocation : Chennai Experience : 4 to 10 Years Mode : Work from Office Job description:Minimum of 4+ years of professional experience in PostgreSQL AdministrationExpert-level knowledge of PostgreSQL concepts, including advanced SQL, PL/pgSQL programming, and database...


  • Chennai, Tamil Nadu, India, Tamil Nadu Softone HR Solutions Full time

    Dear All,We are hiring for PostgreSQL Database AdministratorRole : PostgreSQL AdministrationLocation : Chennai Experience : 4 to 10 Years Mode : Work from Office Job description:Minimum of 4+ years of professional experience in PostgreSQL AdministrationExpert-level knowledge of PostgreSQL concepts, including advanced SQL, PL/pgSQL programming, and database...


  • Chennai, India Softone HR Solutions Full time

    Dear All,We are hiring for PostgreSQL Database AdministratorRole : PostgreSQL AdministrationLocation : ChennaiExperience : 4 to 10 YearsMode : Work from OfficeJob description:- Minimum of 4+ years of professional experience in PostgreSQL Administration- Expert-level knowledge of PostgreSQL concepts, including advanced SQL, PL/pgSQL programming, and database...


  • Chennai, India Softone HR Solutions Full time

    Dear All,We are hiring for PostgreSQL Database AdministratorRole : PostgreSQL AdministrationLocation : ChennaiExperience : 4 to 10 YearsMode : Work from OfficeJob description:- Minimum of 4+ years of professional experience in PostgreSQL Administration- Expert-level knowledge of PostgreSQL concepts, including advanced SQL, PL/pgSQL programming, and database...


  • Chennai, India Softone HR Solutions Full time

    Dear All, We are hiring for PostgreSQL Database Administrator Role : PostgreSQL Administration Location : Chennai Experience : 4 to 10 Years Mode : Work from Office Job description: - Minimum of 4+ years of professional experience in PostgreSQL Administration - Expert-level knowledge of PostgreSQL concepts, including advanced SQL, PL/pgSQL programming, and...


  • Chennai, India Softone HR Solutions Full time

    Dear All, We are hiring for PostgreSQL Database Administrator Role : PostgreSQL Administration Location : Chennai Experience : 4 to 10 Years Mode : Work from Office Job description: Minimum of 4+ years of professional experience in PostgreSQL Administration Expert-level knowledge of PostgreSQL concepts, including advanced SQL, PL/pgSQL programming, and...


  • Chennai, India Softone HR Solutions Full time

    Dear All,We are hiring for PostgreSQL Database AdministratorRole : PostgreSQL AdministrationLocation : ChennaiExperience : 4 to 10 YearsMode : Work from OfficeJob description:Minimum of 4+ years of professional experience in PostgreSQL AdministrationExpert-level knowledge of PostgreSQL concepts, including advanced SQL, PL/pgSQL programming, and database...


  • Tharamani, Chennai, Tamil Nadu, India mds hr consultancy Full time

    Designation - AWS PostgreSQL Database Administrator (DBA) No of Positions opening for : 1 Experience must be between 3-4 Years CTC upto - 13,00,000 **Position Overview**: As an AWS PostgreSQL Database Administrator (DBA), you will play a critical role in managing and maintaining the performance, integrity, and security of PostgreSQL databases hosted on...


  • Chennai, India Softone HR Solutions Full time

    Dear All, We are hiring for PostgreSQL Database Administrator Role : PostgreSQL Administration Location : Chennai Experience : 4 to 10 Years Mode : Work from Office Job description: Minimum of 4+ years of professional experience in PostgreSQL Administration Expert-level knowledge of PostgreSQL concepts, including advanced SQL, PL/pgSQL programming, and...


  • Chennai, India Softone HR Solutions Full time

    Dear All, We are hiring for PostgreSQL Database Administrator Role : PostgreSQL Administration Location : Chennai Experience : 4 to 10 Years Mode : Work from Office Job description: Minimum of 4+ years of professional experience in PostgreSQL Administration Expert-level knowledge of PostgreSQL concepts, including advanced SQL, PL/pgSQL programming, and...