Principal Database Consultant (PostgreSQL)

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:

• 8+ years of working experience for a professional consulting organization in the Database area with strong Database foundation skills .

• 5+ 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

• Excellent troubleshooting 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