SUMMARY

• An accomplished Principal SAP Basis and DB2 Database Administrator, Architect and Engineer.
• Several years successfully installing, configuring, designing, migrating and tuning several large RDBMS databases including DB2 for Z/OS, DB2 for LUW, DB2 Purescale for Linux and AIX, IIDR (IBM InfoSphere Data Replication), DB2 for Iseries (AS400), SAP, HANA, Hadoop, Oracle, SQL Server. Demonstrated strong analytical and business intelligence skills.
• Have had great success delivering Big Data, Data Warehousing and Business Intelligence solutions.
• Projects on very large DB2 AESE (multi - partition databases) running on AIX, Solaris, Linux and Windows operating systems.
• 10 years in technical management and in leadership roles.
• Demonstrated ability to work with IT and business personnel.
• In 2015, successfully migrated very large PeopleSoft and DB2 for ZOS databases to DB2 for LUW V10.5.
• Distributed databases are running on Linux 6.5 and have HADR implemented.

TECHNICAL SKILLS

• IT MANAGED SERVICE DELIVERY
• DATABASE MANAGER
• ORACLE
• HADOOP
• BIG DATA
• BUSINESS INTELLIGENCE
• SAP
• TALEND
• PERL & K-SHELL SCRIPTING
• TABLEU
• BUSINESS OBJECTS
• TSM. SQL SERVER
• ORACE
• EXATADATA
• SCRUM
• AGILE
• PEOPLESOFT
• SALESFORCE
• ETL
• CONTENT MANAGER. NOSQL
• MYSQL.

PROFESSIONAL EXPERIENCE

Principal Database Administrator, Architect and Engineer

Confidential

Responsibilities:

• Successfully delivered conceptual design, logical data model, physical data model, capacity planning, external data interface specs, data loading, data maintenance and storage plan as well as security policies.
• Accomplished appropriateness of data storage, archive, purge and backup strategies. Installed, configured and maintained DB2 PureScale databases.
• Used IBM IDR and AWS to support big data integration, continuous availability, consolidation, warehousing, analytics initiatives as well as zero-downtime migrations and upgrades.
• Reduced infrastructure cost through strong technical leadership and mentoring others on several applications teams, including application developers and DBAs.
• Achieved customer’s target goal by formulating and implementing teams’ technical vision, teaching hands on insight into system architecture, database software development and data warehouse design.
• Successful in the delivery of architecture and design of new applications, stored procedures, databases and infrastructure changes.
• Successfully implemented HADR Fail-over, Monitoring and Maintenance Strategy.
• Executed changes consistent with established change control policy.
• Provided Level 3 production support for SAP, IDM 7.2 & 8.0 I, DB2, SQL Server, MondoDB, NoSQL, Hadoop databases.
• Perform SAP installation.
• SAP Basis security configuration, authorization and security roles, auditing, monitoring and SAP Database performance tuning.
• Install, configure, manage and optimize TALEND ESB Hadoop, Apache Spark and NoSQL databases.
• Supported TALEND ETL and data integration.
• Facilitated the design and development of PostgreSQL databases from business and system requirements. S upported and administered on premise and cloud based Hadoop clusters.
• Installed Guardium and provided support for Guardium.
• Performed Tableau Server administration.
• Performed MongoDB Replica Set and Sharding. Conigured and administered a Cloudera deployment.
• Daily tasks include MongoDB replication setup and managing replicaset.
• Performed security measures, backups and restored backups.
• Developed and maintained a comprehensive library of all supporting documentation.

LEAD DATABASE ENGINEER

Confidential

Responsibilities:

• Designed, implemented and successfully supported first strike defense applications, databases and technical infrastructure.
• Designed, implemented and supported distributed intelligence data warehouses on 3 main operating systems. Installed and configured RDBMS on several IBM SMP servers.
• Resolved locking, latching, versioning, recovery, memory management, I/O contention, indexing, inefficient SQL code generation and successfully optimized low performing reports.
• Developed foreground and background jobs to automate scheduled administration functions including backup to TSM.
• Created user groups, users & granted them roles and privileges.
• Designed backup and recovery strategy.
• Migrated older version of DB2 for LUW to a newer version and release level.
• Executed Snapshots and Event Monitors, EXPLAIN. Implemented new requirements for tables, indexes and views for enhancement projects.
• Implemented requirements for new Data Warehouses, DB2 Instances, Data Marts and Databases, Tables, Indexes and Views.
• Perform Query and Stored Procedure development and improving non-performing Queries and Stored Procedures for optimum performance.
• Set up data replication subscription. Wrote capture and apply procedures.
• Resolved replication bottlenecks through the use of the Replication Alert Monitor.
• Mentored Application Developers in the writing of complex and efficient MicroStrategy and SQL code.
• Orchestrated database design and database performance reviews.
• Executed changes consistent with change control policy.
• Provided Level 3 production support and service management.

SENIOR DB2 DATABASE ADMINISTRATOR

Confidential

Responsibilities:

• Mapped highly complex physical databases from logical models for AMEX corporate card services.
• Actively participated in complex data modeling, integration and capacity planning efforts.
• Ensured compliance to management policies, procedures and standards.
• Identified business requirements, performed analysis and development of data warehouse and database objects that supported business initiatives. (Reported to Raymond Gardner - VP - IT)

DB2 UDB IBM STORAGE

Confidential

Responsibilities:

• Developed DB2 VLDB migration plan and risk assessment for Confidential Corporation.
• Executed plan for migrating DB2 UDB v7.2 data from IBM Shark to Confidential storage devices.
• Created new DB2 UDB v7.2 instances, databases, table spaces, tables and indexes.
• Created Hot Standby Databases with DB2 UDB V8.1 and using IBM Shark Flash copy and Confidential TimeFinder. Transformed that mission-critical 24x7 DevOps with the highest degree of availability, and cost savings.
• Successfully mapped physical layout of DB2 table spaces from IBM Shark to Confidential storage.
• Analyzed and tuned several DB2 databases using EXPLAIN, SNAPSHOT MONITOR, EVENT MONITOR.

SENIOR DATABASE ANALYST

Confidential

Responsibilities:

• Installed, designed, built and configured RDBMS Instances, Data Marts, databases, tables paces, tables, indexes and views.
• Added users and controlled database access privileges.
• Executed RDBMS system utilities and perform database problem resolution.
• Performed database and table space backup and restore.

DATABASE ADMINISTRATOR

Confidential, San Jose, CA

Responsibilities:

• Managed and mentored a DBA staff of 5. Supported DB2 UDB EE v5.2 for Windows and AIX databases. Performed user access control on subsystem.
• Designed OLAP databases. Created groups, users & giving privileges.
• Set up command options and updating the environment variables.
• Installed, configured and tuned DB2 UDB EE databases. Executed DB2 utilities reorgchk, reorg, runstats and backup weekly as part of a maintenance initiative.
• Created instances, databases, DMS and SMS table spaces, tables, indices and views.
• Fine-tuned databases and applications to increase their performance by using EXPLAIN feature, SNAPSHOT and the EVENT MONITOR to accomplish target goal of thirty percent increase in performance.

DB2 Database Administrator

Confidential

Responsibilities:

• Installed, configured and tuned DB2 UDB v3.1 on Windows, OS/2, AIX and S/390 including DB2 Connect.
• Created and updated DB2 UDB v3.1 instances and the admin (DAS) instance.
• Designed and created DB2 UDB v3.1 databases, buffer pools, tables paces, tables, views and indexes.
• Scheduled and executed Copy, Load, Import, Export, reorg, and runstats.
• Performed offline and online backup for DB2 UDB v3.1 databases and table spaces.
• Fine-tune queries to enhance performance by using explain, point in time snapshots and event monitors.