SUMMARY

• Over ten (10) years of professional experience in IBM DB2 LUW/UDB with emphasis on database administration, migration, business requirement analysis, application design, testing, implementation and production support of critical OLTP, OLAP and data warehouse environments
• Experience in development, support activities including installation, configuration, migration and successful deployment of changes across all environments
• Extensive experience in logical and physical design of databases, performance tuning, database utilities, backup and recovery strategies, capacity planning, high availability, disaster recovery, database monitoring, troubleshooting, change and problem management and production support on a 24/7 basis
• Experience resolving various database issues and bottlenecks by working directly with the DB2 development team
• Experience, from a database perspective, dealing with the WebSphere application server, HTTP server, MQ series and Cognos
• Extensive DB2 Connect, Federation server experience with activities involving configuration and maintenance of wrappers, server definitions, user mappings and nicknames
• Expertise in database schema migration and environmental changes etc.
• Proficient in IBM DB2 administration, automation, REORG, RUNSTAT, SQL Performance, Log Analysis, Query Monitor and DB2 BLU
• Excellent knowledge of database backup and recovery of large databases, typically multi - terabytes, HADR and IIDR
• Excellent knowledge of UDB database/instance tuning and optimizing complex SQL statements for best possible performance
• Extensive experience in writing database documentation including data standards, procedures and definitions for the data dictionary
• Experience in scripting like shell, VB script and Perl
• SQL Server (2014) DBA: 2 years’ experience
• Maintained SQL Server Database; ensured accuracy of information and automated numerous functions
• Fine tuning of database objects and server to ensure efficient data retrieval
• Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor
• Designed and implemented incremental and full backup policies and procedures

TECHNICAL SKILLS

Databases: DB2 LUW V9.1, V9.7, V10.1, V10.5 V11.1 FP 1; SQL SERVER 2014, Oracle 11

Database Tools: DB2 Connect, IBM Data Server Client, IBM Data Studio, db2top, db2fodc, db2dart, db2mon, db2pd, db2expln, db2exfmt, db2trc, db2mtrk, db2diag, nmon analyzer, OEM, DSM, SQL Server Management Studio, toad for SQL server

Third Party tools: DBI, Toad, Quest Control, db2 command center, configuration center, Spotlight, DB Artisan, DB2Mon, NetBackup Veritas etc.

Scripting Languages: Shell Scripting, Perl Scripting, VB Scripting

Process management tools: HP- Service Management tool. Change/Incident/Problem - Service Now, Jazz

Operating Systems: AIX, Linux Advanced Sever, Windows

PROFESSIONAL EXPERIENCE

Sr. DB2 Database Administrator

Confidential, Jackson, MS

Responsibilities:

• Involved in DB2 installation/configuration, monitoring, upgrades and maintenance in production and non-production environments
• Involved in Database deployment support for test and production environments
• Diagnosed and addressed database performance issues using performance monitors and various tuning techniques
• Maintained database standard procedure and compliance. Wrote UNIX shell scripting related to DB activities
• Performed authentication and authorization setup. Used SQL, stored procedures, UDT, triggers, views etc.
• Involved in production database support on rotation basis
• Setup database backup and auto-maintenance schedule using newly introduced feature during version upgrade
• Maintained database availability using HADR, server cluster
• Applied Fix packs to keep DB2 at the most current level
• Analyzed complex and long running SQL queries using Visual explain and other tools and optimized them using Design advisor and other tools
• Worked with ETL team in resolving the ETL cycle issues and performance tuning of long running queries
• Developed a Tool that reads set of similar test cases and prepares Response file for Silent Install of DB2 and provides report of test cases on various versions of supported UNIX/ Linux platforms
• SQL Server 2014 monitoring and troubleshooting user queries and concern

Environment: DB2 LUW V10.1, V10.5, V11on AIX and Linux platform, DB2 third party tools and commands including DB2TOP, DB2DART, and DB2PRD etc. IBM OPTIM DSM and TDM tool, SQL Server database administration using Management studio and TOAD, HADR, Cluster, Replication

DB2 Database Administrator

Confidential, Franklin, WI

Responsibilities:

• Served as Onshore team lead, managing a 6 member team
• Installed and configured DB2 UDB new releases, upgrades, and patches
• Provided 24*7 support on rotation handling P1/P2
• Migrated over 1000+ databases from V9.1 to V9.7 and V10.1
• Changed instance level and database level configuration parameters for database
• Conducted simulation before any major activity (upgrades, etc.) on DB2 servers
• Created primary database storage structures. Allocated system storage and planning future storage requirements for the database system
• Responsible for information management, information engineering, planned and implemented database standards, standard operating procedures, and guidelines
• Managed database team work queue and discussed with application team for production implementation/issue and concerns. Maintained Monthly Audit data clean and provided evidence per security standard
• Maintained compliance for incident/change/problem management tickets and SLA
• Managed critical Production Support, Data Security, Change Management, capacity planning, data warehouse, and vendor relations
• Created primary objects (tables, views, indexes etc.). Enrolled users and maintained system security, controlling and monitoring user access to the database
• Facilitated database maintenance activities such as BACKUP, RESTORE, ROLLFORWARD, REORG, and RUNSTATS. Implemented data security guidelines while making data available to those authorized to have access
• Monitored CPU, Memory, Paging space, Disk I/O and analyzed those using topas, nmon and other tools
• Developed backup and recovery solutions for databases especially very large databases depending on their RTO and RPO
• Provided guidance and support to application developers on DB2 best practices during application development
• Coordinated with management to get downtime windows for enhanced application performance by running REORG and RUNSTATS
• Monitored databases using database monitors, snapshot monitoring and event monitoring
• Employed SQL optimization, SQL monitoring, analyzing capacity management

Environment: DB2 Connect, IBM Data Server client, IBM Data studio, db2top, db2fodc, db2dart, db2mon, db2pd, db2expln, db2exfmt, db2trc, db2mtrk, db2diag, nmon analyzer, OEM, DSM, AIX, Linux Advanced Server

DB2 Database Administrator

Confidential

Responsibilities:

• Worked on instance and database installation/upgrade, data analysis, logical/physical design and backup/recovery
• Performed performance tuning, disaster recovery, database migration and database conversion
• Monitored Database, SQL optimization and knowledge on Shell Scripting, Unix Scripting
• Worked with performance tuning utilities like db2explain, db2pd, NMON, VMSTATS etc.
• Decommissioned DB2 release and migration to new version of DB2 and modified, tested, and deployed of database maintenance scripts
• Evaluated and examined disk space allocation in PROD environments on an ongoing basis to ensure sufficient disk space to cover the size increase of PROD/DR databases
• Created shell scripts to monitor file system/tablespaces usage and automatically notify DBA of database performance problems, resulting in increase of database availability
• Created various shell scripts to automate database maintenance such as reorg/runstats and backup/restore/snapshot monitors
• Performed Load, Import and Export Utilities
• Performed schema migration, object creation, backup and restore on request of development team
• Supported both non automatic and automatic environment and converted more than 400+ database from non-automatic to automatic
• Handled P1/P2 issues and were part PM investigation to find out root cause and solution

Environment: DB2 Connect, IBM Data Server client, IBM Data Studio, db2top, db2fodc, db2dart, IBM DB2 LUW AESE, ESE and EEE - v10.1, v10.5 and V11, DB2 Connect, IBM Data Server client, IBM Data studio, OEM, DSM, AIX, Linux Advanced Server