Cassandra Database Administrator

Cassandra Database Administrator

Location: Basking Ridge, NJ 07920

Project Duration: 12 months

Contract Work Arrangement: On-site role (should be available to work 5 days a week from our client Office)

Interview: Three rounds of Video interview

Job Description

We are seeking a Cassandra Database Administrator (DBA) to join our dynamic team. The ideal candidate will be responsible for the performance, integrity, and security of our databases. This role involves installation, configuration, maintenance, performance monitoring, security, backup and recovery, and troubleshooting. The DBA will work closely with developers and other IT staff to ensure optimal database performance and data integrity.

Install and configure new SQL databases on various platforms (physical, virtual, cloud).

Set up database clusters, replication, and high availability solutions.

Configure database parameters and optimize for performance.

Perform regular database maintenance tasks such as vacuuming, analyzing, and reindexing.

Monitor database health and performance using various tools.

Implement and maintain database security measures, including access control and encryption.

Optimize SQL queries and database schema for improved efficiency.

Regularly perform database backups and test recovery procedures.

Manage disaster recovery plans and ensure business continuity.

Troubleshoot database issues and provide timely solutions.

Assist developers with database design and query optimization.

Implement and maintain database security policies and procedures.

Ensure compliance with relevant data privacy regulations (e.g., GDPR, HIPAA).

Regularly audit database security and access controls.

Roles & Responsibilities

Minimum of 5+ years of Cassandra database management systems in testing, implementation, maintenance and administration in a multiple platform environment.

Upgrades of Oracle, SQL, database migrations and updates and application of database patches.

Backup and restores, export and import of data to and from Oracle, SQL run time configuration of Oracle, SQL.

Develop and implement backup and recovery strategies to protect against data loss.

Monitoring at server, database, collection level, and using various monitoring tools related to Oracle, PostgreSQL.

Strong understanding of SQL, Postgre SQL SQL architecture and internals.

Proficiency in SQL and database/data design and architectural principles and methodologies.

Familiarity with Linux/Unix operating systems.

Scripting skills (e.g., Bash, Python) for automation.

Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.

Implements multiple projects along with the production support.

Will perform on-call support for critical needs.

Experience with database monitoring tools.

Implement performance tuning strategies to ensure optimal database response times.