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

📌 Software Engineer-Cassandra-and-Oracle (Chennai)
🏢 Prodapt Solutions
📍 Chennai