SUMMARY

• Over 8+ years of Information Technology experience, exposed to different industries including Retail, Home improvement and health care insurance.
• Expertise on various platforms such as DB2 LUW, Cassandra, MySQL, Mongodb, Couchbase and PostgreSQL.
• Excellent communication skills, working closely with teams involving Data Modelers, Business Analysts, Department Managers, Release Management, Developers and Architects.
• Delivered solutions within aggressive timelines and fast paced work environment that involved both Agile and waterfall work stream.
• Opened PMRs/incident to get resolution from IBM along with Datastax to provide Cassandra support.
• Provided 24x7 infrastructure level support to handle and resolve critical application issues and maintenance.

TECHNICAL SKILLS

RDBMS: IBM DB2 LUW 9.x/10.x, PostgreSQL 11.x/10.x.

NON - RDBMS: Nosql; Mongodb 3.x/4.x, Datastax Cassandra 4.x/5.1.x/6.0.x/6.7.x, Couchbase 6.0.x

Tools: /Utilities: Jenkins, Atlassian Suite, Opscenter, TOAD, TSM, AQT, Avamar, DDboost, Archer, dsloader (v1.x), Mongo Compass, Mongo Atlas, pyyaml

Script Language: Korn shell, Bash Shell, Sql Programming, JSON, Nosql, Python

Cloud: Google Cloud Platform (GCP), Azure Cloud Certified, CCSK in Training

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Worked with Multi waterfall Projects supporting ecommerce website for lowes.com (BC) and LowesForPros (BB).
• Worked on Omnichannel work environment, having Agile work process, involving microservices architectural designs for Enterprise Truck Delivery and Supply chain, New Pricing Services and inventory, Enterprise and online delivery projects, Order cache and Order purchase history, Enterprise Inventory. Created sprints and stories on weekly basis to get the work done for the same.
• Hands on experience in Building Datacenters, performing HACMP (Power-HA), HADR for lowes.com website. Worked extensively on on-perm and cloud DR Buildup, planning and execution.
• Couchbase installation on on-prem data center and GCP for New pricing services Project. Setup XDCR sync replication between the two. Setup security on db level, created user and roles, opened firewalls, created and handled bucket creation.
• Cassandra installation between on-prem DC and Google Cloud Platform for central inventory project. Created 12 node cluster in 2 regions and 4 zones within google cloud. Built a 4 nodes cluster for the same using on-prem google Kubernetes engine pods. Created keyspaces, tables and set up security such as roles and users for the same.
• Performed multiple POC on fog-light for DB2, Cassandra and PostgreSQL, DDBOOST for database backup and restore and Jenkins for scheduling jobs, Google Cloud buildup using compute engine for Couchbase db installation.
• Successfully Upgraded Db2 from version 9.5 to 10.5 with zero downtime to website. Also involved in Project planning, documentation, POC testing and execution for the db2 Upgrade.
• Cassandra dse upgrade from Datastax version of 4.6.1 to v5.1.10 and from v5.1.10 to v6.7 with zero downtime. Built centralized OpsCenter cluster for all the Cassandra servers from v6.0 to 6.7.0/6.7.3
• Successfully installed MySQL cluster using innodb oracle product and percona for multiple microservice projects. Create the databases, tables and set up security by creating db level users and roles.
• Involved in Automation projects which is the Lowes internal cloud system. This involves data transfer and maintenance between multiple OS platforms such as AIX, Windows and Linux.
• Interact with development team, Release and Operations team for incorporating new functionality.
• Experience in both Apache Cassandra & Datastax Enterprise edition in installation, configuration, backup configuration, upgrade, CQL (Cassandra Query Language), node tool commands, bootstrapping, performance tuning, decommissioning, migration etc.
• Worked on Datastax latest tools such as ds bulk loader to load the data from databases such as SQL server and DB2 LUW into the Cassandra domain.
• Worked on tuning and regular maintenance on daily basis to Nodes that results in removal of tombstones. Performed repair and SStable split on Nodes to keep them stable.
• Worked on PostgreSQL installation, tuning, server setup and maintenance on all the 1800 stores as a part of Order history project. PostgreSQL is also used and maintained as a backend for the Atlassian Suits involving tools such Jira, Confluence, bamboo and crowd.
• Generated shell script for multi script deployments, and for grant checks on multi Project works.
• Checking the consistency of the databases using different db2, Cassandra, PostgreSQL, Couchbase commands and windows script.
• Developed shell scripts to handle DBA tasks and alerting systems. Scripts to perform regular maintenance on Cassandra Nodes.
• Responsible for performance tuning, 24 x 7 support, analysis and resolution of database problems that occurs during the critical time processing.
• Assisted Off time and overtime production support as and when needed. Participated in Omni-channel-wide application.

Environment: DB2 UDB 9.7/10.1.x/10.5.x, AIX 6.x/7.x, Datastax V4.x/5.x/6.0.x, CassandraV2.x/3.x, ds loader V1.x, GCP, Python 2.x/3.x

Confidential

Responsibilities:

• Worked with Multi Projects Having SPI, HIPPA and PHI data within them. Projects like RMAS (Obama care), EARP, VBC and RSC.
• Excellent Interaction with Clients, Functional and business analysts, department Managers, different levels of users and developers and experience with Software Development Life Cycle.
• Highly involved in analyzing and tuning DB and DBM parameters, defining Registry variables for performance improvement
• Involved with creating, running and validating DDL and DML on Dev and Test environment. Worked with Production releases on regular basic. Created Range partitioned Tables and specify ranges Creating Tables and Indexes. Altered tables and added check constraints and referential integrity.
• Assisted Off time and overtime production support as and when needed. Participated in enterprise-wide application.
• Interact with business team, development team and release teams for incorporating new functionality.
• Documented plans and procedures in terms of backups, restores and relevant maintenance.
• Developed shell scripts and python scripts to handle DBA tasks and alerting systems.
• Tuning application queries, databases and systems for best performance.
• Install DB2 UDB on AIX. Created instances and databases on different servers and provided connectivity to development and production databases.
• Responsible for software installation, database creation and maintenance, performance monitoring and tuning, backup and recovery, customer consultation, DBMS infrastructure creation and support, problem determination/resolution.
• Analyzed and monitored the entire system to pinpoint the performance bottlenecks using the tools like db2top, db2pd, Nmon.
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.log, monitoring size of table spaces by setting up a threshold.
• Remotely administer the production database 24/7 through VPN connection. This includes monitoring the database growth, checking for the performance bottlenecks, taking backups for disaster recovery and tuning SQL queries for better performance.
• Opened PMRs and SEV1 tickets with IBM DB2 problem determination teams when required.

Environment: DB2 UDB 9.7/10.1/10.5 , AIX 6.x/7.x, Linux RHEL 6/7, Advanced Query Tool, PADB2 Tools. Mongodb 3.x