PROFESSIONAL SUMMARY

• Fifteen years of experience as DB2 database administrator and development.
• Strong academic background, Master Network Security Management 3.7 GPA.
• ITIL, IT Service Management training and certification.
• Extensive experience: DB2 UDB V7.x, V8.x, V9.x, MSSQL Server 2000, 2005.
• Experience includes UNIX, AIX, Sun Solaris, Linux, Windows and MVS operating systems.
• Expertise in setting up High Availability and Disaster Recovery HADR and Q Replication.
• Provided 7/24 oncall production support for mission critical databases.
• Expertise in applying fix packs, migrating databases from previous versions to latest versions and also migrating databases across platforms and data centers.
• Strong database modeling skills using tools like Erwin and be able to work closely with the application teams to resolve the technical issues
• Supporting and resolving technical issues with DB2 UDB for LUW databases. Tuning poorly written SQL statements, creating indexes to improve the query performance
• Expertise in using database utilities like IMPORT/EXPORT/LOAD , db2move, db2look, db2pd, db2mtrk, db2support, db2exfmt, REBIND, REORGCHK, REORG, RUNSTATS.
• Experience in working with teams distributed across different, remote locations.
• Strong troubleshooting, problem solving and analytical skills.
• Excellent communications and interpersonal skills.
• Strong leadership and team building skills.

Confidential

Responsibilities:

• Migrated instance and databases to latest releases and applying fix packs as available.
• I managed and maintained the db2 road map, list of all db2 versions and their support end dates. I recommended and coordinated with customers to perform fixpacks upgrades and versions migration to be compliant with IBM support and have current security patches. Upgraded from V9.1 and V9.5 to V9.7.
• Provided development and support for mission critical application like pricing and trading. I designed the table spaces, bufferpools, created tables, indexes and triggers. I configured dbm and db cfg parameters, setup and test HADR. Also I setup the db maintenance jobs like: backup, reorg check and runstats. As application dba I supported quarterly releases, worked with the developer's team to implement their changes of the databases objects.
• Installation, administration and troubleshooting HADR and Q Replication Peer to Peer.
• Managed and resolved design issues during development stage and worked closely with developers.
• Versed in using project and change management tools such Service Now - used to manage and coordinate change, incident and requests assigned to the dba team huddle boards and other CI tools for project management
• I've been providing guidance and created high level steps for tasks assigned to offshore team for different projects.
• As part of CI Continuous Improvement I've created standard documentation for database design, upgrades, migration processes.
• Performed database tuning, performance analysis and monitoring using Quest, Explain Plan, Foglight, db2top, db2advis, db2pd.
• Review and tune SQL code, Stored Procedures and migrate when required.
• Create databases and manage database objects tables, views, indexes, stored procedures including tablespaces, bufferpools.
• Configured ODBC connection to databases and catalog dbs on db2 clients.
• Performed redirected restore from production databases to non production databases as per the request from application development teams.
• Use db2 utilities such as db2move, export, import, load, reorg, runstats, db2rbind for data movement and synchronization purpose.
• Experienced in maintaining database permissions, groups creation, ID remediation.
• Maintained schema level security in compliance with ING Security Standards.

Confidential

Responsibilities:

• Opened PMR with IBM and troubleshoot databases crashes.
• Provided customer support for issues with connection and permissions.
• Completed redirect restores, backups, exports and imports.
• Performed dbm, db and Linux kernel parameters tuning and configuration.
• Used command line, Toad, Quest and DB2 GUI tools to do monitoring, configuration and performance tuning.
• Setup and maintain HADR.
• Setup, configured and monitor Q Replication peer to peer.
• Performed db2 code development as part of quarterly releases.
• Supported and performed databases migration from AIX V8 FP12 to Linux V9.5.
• Utilize incident and change management

Confidential

Responsibilities:

• Provided support for databases DB2 UDB V8 and V9 on AIX.
• Performed HADR analysis, setup, configuration findings and recommendations for Warehouse Specialists Inc company.
• Tested HADR and application failover using ACR, automatic client reroute, created testing plans and recorded lessons learned for improvement

Confidential

Responsibilities:

• Migrated from DB2 UDB V8.2 on AIX to DB2 UDB V9.1 FP1 WII FP1 and FP3a and FP5.
• Installed and configured of DB2 UDB V8.x and V9.x and related FixPaks and Special Builds.
• Perform tuning I/O and memory, analyzing access plans, modifying SQL, stored procedures and provide support for application developers.
• 24/7 Production environment Monitoring, Diagnosing and Trouble shooting.
• Support over 600 instances with DB2 UDB ESE V8.x and V9.x on AIX, Solaris, Linux and zLinux.
• Created, documented, tested and install DB2 UDB V8 FP 14.
• Participated in interviewing candidates for team roles, training the new hires and being a mentor.

Confidential

Responsibilities include data modeling, logical database design, physical database design/development, and database system configuration and administration, DB2 UDB performance tuning:

• Server installation, configuration, and upgrade experience.
• Create and configure new instances and databases.
• Database backup, restore, and roll-forward recovery experience using advanced recovery techniques.
• Database maintenance experience with Reorg, Runstats, Rebind, Export, Import, Load, Backup and Restore utilities.
• Maintain database objects: create, alter, and drop tables, views and indexes.
• Database monitoring and tuning experience using DB2's Performance Monitor, Snapshot Monitor, Event Monitor, Explain, Visual Explain, and Index Advisor performance tools.
• Tune db and dbm configuration parameters and maintain logs.
• Work with developers to identify and resolve integrity problems.
• Apply and log native DB2 security.
• Problem identification, management, and resolution experience with DB2 diagnostics, trace facilities, database analysis reporting tool DART and DB2Inspect .
• Provide technical support and explain DBS procedures and policy to members of other groups as required.
• Primary support for off-hours production work.
• Enforce naming, documentation standards for database objects.

Microsoft SQL Server Responsabilities:

• Working in a Microsoft SQL Server 2000 standalone and clustered environment designed for high-availability, redundancy and fail-over.
• Installation of SQL Server, SQL Security patches and Service Packs.
• Respond to database requests, typically related to user connections, data sources, and query construction.
• Respond to problems on the SQL applications like: performance, abnormal behavior of the application and investigate causes for any issues using SQL Profiler.
• Check the scheduled jobs and backups output and correct errors.
• Complete SQL Server object maintenance like create, alter or drop database objects.
• Complete SQL Server System Access requests.
• Perform on-request backups and restores.
• Create databases and configure them.
• Create and schedule jobs.
• Perform SQL Server applications upgrades.
• Documentation of procedures and troubleshooting guides.

Confidential

Responsibilities:

• Provide support for IBM Financial Information Warehouse Corporate, an application that provides a common, integrated tool for measurement, business reporting and analysis.
• Design, modify, and create DB2 objects to comply with customer's business requirements.
• Improve application performance through DB2/production scheduling.
• Code dynamic and static SQL embedded in C and PL/1 programs.
• Provide 24-hour on-call support.
• Maintain a positive working relationship with customers.
• Complete extensive DB2 educational roadmap.
• Provide support in installation, implementation and testing, using HTML and VisualAge for Java, for IBM internal web sites.
• Advise and guide users regarding function and performance of HTML.
• Attended, one month, training program focused on e-business application development: design, data modeling, configure, test and package an integrated solution using VisualAge for Java.