Linkage IT - Database Consultant - PostgreSQL

Job Description

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.

More Info

Education