Job Description

Zycus is looking out for a Database Performance Engineer having expertise in Postgre database solutions including, configuration, performance tuning, troubleshooting, and backups.

Roles and Responsibilities:

• The PostgreSQL and Mongo Database Performance Engineer will be responsible for understanding operational requirements including Hardware, Architecture, configuration, Integration, and maintaining mission-critical Production PostgreSQL databases.
• Must have strong experience in DB tuning and implementing optimized configurations as per application load
• Hands on knowledge on writing stored procedures, functions, packages, triggers, and other database objects, to implement business logic and data processing
• Optimize queries for efficient execution and improved database performance
• Proficient in code reviews to ensure adherence to coding standards and best practices
• Performance Tuning and resolve performance issues in the database and queries
• Provide technical support and assistance to end-users, troubleshooting queries/DB related issues
• Identify and resolve errors in queries for robust error handling
• Design and create database objects, including tables, views, indexes, and sequences
• Write complex SQL queries to retrieve, insert, update, and delete data
• Familiar with SQL sub queries, Joins, applying Constraints
• 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.
• Develop Stored Procedures and Database Triggers in support of application development.
• Participate in application development projects and be responsible for the database architecture and design.
• Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
• Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
• Responsible for efficient recovery of databases in case of crashes.
• Responsible for regular maintenance of databases and proactive remediation of database operational problems.
• Responsible for Query tuning and preventative maintenance.
• Experience with Mongo DB ATLAS is nice to have but not mandatory
• Support complex web-based applications.

Job Requirement

• 5-8 years of relevant experience in PostgreSQL required
• Experience in Performance Tuning of large Mongo DB instances
• 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 strong knowledge of AWS Cloud and Azure Cloud.
• Good Knowledge of pgbadger and pgclue report analysis
• Hands-on experience on HA (High Availability) Configuration and strong knowledge of High Availability and Disaster Recovery concepts (i.e. Replication, Cluster).
• Must have strong knowledge of Linux operating systems
• Strong understanding of command line and server administration.
• Knowledge of shell scripting (e.g., Bash, Perl).
• Strong experience in Performance tuning
• Excellent communication and presentation skills with the ability to communicate at all levels of the organization.
• Technical leadership and mentoring skills to guide and act as SME.
• Exceptional problem-solving skills
• Keen to learn new technology with enthusiasm and critical thinking
• Ability to work within a team environment. Self-starter and ability to perform work with minimal supervisory direction
• Excellent analytical and problem solving skills
• 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
• Experience with Unix/Linux including basic commands and basic shell scripting