Leads the design planning, impact analysis, administration, implementation and maintenance of the organization's application Cassandra databases. Consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction.
Handles and leads various large-scale or highly complex data/database management activities including one or more of the following: designing highly complex logical and/or physical database data model; large volume data transformation and migration; capacity planning; developing database design policies, procedures and standards; and security requirements identification, analysis and development.
Provides mentoring, guidance and general oversight to lesser experienced staff in a variety of database design, performance tuning and/or administration activities.
Candidate will be required to :
- Lead or participate in Cassandra database management activities including designing highly complex logical and physical databases
- Installation and administration of Cassandra databases
- Documentation of guides for production database administrators
- Defining standards for installation, deployment, security, authentication and authorization, management policies and best practices
- Defining and implementing backup and restoration strategies
- Defining and implementing monitoring and alarming strategies
- Perform the planning, research, design, implementation, maintenance, and control of server class databases
- Consult with and advise management and multiple clients on high impact data or database management issues, influencing strategic direction
Minimum Qualifications:
- 4+ years of experience with implementing and administrating Cassandra database
- Experience with Data tax Cassandra
- Experience with Data tax Ops Centre backup/restoration and monitoring/alarm implementation
- Experience with Ansible automation tool or equivalent
- 4+ years of Shell or Python or Perl experience
Preferred Skills
- Proven experience with Mongo dB or other SQL and NoSQL databases a plus
- Experience with Agile methodology
- Demonstrated experience with UNIX and Shell Scripting
- Demonstrated experience in designing for high volume OLTP applications
- Demonstrated experience in Change Management and SDLC
- Experience with Version Control System such as Git
- Experience with Issue and Tracking software such as Jira