Zycus - Database Performance Engineer - PostgreSQL/MongoDB

2 weeks ago

MumbaiBangalorePune, India Zycus Full time

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.
Skills and Expertise :
  • 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.
Five Reasons Why You Should Join Zycus :
  • Cloud Product Company: We are a Cloud SaaS Company and our products are created by using the latest technologies like ML and AI. Our UI is in Angular JS and we are developing our mobile apps using React.
  • A Market Leader: Zycus is recognized by Gartner (world's leading market research analyst) as a Leader in Procurement Software Suites.
  • Move between Roles: 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
  • Get a Global Exposure: You get to work and deal with our global customers.
  • Create an Impact: Zycus gives 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.
ABOUT US :


Zycus is a pioneer in Cognitive Procurement software and has been a trusted partner of choice for large global enterprises for two decades. Zycus has been consistently recognized by Gartner, Forrester, and other analysts for its Source to Pay integrated suite. Zycus powers its 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.

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

Start your #CognitiveProcurement journey with us, as you are #MeantforMore


(ref:hirist.tech)

  • Database Administrator

    4 weeks ago

    Pune, India Zycus Full time

    Zycus is looking out for Database Administrator having expertise in PostgreSQL Database solutions including, database installation, configuration, performance tuning, troubleshooting, and backups, monitoring and enhancements. **Responsibilities**: - The DBA will be responsible for understanding operational requirements including Hardware, Architecture,...

  • Zycus - Director - Engineering

    3 weeks ago

    Pune, India Zycus Full time

    Director - Engineering We are looking for a Director of Engineering to lead one of our key product engineering teams. This role will report directly to the VP of Engineering and will be responsible for successful execution of the company's business mission through development of cutting-edge software products and solutions.- As an owner of the product...

  • Database Administrator

    4 weeks ago

    Pune, India Zycus Full time

    Global Delivery- Pune, Bangalore, Mumbai*** **About Us** Zycus is a pioneer in Cognitive Procurement software and has been a trusted partner of choice for large global enterprises for two decades. Zycus has been consistently recognized by Gartner, Forrester, and other analysts for its Source to Pay integrated suite. Zycus powers its S2P software with the...

  • Database Administrator

    1 month ago

    Pune, India Zycus Full time

    Zycus is looking out for **Database Administrator **having expertise in **MongoDB database **solution including, database installation, configuration, performance tuning, High Availability / DR solutions, troubleshooting, and backups, monitoring and enhancements **Responsibilities**: - Database administrator will be responsible for handling task...

  • Zycus - Engineering Director - Java/AngularJS

    2 weeks ago

    Mumbai/Pune/Bangalore, India Zycus Full time

    Job Description : We are looking for a Director of Engineering to lead one of our key product engineering teams. This role will report directly to the VP of Engineering and will be responsible for successful execution of the company's business mission through development of cutting-edge software products and solutions. As an owner of the product, you...

  • Zycus - Engineering Director - Java/AngularJS

    2 weeks ago

    bangalore, India Zycus Full time

    Job Description : We are looking for a Director of Engineering to lead one of our key product engineering teams. This role will report directly to the VP of Engineering and will be responsible for successful execution of the company's business mission through development of cutting-edge software products and solutions. As an owner of the product, you will...

  • MongoDB Specialist

    2 weeks ago

    Bangalore/Pune/Mumbai/Chennai, India RapidBraiins Full time

    Job Summary : We are looking for an experienced MongoDB Specialist with 6 to 10 years of expertise in MongoDB data modeling/design, SQL development with performance tuning, and database administration. The ideal candidate will have a strong background in MongoDB, with experience in data lake and data warehousing applications. The role requires proficiency in...

  • MongoDB Specialist

    3 weeks ago

    Bangalore/Pune/Mumbai/Chennai, IN RapidBraiins Full time

    Job Summary : We are looking for an experienced MongoDB Specialist with 6 to 10 years of expertise in MongoDB data modeling/design, SQL development with performance tuning, and database administration. The ideal candidate will have a strong background in MongoDB, with experience in data lake and data warehousing applications. The role requires proficiency in...

  • Director of Engineering

    4 weeks ago

    bangalore, India Zycus Full time

    Director of Engineering (SOF04147) Software Engineering BengaluruAbout UsZycus is a pioneer in Cognitive Procurement software and has been a trusted partner of choice for large global enterprises for two decades. Zycus has been consistently recognized by Gartner, Forrester, and other analysts for its Source to Pay integrated suite. Zycus powers its S2P...

  • Director of Engineering

    4 weeks ago

    Pune, India Zycus Full time

    Director of Engineering (SOF04146) Software Engineering PuneAbout UsZycus is a pioneer in Cognitive Procurement software and has been a trusted partner of choice for large global enterprises for two decades. Zycus has been consistently recognized by Gartner, Forrester, and other analysts for its Source to Pay integrated suite. Zycus powers its S2P software...

  • Director of Engineering

    4 weeks ago

    pune, India Zycus Full time

    Director of Engineering (SOF04146) Software Engineering PuneAbout UsZycus is a pioneer in Cognitive Procurement software and has been a trusted partner of choice for large global enterprises for two decades. Zycus has been consistently recognized by Gartner, Forrester, and other analysts for its Source to Pay integrated suite. Zycus powers its S2P software...

  • Director of Engineering

    4 weeks ago

    Mumbai, India Zycus Full time

    Director of Engineering (SOF04145) Software EngineeringMumbaiAbout UsZycus is a pioneer in Cognitive Procurement software and has been a trusted partner of choice for large global enterprises for two decades. Zycus has been consistently recognized by Gartner, Forrester, and other analysts for its Source to Pay integrated suite. Zycus powers its S2P software...

  • Director of Engineering

    4 weeks ago

    mumbai, India Zycus Full time

    Director of Engineering (SOF04145) Software EngineeringMumbaiAbout UsZycus is a pioneer in Cognitive Procurement software and has been a trusted partner of choice for large global enterprises for two decades. Zycus has been consistently recognized by Gartner, Forrester, and other analysts for its Source to Pay integrated suite. Zycus powers its S2P...

  • PostgreSQL Database Administrator

    1 month ago

    bangalore, India Wipro Full time

    Experience in PostgreSQL Database AdministrationDesign, configure, test, and support high-availability clustering utilizing PostgreSQL technologiesResponsible for understanding operational requirements including Hardware, Architecture, configuration, Integration and maintaining mission-critical Production PostgreSQL databases.Responsible for all Logical and...

  • MongoDB

    2 weeks ago

    pune, India LTIMindtree Full time

    Experience - 6 + yearsLocations - Pune / Mumbai /ChennaiPrimary Skills- MongoDBNotice Period - Immediate - 30 DaysJob Description-Expertise in MongoDB Data Modeling/Design, SQL Development with Performance Tuning• Expertise with MongoDB required. (required)• Experience with Data Lake and Data Warehousing applications.• Experience with database...

  • MongoDB

    4 weeks ago

    Pune, India LTIMindtree Full time

    Experience - 6+ yearsLocations - Pune / Mumbai /ChennaiPrimary Skills- MongoDBNotice Period - Immediate - 30 DaysJob Description-Expertise in MongoDB Data Modeling/Design, SQL Development with Performance Tuning• Expertise with MongoDB required. (required)• Experience with Data Lake and Data Warehousing applications.• Experience with database...

  • MongoDB

    4 weeks ago

    Pune, India LTIMindtree Full time

    Experience - 6+ yearsLocations - Pune / Mumbai /ChennaiPrimary Skills- MongoDBNotice Period - Immediate - 30 DaysJob Description-Expertise in MongoDB Data Modeling/Design, SQL Development with Performance Tuning• Expertise with MongoDB required. (required)• Experience with Data Lake and Data Warehousing applications.• Experience with database...

  • Database Engineer

    3 weeks ago

    bangalore, India Nutanix Full time

    The Opportunity Customer adoption of NDB, bringing back key learnings/identified problems from customers, pre-sales guidance/assistance where NDB sales specialists need help to unblock a customer, design and validate joint solution architectures that require a mix of NDB and third party products working together (., HYCU backup interoperability with...

  • Senior Database Engineer

    2 weeks ago

    bangalore, India Top Talent Technologies Private Limited Full time

    Job Description : We are currently seeking a skilled and experienced Database engineer to join our dynamic team. As a Database engineer, you will be responsible for designing, optimizing, and architecting database schemas, with a primary focus on PostgreSQL and other databases. You will play a pivotal role in ensuring the efficiency, scalability, and...

  • Senior Database Engineer

    2 weeks ago

    Bangalore, India Top Talent Technologies Private Limited Full time

    Job Description : We are currently seeking a skilled and experienced Database engineer to join our dynamic team. As a Database engineer, you will be responsible for designing, optimizing, and architecting database schemas, with a primary focus on PostgreSQL and other databases. You will play a pivotal role in ensuring the efficiency, scalability, and...