SUMMARY

• Strong background involving DB2 Database administration on all phases of software development lifecycle i.e. Development, Analysis, Design, Testing and Implementation for various kinds of applications.
• Worked as DB2/UDB Database administrator on AIX, UNIX, LINUX and Windows Platforms with expertise in online transaction processing and multi - user systems involving large and distributed databases.
• Involved extensively in Installation, and Configuration, upgrading, and troubleshooting DB2 databases.
• Skilled in database administration tasks like SQL coding, Relational Design, Referential Integrity, Index strategies, and SQL Troubleshooting Using DB2 UDB.
• Actively involved in Data Center Migration.
• Worked on PureData System for Transactions (PDTx), DB2 PureScale environments, Lead Migrations, Moving standalone servers to clustered environments.
• Migrating DB2 UDB databases from old to newer versions and applying FIXPACKS to keep DB2 at most recent level.
• Experienced in OLTP & OLAP database environments which include Single Partitioned and Multi-Partitioned Databases (DPF).
• Setting up HADR environment on the DB2 servers using db2haicu and Tivoli System Automation on Multi-platforms.
• Perform AUDIT on the Databases to give users bare minimum privileges and Database objects.
• Experienced in handling DB2 UDB security, establishing Replication between servers, Capacity Planning, Backup and Restore, Shipping archival logs, Corruption and Recovery, Estimations, Managing login/permissions.
• Remotely administrating the production database 24/7 through VPN.
• Experienced in using Operating System monitoring using tools such as NMON, TOPAS, TOP, VMSTAT, IOSTAT, NETSTAT etc.
• Familiar with tools like QUEST FOGLIGHT, CENTRAL, PERFORMANCE ANALYSIS, for database alerting, and running reports and analyze database historical data.
• Highly involved in performance tuning like performing REORGS, RUNSTATS on the database tables frequently and tuning SQL Queries and REBINDING them to the database.
• Wrote SHELL, SQL SCRIPTS and setup CRON jobs for checking backup of databases and crucial system tables. Also setting up database monitoring on all the database servers using a jump server.
• Experienced in working on ETL batch jobs and troubleshooting.
• Excellent analytical and functional skills with strong communication and interpersonal skills. Actively involved in the full project life cycle, user requirements to implementation. Willing to learn and adapt to new challenges.

TECHNICAL SKILLS

Databases: DB2 UDB ASE, EEE, WSE V 8.x, 9.x, 10.1, 10.5 PureData Systems (PDTx), PureScale, Infosphere Balanced Warehouse 9.5.

Data Tools: Optim Performance Manager OPM, IBM Datastudio, TSM, Uptime, Quest Foglight 4.x, 5.x, Spotlight, HACMP, Q-Replication, Federation, db2pd, db2haicu, db2top, db2audit, MQT, MDC, Quest Performance Analysis, EMC NetWorker, IBM TSM, DB2 Connect, BMC Change Manager, HP Change Management Suite, JIRA, Tripwire, SQL Optimizer, Optim Configuration Manager, Tivoli System Automation for Multiplatforms (TSAMP), Symantec ESM, Netcool, OEM Grid, OBIEE, NMON, Topas, SFTP, SCP and SSH.

Operating System: AIX 5.x, 6.x, Redhat Linux 4.x, 5.x, Solaris 5.10, Windows Server 2008.

Programming: Assembly Language, C++, Java, Shell Scripting, PERL Scripting, AWK and SED.

Schedulers: Cron.

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Database Administrator

Responsibilities:

• Working in Bureau of Enterprise Systems & Technology (BEST) team in Build, Deployment and Database support system projects.
• Working on a high profile project involved in setting up DB2 pureScale database supporting Affordable Healthcare application for Confidential .
• Worked on building HADR environment for the IBM Security Access Manager and Security Identity Manager applications.
• Migrated databases from Stand alone to PureScale servers, this involves Datacenter Migration as well.
• Worked on initial setup and Database move from Purescale to PDTx appliance.
• Worked in fast paced environment in building and configure 3 Database environments on IBM PureData Systems with in the project schedule.
• Actively worked with vendors in the process of deploying code and effectively managing the requests across all the regions.
• Involved in automating database maintenance tasks both Offline and Online which includes Backup, Reorg and Runstats.
• Providing on call support round the clock, addressing production issues by providing root cause analysis and fix (Instant and Long-term).
• Assisting and guiding DBA colleagues in the team on using new features, monitoring routines, snapshot views in DB2.
• Designed & Architected, wrote automated shell scripts to monitor all DB2 servers and provide Health Checks on regular basis from a jump server.
• Worked on POC to implement HADR in pureScale environment to make sure services are always available.
• Worked with Middleware Administrators in implementing Workload Balancing feature from the Websphere Application Servers in pureScale environments.
• Support Databases for Filenet Content Manager Application.
• Support Databases for Security Identity Manager (SIM) and Security Access Manager (SAM ) applications.

Environment: IBM DB2 V 9.7, 10.1, 10.5 PureData Systems (PDTx), PureScale, Linux, Optim, Data Studio, Foglight, Toad, Uptime, JIRA, Tripwire.

Confidential, Providence, RI

DB2 Database Administrator

Responsibilities:

• Working in Enterprise Data Services team for project delivery, change management and providing level 3 support.
• Involved in delivering critical projects in the Bank such as RSA Passmark and IBM Payments Director, where Passmark database is considered the most critical as it authenticate users online.
• Working across complex Data warehouse environment where 4 databases are partitioned into 40 logical partitions on the same 5 physical servers.
• Followed bank process and hardening standards in the new implementations, runbook, completed all the checklists prior to go live.
• Involved in starting up projects with estimation, licensing, capacity planning, and storage.
• Frequently refreshing the databases to lower regions and masking the data as per the requirement.
• Involved in setting up Quest performance analysis which is used to analyze the database bottlenecks.
• Raising PMR tickets with IBM and coordinating the efforts with Database support teams to troubleshoot critical database issues.
• Wrote shell scripts to run the utilities such as Backup Full and Incremental, Reorg, Runstats, and archiving dialog.
• Running database weekly reports to check the database non-standard configuration, Database size, DMS tablespace size, Filesystems Monitoring.
• Worked on databases as large as 16TB and involved in performance tuning.
• Worked with information security teams in provisioning and running Symantec Enterprise Security Manager Scans to see any unauthorized users and ports.
• Experienced in working in HACMP and VERITAS Clusters, and also aware of SAN replication.
• Involved and successful in running the DR exercises across various clusters.
• Involved in working with Infrastructure teams in installing IBM Netcool and testing the critical alerts such database backup failures.
• Prepare database implementation plan and go through all possible scenarios in the change board call, prior scheduling Database change requests.
• Worked with UNIX teams in maintaining the DB2 inventory, Blade logic report for estimates and licensing.

Environment: IBM DB2 V 8.2, 9.1, 9.5, 9.7, AIX 6.x, Foglight Performance Analysis, EMC RSA Passmark, OBIEE, Toad.

Confidential, Dallas, TX

DB2 Database Administrator

Responsibilities:

• Involved in project upgrading home grown lottery application.
• Lead a project to upgrade 30 databases from version 7 to version 9.7, which is a cross-platform migration from AIX to Linux.
• Upgraded database instances from 32-bit to 64-bit.
• Implemented database standard security baselines suggest by Center for Internet Security.
• Setting up Federation to the remote databases in other treasury office locations.
• Prepared backup and recovery strategies depending upon SLA which using backup compression.
• Implemented new features on the databases like Audit, Storage Compression.
• Involved in the data movement activity across DB2 LUW and Mainframe databases using EXPORT and Load Utilities.
• Involved in performance tuning the database.
• Provided on call support and implemented database changes.
• Wrote Shell scripts to automate tasks for maintenance such as for Backup, Reorg and Runstats.

Environment: IBM DB2 V 7.1, 9.7, AIX 5.2, RedHat 5, TSM, Websphere.

Confidential, Cincinnati, OH

DB2 Database Administrator

Responsibilities:

• Working as On-Call Database Administrator supporting and handling DB2/UDB for the Enterprise Database Management team.
• Working across the OLTP and Data warehouse environment.
• Implemented crucial database upgrades on the Online Banking server successfully.
• Checking the Audit for each quarter and checking up if there are any audit violations in all the Test, Development, Stage and Production Databases.
• Working with Instance and Database configuration parameters to automate tasks such as logging, memory management and Database storage.
• Working in rotational shifts responding to the pager alerts, staying on-guard to support Production Databases.
• Followed security standards, to give bare minimum access to the users.
• Implemented changes to detect the Locking situations by implementing new techniques and by guiding application team to run Jobs appropriately.
• Running continuous Snapshots to rectify and resolve the performance issues and working on AIX monitoring tool such as NMON and Topas.
• Supporting wide range of applications.
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to in corporate the new functionalities.
• Worked on Multi-Terabyte databases (Multi Partitioned and Single Partitioned), implemented disk defragmentation which is a crucial project on a partitioned database.
• Database Backup & Recovery (offline & online Backups - Full & Incremental). Database cloning using Redirected Restores, scheduling runstats and reorgs. Followed Data retention policy to and scheduled shell scripts to purge older data.
• Performed Scheduled maintenance on the databases such as reorg and runstats also in purging the older logs and backup images.
• For the technical support, opened PMR’s with IBM and Quest Software during the development phases.
• Performance tuning, Index Build, Running Explain format, Running db2advis plans, Adding Tablespaces and Containers, Scheduling Bulk Loads, assisting Application developers in re-writing the queries.

Environment: IBM DB2 V 8.2, 9.1, 9.5, 9.7, IBM Datastudio, AIX 5.x, 6.x, Foglight V4.2, 5.6, Toad, NetWorker, TSM, OEM.

Confidential, Columbus, IN

DB2 Database Administrator

Responsibilities:

• Played a crucial as a DB2 Database Administrator in setting up the HADR environment on the DB2 Workgroup Servers for Domain Architecture team.
• Highly involved in the project capacity planning and gathering prerequisites for the project.
• Applying Fixpacks to the most recent level of the DB2 version.
• Working with Instance and Database configuration parameters to automate tasks such as logging, memory management and Database storage.
• Migrating Database servers to the latest version which is 9.5.8 to 9.7.4.
• Working with the Operations DBA’s assisting them with the production issues.
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to in corporate the new functionalities.
• Setup HADR between primary and secondary servers to ensure High Availability using db2haicu & TSAMP.
• Suggesting Backup policies as per the requirement (Offline/Online; Incremental/Delta) and implementing the same and tuning the parameters accordingly.
• Database Backup & Recovery (offline & online Backups - Full, Incremental & Delta Incremental). Database cloning using Redirected Restores.
• Performed Scheduled maintenance on the databases such as reorg and runstats also in purging the older logs and backup images.
• Create and maintain documentation such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships, security baseline checklist, transition checklist, test case checklist documents for the project.
• Involved in the IBM Lotus Notes upgrade with the simultaneous upgrade on the DB2 servers.
• Implemented CIS standard security baselines while making data available to those authorized to have access.
• Worked with the IBM vendors to implement the design plans and provide solution architecture.
• Performed Knowledge Transfer to the remotely working DBA’s for the Operations Support.
• Provided DB2 support services in Staging and Production environments to the Operations DBA’s.
• Worked with various teams such as Architecture design, Network Support, Windows, UNIX, and SAN to setup the clusters.

Environment: IBM DB2 V9.5, 9.7, RedHat 5.4, Windows 7, IBM Data Studio, IBM Optim Performance Manager, BMC Change Manager, IBM Sametime 8.5.2.