Sr. Database Developer / Team Lead Job in Cygnet Infotech

Technical Skills:

• Cassandra, CQL, Performance Tuning and Optimization, Monitor Resource Usage, Configuration
• Hands on experience in configuring, adding, removing, upgrading, and decommissioning Cassandra nodes/data centers
• Experience in scripting, automation and monitoring compression, compaction, SS table, partition keys, primary keys.
• Strong knowledge on tombstone repair Compaction issues

Responsibilities

• Install, configure multi-nodes fully distributed Cassandra cluster.
• Work closely with development team and provide database support in scheme design and changes, performance tuning as well as code review
• Deliver high quality, defect-free solutions
• Actively participate in backlog refinement, estimation sessions and daily stand-ups.
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Design database and structures.
• Develop, implement, and optimize scripts and functions
• Creating views, functions, and scripts.
• Writing optimized queries for integration with other applications.
• Maintaining data quality and overseeing database security.
• Review and interpret ongoing business requirements
• Research required data
• Analyse existing queries for performance improvements
• Basic DBA activities needed for the project.
• Troubleshooting data modelling issues