Location:

Mumbai, Maharashtra, India

Job ID:

R0057663

Date Posted:

2024-08-01

Company Name:

HITACHI INDIA PVT. LTD

Profession (Job Category):

Other

Job Schedule: 

Full time

Remote:

No

Job Description:

Job Title: PostgreSQL Database Administrator (L2)
Location: Mumbai, India
Company: Hitachi Systems India Pvt Ltd.
Salary Range: As per Industry

Company Overview:

Hitachi Systems India is driving the digital change in the businesses through integrated IT solutions and services. Our multi-technology capabilities are backed by experience to serve large enterprises to mid-size and small businesses across various industries. Our endeavor is to help businesses become more agile and act in response to rapidly changing technology landscape due to digital transformation.

Job Overview:

As a PostgreSQL Database Administrator at the L2 level, you will be responsible for maintaining the integrity, performance, and security of our PostgreSQL database systems. Your role will involve troubleshooting issues, implementing best practices, and collaborating with other teams to ensure optimal database functionality. The ideal candidate should have a strong background in PostgreSQL administration and a proactive approach to problem-solving.

Responsibilities:

1. Database Maintenance:

• Perform routine database maintenance tasks, including backups, restores, and updates.

• Monitor database performance and implement optimizations to ensure efficient operation.

2. Troubleshooting and Issue Resolution:

• Diagnose and resolve database-related issues promptly.

• Collaborate with the support team to address and solve customer-reported problems.

3.Security and Compliance:

• Implement and maintain database security measures to protect sensitive information.

• Ensure compliance with relevant data protection regulations and industry standards.

4. Performance Tuning:

• Analyze and optimize SQL queries for improved database performance.

• Collaborate with developers to enhance application performance.

5. High Availability and Disaster Recovery:

• Implement and maintain high availability solutions.

• Develop and test disaster recovery plans to minimize downtime.

6. Documentation:

• Create and maintain detailed documentation related to database configurations, processes, and procedures.

7. Collaboration:

• Work closely with development and infrastructure teams to address database-related requirements.

• Participate in cross-functional teams to implement new database solutions.

Experience: 4+ years

Skills:

• open source migration oracle to Postgres, DB2 to Postgres
• Familiarity with other database management systems.
• Knowledge of cloud database services (e.g., AWS RDS, Azure Database for PostgreSQL).

Qualification:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a PostgreSQL Database Administrator (L2) or similar role.
• In-depth knowledge of PostgreSQL architecture, configuration, and best practices.
• Proficient in SQL and scripting languages (e.g., Bash).
• Experience with database security and compliance.
• Strong problem-solving and troubleshooting skills.
• Excellent communication and collaboration abilities.