SUMMARY

• 7 years of IT experience with database administration in all phases of software development lifecycle, i.e. development, analysis, design, testing and implementation for various kinds of applications.
• Worked as aDB2 UDB V8.x,9.7, 10.1Database Administrator on UNIX, LINUX, Windows and Z/OS platforms with expertise in online transaction processing and multi - user systems, involving large and distributed databases.
• Extensive experience with installation, configuration, upgrade, and troubleshooting DB2 databases.
• Experience withDB2Work Load Management (WLM), Q-Replication and DB2Pure Scale.
• Implemented and captured table level audit information.
• Implemented SSL and data encryption based on AES256 mode.
• Migrated DB2 UDB databases from old to newer versions and applied FIXPACKS to keep DB2 Confidential most recent level.
• Implemented DB2/UDB replication, federation, and partitioning (DPF).
• Experienced in OLTP and OLAP database environments, which included Single Partitioned and Multi-Partitioned Databases (DPF).
• Skilled in database administration tasks, including SQL coding, relational design, referential integrity, index strategies, and SQL troubleshooting, using DB2 UDB.
• Performed AUDIT on the Databases to give users bare minimum privileges on the Database and Database objects.
• Experienced in handling DB2 UDB security, establishing Replication between servers, Capacity Planning, Backup and Restore, Shipping archival logs, Corruption and Recovery, managing login/permissions.
• Implemented DB2 RCAC masking rules on high profile columns.
• Implemented Q-replication method to sync data from OLTP to Data Warehousing environment.

TECHNICAL SKILLS

Databases: DB2 UDB V 8.x, 9.x, 10.1, Oracle 10g, SQL server.

Data Tools: IBM Data studio 2.x, Quest Foglight 4.x, 5.x, Spotlight, db2pd, db2haicu, db2top, SQL Loader, EMC NetWorker, IBM TSM, DB2 Connect, BMC Change Manager, SQL Optimizer, Optim Performance Manager, Tivoli System Automation for Multi-platforms (TSAMP), Erwin Data Modeler, OEM, NMON, Topas, SFTP and SSH.

Operating System: AIX 6.x,5.x/4, DB2 on Z/OS, Redhat Linux 4.x, 5.x, Solaris 2.8/2.7/2.6, Windows Server 2008, NT 4.0, HP-UX10.2/11.0.

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

Schedulers: Cron, Autosys, Windows Scheduler.

ETL Tool: DataStage v8.5.

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

Sr. DB2 DBA

Responsibilities:

• Responsible for installations for DB2 ESE on AIX/Linux environment and migration of DB2 UDB version 9.1 to DB2 UDB V9.5, V9.7, V10 and V11.1.
• Implemented HACMP Strategy and High Availability Disaster Recovery, Federation, Performance monitoring and fine tuning OLTP and DSS Applications, and Problem determination and troubleshooting,
• Interacted with UNIX and Application group, and playing a diverse role with a large team of DBAs.
• Implemented Q-Replication method to sync data from OLTP to Data Warehousing environment.
• Implemented LDAP authentication from TAM (Tivoli Access Management) to DB2 LUW.
• Implemented Backup/Recovery of databases both manually and using scripting.
• Documented plans and procedures in terms of backups, restores and disaster recovery.
• Created large table spaces, using Automatic Storage Management.
• Installations, In-place and Side-by-Side Migrations of DB2 ESE and DPF databases.
• Used Erwin data modeling tool for designing logical and physical data model.
• Monitored and tuned database software after installation and applied fix packs for peak performance.
• Implementing capacity planning and partition table/index for very large and fast growing tables
• Mentored customers on managing complex environment, database performance tuning through database physical design, configurations and implementations of data aggregations, MQTs, partitioning, indexing and related settings.
• Performed database objects creation and alteration (tables, indexes, views, stored procedures, functions).
• Improved performance by 35% by converting table spaces to multiple partitions with DPF.
• Responsible for query performance optimization, tuning implementations, and production support.
• Established standards, controls, and procedures to ensure data integrity and security.
• Established effective security processes plans and policies, like SOX.
• Implemented database auditing with the help of db2audit tool.
• Implemented security administration tasks, such as identification and authentication controls.
• Performed version migrations from V9.7 and V10.1.
• Provided recommendations for ongoing tuning of environment based on growth projections.
• Monitored tasks with respect to database performance on packaged applications.
• Escalated performance exceptions and worked with the application.
• Supported team to improve package performance.

Environment: IBM DB2 V9.5, 9.7, 10.1, 11.1 DPF,AIX 6.1, TOAD, OPM, Erwin, LDAP, TSM, Q-Replication, DataStage, Cisco Storage Manager, Flash Copy Manager.

Confidential, Plymouth, MN

Sr. DB2 DBA

Responsibilities:

• Worked as a DB2 Database Administrator in setting up the HADR environment on the DB2 Workgroup Servers.
• Highly involved in the project capacity planning and gathering prerequisites for the project.
• Applied Fix-packs to the most recent level of the DB2 version.
• Worked with instance and database configuration parameters to automate tasks, such as logging, memory management and database storage.
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery.
• Generated and implemented DDL for several projects from the logical model, using Erwin Data modeling.
• Worked with the Operations DBA’s assisting them with the issues related to the production.
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to incorporate the new functionalities.
• Develop backup and recovery solutions for databases especially very large databases.
• Setup HADR between primary and secondary servers to ensure High Availability, using db2haicu and TSAMP.
• Suggested Backup policies as per the requirement (offline/online; incremental/delta) and implemented the same and tuned the parameters accordingly.
• Worked with various Data Movement Utilities, like Load, Import, Export, db2move, Replication for timely movement of data.
• Managed database storage and capacity planning on DPF and Non-DPF databases.
• Create Views, Constraints and Triggers to implement business rules in SQL Server Using SSMS.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers in SQL Server.
• Extensively used triggers, transaction in stored procedures which involves complex joins and Sub-Queries to simplify complex queries involving multiple tables.
• Provided support on replicating data, using Q-Replication.
• Performed Scheduled maintenance on the databases, such as regorg and runstats in purging the older logs and backup images.
• Created and maintained 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.
• 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 V10.5, 9.7,MSSQLServer 2008R2,RedHat 5.4, Windows 7, IBM Data Studio, IBM Optim Performance Manager, BMC Change Manager, GSM, ITSM tool, BMC Remedy.

Confidential, McLean, VA

DB2 LUW Database Administrator

Responsibilities:

• Installed, configured and upgraded DB2 server software and related products.
• Administer DB2 subsystems in Production, UAT, SIT and Development for both DPF and non-DPF environments
• Troubleshot day-to-day problems encountered on production, development and test database environment.
• Designed, implemented and administered DB2 UDB for development, test and production environments.
• Migrated Development (DEV), Test (UAT) and production (PROD) databases from DB2 9.5 FP 5 to DB2 9.7 FP 4.
• Maintained, implemented, tuned and upgradedDB2Databases (Z/OSData Sharing Environment) in SAP environment.
• Tested to optimize the procedures and triggers to be used in production for SQL server.
• Experience in database performance tuning andSQLQuery Tuning and Optimization.
• Worked as adeveloperin creating complex stored procedures, triggers, and user defined functions
• Developed and implemented standards to create databases and various database objects.
• Managed database loading, migrating and maintaining data with LOAD, EXPORT and IMPORT DB2LOOK.
• Put AutoSys job scheduling daily based for Backup, reverse engineering, size of tablespaces, snapshot and runstats scripts.
• Took online and offline backups, as well as wrote shell scripts and scheduled them.
• Requested space for file system and raw-devices to UNIX group.
• Wrote shell scripts in UNIX (AIX/Solaris/HP) with a good understanding of UNIX servers and architecture.
• Cataloged multiple instances and configured connectivity to databases from remote clients.
• Tuned Database Manager Configuration parameters as needed.
• Bound the server DB2 utilities to the databases.
• Requested TSM management class from the TSM administrator and configure ddatabase parameters to use TSM management class.
• Tuned DBM configuration parameters and DB cfg parameters.
• Dropped and added users, logins, aliases, and groups to the databases and granted/revoked permissions on database objects.
• Installed DB2 10.1 AESE on sandbox and worked on prototype scenarios for replication.
• Extensively involved in Application Support, Design, User Administration, Security, Performance Tuning, Optimization and Backup/Recovery.
• Provided 24/7 on call support weekly.

Environment: IBM DB2 V 9.1, 9.5, 9.7, 10.1, MicrosoftSQLServer 2008 Enterprise edition, SQL server management studio (SSMS), SAP, AIX 5.x, 6.x, Foglight V4.2, 5.6, Toad, NetWorker, TSM, BMC Remedy.

Confidential, Alpharetta, GA

DB2 UDB DBA LUW

Responsibilities:

• Performed DB2 Database Administration on Linux, UNIX and Windows, including audit configuration, SQL Tuning, resource monitoring and performing security architecture review.
• Implemented a full-fledged development, QA, test and production DB2 UDB databases for PeopleSoft financials and portal databases.
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to incorporate the new functionalities. Migrated from V8.2 to V9.5.
• Suggested Backup plans as per the requirement (offline/online; incremental/delta) and implemented the same and tuned the parameters accordingly.
• Worked with instance and database configuration parameters to automate tasks, such as logging, memory management and database storage.
• Worked closely with developers to create database objects (tablespaces, schemas, tables, views, indexes) as per the requirement.
• Responsible for performance tuning through various schemes, such as increasing the buffer pool size, performing RUNSTATS, REORG, and REORGCHK’s, creating indexes, using db2explain and db2 advisor.
• Responsible for monitoring, database, Tablespaces and its objects through Snapshots and Health Monitors and worked with tools, like Quest Central.
• Created scripts to automate Backups, Runstats, increasing file systems, Reorgchk.
• Extensively used DB2TOP for monitoring databases both in Interactive and Batch modes.
• Provided security Confidential various levels, instance, database, objects and granted privileges and authorizations to users and groups respectively.
• Provided knowledge transfer to other DBA’s through sessions and presentations.
• Recovered the database to a consistent state through Restore, Roll-forward and Recover techniques and also performed Redirected restore in case of movement of tablespace containers.
• Worked with various Data Movement Utilities, like Load, Import, Export, db2move, Replication for timely movement of data.
• Used IBM Data Studio to execute tasks, edited data in tables; generated Interactive access plan diagrams for SQL scripts.

Environment: DB2 UDB V9.5, V9.1,AIX 5.2/5.3, Windows 2003/XP, Solaris DPROP, Erwin, BMC Patrol, Quest Central.

Confidential

Assistant System Engineer / DB2 UDB Developer

Responsibilities:

• Responsible for database administration and support.
• Provided database restore and disaster recovery.
• Performed logical and physical database design.
• Altered tables and added check constraints and referential integrity.
• Created and maintained databases, tablespaces, tables, views, and indexes.
• Interacted with business team and development teams for incorporating new functionality.
• Participated in enterprise-wide application and database production releases.
• Designed and implemented backup architecture viz., backup requirements, backup standards and retentions.
• Checked the consistency of the databases, using different DB2 commands.
• Data maintenance activities, like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT.
• Tuned application queries, databases and systems for best performance.
• Performed performance tuning and capacity planning, using the parameters of DBM configuration file and DB configuration file and various DB snapshots.

Environment: DB2 UDB V6.1/7.1, AIX, WIN NT, Java 1.2, JSDK 2.0, JDBC, JavaScript, Apache Web Server EJB (J2EE), XML.