SUMMARY

• Over 7 years of IT experience with emphasis on Database Administration, development, migration, Business Requirements Analysis, Application design, testing, implementation and maintenance of databases on DB2 UDB EE, DB2 UDB EEE and DB2 UDB ESE with DPF on LINUX, UNIX and Windows Platforms
• 7+ years of rich experience in Database Administration using DB2 UDB and with strong business knowledge of Financial, Insurance and Manufacturing projects
• Worked through all phases of system development life cycle and has performed as a senior DB2 UDB DBA
• Expertise in development support activities including installation, configuration and successful deployment of changes across all environments
• Migrating DB2 UDB databases and applying fix packs to keep DB2 at most recent level
• Provided production support for critical applications running on 24/7 basis
• Experience in implementing Backup and Recovery strategies, Q - Replication and developing Architecture for building a database by using tools like Erwin and writing necessary Shell scripts
• Running utilities like LOAD, COPY, IMPORT, EXPORT, REORG, RUNSTATS, REBIND
• Worked with third party tools like TSM, BMC Patrol, VERITAS Net backup, Remedy, and Toad.
• Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning
• Extensive DB2 DBA and DB2 Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications.
• Experienced in setting up backup policies and retention policies using Tivoli Storage Manager and Veritas net backup and do the alignment from db2 databases, Test and schedule and report any failures and apply upgrades and maintain raise PMR with IBM for any unknown issues.
• Wrote Several Complex Stored Procedures, Functions and worked on performance tuning and wrote Perl, korn shell, Jmeter scripts for stress test.
• Familiarity and experience with data warehousing and DB2 Pure scale, Data center Replication Symmetrix Replication Data Facility (SRDF).
• 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
• We discovered that DB2 Health Monitor was causing heavy locking and slow connection times in our heavy transaction volume application. Every two hours, when DB2HMON would fire, it would drag the entire system down. We solved the problem by deactivating Health Monitor.

TECHNICAL SKILLS

Operating Systems: Linux (Redhat, SuSe), AIX 5L/V6.1/ V7.1, SUN Solaris 5.10/5.11, HP/UX and Windows 2007/NT/XP.

Hardware: IBM and SUN machines

Environment: DB2 V9.1, DB2 V9.5/V9.7 and DB2 V10.1, Oracle 11g, SQL Server 2000, IBM Informix

Tools: Quest Central, BMC Patrol, JS Console, DB Artisan, Control Center, Foglight and Visual Explain.

Computer languages: Perl, PL/SQL, C, C++, SQL, .Net, Vb.Net, PHP

Software Packages: Lotus Notes, MS Office XP, MS Visio, Rational Rose

Shell Scripting: KSH, Bash, Perl and C shell

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

DB2 UDB LUW DBA

Responsibilities:

• Involved in Design and development of logical and physical layers of databases.
• Installation and configuration. Of different versions of 10.x/9.x DB2 UDB on AIX 5.x.
• Worked on HADR setup with Tivoli System Automation (TSA).
• Created database and managed various database objects like indexes, tables and Tablespaces.
• Collected the database statistics using RUNSTAT, REORG, REORGCHK utilities and involved in analyzing the statistics
• Created scripts for backup, recovery and roll forward for the databases on weekly bases
• Used Import, Export and Load utilities in accordance with db2move command to populate large amount of data like databases.
• Designed and implemented back-up, recovery, archiving, and conversion strategies.
• Responsible for Database performance tuning analysis.
• Responsible for backup and logging/recovery policy.
• Developed database security strategy to provide access to large number of users in production environment.
• Install, configure and test new LDAP DB2 plug-in; work with Security Analysts to develop new DB2 security policy24X7 on-call support and problem resolution.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and the physical database.
• Responsible for monitoring database and perform tuning when necessary.

ENVIRONMENT: DB2 V10.x/9.x, AIX 5.x, DBArtisan, Visual Explain, BMC Patrol, IBM Performance Expert, windows NT/XP, Server, Erwin, SAN.

Confidential, California

DB2 DBA

Responsibilities:

• Efficiently carried out backup and recovery processes including Redirected Restore.
• Worked on configuring and maintaining the High Availability Disaster Recovery (HADR) feature.
• Worked closely with the RUNSTAT, REORG and REORGCHK utilities, created the Reorg script to reorg tables that has high fragmentation ratio in the REORGCHK report.
• Proven Linux/UNIX experience, including shell scripting.
• Broad knowledge in the development and tuning of SQL.
• Proactively monitored large-scale production DB2 LUW database subsystems to avoid unscheduled outages.
• Supported the product development and test teams through the SDLC process.
• Produce technical documentation.
• Responsible for upgrading DB2 from V8 to V9. x.
• Installed Sybase on UNIX Systems and applied required patches by monitoring new patch releases
• Created Sybase user logins with appropriate roles, unlocked the logins, and monitored the user accounts.
• Checked for Sybase database consistency, fixing DBCC errors, monitoring of error logs regularly
• Provided exceptional technical expertise in supporting large-scale 24x7 operational production subsystems including maintenance, tuning,performance analysis, capacity and availability planning, resource utilization, utilities,security and troubleshooting.

ENVIRONMENT: DB2 UDB V9.x/V10, Sybase 11, AIX 5.3 64 bit, DB2 Development Center, WebSphere 5.x/6.x, and Erwin.

Confidential

DB2 DBA

Responsibilities:

• Perform database maintenance activities such as backup, reorg, runstats.
• Install and configure DB2 UDB new releases, upgrades, and patches.
• Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases.
• Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.
• Responsible for proactively monitoring performance, diagnosing problems and tuning queries and databases.
• Assisting with the creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes)
• Implemented data security guidelines while making data available to those authorized to have access.
• Create and maintain documentation such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships documents for all the internal projects.
• Interface with business analysts & developers with regards to application, logical & physical database design, create and maintain logical entity relationship diagrams, transform logical models into physical data models.
• Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
• Provide 24X7 on-call support to troubleshoot issues with the Production schedule.

ENVIRONMENT: IBM and SUN machines, AIX 5.2 and 5.3, Windows NT/XP, DB2 V8.2, DB2 V9.1, Foglight and Quest Central.