Linkage IT - Database Consultant - PostgreSQL

Responsibilities :

• Assess the existing deployments of Postgres and 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 bachelors or masters degree in computer science / Engineering or equivalent experience

• Have strong written and verbal communication skills

• Excellent troubleshooting skills

What will give you an edge :

• Proficient with the PostgreSQL community version.

• 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.