We provide IT Staff Augmentation Services!

Cassandra Database Admin Resume

5.00/5 (Submit Your Rating)

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.

We'd love your feedback!