Software Engineer-Cassandra-and-Oracle

Prodapt Solutions; Chennai District; On-site; INR 600,000 - 900,000; Full time

Job summary

Prodapt Solutions is looking for a Database Administrator to manage and maintain both Cassandra and Oracle databases. The role includes implementing database solutions, monitoring performance, handling backups, and collaborating with development teams.

The ideal candidate will have solid experience with database administration, cluster planning, and optimization, ensuring reliability and high availability of database services.

Qualifications

• Experience with Cassandra including cluster planning, creation, and maintenance.
• Proficient in Oracle administration and database optimization strategies.
• Experience with AWS RDS instance administration.

Responsibilities

• Manage and maintain Cassandra and Oracle databases.
• Monitor database performance and ensure optimization.
• Execute database migrations and upgrades.
• Respond to alerts and incidents to minimize downtime.

Tools

Cassandra

Oracle

AWS RDS

Spark

Linux

Job description

Overview

Cassandra:

• Cassandra cluster planning which includes Data sizing estimation, and identify hardware requirements based on the estimated data size and transaction volume.
• Create, install, and configure a Cassandra cluster
• Use tools to monitor cluster availability and performance
• Export data into different data formats
• Use primary index and secondary indexes correctly to perform queries on data
• Backup and restore data to secure the system in the event of failure
• Tune the performance of Java Virtual Machine (JVM), caches, and compaction
• Cassandra Data Modelling, NoSQL Architecture, Keyspace, Table, Index creation, User creation access administration.
• Administration, Maintenance and supporting of the cluster using Opscenter, Devcenter, Linux, Spark
• CQL Queries to support Integration with Cassandra Cluster
• Create and maintain detailed documentation of database configurations, procedures, and troubleshooting steps.
• Respond to alerts and incidents promptly to minimize service disruptions.
• Collaborate with Level 1 and Level 2 support and other teams to address escalated incidents.

Oracle Administration Maintenance

• Install, configure, and upgrade Oracle database software.
• Apply quarterly patches for Grid and Oracle home
• Configure and maintain standby database.
• Monitor database performance and implement optimization strategies.
• Ensure database security and compliance with organizational policies.
• Perform regular backups and recovery operations.
• Collaborate with developers to design and implement database solutions.
• Troubleshoot and resolve database-related issues promptly.
• Develop and maintain database documentation and standards.
• Plan and execute database migrations and upgrades.
• Setup Oracle golden gate both uni-directional and bidirectional.
• Maintain Oracle Golden Gate synchronization with source.
• Identify the Oracle Golden Gate sync related issues and implement the best practices.
• Identify the performance issues and implement the best practices.
• User creation and access management.
• Storage capacity planning to ensure ASM and tablespace were maintained under threshold and avoided repetitive space related incidents.
• Create and maintain RAC with Data guard.
• Administration of RAC database.
• AWS RDS instance administration, Rehydration, engine upgrade and certificate renewal