Job Description

Job Title: PostgreSQL
Experience: 2-3 years
Location: Ambattur, Chennai
Notice period: Immediate

Job description

We are looking for Postgresql Database

In depth knowledge of the PostgreSQL architecture

Experienced in installing, configuring and upgrading EnterpriseDB/Postgres databases and clusters.

Experience in configuring and supporting Enterprise Manager.

Setting up users tools for administration.

Experience in deploying EnterpriseDB in Linux on Power environment and good understanding of operating system concepts of Linux (RHEL).

Good knowledge of capacity planning and architecture design for database server deployment.

Proven experience in working in a mission critical environment in a multi-terabyte database platforms.

Working knowledge of architecting, configuring, setting up Enterprise Fail over manager for HA solution.

Experience in setting up EnterpriseDB Replication.

Working Knowledge of connection poolers (pgPool and pgBouncer)

Perform routine maintenance on several database environments including application of updates, patches, and hotfixes

Installation/configuration and implementation of PEM, BART, xDB/EFM, Performance Dashboard.

Creating databases, migrating database objects from non-production to production environment.

Designing and building data models, schemas, views, and tables to support application requirements

Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools such as Guardium.

Extensive experience designing and executing backup and recovery concepts and procedures

Measure database performance and troubleshoot complex database issues, I/O bottlenecks, SQL Tuning/

Provide 24 x 7 Support to Critical production systems.

Knowledge of Project Management Methodologies

Experience in working closely with the application development teams to resolve any performance related issues and provide application support.

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

Experience:

• 5S: 1 year (Required)

Work Location: In person