OBJECTIVE:

Architecting and administering Relational Database Management System projects including DB2 Universal Database Enterprise Server Edition on client/server distributed platforms. As well as managing high transactional DB2 databases.

SUMMARY:

• Self - motivated and goal-oriented IT professional with years of experience administering DB2 Universal Database from version 5 through version 10.5
• Accustomed to working in cross-functional teams and on own initiative in a variety of disciplines
• Superior record of delivering simultaneous large-scale, mission-critical projects on time and under budget.
• Strong analytical and problem solving skill with extensive performance tuning experience
• Proven ability to direct complex, high-profile projects requiring coordination of multiple resources.
• Experience managing large scale DB2 deployments
• Excellent motivator with the aptitude for assessing corporate needs and delivering programs that meet goals and remain in budgetary guidelines
• A pleasant team player with excellent interpersonal and communication skills
• Has a strong aptitude for learning new technologies and propensity to share acquired knowledge with team members. Working knowledge and understanding of ITIL principles
• Excellent verbal and written skills
• Scripting experience using shell and Korn scripts
• Competent with converting logical data models into high performance physical designs.
• Experience with stored procedures, triggers and UDF
• Database monitoring and tuning experience using DB2's Performance Monitor, Snapshot, Event Monitor, DB2TOP,Explain,Data Studio, Design Advisor performance tools and various operating system performance monitoring tools.
• Database maintenance experience with Reorg, Runstats, Rebind, Export, Import, Load, DB2MOVE, Backup and restore utilities and data replication between Oracle and DB2 using GoldenGate
• High availability (HA) experience implementing HADR, Veritas Cluster Systems and PowerHa technologies, SQL Replication and Q-replication and DB2 PureScale
• Demonstrated experience with enterprise backup and recovery strategies.
• Strong experience with performance tuning of DB2 databases and SQL
• Problem identification, management and resolution experience with DB2 diagnostics, trace facilities, INSPECT tool and DB2 problem determination tool (db2pd) and Administration Views
• Experience: (6 years HADR) (3 years QREP at Blue Cross and Dicks Sporting Goods).
• Solid experience working with DB2 internal architecture
• Server installation, silent installation, configuration and upgrade experience on single processor, symmetrical multi-processing, silent installation, configuration, and upgrade experience on single processor, symmetrical multi-processing(SMP),massively parallel processor (MPP), with enterprise storage area networks (SAN)/DAST
• Client/server communications experience using TCP/IP, IPX/SPX, and Fast Communications Manager over System Area Networks with TCP/IP
• Client installation, configuration, migration and upgrade experience at various code and fixpack levels from DB2 V5.x to DB2 V10.5 on AIX and LINUX platforms at 64-bit levels
• Instance and database creation, configuration and tuning experience in single node non-partitioned (EE) and multiple node partitioned (EEE/ESE DPF) servers configurations, Federated database

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

DB2 Database Administrator

Responsibilities:

• Setup a combination of Q-replication and HADR technologies to facilitate DB2 version upgrade in an environment where database downtime is not an option.
• Relocate live databases across multiple hosts
• Build and Support databases in multi-HADR environments
• Support Greenplum databases
• Setup DB2 clients and DSdriver configurations to facilitate connectivity to databases in HADR environments.
• Troubleshoot database errors identified and reported by application developers as well as database related errors alerted by custom scripts developed by DB2 team.
• Perform DB2 client and Server installations and upgrades from v10.1 to v10.5 on AIX, Linux and Solaris
• Support application developers by creating schemas, reviewing and approving SQLDs, partitioning tables, granting privileges, import/export large amount of data, backup and restore tablespaces and databases and performance tuning
• Developed a comprehensive script to monitor and terminate any Netbackup initiated backup process that run during business hours. The script was deployed using Jira.
• Part of DB2 team on-call rotation to provide 24x7 support for DB2 and Greenplum databases

Confidential, Coraopolis, PA

Senior Systems Engineer

Responsibilities:

• Sole DB2 DBA responsible for building and supporting database infrastructure to support Confidential ’s Sporting Goods rapidly growing e-Commerce environment.
• Work with System Administrator to provision hardware and storage requirements to support database
• Provide technical direction and recommendations in terms of the overall DB2/LINUX/ UNIX architecture
• Work closely with WebSphere commerce developers to build Development, Quality Assurance, User Acceptance Testing and Production environments to support code promotion from lower to higher environments
• Installed DB2 V9.7 and migrated to v10.5. Created DB2 instances and worked with developers to deploy WebSphere Commerce databases.
• Configured DB2/Open LDAP authentication and database authorizations to manage and control data access and security
• Install and configure MySQL to support ETL and Customer Care applications
• Setup AppDynamics and Optim Performance Manager for application and database monitoring
• Hands-on experience with Hadoop administration
• Developed proactive performance monitoring, healthcheck and maintenance scripts to automate online backup/reorg/runstats
• Provide ongoing tuning advice to developers and make database and database manager configuration changes to address performance constraints
• Analyze and provide timely solutions to application performance problems and SQL error messages
• Setup and implemented HADR to support continuous availability and disaster recovery requirements between two data centers for Websphere Commerce application
• Design, install and implemented DB2 PureScale to enhance continuous availability and scalability requirements
• Created and continue to update DB2 Team Standards and Procedure and Best Practices documentation

Confidential, Downers Grove, IL

Senior DB2 UDB DBA

Responsibilities:

• Was hired as the senior DB2 DBA to lead a newly formed database team to undertake a huge DB2 migration from EDS to Confidential
• Responsible for the migration that took one year and all new installations spanning a period of six years
• Lead a team of five DB2 DBAs with the documentation of operational procedures for database maintenance, failover and disaster recovery. Participate in disaster recovery drills
• Task included data modelling and design migration of 2.5T database from DB2 V8.1 TO V9.7 TO V10.1 fp2, performance tuning and trending using Foglight, setting up Veritas Netbackup for DB2 partitioned and non-partition database, using TDMF for database replication and migration, and setting up HADR with TSAM
• Installing and managing DB2 pureScale investigating and resolving database incompatibilities due to difference in customer environments, formulating a backup strategy to provide recoverability for different types of data loads and writing database standards for DB2 team use.
• Developed database health and proactive monitoring scripts.
• Assisted System administrators with the setup and configuration of Timefinder and Guardium auditing tool.
• Provide cross training for DB2/ZOS and DB2/UDB teams
• Responsible for providing trend analysis to management to help them make informed decisions regarding resource management and capacity planning.
• Lead team with the documentation of operational procedures for database maintenance, failover and disaster recovery.
• Work with application developers and other technical resources to support applications with requirements for high availability, high performance and high reliability.
• Applications include Service Oriented Architecture (SOA), Tivoli Directory Server (LDAP), WebSphere, Filenet/P8, IBM Tivoli Composite Application Manager (ITCAM), IBM License Metric Tool (ILMT) and home grown applications called Bill Review.
• Work with storage team to allocate and reclaim LUNS off EMC Clariion and EMC Symmetrix arrays for database hosts. Participate in weekly Enterprise Change meetings administered by Change Advisory Board (CAB) to review and approve emergency and expedited change tickets. Operational knowledge of BMC Remedy Incident and Change management tool. Administer databases with adherence to ITIL standards.

Confidential, Chicago, IL

Senior DB2 UDB DBA

Responsibilities:

• Provided database support for Security Automation application databases.
• Migrated a 1.8T partitioned data warehouse database from DB2 v7 to DB2 v9 and assisted data modelers and application developers to redesign the database and translate logical to physical design.
• The application was a combination of five databases consisting of LDAP database, ITIM database, WAS database, Role Based database and a reporting data warehouse database.
• The databases were clustered in an active-inactive failover configuration. Task included implementing Q-replication to update the reporting database, implementing Query Patroller to manage queries and track performance.
• Used Quest Central and monitoring scripts to monitor database performance. Performed database tuning and assisted application developers with their database schema changes. Performed reorgs, runstats, rebinds and data loads. The databases environment was categorized into production, development and test environments.
• Provided database support for Siebel HR databases. Task mainly involved database performance tuning, troubleshooting, reorg, runstats, data loads, imports and exports.
• Supported application developers with schema release changes and provided database support during change implementation at nights and weekends
• Provided database support for Content Manager Application.
• Worked closely with application developers to troubleshoot performance issues and tune database
• Created security and database audit documentation and assisted with the creation of team database administration standards and guide junior members with tasks like logical and physical design, installation, upgrades, disaster recovery testing, and migration and troubleshooting.
• Created Korn script to proactively monitor and report the health of team databases
• Supported database replication using HADR/QREP technologies
• Provide 24x7 on-call support

Confidential, Southbury, CT

Senior DB2 DBA

Responsibilities:

• Performed various DB2 Universal Database engagements as application and production DBA for IBM internal and commercial clients including pharmaceutical, financial, insurance and entertainment industries and also state and federal agencies
• Customer engagements typically involved in-depth analysis and review of DB2 Universal Database implementation including hardware, software, database, monitoring, tuning, recovery, maintenance, and data migration, in addition to onsite/offsite problem determination and support.
• Performed over 100 DB2 version to version migrations from v5 through version 8.2 fixpack 12 and performed data migration/porting from Sybase ASE 12.0 to DB2 V8.2 using DB2 migration tool. . Implemented data recovery solution by installing and configuring Data Replication software to propagate data from primary database servers to backup database servers at remote sites and implementation of HACMP technologies. Occasionally engaged in Oracle 8i and 9i support and Microsoft SQL server 2000 support for some customers. Provided support for SAP database.
• As a backup team lead, prepared best practice documentation and training module for my team to ensure adherence to security standards, reliable data availability practices and optimum database performance.
• Assisted in the training of newly hired and less experienced team members in both database and system administration functions.

Confidential

DB2 UDB DBA

Responsibilities:

• Implementation of data warehousing solution for Confidential . Customer was looking for a solution to provide capacity planning, performance trending and resource utilization for over 500 systems.
• This engagement involved requirement gathering from customer to facilitate logical and physical design to support projected data load.
• Task included Installation and configuration of DB2 v8 fixpack 11 client on Windows 2003, and DB2 ESE 64-bit on Linux Redhat and AIX 5.3 (P 630)
• Configuration of DB2 registry variables, database and database manager parameters, optimization of table spaces and buffer pools, performance tuning and database maintenance, utilizing online reorg and offline backup strategy using Tivoli storage manager. Data growth was over 2G per day.

Confidential

DB2 UDB DBA

Responsibilities:

• Provided DB2 Universal Database architecture, installation and performance tuning support for various applications for Confidential
• The primary goal of this project was to architect and design a 2.2T database for storing data for software and hardware configurations for 50,000 endpoints in a Tivoli managed environment.
• Primary responsibilities included installing, configuring and tuning DB2 UDB v7.2 EEE database on large 8-way AIX Servers in a SAN environment. Database was later migrated to v8.1 Fixpack 12.
• Replication was implemented at a remote location. Maintenance and proactive monitoring scripts were deployed to manage database.

Confidential

DB2 UDB DBA

Responsibilities:

• Provided DB2 Universal Database consulting and training for Confidential insourcing project team in California
• The goal of this project was to provide the necessary mentoring, training, and hands-on experience for a newly created DB2 team to implement and support DB2 UDB on the Linux Redhat and Windows 2003 platforms.
• Primary responsibilities included knowledge transfer, assisting with documentation of operational standards to the infrastructure team in the areas of performance, security, recovery, and high availability

Confidential, Harrisburg

Responsibilities:

• Provided DB2 Universal Database consulting and training support for Tivoli Enterprise Console (TEC) and Data warehouse team at Confidential, Harrisburg.
• The goal of this project was to architect and implement a large scale DB2 database solution for enterprise monitoring application and to facilitate robust data reporting.
• Primary responsibilities included logical and physical database design and implementation of DB2 V8.2. Configuration of Tivoli Storage Manager backup client and installation and administration of Crystal Report tool.

Confidential

DB2 UDB DBA

Responsibilities:

• Provided database support for Confidential - IBM DB2 database insourcing project
• Achieved 80% performance improvement by working with Application developers to identify application bottlenecks and addressing them
• Reconfigured backup configuration parameters and drastically reduced online backup completion time from 14 hours to 2hrs