Kshema - PostgreSQL Database Administrator

2 weeks ago

Hyderabad, Telangana, India Kshema General Insurance Limited Full time

At Kshema, we are re-imagining agricultural insurance with the power of Public Cloud, GIS, Remote sensing and cutting-edge AI-based algorithms to assess, model and price insurance risks for farmers adequately. We are taking the latest advances in Mobile, Geospatial technologies and the web to empower the next generation of agricultural insurance.

Job Summary :

We are seeking a highly skilled and experienced PostgreSQL DBA to join our dynamic team. In this role, you will be responsible for the day-to-day production operational tasks, database administration, architecture, and automation of database services and solutions. You will play a crucial role in ensuring the performance, reliability, and security of our PostgreSQL databases, which are critical to our innovative agricultural insurance platform.

Key Responsibilities :

- Manage and maintain PostgreSQL databases (versions 12+, 13, 14) in production environments.

- Perform database installations, upgrades, and patching.

- Implement and manage High Availability (HA) solutions for PostgreSQL databases.

- Monitor database performance and proactively identify and resolve performance bottlenecks.

- Ensure data integrity and security through robust backup and recovery strategies.

- Implement and maintain database security policies and procedures.

- Perform database performance tuning and query optimization using native monitoring and troubleshooting tools.

- Analyze and optimize SQL queries to improve performance.

- Conduct performance testing and capacity planning.

- Implement and manage comprehensive backup and restore strategies using tools like pg_dump and physical backup solutions.

- Perform regular backup testing and disaster recovery drills.

- Configure and manage PostgreSQL replication and failover mechanisms.

- Ensure seamless failover and minimize downtime in case of database failures.

- Manage PostgreSQL databases on cloud platforms (AWS, Azure), including cloud DB technologies like RDS and Aurora (highly desirable).

- Optimize cloud database configurations for performance and cost-effectiveness.

- Develop and maintain scripts for database automation tasks (Bash, Python, Git).

- Automate routine database maintenance and administration tasks.

- Collaborate with development and operations teams to ensure smooth database operations.

- Provide technical support and guidance to developers and other stakeholders.

- Document database configurations, procedures, and troubleshooting steps.

- Demonstrate excellent written and verbal communication.

Required Skills & Experience :

- 5+ years of experience as a PostgreSQL DBA (versions 12+, 13, 14).

- Proven experience managing HA solutions for PostgreSQL.

- Strong experience with backup and restore procedures (pg_dump, physical backup tools).

- Expertise in database performance tuning and SQL query optimization.

- Experience with PostgreSQL replication and failover.

- Experience with scripting and task automation (Bash, Python, Git).

- Experience with performance tuning and query optimization using native monitoring and troubleshooting tools.

- Ability to organize and plan work independently.

- Ability to work in a rapidly changing environment.

- Ability to multi-task and context-switch effectively between different activities and teams.

- Excellent written and verbal communication skills.

- Flexible, team player, and "get-it-done" personality.

- Experience with cloud platforms (AWS, Azure), including cloud DB technologies (RDS, Aurora).

- Experience with container technologies (Docker, Kubernetes).

- Networking knowledge related to databases (Linux iptables, DNS, load balancers).

(ref:hirist.tech)

  • PostgreSQL Database Architect

    4 days ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    Job OverviewKshema General Insurance Limited is seeking a highly skilled PostgreSQL DBA to join our dynamic team. As a critical member of our database administration team, you will be responsible for the day-to-day production operational tasks, database architecture, and automation of database services and solutions.Main Responsibilities- Manage and maintain...

  • Database Performance Expert

    3 days ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    PostgreSQL Database Administrator Job SummaryWe are seeking an experienced PostgreSQL DBA to join our dynamic team. In this role, you will be responsible for the day-to-day production operational tasks, database administration, architecture, and automation of database services and solutions.Main Responsibilities- Manage and maintain PostgreSQL databases in...

  • Kshema - Database Architect - SQL/NoSQL

    4 days ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    Job Description : Position Overview : At Kshema, we are re-imagining agricultural insurance with the power of Public Cloud, GIS, Remote sensing and cutting-edge AI-based algorithms to assess, model and price insurance risks for farmers adequately. Our team is passionate about innovation and excellence, and we are looking for talented individuals to join us...

  • PostgreSQL DBA

    3 weeks ago

    Hyderabad, Telangana, India Kshema Full time

    Job DescriptionAt Kshema, we are re-imagining agricultural insurance with the power of Public Cloud, GIS, Remote sensing and cutting-edge AI-based algorithms to assess, model and price insurance risks for farmers adequately. We are taking the latest advances in Mobile, Geospatial technologies and the web to empower the next generation of agricultural...

  • Kshema - Database Architect - SQL/NoSQL

    2 weeks ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    Job Description :Position Overview :At Kshema, we are re-imagining agricultural insurance with the power of Public Cloud, GIS, Remote sensing and cutting-edge AI-based algorithms to assess, model and price insurance risks for farmers adequately. Our team is passionate about innovation and excellence, and we are looking for talented individuals to join us in...

  • Kshema - Database Architect - SQL/NoSQL

    3 weeks ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    Job Description :Position Overview :At Kshema, we are re-imagining agricultural insurance with the power of Public Cloud, GIS, Remote sensing and cutting-edge AI-based algorithms to assess, model and price insurance risks for farmers adequately. Our team is passionate about innovation and excellence, and we are looking for talented individuals to join us in...

  • Kshema - General Manager - Administration

    1 week ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    About Us Kshema General Insurance Limited (Kshema) was established in 2018 and is India's only Digital Agri Insurance Company catering to farmers and cultivators in the Agriculture Sector. Kshema enables cultivators to build resilience against financial distress caused by extreme climate events and perils through localized insurance products. Kshema...

  • PostgreSQL DBA

    3 weeks ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    At Kshema, we are re-imagining agricultural insurance with the power of Public Cloud, GIS, Remote sensing and cutting-edge AI-based algorithms to assess, model and price insurance risks for farmers adequately. We are taking the latest advances in Mobile, Geospatial technologies and the web to empower the next generation of agricultural insurance. We are...

  • Database Architect Lead

    4 days ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    Job OverviewKshema General Insurance Limited is seeking an experienced Database Architect Lead to join our team. This key role will involve designing, implementing, and maintaining database systems that support our business applications and services.Key ResponsibilitiesDesign and implement database solutions that meet business requirements and industry best...

  • PostgreSQL Database Administrator

    4 days ago

    Hyderabad, Telangana, India Tata Consultancy Services Limited Full time

    Company Overview:Tata Consultancy Services Limited is a leading IT services company with a strong presence globally.We are looking for a skilled PostgreSQL Database Administrator to join our team.Job Description:The successful candidate will be responsible for supporting our PostgreSQL database and ensuring its smooth operation 24/7.Key responsibilities...

  • PostgreSQL Database Administrator

    15 hours ago

    Hyderabad, Telangana, India SHAKTI INFOSOLUTIONS PVT. LTD. Full time

    Wrok Mode Hybrid : 3days Mandatory Role : Postgres DBA SQL - Strong hands-on experience in managing PostgreSQL databases, ensuring their availability, reliability, and security. - Expertise in backup, recovery, and disaster recovery planning. - Experience in high availability, replication, and clustering techniques. - Managing users, roles, and access...

  • Cloud DBA Specialist

    3 days ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    Job DescriptionWe are seeking a skilled PostgreSQL DBA to join our innovative agricultural insurance platform. As a key member of our team, you will play a crucial role in ensuring the performance, reliability, and security of our PostgreSQL databases.Main Responsibilities- Manage PostgreSQL databases on cloud platforms, including AWS and Azure.- Optimize...

  • Postgresql Database Administrator With Docker

    3 weeks ago

    Hyderabad, Telangana, India People Prime Worldwide Full time

    About Client One of our MNC clients offers technology consulting and digital solutions to global enterprises across industries enabling transformative scale at unparalleled speed With 145 000 professionals across 90 countries helping 1100 clients it provides a full spectrum of services including consulting information technology enterprise...

  • General Manager Administration

    3 days ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    About Kshema Kshema General Insurance Limited (Kshema) is India's only Digital Agri Insurance Company. Established in 2018, Kshema caters to farmers/cultivators in the Agriculture Sector. It enables cultivators with resilience from financial distress due to extreme climate events and perils through localised insurance products. Kshema leverages Technology to...

  • General Manager Administration

    4 days ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    About KshemaKshema General Insurance Limited (Kshema) was established in 2018 and is India's only Digital Agri Insurance Company catering to farmers/cultivators in the Agriculture Sectors. Kshema enables cultivators with resilience from financial distress due to extreme climate events and perils through localised insurance products. Kshema is leveraging...

  • General Manager Administration

    1 day ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    About KshemaKshema General Insurance Limited (Kshema) was established in 2018 and is India's only Digital Agri Insurance Company catering to farmers/cultivators in the Agriculture Sectors. Kshema enables cultivators with resilience from financial distress due to extreme climate events and perils through localised insurance products. Kshema is leveraging...

  • General manager administration

    5 hours ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    About KshemaKshema General Insurance Limited (Kshema) was established in 2018 and is India's only Digital Agri Insurance Company catering to farmers/cultivators in the Agriculture Sectors. Kshema enables cultivators with resilience from financial distress due to extreme climate events and perils through localised insurance products. Kshema is leveraging...

  • General Manager Administration

    2 weeks ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    Job DescriptionAbout Us Kshema General Insurance Limited (Kshema) was established in 2018 and is India&aposs only Digital Agri Insurance Company catering to farmers and cultivators in the Agriculture Sector. Kshema enables cultivators to build resilience against financial distress caused by extreme climate events and perils through localized insurance...

  • General Manager Administration

    5 hours ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    About UsKshema General Insurance Limited (Kshema) was established in 2018 and is India's only Digital Agri Insurance Company catering to farmers and cultivators in the Agriculture Sector. Kshema enables cultivators to build resilience against financial distress caused by extreme climate events and perils through localized insurance products. Kshema leverages...

  • Administrative Director

    1 day ago

    Hyderabad, Telangana, India Kshema General Insurance Limited Full time

    About KshemaKshema General Insurance Limited (Kshema) is a pioneering digital agri-insurance company in India, serving the agricultural sector since 2018. Our mission is to provide farmers with resilience against financial distress caused by extreme climate events and perils through innovative insurance solutions.We have a pan-India presence with over 500...