PROFESSIONAL SUMMARY:

• Database administrator specializing in IBM UDB DB2 and SQL Server, with 14 years of experience in various aspects of database administration including physical and logical design, performance monitoring, maintenance, query analysis, optimization, backup/recovery, replication and migration.
• Proven experience with providing production support for Oracle and Sybase Database servers.
• Installation and DB Configuration
• Database Performance Tuning
• High Availability and Disaster Recovery (HADR)
• Shell and PowerShell scripting
• Replication and Reporting
• Security Best practices
• Virtualization and consolidation
• Data Archiving and Reporting
• Extraction Transformation Load (ETL)
• Index Maintenance (RUNSTATS/REORGS)
• Amazon Web Services (AWS)
• Clustering and Database Encryption

TECHNICAL SKILLS:

Databases: IBM DB2 UDB V11.1/10.x/9.x/8.x, Sybase 15.7, PostGreSQL and MS SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014 and 2016.

Operating Systems: AIX, Linux, SUN OS and Windows Server 2003/2008/2012/2016

Database Tools: BMC Patrol, NetBackup, CyberArk, Qualys, DBArtisan, Foglight, IBM Change Data Capture, Optim, LiteSpeed and Spotlight

Misc: CyberArk, Qualys, Service Now, SSCM, SCOM, Autosys and Control - M

EXPERIENCE:

Confidential

Senior Database Administrator

Responsibilities:

• Installed and configured DB2 V10.5/11.1 and assisted in application enhancements through code changes.
• Created a lean process to migrate databases from AIX to Linux servers by utilizing db2look and LOAD utility.
• Migrated mission critical databases from AIX to Linux from IBM Power Series hardware to reduce costs.
• Upgraded DB2 10.1 databases on 32 bit edition of DB2 to 64 bit edition of V10.5.
• Identified problem queries and improved performance by suggesting index changes and table maintenance.
• Evaluated DBM and DB Configuration parameters and recommended changes to reduce bottlenecks.
• Configured automated jobs for database backups, statistics, index reorganization and capture audit information.
• Converted several SMS/DMS Tablespaces to AUTOMATIC Storage to reduce maintenance and improve performance.
• Consolidated and Virtualized database servers thereby reducing licensing cost by 20%.
• Remediated all database vulnerabilities as reported by QUALYS and achieved 100% compliance with regards to database configuration and password management.
• Automated table EXPORT/IMPORT to be used for rollback during database changes.
• Configured HADR with multiple standbys so provide business continuity and disaster recovery.
• Created a library of scripts, for database monitoring, utilizing system views, monitor tables, table functions and db2pd.
• Secured Database accounts using complex password policies and providing database access at a granular level.
• Performed capacity planning and recommended solutions including data archiving to manage data usage.
• Setup PostGreSQL database in AWS RDS and configured auditing.
• Managed the CyberArk Project and achieved 100% compliance with regards to password management.
• Reduced the RTO for several high critical applications by more than 30 minutes. Achieved this by automating the steps involved in bringing the Disaster Recovery servers online.
• Conducted Disaster Recovery Tests during BCP and documented shortcomings to improve the process.
• Provided 24x7 oncall support for problem management and incident resolution.

Confidential

Senior Database Administrator

Responsibilities:

• Installed and configured DB2 UDB database in V8.x, V9.x and V10.1.
• Reviewed performance stats and recommended changes for tuning database, server, and storage configurations, as well as application.
• Implemented HADR and SAN Replication for Disaster Recovery solution.
• Identified long running queries and confirmed bottlenecks using Explain plans.
• Rewrote the database monitoring scripts to use Monitor (MON) table functions.
• Analyzed Index usage, table fragmentation, optimizer statistics, parameter settings, transaction logging, database layout, session activity, cache utilizations, sorts, buffer pool utilizations, locks, deadlocks, and others.
• Planed and Tested annual Disaster Recovery procedures for all the database servers.
• Created an intelligent script to identify fragmented indexes and REBUILD/REORGANIZE them.
• Created automate scripts for DB2 utilities like LOAD/IMPORT/EXPORT/DB2MOVE and RUNSTATS/REORG
• Fine tuned Database Manager and Database configuration parameters to improve performance.
• Managed database storage and capacity planning on DPF and Non-DPF databases.
• Created and modified T-SQL stored procedures and developed detailed programming logic and coding changes.
• Maintained and improved existing ETL solutions from IBM DB2 to SQL Server.
• Conducted Disaster Recovery Tests during BCP and documented shortcomings to improve the process.
• Developed and documented current and new objects, including jobs, tables, views, partitions, indexes, constraints, stored procedures, functions, SSIS packages, etc.
• Analyzed query plans, index usage and locks. Troubleshoot query performance and server bottle necks including Network Traffic, Hardware usage and Blocking.

Confidential

Database Administrator

Responsibilities:

• Database Design, Implementation, Troubleshooting and other database Administration services for DB2 UDB V7/8/9.
• Provided support to various Middleware Applications like WebSphere Application Server (WAS), Vignette and Oracle Portal in Production, Test and Development Environments.
• Performed database maintenance activities such as BACKUP, REORG and RUNSTATS.
• Installed & configured DB2 UDB new releases, upgrades & patches
• Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases.
• Analyzed DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.
• Set up HADR for databases for Disaster Recovery.
• Proactively monitored performance, diagnosed problems and tuned queries and database.
• Created and maintained documentation such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships documents for all the internal projects.
• Developed, tested and implemented backup recovery strategy using log shipping and HADR.
• Developed new processes, utilized and refined existing processes for database software installation and configuration.
• Assisted developers and architects with application, logical & physical database design, create and maintain logical entity relationship diagrams, transform logical models into physical data models.
• Provided 24X7 on-call support to troubleshoot issues with the Production schedule.

Confidential

Database Administrator

Responsibilities:

• Migrated UDB V8.1 databases from p690 to new p595, AIX V5.3, machines.
• Provided onsite support for all database administration work that has been handed over to offshore team.
• Performed database software installations, created/configured databases.
• Performed Database Backup/Recovery including ‘Redirected’ Restore.
• Used tools like db2advise, db2look, db2move and db2adutl to monitor, analyzed and made changes in the database.
• Implemented a library of homegrown scripts to automate the scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
• Served as primary contact between the application teams and IT support groups (DBA, Middleware, Application Change Control, etc.)
• Monitored DB2 UDB processes and logs for any anomalies and provided corrective actions.
• Provided assistance to the development team on performance tuning, resolving locking solutions, assist data modeler with SQL scripts.
• 24X7 on-call support and problem resolution.