SUMMARY:

• Objective: To obtain a challenging position as a Sr. Database Administrator - Outstanding competence in RDBMS and data modeling principles in DB2 UDB, Oracle, MySql and NoSql Cassadra and MongoDB
• Superb experience on Cassandra cluster Architecture, install, configure, maintenance and support Proficient skills in Cassandra parallel backups, restore, and object storage backup Experience in installation, configuration Cassandra 3.11.2 and monitoring DataStax Enterprise 4.7 cluster on 12 pods Vast knowledge about Cassandra tools like kubernate, nodetool,Cqlsh, Cfstats, TPstats, Dstats, Compaction and compression Strong understanding of Hadoop eco system such as HDFS, MapReduce, Hadoop streaming, Sqoop, oozie, Hive, SPARK and AWS Experienced on other NoSQL databases Mongo DB, Couch Base, with Big Data
• - Over 18+ years of extensive experience as DBA in DB2 UDB on LUW, and mainframe DBA
• Bachelor s Degree in Computer Science and Engineering from Canada Extensive experience in supporting application development, resolving performance issues, monitoring data security and integrity as well as assessing data models to ensure technical accuracy Substantial experience in installing and configuring in DB2 EE/EEE/DPF,MPP on LUW, and Z/OS Exceptional knowledge for high availability in RSCT, TSAMP, HADR, DPF, SQL and Q-replication with DB2 LUW Proficient experience with installing, migrating, upgrading DB2, Oracle,and Mysql Vast knowledge and experience and Mysql different types replication, and, and Oracle active, passive, and data-guard setup Superb skills in DBMS utilities, BMC tool, backup, restore, recovery, Oracle RAC, OEM, and data replication on DB2 EE/DPF, ORACLE, MySql env Competent knowledge in Performance Tuning, and Optimization in 10 GB 20 TB SF databases Strong knowledge in large scale of Database migration between RDBMS systems and NoSQL

PROFESSIONAL EXPERIENCE:

Sr. Database Administrator

Confidential

• Involved in Cassandra Architecture, Cassandra data modeling and installation using helm, configuration and monitoring Multiple DataStax Enterprise Cassandra cluster Developed script for creating parallel snapshots, nodetool repair, and restore Manage and Supporting production Cassandra Clusters with 100+ pods, Terabytes of data across clusters Actively evaluating and setting up Cassandra Databases on AWS and baremetal systems for non-production environment. Worked on automation in maintaining Production Cassandra clusters for recycle, backup, restore, refresh and repair Compaction, compression Cfstats, TPstats, Dstats, Compaction and compression Worked with Datastax Support team in implementing patches and Upgrades Worked on Nodetool utilities, shell and Python script, also worked on troubleshooting on hardware ware failures Involved in troubleshooting Cassandra performance related issues by analyzing various metrics available from OpsCenter Worked with Development team and Operation team on critical to minimize customer impact and verifying the data consistency across all datacenter Create new Colum Family’s as per application migration requirements Experience in benchmarking Cassandra Cluster using Cassandra stress tool. Prepared DB2 server migration plan from AIX to LINUX System and coordinate all the migration activities in DB2 V8.2, V9.7, V10.1 in DPF environment Setup, configure HADR with TSAMP/db2haicu on AIX, and Linux env and provide support Migrated database from AIX to LINUX system and upgrade db2 V9.7 to V10.5, V11.1 Planned and provided DBA support databases tasks including backup/recovery, replication, deployment and real time production troubleshooting responsibilities on DB2 UDB databases with HADR, DPF, and SQL/Q-Replication env Installed, configure, monitor, upgrade and maintain database in production and non-production environments Experience with large scale Hadoop environments build and support including design, capacity planning, cluster set up, performance tuning and monitoring Installed, configured mysql 5.1 -5.7 mysql,and setup master-slave, cascaded and master-master replication Provided support in DB2, and MySQL Production databases for world class customers Configured, capacity planning, setup monitoring, and provide DBA support including performance tuning Established and implemented flexible and maintainable data warehousing architecture for future growth Coordinated and communicated with internal stakeholders and subject matter experts to collaborate on steady state operations as well as new projects and implementations Migrated DB2 servers from DB2 EE to DPF and provided DBA support in production env Created Disaster Recovery environment using LOG shipping and and multi HADR using SSL Set up and Configure DB2 Native Encryption and log compression to enhance data security and storage consumption Set up and configure TSAMP on HADR with DB2HAICU for maximize database availability
• Setup and support different types of replications, like SQL, Q-Rep, data stream and sharePlex
• Created and configure SQL and Q replication and support in critical business env
• Optimized and tuned various types SQL in production environments. Managed test and production Databases doing backup, reorg, runstats, and maintenance Configured/setup GPFS file system for PureScale env on Aix and Linux OS
• Setup and configured and support DB2 HADR,SQL,Q-replication, and PureScale V9.8
• Configured, capacity planning, setup monitoring, and provide DBA support including performance tuning

Sr. Database Administrator

Confidential, Town and County, MO

• Installed, configured mysql 5.1 -5.7 mysql,and setup master-slave, cascaded and master-master replication Provided support in DB2, ORACLE RAC, Data guard, and MySQL Production databases for world class customers Configured, capacity planning, setup monitoring, and provide DBA support including performance tuning Established and implemented flexible and maintainable data warehousing architecture for future growth Installed and configured ORACLE 10/11g/12c in LINUX multi nodes RAC systems Prepared DB2 server migration plan from AIX to LINUX System and coordinate all the migration activities in DB2 V8.2 and later on V9.7 in DPF environment Experienced on Cassandra, Mongo DB, Couch Base, with Big Data, NoSQL databases Experienced on Cassandra, Mongo DB, Couch Base, with Big Data, NoSQL databases Coordinated and communicated with internal stakeholders and subject matter experts to collaborate on steady state operations as well as new projects and implementations Migrated DB2 servers from DB2 EE to DPF and provided DBA support in production env Created Disaster Recovery environment using LOG shipping and HACMP ideology Upgraded DB2 V7.* /V8.*version to V9.*/V10.1/10.5 in Aix, Linux and Windows environment Set up and Configure active - passive DB2 server with Veritas Cluster and SAN System Set up and configure HADR with DB2HAICU for maximize database availability
• Setup and support different types of replications, like SQL, Q-Rep, data stream and sharePlex
• Planning and implementing active - active servers using Confidential DB2 PureScale
• Created and configure SQL and Q replication and support in critical business.
• Planned and implemented DB2 version/Fixpack upgrade in LUW system
• Install, configure and support ORACLE, and DB2 Linux,UNIX and Windows env
• Optimized and tuned various types SQL in production environments. Managed test and production Databases doing backup, reorg, runstats
• Setup and configured and support DB2 HADR,SQL,Q-replication, and PureScale V9.8
• Configured, capacity planning, setup monitoring, and provide DBA support including performance tuning Established and implemented flexible and maintainable data warehousing architecture for future growth Installed and configured ORACLE 10/11g/12c in LINUX multi nodes RAC systems Provided support in DB2, ORACLE RAC, Data guard, and MySQL Production databases for world class customers Worked with very large databases and database partitioning, performance tuning, and monitoring Helped and co-ordinate for RMAN backup and restore recovery on RAC and standalone env Planned, applied oracle CPU and PSU patch and any security vulnerability patch Established and enforced best practices for extracting, transforming and integrating new data sources swiftly and reliably
• Configured, capacity planning, setup monitoring, and provide DBA support including performance tuning
• Prepared DB2 server migration plan from AIX to LINUX System and coordinate all the migration activities in DB2 V8.2 and later on V9.5 in DPF environment Migrated DB2 servers from DB2 EE to DPF and provided DBA support in production env Created Disaster Recovery environment using LOG shipping and HACMP ideology Upgraded DB2 V7.* /V8.*version to V9.*/V10.1 in Aix, Linux and Windows environment Set up and Configure active - passive DB2 server with Veritas Cluster and SAN System Set up and configure HADR with DB2HAICU for maximize database availability Setup and support different types of replications, like SQL, Q-Rep, data stream and sharePlex Planning and implementing active - active servers using Confidential DB2 PureScale Created and configure SQL and Q replication and support in critical business. Planned and implemented DB2 version/Fixpack upgrade in LUW system Install, configure and support ORACLE, DB2 and Mysql 5.1-5.7 in Linux and Windows env Install, configure OEM and use OEM for performance tuning, and analysis Optimized and tuned various types SQL in production environments. Managed test and production Databases doing backup, reorg, runstats Installed and configured ORACLE 10/11g in LINUX multi nodes RAC systems Provided support in DB2, ORACLE and MySQL Production databases for world class customers Setup and configured, and support DB2 PureScale V9.8

Database Administrator

Confidential, Essex JCT, VT

• Participated in system life cycle from requirements gathering and program spec writing thru program development, testing, implementation and production support Configured, maintained DPROP (SQL, and Q-Replication) forward, Reverse, Time and/or Event-Based, and Bi-directional
• Monitored, analyzed and tuned the performance of DB2 for z/OS using OMEGAMON XE
• Investigated customer issues with database administration, connectivity, and application development, through the use of advanced tools and technical diagnostics Analyzed and optimized of production databases residing in various Servers, and developed and implemented project plan for migrating historical data Acted as consultant and mentored for development teams to ensure sound physical data model Performed system monitoring, tuning and assisted programmers with explain analysis, NimBus and SQL tuning of system utilizing Packages in multiple Collection environment Designed and recommended data warehouse/data mart architectures for future versions of the VIEWS systems utilizing a DB2 UDB data warehouse solution Managed VIEWS 3.0 database development and design team

Database Administrator

Confidential, Sidney, NE

• Written DB2 code for building database, database installation, configuration, upgrades, database monitoring, and tuning various performance issues, database programming, and database migration in HP-UX, and AS400 Managed DB2 UDB database access and security on a multiple-domain network, and backup, restore, recovery strategies, database documentation (data dictionary, database diagrams, scheduling tasks)

Database Performance Specialist

Confidential

• Written DB2 code for building database, database installation, configuration, upgrades, database monitoring, and tuning various performance issues, database programming, and database migration Managed DB2 UDB database access and security on a multiple-domain network, and backup / recovery strategies, database documentation (data dictionary, database diagrams, scheduled tasks) Worked for decision support benchmark and reported the performance metric (QphH@Size), and query throughput in UDB DB2 V7.1-8.1 EE and EEE databases Designed functional specs and matching algorithm to map entity/relation of multi-platforms Worked technical support role on a number of platforms including AIX, NT, Solaris, HP, Linux towards DB2 Universal Database V.6.0 -V.8.1 Investigated customer issues with database administration, connectivity, and application development, through the use of advanced tools and technical diagnostics Provided end-to-end support could include identifying potential defects within the DB2 UDB product source code and working very closely with software development teams across Confidential Performed system monitoring and tuning and assisted programmers with explain analysis and SQL tuning of system utilizing Packages in multiple Collection environment

Database Architect

Confidential

• Built a production support department including policy and procedures to monitor the DB2 Universal Database Performed space management task responsible for dataset placements for entire set of IMS and DB2 database datasets Provided UDB DB2 support and data architecture planning for production and development MDI gateways and the SQL Server replication functions. Review of daily operational procedures and improvements to those functions. Conducted Performance Tuning and testing to optimize NT Server and SQL Server performance for DB2 Database. Designed data warehousing system for sales and marketing departments Developed new code and support up and running program for current /previous updates Implemented replication of production UDB database engine, and development environment Designed a migration plan to migrate the current database to Oracle/Solaris platform Experienced at converting logical design into physical data structures and maintaining DB2 security Ensured Q&A report, validation and maintained data integrity, consistency and accuracy Maintained data backup and recovery in Win2K & WinNT server and monitoring procedures

Database Administrator

Confidential

• Created and controlled database, users, and maintained backup and crash recovery policies Designed & wrote Unix shell scripts to automate much of the UDB RDBMS operations functions Participated in system life cycle from requirements gathering and program spec writing thru program developement, testing, implementation and production support Selected and introduced UDB database production support and development design tools for the views and warehouse Designed and recommended data warehouse/data mart architectures for future versions of the VIEWS systems utilizing a DB2 UDB data warehouse solution Managed the VIEWS 3.0 database development and design team. Migrated database from Oracle version 7.3 to 8.0 and installed SQL Server in WinNT Created tablespaces, profile, and technical trouble shooting to the database and SQL Server Planned and implemented data reorganizations and partitioning features of DB2 and Oracle Designed data structure and data integrity rules using SQL, PL/SQL triggers and procedures

Network Administrator

Confidential

• Created new account, maintained existing user account in database and worked with customers Installed, configured, troubleshoot protocols of TCP/IP, WinNT Server and Workstation 4.0 Assisted in maintaining server control through staging server in a high -tech environment Resolved application and connection problems, managed all users accounts through TCP/IP Used Remote Sensing (RS) and ArcGIS to capture and record GPS metadata and to locate zone Experienced using GPS, ARC/INFO, MapView 2.0 tools to display areal map
• EDUCATION: