Database Consultant - PostgreSQL Linkageit

8.0 - 10.0 years

9 - 13 Lacs

Navi Mumbai

Work from Office

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.

Posted 3 days ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.