SUMMARY
Senior Database Manager/Administrator responsible for information management, information engineering, and data warehouse architecture on DB2/UDB and Oracle databases. Planned and implemented database standards, standard operating procedures, and guidelines. Managed RDBMS installation, upgrade, and configuration. Implemented DB2/UDB replication, federation, and partitioning (DPF). Areas of expertise and accomplishment encompass: Database Installation/Upgrade, Data Analysis, Logical/Physical Design, Backup/Recovery, Critical Production Support, Data Security, Performance Tuning, Change Management, Capacity Planning, Disaster Recovery, Database Migration, Database Conversion, Data Warehouse, and Vendor Relations.

TECHNICAL SKILLS

Hardware: IBM, HP, Sun, Amdahl, Hitachi, Compaq, Sequent, OpenPower, BladeCenter, iSeries, Dell
Software: DBMS: DB2/UDB 8.2, 9.1, 9.5, 9.7 DB2 EEE, Oracle 8i, 9i, 10g, Sybase, SQLServer, IDMS, SQL/DS
Operating Systems: Solaris, AIX, Linux, Windows, OS/390, OS/400, VM, MVS
Storage: EMC/SRDF, Veritas
FrontEnds: PowerBuilder, Developer/2000, Visual Basic, VisualAge for Java
Web: IBM Websphere, Weblogic, iPlanet, Netscape, IlS, Vignette StoryServer
Security:Languages: Kerberos, ACF2, Siteminder, Entrust, C++, JavaScript, HTML, SQL, Perl
Network Protocols: TCP/IP, SPX/IPX, ODBC, DRDA, JDBC APPC, LU 6.2
Middleware: Shadowbase, Shadow Direct, Oracle Gateway, Neonet, MQSeries/MQSI, MDI Gateway
Case Tools: ADW, PowerDesigner, Erwin, Embarcadero, Rational Rose
ERP: Oracle Financials General Ledger, Peoplesoft Human Resources, J D Edwards General Ledger
System Management: Enterprise Manager, Patrol, Autosys, PVCS, NetDeploy, Remedy, Tivoli, Harvest, Oracle Enterprise Management, Jira, Optim
Data Warehouse / ETL: Informatica, Data Stage, Synopsis
OLAP: Cognos Impromptu, Powerplay, Crystal, Hyperion
Testing: LoadRunner, WinRunner, Test Director
Communications: Hummingbird, Reflections, Cisco VPN
Replication: SQL Replication, QREP, HADR

EMPLOYMENT HISTORY

Confidential, New York, NY 08/09 – Present
Senior DB2/UDB Database Administrator
Managed large, mission-critical databases. Interpreted business requirements and recommended solutions. Assisted with the physical design of financial databases. Created physical database design diagrams. Designed, created, implemented schema objects i.e., tables, indexes, constraints, stored procedures. Completed redesign of large tables to multi-dimensional cluster (MDC) and range partitioned tables. Migrated database changes across development, beta, and production environments. Installed, configured, and maintained DB2 LUW RDBMS server/client software and related DB2 administration tools. Worked with DB2 on Solaris, Linux, and AIX environments. Created, configured, and upgraded DB2 instances. Maintained and modified database manager and database configuration to improve performance. Partnered with Systems Programming and Storage/SAN staff on making recommendations for system level modifications related to DB2. Managed database storage allocation and storage capacity planning. Configured database servers for high availability/disaster recovery. Developed and implemented database security procedures and scripts to standardize database access privileges. Specifically, authorizations and privileges were based upon environment, database, schema, and access level.

Implemented performance management tool used to diagnose and resolve several production performance issues. Implemented performance management, reporting, and alert processing. Reviewed and analyzed SQL and database performance. Improved databases performance using DB2 performance tools and techniques. Monitored database growth and performance in all environments. Performed root cause analysis in collaboration with management, peers, developers, SAs, and other support groups to address production problems. Investigated and resolved production issues timely. Provided global 24 x 7on-call production support on a regular schedule. Performed problem determination and resolution for production break/fix problems. Supported SQL replication and build/rebuild HADR database environments. Researched, setup, tested, and managed database backup/restore procedures both intra and inter data center. Resolved complex backup/restore/recovery problems and identified innovative solutions. Implemented and documented database Netbackup procedures. Executed successful database high availability and disaster recovery failovers. Instrumental in the decommissioning of DB2 v8 release and migration to DB2 V9.7. Worked with development team to exploit features of v9.7. Responsible for the modification, testing, and deployment of database maintenance scripts. Participated in vendor software evaluation program.

Confidential, New York, NY 05/07 – 8/09
Senior DB2/UDB Database Administrator
Production: Provided Global 24 X 7 production support including Europe and Asia-Pacific regions. Executed several successful database disaster recovery and high availability failovers. Migrated several databases from development to the staging and production environments. Responsible for the modification, testing, and deployment of database maintenance scripts (14) in all environments (i.e., approximately 500 hosts). Performed problem determination and resolution for production break/fix problems. Conducted performance analysis and tuning for slow processing transactions and SQL. Managed database storage and capacity planning on DPF and Non-DPF databases. Implemented the DB2 Governor to remove idle database connections, and ensure efficient utilization of production database resources.

Development: Installed and configured DB2/UDB 8.2, 9.1, and 9.5 databases on Solaris 10 and Linux. Configured the host for VCS high availability and QREP replication resources as well as SRDF disaster recovery. Created new databases and standard maintenance jobs. Scheduled all database maintenance on Autosys. Implemented range partitioning on large DB2 V9 database to simplify data management and roll-in/rollout strategy. Implemented database security using LDAP and Kerberos. Upgraded the software to the latest fixpaks to alleviate known DBMS problems. Tested base DB2 version 9.1 and 9.5 functionality, and worked with IBM to resolve problems. Supported Fixed Income and Investment Banking database conversions from Sybase to DB2/UDB V9.

Confidential, New York, NY 09/06 – 5/07
Director Data Management
Designed and implemented DB2 databases supporting core business applications. Developed architecture solutions that complied with business requirements. Established data management policies and procedures. Lead JAD sessions to clarify business requirements. Presented data architecture solutions to business areas. Worked in collaboration with designers and business subject area experts for data capturing and analysis, and business rule identification.

Identified data mapping and data conversion issues. Established data dictionary and data administration function. Administered and maintained effective project plans. Participated on a cross-functional team planning and formulating data warehouse strategy. Collaborated with peers to improve the data warehouse environment, and implemented recommendations on the architecture and ETL process. Identified alternatives and expedited the implementation of recommendations. Initiated the evaluation of several ETL tools to improve the process and minimize resource requirements. Coordinated data mapping and data conversion issues. Managed and coordinated the conversion of data marts from Oracle to DB2/UDB including SAN storage requirements. Provided leadership and delivered flexible database designs Conducted software evaluations from a data perspective. Lead the evaluation of DB2/UDB version 9. Documented test plan including the testing of data partitioning (DPF), table partitioning, multi-dimensional clustering (MDC), XML support, and data compression. Improved performance by 40% by converting tablespaces to multiple partitions with DPF. Determined techniques to load various external XML feeds into DB2/XML tables. Planned implementation and rollout across environments.
Reviewed production support procedures to improve availability, integrity, and performance of the production databases. Improvements included: automated scripts to monitor databases and report issues, daily review of reports, logs, and backups, storage usage and thresholds, off-hour monitoring of critical databases, review and tuning of instance configuration/settings and SQL, and enforcement of database security. Additionally, revised the process for production replication and federation of database tables, and coordinated the offsite disaster recovery tests. Responsible for project plans, resource allocation, project status reporting, vendor invoice reconciliation, master service agreements, performance appraisals, education planning and scheduling, and career development plans. Represented the area in all project management office initiatives.

Confidential,New York, NY 05/05 – 09/06
Senior Database Administrator
Designed and developed the replication reporting DB2/UDB database on the Suse/Linux platform to ensure accurate and timely replication. Identified business requirements, and analyzed data and business rules. Created database objects including tables, indexes, views, stored procedures, and functions. Developed and tested the database stored procedures (SQL) and alert processing programs (Jython) to ensure the transformation of operational data on multiple servers. Conducted SQL optimization and tuning to improve performance including explain plan, index and access path analysis, and db2advisor recommendations. Implemented export, import, reorgchk, reorg, and runstats utilities. Implemented the DB2 governor for efficient management of database resources. Implemented summary tables (MQT) for multi-dimensional reporting.
Documented business attributes and entities. Created logical entity relationship diagrams using Erwin. Created physical database design in third normal form. Updated logical and physical models based upon new business and data requirements. Validated models with business users and development team. 
Migrated the Interactive Voice MYSQL database to the DB2/UDB/Linux platform. Conducted data type analysis and conversion solutions. Created the database objects including tablespaces, bufferpools, tables, indexes, and constraints. Researched and resolved data type incompabilities. Performed maintenance as needed specifically reorgs, runstats, imports, exports, backups, and restores. Coordinated changes with the migration team. Performed storage capacity planning tasks.
Migrated the Bill Payment POSTGRES database to the DB2/UDB/Linux platform. Established the development. QA, and production environments. Created the database, tablespaces, bufferpools, tables, indexes, and constraints. Researched and resolved data anomalies related to the conversion. Created scripts to load/import production data. Implemented federated access to existing databases including wrappers, servers, user mapping and nicknames. Documented database implementation plan and coordinated the migration. 
Created the Static Fraud System database tables, indexes, and constraints in all environments. Developed and tested queue SQL queries. Created test data scenarios. Conducted SQL tuning to improve performance. Developed and tested criteria to identify fraud based upon business rules. 
Additional responsibilities included: developing database physical designs for core databases and tables, diagnosing database problems and implementing solutions, participating in database upgrades, assisting application developers with SQL coding, tuning and triggers, troubleshooting and resolving production database problems, monitoring, analyzing and tuning database performance, performing 
ongoing database enhancements and maintenance, developing and testing data patches, and providing adhoc production reports. Maintained project plans. 

Confidential,New York, NY 06/04 – 05/05
Senior Database Administrator
Supported and maintained DB2/UDB 7.2 and 8.1 databases including RDBMS installations and upgrades. Responsible for DB2 instance configuration, production database replication, table maintenance, and database backups and restores. Performed data imports and exports across platforms, created production utility scripts e.g., runstats, reorg, and implemented database security. Monitored database performance, migrated databases to QA and production environments and managed database storage. Provided 24 X 7 production support, executed database recovery process in support of disaster recovery tests. Converted DB2/UDB update anywhere replication from 7.2 to 8.1. Installed Oracle 9i/10g RDBMS software and runtime clients. Implemented Oracle’s standby database at the disaster recovery site. 
Developed logical and physical models that complied with the business requirements and data management procedures. Assisted application teams with data modeling and data conversion requirements. Established data naming conventions for standard business names, attribute names, and column names across databases. Provided database design and support services to several application groups.

Confidential, New York, NY 03/01 – 07/03
Database Manager / AVP
Lead database infrastructure team support including installations, upgrades, maintenance, power-downs, and disaster recovery. Lead a 12-person database team supporting DB2, Oracle, SQL Server, Sybase, and IDMS databases. Responsibilities focus on database design and implementation, performance monitoring and tuning, quality assurance testing and troubleshooting production problems. Major functions included logical modeling, physical database design, database creation and migration, backup/recovery, capacity planning, storage layout and management, production implementation and disaster recovery. Manage major infrastructure projects including business continuity testing, Remedy ticket support, database security and database production scheduling

Agency
Oversaw and participated on the Partnership DB2 database design and implementation. Coordinated project activities and review project status. Assisted with data definition, logical design, design validation, and physical design. Developed and maintained plans, coordinated project activities, and reviewed status of critical deliverables. Oversaw and participated on the Senior Accumulation Plan DB2 database design and implementation. Planned project activities and review project status. Mentored DBA on development support activities.
Coordinated semi-annual disaster recovery tests at IBM\'s Sterling Forest Recovery Site. Managed DB2 DBMS upgrade across all environments. Supported large-scale DB2 databases (Accounting, Leads, Agent Ledger) and developers in a COBOL/CICS/OS390 environment. Directed Annual Planning database conversion from Sybase to Oracle. Coordinated data analysis and data mapping. Redesigned database structures for Oracle. Coordinated data extract from Sybase and load on Oracle. Resolved data type conversion obstacles. Directed Agent Contracting database conversion from Sybase to Oracle. Converted existing database with new functionality. Coordinated data analysis and data mapping. Completed logical and physical design using Erwin.

Financial Management - Oracle Financial Data Warehouse
Developed and maintained plans, formulate strategy, coordinate project activities and review status of critical deliverables. Developed and oversaw the implementation of detailed project plans. Coordinated business requirement meetings to review business rules, identify ETL requirements, and discuss referential integrity requirements. Lead team to design of star schema dimensions and measures. Lead team to design the architecture for data warehousing components specifically, tool integration strategy, ETL strategy, and data movement and aggregation. Directed performance stress test evaluating database resource utilization and hardware capacity.

Individual Policy Services - Oracle Consolidated Statements Database 
Directed database administrators providing core database support services. Facilitated database development, balance DBA resources, and coordinate production implementation. Planned project activities and review status of critical deliverables.

Confidential, White Plains, New York 12/99 – 03/01
Senior Database Administrator
Installed DB2/UDB database management software on Unix and NT platforms. Configured disk mirror and striping using Veritas software. Upgraded software on both the NT and Unix platforms. Installed and tested DB2/UDB software fixpaks. Documented annual storage capacity requirements. Designed the Customer Accounts DB2/UDB database on SUN/Solaris platform. Developed logical and physical designs. Created database objects and backup/recovery procedures. Provided 24 x 7 production support. Troubleshoot and resolved production database problems. Monitored, analyzed and tuned database performance. Assisted application developers with SQL tuning and triggers. Installed client software to establish database connectivity. Performed ongoing enhancements and maintenance. Migrated DB2/UDB databases from NT to UNIX platform. Documented and maintain logical/physical database models.

Confidential, New York, New York 10/84 – 12/99 
Vice President / Manager - Corporate Systems Technology Services 
Selected to oversee the start up of the Corporate Systems Technical Architecture Group and develop a three-year Technology Plan. Collaborate with partners to understand business requirements and identify technological solutions to business problems. Provided technology vision and direction, evaluate and research emerging technology as well as validate technical architecture alternatives.

Financial Systems:
Developed and maintained plans, formulate strategy, coordinate project activities and review status of critical deliverables. Oversaw the evaluation, planning, and selection of the hardware to support the Oracle Financials 11.0 release upgrade. Identify hardware and network requirements for infrastructure testing. Scheduled vendor evaluations and research Oracle\'s Network Computing Architecture. Directed performance stress test evaluating network and hardware resource utilization from strategic locations, network predictive modeling, and hardware capacity planning.

Global Human Resources:
Evaluated global technical architecture and recommend deployment strategy. Performed design validation and determine requirements for network performance test to evaluate the global architecture for scalability, availability, and performance. Coordinated network upgrades, outstanding requests and related network issues. Evaluated ETL and OLAP/ROLAP/MOLAP tools for data mart implementation and define the global architecture. Formulated data strategy with project team and collaborated with project planning team.

Vice President / Database Manager - Private Client Information Management 
Directed database administrators (16) providing DB2 and Oracle database support services. Facilitated database development and implementation. Oversaw data integration, high priority issue resolution, business and technical planning, allocation and management of resources, and status reporting. 
Created and managed work plans, technical solutions, documentation and developed database management services. Managed critical production support for over 95 databases. Responsibilities focus on data administration, logical/physical database design, backup/recovery, performance monitoring and tuning, disaster recovery, security, and quality assurance testing. 
Performed performance appraisals, career development, salary planning, education planning and scheduling. Coordinated database audits and resolved critical audit points. Managed database tool selection and implementation.

EDUCATION
M.S. in Information Systems 
B.A. in Finance