SUMMARY:

• 11+ years of experience in Database Technologies (UDB DB2 V 9/9.5/9.7/10/10.5 Mysql 5.0/5.5/5.6 and Oracle).
• Cross skilled DBA on UDB DB2, Mysql, Sql - Server and Oracle
• Experience in handling No-sql databases like Cassandra, couchbase etc
• Experience in leading and mentoring fellow team members technically and strategically.
• Experience in Database Modeling: Physical and Logical Database designing and developing.
• Good exposure to various RDBMS products and components,
• Proficient in Instance/Database migration and applying regular/alternate fixpacks on Single/Multi partitioned environment (EEE/ESE/DPF).
• Experience in handling variours OLTP and OLAP applications.
• Experience in setting up Mysql (master/slave, multi master) replication
• Experience in setting up HADR and Replication (Mq and SQL) for DB2 UDB database systems.
• Hands on exposure on ETL tools like IBM database WTX, and informatica.
• Good exposure to OS (UNIX/Linux) and Storage related capacity planning.
• Good exposure to Hardware sizing for UNIX and Linux based database systems.
• Proficient in shell scripting (KSh) and hands on with Perl scripting
• Explored other databases like Mongo DB and PostgreSQL
• Self learner and Motivated individual who can operate well by myself and as a team, always interested in learning and exploring New technologies

TECHNICAL SKILLS:

Relational Databases: DB2 V7 UDB, DB2 v8.2 LUW, DB2 V 9 /9.5/9.7/10.1/10.5 LUW MYSQL 5.x Sql server 2008,2012 2014, Apache Cassandra, Postgresql etc

Other DB related Skills: Erwin, Quest, IBM optim admin, Datastage Tx, Informatica, Rman, TSA, TWS, TSM, Symmentec netbackup, Mysql ( workbench, enterprise manager, enterprise backup ) etc

Operating Systems: WindowsNT/2000/XP, Windows, AIX 5x, 6x, Linux(redhat), Sun-Solaris and HPUX platforms.

Application Servers: WebSphere Application Server, Webspehere Portal etc

Programming Languages: Shell (ksh,Bash), Perl, C ++, Java

Change / Repository Management: Rational ClearCase, HP service manager, Digital work flow, service desk

Project Management / COTS: MS Office, OpenOffice

Other Tools: Open ssl, BMC Best 1( Analyze, predict and performance assurance), Hp diagnostics,wiley Intoroscope, TWS. Open ss

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

Senior Database Administrator

Environment: Linux, Unix, Windows

RDBMS: MYSQL ( V5.x) DB2 LUW V9.5, V9.7, V10.5, Sql-Server 2008 and 2012

Tools: Remedy, Netbackup, Erwin data modeler, ksh, Bash, perl, Vsphere

Responsibilities:

• Installation, configuration and upgrading of DB2, Mysql software and related products.
• Evaluate and explore new RDBMS and features ( Apache Cassandra, Mongo DB, posgre Sql etc )
• Establish and maintain sound backup and recovery policies and procedures.
• Set up and maintain Mysq Replicaton, Mysql cluster, Sql server cluster and mirroring and DB2 HADR
• Implement database design agreed upon by System and Application DBAs.
• Implement and maintain Db level user authentication and security.
• Experience in utilizing mysql Mysql workbench, Mysql Enterprise Monitor and backup
• Assist in application tuning and performance monitoring mostly on Mysql ( used Mysqltuner.pl )
• Maintain documentation and standards.
• Plan growth based on work load characterization and perform infrastructure changes (capacity planning).
• Provide 24x7 supports.
• Experience in setting up mysql and Open ssl secured connection configuration
• Monitor/troubleshoot issues in all logs and jobs on server to keep database server functioning for application.

Confidential, Rocky Hill, CT

Senior Database Administrator (DB2 UDB)

Environment: UNIX, DB2 UDB LUW V 9.5, V9.7. ( EEE, DPF )

Tools: Quest central, HP SM, TWS, CA-Erwin,TSA,TSM,.Replication center.

Responsibilities:

• Create and maintain physical and logical data models using Erwin data modeller.
• Create and maintain DB2 instances and databases on Unix and linux
• Backup and recovery for DB2 databases on Unix and Linux. Using TSM.
• Performance tuning for the db2 instances and databases
• Set up and maintain TSA (Tivoli System Automation) and automate disaster recovery failover.
• Automate database and instance monitoring and maintaining script ( K-shell, Unix ).
• Set up and maintain MQ- replication on Db2 UDB..
• Set up and maintain TWS ( Tivoli workload scheduler) Jobs for Db2 on Unix and linux.
• Capacity planning for unix and linux systems for db2 database systems.

Confidential, Bloomington, IL

Database performance Analyst /Administrator (DB2 UDB) .

Environment: UNIX, DB2 UDB LUW V8, V9, V9.5. ( EEE, DPF )

Tools: Quest central, Quest spotlight, Toad 4.5, BMC Best 1, HP service Manger.

Responsibilities:

• Monitoring performance of production databases and tuning .
• Analyze workload characterization and plan hardware capacity ( capacity planning )
• Work on ETL and reporting tools and provide guidance to the development team. server sizing for various kinds of applications (OLTP and OLAP).
• Involve in design and development stages of project in database performance perspective.
• Member of IIA ( Infrastrucutre Impact Analyst) team.
• Anslysis of OS (UNIX, Linux using BMC BEST 1, also modeling and sizing of linux and Unix servers, VMs and LPARS.
• Set up BMC patrol alerts for DB2
• Involved in working on major performance improvements related to Massive insurance domain datamart ( DPF - EEE) databases

Confidential, Irving, TX

Database Administrator (DB2 UDB) (Application DBA)

Environment: UNIX, DB2 UDB LUW V8, V9

Responsibilities:

• Implement new business requirement on to the relational database id DDL.
• Designing and implementing the logical and physical database schemas and other objects models.
• Setup new Development /Testing Databases.
• Designing, Coding, Testing and debugging various Db2 objects such as procedures, triggers etc.
• Coordinating with Developers for changes (code and object) associated with database..
• Performance Tuning the Application/Database.
• Write shell scripts for scheduling the utilities and other tasks.
• Worked on various DB2 utilities and tools.
• Granting Rights/Privileges on DB2 objects
• Setup for the backup and recovery.
• Monitor, Maintain and support SQL replication.
• Involved in 24/7 on call production support and code drop activities.

Confidential

Database Administrator (DB2 UDB)

Environment: UNIX, DB2 UDB LUW V8, V9

Responsibilities:

• Server builds - installing DB2 UDB V8 and V9 on various platforms (mostly UNIX).
• Event and Incident Management using tool called a Digital work flow which is similar to Remedy and Clearquest ticketing systems and Clear case used for version control.
• Instance creation and configuration.
• Up gradation of the DB2 UDB (applying fixpak).
• Installation of alternate fixpak
• On call - adhoc production support for Db2 UDB database related problems.
• Supported and Coordinated Data center migration involving more than 100 severs with 400 instances and databases.
• Performing scheduled utilities like Backups, REORG, RUNSTATS etc.
• Performing security Audits.
• Provided production support for critical applications running on 24x7 basis.

Confidential

Database Administrator ( designation: Software Engineer)

Environment: AIX and Solaris for databases DB2 - UDB 8X (mostly), Oracle 9i, 10G

Responsibilities:

• Implement new business requirement on to the relational database id DDL.
• Designing and implementing the logical and physical database schemas and other objects models.
• Setup new Development /Testing Databases.
• Designing, Coding, Testing and debugging various Db2 objects such as procedures, triggers etc.
• Coordinating with Developers for changes (code and object) associated with database..
• Performance Tuning the Application/Database.
• Write shell scripts for scheduling the utilities and other tasks.
• Analyzing and Tuning Application SQL’s
• Worked on various DB2 utilities and tools.
• Granting Rights/Privileges on DB2 objects
• Setup for the backup and recovery.
• Supporting and monitoring HADR
• Setup, monitor and support MQ replication.
• Managing logs and file system
• Involved in 24/7 on call production support