SUMMARY:

• Database Administrator with 18+ years of experience in the IT industry and with over 12 years as a Sr.DB2 UDB Database Administrator.
• Lead DBA for supporting multiple database environments and applications in production, test and development servers.
• Served as a technical expert in DB2 technologies (Data Partitioning - DPF/HADR/Q-Replication/Federation) working collaboratively across functional and development teams.
• Technical Lead DBA for Payroll, Merchandising Accounts Payable application from support in DEV/QA to UAT testing and production implementation.
• Extensive experience in Enterprise Data Warehousing, ETL, data mart and data cube solutions.
• Extensive experience in Database migration and upgrades to DB2 11 from 9.7 and 10.5 systems.
• Extensive experience installing, configuring, back-up, recovery, trouble shooting, performance tuning, capacity planning, upgrading, testing, implementation, migration and maintenance of databases on AIX, UNIX, Linux and Windows environment.
• Technical Lead for designing and tuning database system resources for optimal performance and identifying and implementing performance enhancements.
• Extensive expertise in capacity planning, availability strategies, data management, backup, recovery procedures, database migration issues and implementation.
• Expert level database performance and SQL tuning skills in a complex enterprise environment.
• Good understanding of incident and change management principles and best practices.
• Extensive experience in understanding and following the change management process to implement or deploy the new changes in Production, UAT environments.
• Responsible for designing global db2 security model confirming to business regulations and creation of roles and granting necessary privileges for users and groups.
• Ensured database design and data processing comply with policies, standards, principles and meets established Service Level Agreements (SLA)/goals for business needs.
• Installed and implemented databases, migrated/upgraded database as necessary.
• Mentored and trained other DBA’s and developers on DB2 functionalities.
• Acted as a liaison between multiple teams providing database, application support and training.
• Provided 24x7 production rotational on-call support, off-hour deployments and maintenance.
• Excellent verbal, written and business communication skills.
• Flexible, adaptable and able to manage multiple tasks in a dynamic environment.

TECHNICAL SKILLS:

Databases Administration: DB2 UDB 11, 10.x, 9.x, 8.x

Oracle 10g, 8.1, SQL Server, Mongo DB, Postgress: AppServer/App Tier Administration

WebSphere 7.x, 6.x,5.x: IIS, Confidential HTTP Server, MQ

Reporting Tools Administration: Crystal Reports, Business Objects, DataStage 11, 9.x

Programming: Unix Shell scripting, Perl, Java, Data Studio -Stored Procedures, Cobol, C, C++

DBTools: OPTIM, DBArtisan, BMC Patrol, DBI Panther, DBI Eagle, ERWin, Data Studio, Toad

Applications & Packages: ITIM, Manugistics, Lawson, Versata, ODS, WTD, POCC, Workbrain, InfoSphere, Oracle ERP Foot prints, HP Service manager(Change/incident management package)

WORK EXPERIENCE:

Confidential, Burbank, CA

Sr. DB2 Database Administrator

Responsibilities:

• Responsible for managing multiple large DB2 database systems in Production environment supporting Payroll, Insurance, BI and Datamart applications.
• Supported DB2 database in DEV/QA/UAT and Production evironments.
• Implemented Database Federation between multiple data sources, Warehouse with DPF, High Availability (HADR) and Q-Replication solutions based on business needs.
• Upgraded databases to DB2 11 from older versions like 9.7 and 10.5
• Performed database migration during data center move for all DB2 databases to new systems.
• Performed routine maintenance BACKUPs, Restore, REORG, RUNSTATS for all databases.
• Designed and Implemented automation jobs for maintenance and monitoring tasks by scheduling weekly, daily and hourly jobs through crontabs and third party scheduling software.
• Applied fixpacks routinely and configured DB2 UDB on Unix/Linux and Windows environment.
• Responsible for implementing database and application changes, upgrades and deployments.
• Performed routine database maintenance tasks with respect to capacity planning and database performance.
• Experienced with performance monitoring and tuning with event-monitors, snapshots, db2top, db2pd, Optim performance manager tools.
• Monitored long running SQLs on a routine basis and performed query tuning to improve overall performance.
• Monitored database performance with respect to Memory, CPU Utilization and IO bottlenecks for multiple workloads and performed database tuning to handle growing requirements.
• Expert level database and SQL tuning skills with hands on experience in dynamic environments.
• Performed root cause analysis on DB2 databases, application and system related problems.
• Resolved complex production problems and provided 24x7 production on call support on a rotating basis.
• Scheduled automated jobs for data moves, ETL between production and test environments.
• Deployed and administered Datastage ETL jobs in production environment.
• Followed incident and change management principles and best practices.
• Participated in release and change management meetings and database SCRUM meetings.
• Performed system administration tasks for managing storage (LVM, Veritas), users, filesystems.
• Developed and tested Disaster Recovery procedures including VMWare level snapshots and routine offsite system recovery exercise.
• Installed and supported SAS application on cloud hosting for ETL processing of Payroll data

Confidential, Framingham, MA

Sr. DB2 Database Specialist

Responsibilities:

• Responsible for administration of multiple large DB2 database systems in Production environment supporting complex financial, retail, purchasing, stores management, workforce management, ETL applications.
• Installed and administered DB2 database and WebSphere servers hosting all of the above mentioned applications.
• Implemented Database Federation between multiple data sources, High Availability solutions (HADR) and Q-Replication solutions based on business needs.
• Applied fix packs routinely and configured DB2 UDB and WebSphere on AIX.
• Responsible for implementing complex database and application changes, upgrades and deployments.
• Performed routine database maintenance tasks with respect to capacity planning and database performance.
• Experienced with performance monitoring and tuning with event-monitors, snapshots, db2top, db2pd, DBArtisan, BMC tools and DBI tools.
• Performed root cause analysis on DB2, WebSphere application and system related problems.
• Provided 24x7 production on call support on a rotating basis.
• Managed SLAs for uptime by establishing maintenance window for routine software/hardware upgrades and database maintenance.
• Responsible for Crystal reports administration, ETL, data cube build for facilitating various reports generation for business needs.
• Scheduled automated jobs for data moves between production and test environments and also datafeeds from mainframe databases and datafeeds to netezza data warehouses.
• Participated in CAB and transition meetings for business impact analysis and approval of application and database changes into production environments.
• Provided SOX Audit reports on a routine basis to auditors for SOX compliance.
• Maintained and supported ITIM, Manugistics, Lawson, Versata, ODS, WTD, POCC, Workbrain, applications.

Confidential

Database Administrator/Software Developer

Responsibilities:

• Worked on customer benchmarks for pre-sales opportunities for Confidential along with partners like i2, Siebel, Ariba and SAP.
• Responsible for implementation, database administration, performance tuning, database migration and documentation.
• Technical Lead for benchmarking activity of various products of i2 technology - identified, recommended, implemented performance enhancements, designed and tuned database system resources for optimal performance.
• Extensive experience in installing and administering DB2 and WebSphere products.
• Performed query tuning, memory and I/O performance tuning.
• Managed DB2 Codepath optimization (pathlength) performance work for db2 v8 and v7.
• Codepath optimization has a direct influence in CPU utilization of DB2 processes, and optimizing codepath improves database performance.
• Developed a toolkit to automate the process of pathlength performance testing and another tool to analyze data produced.