Database Consultant - PostgreSQL DBA

EDB; Mumbai; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

EDB in Mumbai seeks a seasoned database consultant to deliver enterprise PostgreSQL support and architecture guidance. You will work with customers on deployments, migrations from Oracle/SQL Server/MySQL, and performance tuning, while collaborating with product and sales teams on future directions.

The role requires 6+ years in database consulting, strong Linux and scripting skills, and travel up to 30-40%. Excellent communication is essential.

Qualifications

• 6+ years of experience in a professional consulting organization in the database area.
• 4+ years of direct experience with PostgreSQL and Oracle databases.
• Expertise in PostgreSQL high availability in large enterprise environments.
• Experience with Linux system administration and scripting.
• Strong written and verbal communication skills.

Responsibilities

• Assess existing deployments of PostgreSQL and related tools at the customer site; document required technical steps.
• Gather enterprise-wide database requirements by consulting with client stakeholders.
• Create proposals for professional services aligned with customer objectives.
• Guide customers in developing Postgres-based applications using languages like C/C++, PHP, Python, Java or Ruby.
• Troubleshoot database performance issues and perform migrations to PostgreSQL.
• Perform database migrations from Oracle, SQL Server, and MySQL to PostgreSQL.
• Implement High Availability configurations for PostgreSQL.
• Evaluate security needs and propose suitable solutions.
• Document work clearly in runbooks and communications.

Skills

Strong communication

Time management

Leadership

Multitasking

Travel readiness

Education

Bachelor’s or Master’s in computer science/engineering

Tools

PostgreSQL

Oracle databases

Linux administration

SQL

PgBouncer

PgPool

Job description

Work Timings:

2:30 PM to 10:30 PM / 5 days week

EDB is searching for a customer-facing individual to provide EnterpriseDB PostgreSQL technical assistance to our customers both in-person and virtually. This entails learning about their industry, formulating suggestions, providing Database deployment architecture, configuring/implementing database solutions. The ideal candidate is able to organize weak or ambiguously built client needs and turn them into successful customer interactions. This individual possesses a strong blend of people skills and in-depth understanding of database deployments. Technical skills are as vital as written and vocal communication skills. This individual will not only provide technical services to customers but also collaborate with our product engineering teams to establish the future direction of our products and provide input to sales and sales engineering regarding new business opportunities. This job can include some moderate travel.

What your impact will be:

• Assess the existing deployments of Postgres, associated tools in the customer place, and make recommendations on how to improve them and document the required technical steps.
• Gather and record the enterprise-wide database requirements by consulting with the stakeholders in the client teams.
• Work on creating proposals for professional services that meet the objectives and goals of customers.
• Possessing knowledge of programming languages like C/C++, PHP, python, Java or Ruby to guide customers in the development of custom Postgres-based applications.
• Troubleshooting the various Database challenges including the performance issues
• Perform database Migrations from Oracle, SQL Server, and / or MySQL to PostgreSQL
• Performance tuning for existing database deployments
• Work with customers to upgrade their application to the latest version of Postgres and configure / change their application to take advantage of new features.
• Design and implement Database High Availability configurations using PostgreSQL.
• Evaluate security needs by customers and make recommendations.
• Document all work clearly and concisely in runbooks and customer communications throughout the project.
• Implement backup strategies and perform upgrades and patching.
• Develop Data migration strategies to migrate large databases in line with the customer downtime constraints.
• Implement advanced Database monitoring and set up the alerts using the industry best practices and tools.

What you will bring:

• 6+ years of working experience for a professional consulting organization in the Database area with strong Database foundation skills.
• 4+ years of direct working experience on PostgreSQL and Oracle databases
• Expertise in PostgreSQL Database implementation for high availability in large enterprise environments.
• Be familiar with database design and building applications for PostgreSQL, Oracle, or other databases.
• Expert knowledge on General system administration and performance tuning skills for Linux (Ubuntu, Centos, Red hat, or Debian), including troubleshooting and scripting.
• Be well-versed in SQL and MS Windows
• Have strong time management skills, and the ability to balance multiple projects in parallel.
• Have a bachelor's or master's degree in computer science / engineering or equivalent experience
• Able to travel about 30 - 40%
• Have strong written and verbal communication skills

What will give you an edge:

• Proficient with PostgreSQL community version and EDB's PostgreSQL
• Proficient with EDB tools
• Proficient with database tuning and use of PostgreSQL tools such as PgBadger, PEM, BARMAN
• Proficient with PostgreSQL replication technologies Streaming, Logical and Bidirectional
• Proficient with PostgreSQL architecture
• Proficient with PostgreSQL networking, HBA and connection pooling (PgBouncer, PgPool)
• Working knowledge of OLTP/DSS/DW system design
• Working knowledge of scripting languages, BASH, KSH, Python, Perl etc.
• Have experience deploying open-source software.
• Working with virtual teams and from remote office locations