PostgreSQL DBA Jobs in Mumbai at Zycus Infotech

Last Updated: Sep 19, 2021 05:10 IST

JOB DETAILS

Company Name
Zycus Infotech
Job title
PostgreSQL DBA
Education
Location
Experience
5-8 Years
Salary
Not Mentioned

Job Profile



Zycus is looking out for a PostgreSQL DBA having expertise in Postgre database solutions including, database installation, configuration, performance tuning, troubleshooting, and backups.
  • The PostgreSQL DBA 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
  • 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.
  • Responsible to migrate Products on MSSQL / Oracle database to PostgreSQL, planning the cutover and Go-Live in the shortest migration window.
  • 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.
  • Support complex web-based applications.
Requirements:
  • 5-8 years of relevant experience in PostgreSQL required
  • Experience as DBA in high-load, large-d production DB
  • Must have experience of migration from Oracle, MSSQL and other databases to PostgreSQL.
  • 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 communication 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.
Benefits:
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.

  • Apply to More than 1000+ new jobs in your city

    OTHER DETAILS

    Key skills
    Postgresql Dba
    Industry
    IT/ Computers - Software
    Summary
    Zycus is looking out for a PostgreSQL DBA having expertise in Postgre database solutions including, database installation, configuration, performance tuning, troubleshooting, and backups. * The PostgreSQL DBA will be responsible for understanding
    Last Date
    2021-09-23

    Alert : FreshersLIVE Employees will not call any candidates towards Job Offer or Job assistance. FreshersLIVE will never charge any candidates for Jobs. Please be aware of fraudulent calls or emails. Please write to [email protected] for any assistance.
    Disclaimer: This Job is auto-published from MonsterIndia. For any issues with above Job Posting, please contact MonsterIndia

    Apply Various Job Roles on Fresherslive.com

    Job Role Apply Link
    Other Roles Other Roles Jobs 2021 (56777 Vacancies)
    Anganwadi Worker Anganwadi Worker Jobs 2021 (50485 Vacancies)
    Software Software Jobs 2021 (29482 Vacancies)
    Programmer Programmer Jobs 2021 (24338 Vacancies)
    Trained Graduate Teacher Trained Graduate Teacher Jobs 2021 (14912 Vacancies)
    Assistant Assistant Jobs 2021 (12662 Vacancies)
    Designer Designer Jobs 2021 (10501 Vacancies)
    Application Engineer Application Engineer Jobs 2021 (9980 Vacancies)
    Gramin Dak Sevak Gramin Dak Sevak Jobs 2021 (9213 Vacancies)
    Pre Primary Teacher Pre Primary Teacher Jobs 2021 (8393 Vacancies)
    Assistant Teacher Assistant Teacher Jobs 2021 (7886 Vacancies)
    Customer Service Executive Customer Service Executive Jobs 2021 (7616 Vacancies)
    Auxiliary Nurse Midwifery Auxiliary Nurse Midwifery Jobs 2021 (5000 Vacancies)
    Trainee Trainee Jobs 2021 (4479 Vacancies)
    Development Officer Development Officer Jobs 2021 (4396 Vacancies)
    Apprentice Apprentice Jobs 2021 (3607 Vacancies)
    Business Development Manager Business Development Manager Jobs 2021 (3005 Vacancies)
    Health Officer Health Officer Jobs 2021 (2850 Vacancies)
    General Medical Officer General Medical Officer Jobs 2021 (2632 Vacancies)
    Teacher Teacher Jobs 2021 (2571 Vacancies)
    View More Jobs By Role (1 lakh + vacancies)

    Fresherslive.com has taken maximum steps to ensure that the job posting is genuine. This Job posting was made by the company/recruiter directly and exclusively on Fresherslive.com. If the recruiter is charging any Fees from the job seekers, please write to us at [email protected] / [email protected].