SUMMARY OF EXPERIENCE

• Over 9+years of IT experience with emphasis on Database Administration comprising RDBMS and No - SQL databases at all phases of software development lifecycle i.e. Development, Analysis, Design, Testing, Implementation and Support for various applications using different flavors of database administration software’s.
• Hold a year and a half plus years of experience in administrating production, development and testing environments and also help and suggest application developers on data modeling when required.
• Prepare prerequisites for the installation like JDK, JNA, Python installation using yum tool.
• Extensive knowledge in end to end installation and setup Cassandra as a package service/tar ball. Have set up Cassandra on over 80+ nodes.
• Uninstall Cassandra and remove all related files.
• Deep experience in setting up single node cluster, multi node cluster and multi datacenter cluster.
• Upgrade/down grade Datastax for Cassandra along with database upgrade.
• Good understanding on Architecture, Configurations and Security of Cassandra. Data read path and write path for Cassandra.
• Creating V-token node and Single token node. Converting single node token to V-token node.
• Generate and assign tokens evenly for single token node. Move existing token to a new token range for single token node.
• Adding a new node to existing cluster (v-token/single token) and adding a new datacenter to existing cluster.
• Replacing a dead node or dead seed node and also replacing a running node with a new node.
• Safely moving a node from one rack to another.
• Decommissioning a single node or entire datacenter from a cluster.
• Have worked on switching the snitches from SimpleSnitch to GossipingPropertyFileSnitch on an up and running existing cluster.
• Remove a dead or alive node from a cluster.
• Creating Keyspaces with SimpleStrategy or NetworkTopologyStrategy replication factor, tables and other objects using CQLsh.
• Changing existing keyspace strategy.
• Database maintenance using Compaction, Repair and Compression.
• Moving data to or from other databases using COPY command and SSTableLoader.
• Backing up and restoring data for a node or Cluster or entire DataCenter.
• Taking Snapshot, deleting snapshot and enabling incremental snapshot.
• Restoring from snapshot, restoring a snapshot into a new cluster.
• Installed DatastaxAgent and OpsCenter for monitoring.
• Monitor and tune node, datacent and cluster using Opscenter and nodetool utility.
• VERSION: DataStax 4.6/4.8 Cassandra 2.0/2.1, Opscenter 5.0/5.2, DevCenter 1.6

TECHNICAL SKILLS

RDBMS: DB2 UDB and POSTGRES

No SQL Database: CASSANDRA

Operating System: IBM AIX, UNIX, RH Linux, Windows

Monitoring Tools for DB2: IBM Control Center, Toad suite, IBM OPM, db2top, db2pd

Monitoring Tools for Cassandra: DevCenter, OpsCenter, nodetool

Monitoring Tool for OS: Top, topas, nmon, iostat, vmstat, errpt, lsof

Ticketing tools: BMC remedy, Atlassian suite, Service Now, ASK, Yantra

Languages: Shell scripting, SQL, CQL, C, C++

PROFESSIONAL EXPERIENCE

Confidential

DBA (Db2, Cassandra and Postgres)

Responsibilities:

• Install db2 for new development and testing servers on AIX and Linux.
• Install db2 client and db2 drivers on WCS servers.
• Db2 support for production, development and testing servers.
• Upgrade db2 from v9.5 to v10.5.
• Setup multiple standby HADR on v10.5 for production.
• Db2 Q-replication from production to reporting server setup.
• Database backup and restore solution for all environment.
• Provide Performance tuning, SQL tuning and db2avise.
• Monitor and Trouble shoot database on daily basis.
• POC on foglight.
• Backup and restore POC on Avamar.
• Using tools and utilities like db2top, db2pd, toad suite for db2 including spotlight.
• OS related monitoring and troubleshoot using nmon, topas, vmstat, iostat, errpt and more.
• Suggest capacity planning for db2 and Cassandra servers.
• Work with IBM on PMR’s.
• Install and upgrade Datastax Cassandra as a package.
• Setup new, single and multi-node cluster using Cassandra.
• Add, remove and decommission nodes on Cassandra cluster.
• Create new keyspaces and column families.
• Work with application developers on CQL data modeling.
• Install DatastaxAgent and Opscenter for Cassandra.
• Performance monitoring and tuning for Cassandra using Opscenter and nodetool utility.
• Datacopy using COPY command and SSTable loader.
• Backup and restore snapshot for nodes or Cassandra cluster.
• Create shell scripts to automate things.

Environment: DB2 ESE Version 9.5.8/9.7/10.5, AIX 6/7, IBM Utilities, Shell Scripting, CLP, DB2 data studio, Toad, Spotlight. Datastax Cassndra 4.6/4.8, Opscenter 5.0/5.2.

Confidential, Los Angeles, California

DBA (DB2 and Cassandra)

Responsibilities:

• Leading a team of 6 members productively and ensure responsibilities' in managing their need and growth.
• Install, upgrade and manage db2 product, apply licenses.
• Designed logical and physical databases and database objects for DB2 UDB.
• Implemented High Availability Disaster Recovery (HADR) with Tivoli System Automation.
• End to end setup, maintenance and performance tuning of larger data warehouse projects.
• Automate work using scripting.
• Sql tuning and index recommendation for db2
• Data move using db2move, admin copy schema procedure and cursors.
• Q-replication and Sql replication.
• Setup STMM and test in tuning database.
• Create and maintain database objects.
• Backup and restore solution using TSM.
• Partner with IBM and work on PMR to troubleshoot root cause.
• Coordinating with the core development team for coding static PL/SQL stored procedures.
• User creation and providing necessary Roles, Privileges and quota as per the requirements and standards.
• Designed and support compression tables, partition tables, MDC, MQT and temporary tables.
• Created snapshot monitors and event monitors to regularly check the health of the system
• Identifying the root cause for performance bottlenecks and providing the solution in the effective way.
• Generated various performance reports like SQL base comparison report etc using OPM tool.
• Perform AUDIT on the Databases to give users bare minimum privileges on the Database and Database objects.
• Involved in reducing HWM and free the space and add it to the File System.
• Supported project releases in production and lower environments.
• Install Datastax Cassandra as a service and tar ball.
• Setup single and multi-node cluster.
• Use Opscenter and nodetool utility to monitor and tune Cassandra node.
• Add and remove node to a Cassandra cluster.

Environment: DB2 ESE Version 9.7/10.1/10.5, AIX 6/7, IBM Utilities, Shell Scripting, CLP, DB2 data studio, TSM.

Confidential

DB2 DBA

Responsibilities:

• Install and maintain db2 for LUW, AIX.
• HADR for DR setup.
• Uninstall db2 and drop related files.
• 24/7 support for production environments.
• Support development and testing databases.
• Performance tuning for all kind of environments.
• Database base regular maintenance using db2 reorg and runstats.
• Db2 backup and restore.
• Validate and help creating db2 objects.
• Trouble shoot the bottleneck on severity issues.
• Scripting to automate monitoring and daily activities.
• Generate multiple reports for analysis and dashboard.
• Q-replication and SQL-replication.
• DPF for warehouse databases.
• PMR support and co-ordinate with IBM.

Environment: DB2 ESE Version 9.1/9.5/9.7, AIX 5.x/6.x, UNIX, RHL, DB2 connect, TSM.

Confidential, Charlotte, North Carolina

DB2 DBA

Responsibilities:

• Designed and implemented DB.
• Developed and implemented backup (online, offline) using TSM.
• Mange database backups, archive logs to TSM and purge them if required or elapses service agreements.
• Taking compressed backups and restore to TSM and disks. Extract and verify logs from TSM server.
• Provide performance tuning suggestion for SQL queries.
• Perform attach, detach for table partition.
• Help application team to extract and upload data in different file.
• Involved in capacity planning and decision making.
• Restored redirect QA(Preprod) or DEV database from TSM backup.
• Built and implemented stored procedures using SQL languages.
• Provided 24 x 7support during major releases and migrations.
• Also give on-call support when required or on emergency occasions.
• Create and implement Change requests (Normal, Expedite and Latent changes).
• Mange db2 inventory and database size report.
• Assisted Developers in tuning their PL/SQL Procedures.
• Monitor CPU, memory and Disk IO for Database servers using NMON, TOPAS, TOP, db2pd.
• Checking adapter related error using errpt command at OS level
• Granting authorizations to users to access db2 database as per customer request.

Environment: DB2 ESE Version 8/9.1/9.5, AIX 5.x, UNIX, RHL, Power Builder, Toad.

Confidential

DBA

Responsibilities:

• Provide support for over 500 databases (development, testing and productions databases).
• Install and un-install multiple copies of db2 product. Apply and manage licenses.
• List and manage db2 copies using db2ls command.
• Setting environmental variables OS level using export.
• Also setting registry variable using db2set both globally and locally.
• Database creation and maintenance.
• Work on incident tickets and resolve them within the provided SLA.
• Create and manage change requests.
• Provide value added services to improve the database performance.
• Help the application team when ever needed.
• Buffer pool tuning to increase higher hit ratio for queries.
• Attend tech calls on behalf of the team and resolve the issues at the quickest.
• To make sure all the databases have backups according to the standards agreed by CSC/SCB.
• Developed and implemented backup (online, offline, incremental) to TSM and DISK.
• Restore database from TSM server, incremental redirect restores, rollforward.
• 24 hours on-call support over the weekends when required.
• Manage db2 inventory and database sizes report.

Environment: DB2 ESE Version 8/9.1/9.5, AIX 5.x, UNIX, RHL, Power Builder, Toad.