PostgreSQL Database Solutions Specialist

We are seeking a skilled PostgreSQL Database Solutions Specialist to join our team. As a key member of our database operations team, you will be responsible for handling operational tasks including hardware, architecture, configuration, integration, and maintaining mission-critical production PostgreSQL databases along with other DBMS technology stack.

• The ideal candidate will be responsible for handling operational tasks including hardware, architecture, configuration, integration, and maintaining mission-critical production PostgreSQL databases along with other DBMS technology stack.
• Architect and enhance the setup for different workloads to optimal performance.
• Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
• Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need for downtime.
• Participate in application development projects and be responsible for the database architecture and design.
• Problem analysis and solution implementation
• Undertake database upgrades, migrations and other administrative projects.
• Responsible for database performance review to ensure queries are optimized and tuned to perform efficiently prior to production release.
• Responsible for regular backups and recovery of databases.
• Responsible for regular maintenance of databases and proactive remediation of database operational problems.
• Responsible for Query tuning and preventative maintenance.
• Undergo cross training for other DBMS implementations.
• Support complex web-based applications.

• 3-5 years of relevant experience in PostgreSQL required
• Experience as DBA in high-load, large-sized production DB
• Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
• Must have knowledge of AWS Cloud
• Good Knowledge of pg-badger and other report analysis
• Experience on HA (High Availability) Configuration and strong knowledge of High Availability and Disaster Recovery concepts (i.e. Replication, Cluster).
• Ability to detect and troubleshoot database-related CPU, memory, I/O, disk space, and other resource contention issues. Have proficiency with Linux for basic administrative tasks
• Should be able to work and lead projects to closure, independently
• Must have strong knowledge of Linux operating systems
• Strong understanding of command line and server administration.
• Knowledge of shell scripting (e.g., Bash, Perl).
• Experience in Performance tuning
• Excellent communication and presentation skills with the ability to communicate at all levels of the organization.
• Exceptional problem-solving skills
• Keen to learn new technology with enthusiasm and analytical thinking
• Ability to work within a team environment. Self-starter and ability to perform work with minimal supervisory direction
• Excellent analytical and communication skills
• Familiar with ITIL process of change management and incident management process.
• Experience with Unix/Linux including basic commands and basic shell scripting.
• Open to work on other DBMS technologies and up-skill respectively.

We are a pioneer in Cognitive Procurement software and have been a trusted partner of choice for large global enterprises for two decades. We have been consistently recognized by Gartner, Forrester, and other analysts for our Source to Pay integrated suite. We power our S2P software with the revolutionary Merlin AI Suite. Merlin AI takes over the tactical tasks and empowers procurement and AP officers to focus on strategic projects; offers data-driven actionable insights for quicker and smarter decisions, and its conversational AI offers a B2C type user-experience to the end-users.

We help enterprises drive real savings, reduce risks, and boost compliance, and our seamless, intuitive, and easy-to-use user interface ensures high adoption and value across the organization.

We believe that change leads to growth and therefore we allow our employees to shift careers and move to different roles and functions within the organization. You get to work and deal with our global customers.

We give you the environment to create an impact on the product and transform your ideas into reality. Even our junior engineers get the opportunity to work on different product features.