Job Description
Job Description
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, configuration, Integration, and maintaining mission-critical Production PostgreSQL databases along with other DBMS technology stack.
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.
Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
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.
Support complex web-based applications.
Job Requirement
Requirements :
3-5 years of relevant experience in PostgreSQL required
Experience as DBA in high-load, large-d 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 pgbadger and other report analysis
Hands-on 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
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 critical 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 DMBS technologies and upskill respectively.
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
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, configuration, Integration, and maintaining mission-critical Production PostgreSQL databases along with other DBMS technology stack.
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.
Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
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.
Support complex web-based applications.
Job Requirement
Requirements :
3-5 years of relevant experience in PostgreSQL required
Experience as DBA in high-load, large-d 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 pgbadger and other report analysis
Hands-on 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
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 critical 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 DMBS technologies and upskill respectively.
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
💡 Quick Summary
Seeking a career-building opportunity? The Database Administrator | |VDW030 position is now open for candidates interested in the Database Administrator sector. This role in Pune offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.