Cassandra and Postgres Database Administrator

2 weeks ago

Pune, India Trigent Software Private Limited Full time

Role Purpose

Cassandra and Postgres Database Administrator (DBA)


Job Summary:


Cassandra Database Administration:
Design, configure, and maintain Cassandra clusters deployed in HSBC.
Install, configure, and manage multi-node Cassandra clusters both on-premise and cloud, both public and internal
Perform database backups, recovery, and restoration activities.
Manage database schemas, tables, indexes, and user permissions.
Diagnose and troubleshoot production incidents and resolve performance bottlenecks, including slow queries and resource utilization
issues.
Optimize database configurations, query performance, and data modeling for improved efficiency and scalability.
Execute repairs in case of data inconsistency and perform JVM tuning and garbage collection optimization.
Estimate storage requirements and collaborate with infrastructure teams to ensure adequate resources are provisioned.
Regularly review and update security configurations to address emerging threats and vulnerabilities.
Set up database monitoring tools to proactively identify performance issues, errors, and anomalies.
Respond to database alerts and take appropriate actions to resolve issues.
PostgreSQL Database Administration:
Collaborate with teams to integrate PostgreSQL databases into the infrastructure and ensure their optimal performance.
Perform PostgreSQL database backups, recovery, and restoration activities.
Optimize PostgreSQL configurations and query performance for transactional workloads.
Design and implement PostgreSQL data models and SQL scripts for transactional workloads.
Manage PostgreSQL databases in GCP environments (preferred).
Diagnose and troubleshoot PostgreSQL production incidents and resolve performance bottlenecks.
Requirements:
Cassandra:
5+ years of experience in Cassandra database administration.
Expertise in installing, configuring, and monitoring Cassandra clusters.
Experience in creating column families, bootstrapping, decommissioning, removing, replacing, and repairing nodes.
Proficiency in creating keyspaces, tables, and secondary indexes in Cassandra.
Strong experience in performance tuning Apache Cassandra clusters to optimize writes and reads.
Hands-on experience with Cassandra data modeling and CQL scripting.
Proven ability to evaluate database performance, isolate bottlenecks, and implement optimizations in transactional settings.
Experience in managing and monitoring 24x7 production database environments.
PostgreSQL:
5+ years of experience in PostgreSQL database administration.
Expertise in installing, configuring, and monitoring PostgreSQL databases.
Proficiency in PostgreSQL data modeling and SQL scripting.
Strong experience in performance tuning PostgreSQL databases to optimize writes and reads.
Hands-on experience with PostgreSQL in GCP environments (preferred).
Proven ability to evaluate database performance, isolate bottlenecks, and implement optimizations in transactional settings.
Preferred Skills:
Experience with Datastax Enterprise Service (DSE).
Familiarity with cloud environments like GCP.
Strong troubleshooting and analytical skills.

  • MySQL and Postgres Database Administration

    3 days ago

    Mumbai, Pune, India Crisil Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    We are seeking an experienced Database Administrator (DBA) to join our team, responsible for the administration, maintenance, and optimization of our MySQL and Postgres databases. The candidate should have a strong background in database design, development, and performance tuning, with expertise in both MySQL and Postgres administration.Key...

  • Cassandra Database Admin

    4 weeks ago

    Pune, India POWER IT SERVICES Full time

    Casandra Database Administrator Experience: 7 years Technical Skills: • Strong experience with Apache Cassandra (Open Source, DataStax, Scylla DB). • Deep understanding of Cassandra architecture, partitions, replication, and consistency levels. • Proficiency in CQL (Cassandra Query Language) and data modelling. • Hands-on experience with Linux...

  • Postgres Database Sme

    2 weeks ago

    Pune, India Kyndryl Solutions Private Limited Full time

    **Why Kyndryl** Kyndryl is a market leader that thinks and acts like a start-up. We design, build, manage, and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward - always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our...

  • Database Administrator

    5 hours ago

    Pune, India Appriffy - Digital IT Hub Private Limited Full time

    A professional Database Administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end - users. Key Responsibilities - Install and maintain the performance of database servers. - Develop...

  • Postgres Database Administrator

    1 week ago

    Pune, India Zycus Full time

    Global Delivery- Pune*** **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...

  • Database Administrator

    2 days ago

    Pune, India SourceTal® Hiretech Full time

    We are hiring for **Database Administrator** one of our leading client at Pune Location. Skills Set : Database Administrator Mode of Hiring : Permanent Role Years of Exp : 5-12 Location. : Pune Notice Period : Immediate/15 Days Max. **Job Description**: Mandatory-Hands on experience on Oracle as well as MS Sql Server. Nice to have-Some exposure to any...

  • Postgres Expert Full-time

    2 days ago

    Pune, India HyreFox Consultants Full time

    **Responsibilities**: Design, deploy, and maintain highly available and scalable Postgres database solutions. Perform database administration tasks, including backup and recovery, monitoring, performance tuning, and troubleshooting. Develop and optimize SQL queries and database schema designs for improved performance and...

  • Oracle Database Administrators

    1 week ago

    Pune, Maharashtra, India CosMic IT Full time

    Full Time - Pune, India - Posted 1 year ago - Applications have closed - CosMicIT **CosMic IT** - Find Your Dream Job Here_ Greetings Everyone! We have an urgent requirement for Oracle Database Administrators Location: Pune, India Experience required: 5+ years **Job Description**: - Oracle 12c/19c DB administrator - Oracle 19c DB administrator...

  • Database Administrator

    1 week ago

    Pune, India Peel-works Full time

    Job Roles and Responsibilities: - Build database systems of high availability and quality depending on each end user’s specialized role. - Design and implement database in accordance to end users’ information needs and views. - Define users and enable data distribution to the right user, in appropriate format and in a timely manner. - Use high-speed...

  • Database Administrator

    2 days ago

    Chennai, Mumbai, Pune, India Luxoft Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Project description The primary goal of the project is the modernization, maintenance and development of an eCommerce platform for a big US-based retail company, serving millions of omnichannel customers each week. Solutions are delivered by several Product Teams focused on different domains - Customer, Loyalty, Search and Browse, Data Integration, Cart. ...