Cassandra Database Admin Resume
Charlotte, NC
SUMMARY
- 8 + years of IT industry experience encompassing a wide range of skill set, roles and industry verticals. My area of expertise is Banking Customer information maintenance. My forte is Cassandra, Kafka with exposure to MDM & DB2.
- Also executed software projects for Energy and Utilities and Automobile domain.
- Managed Development, Technology re - engineering projects, involving Apache Cassandra, Datastax Enterprise Cassandra, apache Kafka, Hortonworks Kafka, Java, IBM MDM, DB2, Datastax Opscenter, devcenter, and web services.
- Have involved in Cassandra, DB2 database administration and data modelling activities such as capacity planning, design, installation, maintenance, optimization monitoring and support.
- Extensive experience with analysis, design, development, customizations and implementation of software applications.
- Experience with Agile and waterfall development and project methodologies.
- Have the ability to adapt seamlessly with new environment/people and also have the potential to learn new technology/processes in ease.
- Worked closely with client managers/business analysts of the bank to drive technical solutions, design and provide development estimates for schedule and effort.
- Dynamic, hard-working, ability to work in-groups as well as independently with initiative to learn new technologies/tool quickly and emphasis on delivering quality services.
- Have strong ability to build productive relationships with peers, management, and clients using strong communication, interpersonal, organizational, and planning skills.
TECHNICAL SKILLS
Databases: Apache Cassandra, DSE Cassandra, Apache Kafka, DB2
Reporting Tools: Datastax Opscenter
Operating Systems: OS390,Windows, Linux, OS X
Languages: SQL, CQL, Cobol, Shell and Python
Product: IBM MDM, DSE
Software: Datastax DevCenter, IBM Data Studio, FTP, NDM, ERwin Data Modeler
Testing Software: Quality Centre
Job Scheduling: CA7 Scheduler, Crontab, Autosys
PROFESSIONAL EXPERIENCE
Confidential
Cassandra Database Admin
Responsibilities:
- Architecture, design and capacity planning, implementation for various applications for Cassandra infrastructure.
- Seamless Installation of new Apache/DSE Cassandra, Apache Kafka and Solr.
- Upgradation & expansion ofthe current systems and decommission ofthe failure items includes add new node/new data center into Cassandra cluster, also removing failure node and DC.
- Performing backup, bulk load, run repairs, monitoring using custom build scripts as well as Opcenters.
- Create Cassandra DB objects like keyspace, column family, indexes, Solr indexes, users and explored CQL to support various application activities.
- Installing Kafka message broker clusters zookeeper clusters and involved in creating Kafka topics, partitioning planning, SSL setup, Monitoring and support.
- Installation of new Apache Cassandra, DSE software & tools, upgradation & expansion ofthe current systems and decommission ofthe failure items.
- Provide cross-functional support to various application team which are using Cassandra on all DB issues and queries.
- Analysis is carried out to resolve various performance issues by suggesting better techniques and practices as part of issue resolution.
- Handle issues, bugs and provide solutions with root cause analysis and involve Datastax for product support if needed
- Active co-ordination & follow-up is being done all hardware, network issues.
- Technical leadership for resolving complex programming tasks. Several operational tasks are performed along with other tasksto managethe health of allthe clusters are also taken upregularly.
- Responsible for ensuring quality deliverables within the stipulated timelines.
Environment: Datastax Enterprise Cassandra, Apache Cassandra, Apache Kafka, Datastax Opscenter, DB2
Confidential, Charlotte, NC
Technical Developer/ Cassandra Data modeler
Responsibilities:
- Provided application production support, which includes level 2 and level 3 support for the Reference Data Systems module this is core part of retail banking business of Confidential .
- Responsible to make sure that Batch runs as per SLA and no issues reported. Acknowledge and fix the Level1 Pages for job abends/ Issues.
- Responsible for schedule tracking to meet delivery deadlines and also documenting all the information gathered during the incident for future reference by all the team members.
- Created a project plan for DB2 to Cassandra Conversion, Out of MDM process.
- Provide road map for the Cassandra conversion and implementation support.
- Develop Cassandra Data model considering current functionality and business need of application.
- Responsible for creating incident ticket by using Maximo ticketing tool and open the bridge line. Understand the issue and bring all relevant teams (ex- Level 3, DBA, Network, performance etc.) on that bridge to discuss about the problem and try to find out the root cause of the problem.
- Perform proactive root cause analysis of all identified issue related to RDS (Reference Data Systems) by checking logs and engaging associate technical team involved to drive the issue to a resolution.
- Provide application production support, which includes level 2 and level 3 support for the Reference Data Systems module this is core part of retail banking business of Confidential .
- Address all concerns and information requested by Client on priority basis, making sure everything is smooth.
Environment: Datastax Enterprise Cassandra, Apache Cassandra, Datastax Opscenter, COBOL, Easytrieve, IBM Data Studio, Oracle, DB2, MQ, ERwin Data Modeler & IBM DB2 Utilities.
Confidential
Technical Developer
Responsibilities:
- Working in technical arena in delivering solution to our customer in the Energy & Utilities sector.
- Deliver new and complex high quality solutions to clients in response to varying business requirements.
- Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
- Responsible for providing 24*7 PRODUCTION Support and Maintaining LCIS (Legacy Customer Information System) Application which is the heart and the most critical and challenging application of Confidential business.
- Responsible for resolving emergency and normal defects which were tagged under stipulated releases and creating Positive and Negative test cases so as to check the validation of changes.
- Utilize in-depth knowledge of functional and Technical experience in IBM Mainframes to deliver effective solutions to customer.
- Responsible for resolving service requests raised by the users of Confidential .
- Working as Metrics coordinator in the account to work on the metrics related reports on account level.
Environment: COBOL,RPM, Remedy, Clear quest, IBM Mainframes & IBM DB2 Utilities.
Confidential
Technical Developer
Responsibilities:
- Responsible for working on Change request and enhancements so involved highly in coding and unit testing phase.
- Responsible for gathering requirement from the client and preparing efficient solution to help customer in their problem.
- Responsible for preparing unit test cases and documentation of every positive and negative test case.
- Ensure that all requirements are covered as per the change request or enhancement.
- Communicate activities/progress to project managers, business development, business analysts and clients
- Develop implementation and test plans, coordinate and work with clients.
- Responsible for providing 24*7 PRODUCTION Support.
- Responsible for single handedly handling small projects that came up as transition from Confidential to Confidential .
- Responsible for KT(Knowledge Transfer) to new team members.
Environment: COBOL, QMF, CHANGEMAN, File manager, Fault Analyser, IBM Mainframes & IBM DB2 Utilities.