SUMMARY

• Development of ad - hoc reports generation for management use
• Database Analyst with 15+ years of experience in database design, maintenance, performance and support
• Experienced RDBMS for development, maintenance, and storage of large databases
• Proficient in SQL coding, analysis and performance
• Knowledge in problem resolution of processing logic, COBOL coding and JCL development
• Experienced with various 3rd-party vendors tools to support day-to-day database functions. Tool such as Platinum / CA Database Suite, IBM database suite & utilities, BMC database suite, File-Aide, Omegamon, CA-7 Erwin Tools, Strobe, Endevor, RACF, Compuware Tools
• Experience with change management process for applications and documentation
• Proficient in translating business and user requirements into detailed specifications
• Experienced in conducting requirement analysis, use case design and developing logical models.
• Experiences in reviewing and finding complex issues by reading log files, partnering with systems, storage and network infrastructure partners
• Active team participant in establishment of policies and procedures
• Strong expertise in Data analysis, Data mapping, Data modeling and development
• Excellent in gathering business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
• Excellent communication and organizational skills including the ability to multi-task prioritize and manage increasingly complex issues.

TECHNICAL SKILLS

• Requirements Collection
• TSO / ISPF
• QMF (Query Mgr)
• Strobe
• Data Analysis
• DB Performance Tools
• SQL
• RACF
• MS/Project
• VSAM
• DB2 v6 to v10
• Endevor
• MS/Office Tools
• DASD
• Job Scheduling (CA7)
• File-Aid
• IBM Mainframe
• IBM - OS 390 z/OS
• Change Management
• DB2 Connect
• CA Administration Tools
• IBM Administration Tools

PROFESSIONAL EXPERIENCE

Confidential

DB2 DBA

Responsibilities:

• Primary responsibility for managing and maintaining large database systems for Confidential:
• Primary DB2 z/OS DBA Administrator for IMB DB2 database platform - DB2 v11 and IMS v14
• Vertical Processing Functions responsibilities were Decision Support, Dealer Communication Services, Vehicle Order Management Sales Planner, Vehicle Order Database, Vehicle Order Management, Vehicle Order Management Vehicle Specification, Customer Delivery Reporting System, Dealer Information Database, Dealer Network Planning System, Delivery Reporting & Stocks, CDR Transactional Data Base & CIRCUS, Vehicle Information Database. DBA’s are responsible for four verticals, Global Marketing & Sales, Customer Care & Aftersales, Powertrain and Global Finance.
• Added changes to the production environment that been vetted in the test environments
• Granted DELETE, INSERT, SELECT, UPDATE on new test and production DB2 tables
• Standardize the Mainframe environments and reduced the number of incidents
• Supported driving innovation through achieve an annual aggregate of 80% or higher
• Demonstrates the highest level of honesty, integrity and trust. Maintains the highest of ethical standards in performing daily responsibilities. Exhibits ethical behavior as outlined in Winning with Integrity.
• Demonstrates the highest level of technical competence, problem solving skills, innovation and initiative.
• Performed reorganization on production physical DB2 table space datasets supported by change requirements
• Performed reorganization on production physical IMS database dataset supported by change requirements
• Maintain documentation on DB2 DBMS and IMS DBMS aspect of the application so other leveraged DBA’s can support the application. Maintain backup, recovery, reorganization JCL streams to support the required
• Understands the organization’s business climate, customers, competitor and impacts that affect company performance. Achieves agreed upon goals within the time allotted.

Confidential

DB2 DBA

Responsibilities:

• Primary responsibility for managing and maintaining large database systems for Financial Institution:
• Primary DB2 z/OS DBA Administrator for IBM DB2 database platforms - DB2 v9 to v 10, z/OS
• JCL, DDL, DML, SQL, SMP/E, TSO, QMF, REXX, SMF, change management software, modeling software, ITSP
• Achieved data redundancy reductions through analysis
• Rewrote 900 plus Image Copy utility jobs to reduce redundant in CA7
• Save the company $250 thousand dollars from over allocated tables, indexes and maintenance jobs.
• Liaison between test center, DBA’s, systems programmers and developers
• Strong SQL query development and performance on IBM and SQL platforms
• Assisted development team with database performance analysis
• Supported developers in SQL and database design, and maintenance
• Participates in upgrades to CA database suite and IBM database suite. Support of DB2 z/OS Data Sharing in Parallel Sysplex environments
• Administration of IBM DB2 Administration Tool Suite and Administration of CA DB2 Administration Tool Suite
• Migrated database structures through 60 subsystem environments from test to production and kept all environments in sync.
• Developed and implemented process and technical improvements that increase the availability and quality of products and services delivered into production.
• Customized reports to monitor databases. Active team member for implementation of business initiatives including brainstorming on new functionality for current systems.
• Maintained data integrity and maintenance
• Database Subsystem Performance Tuning; Application Performance Tuning
• Backup and Recovery, Problem Determination / Problem Resolution
• Manage the analysis and communication of supported and or project requirements, updates, metrics and general information, including project and operational activities, enhancements, test readiness development and maintenance plans to ensure proper operation of business system and services are optimized.
• High-Availability using Data Sharing in a Parallel Sysplex environments
• Logical Data Modeling, Physical Database Design
• Create production tests by developing data load scripts and utility function for each environment as well as the systems testing and implementation plan.
• Coordinate physical changes to mainframe databases; and codes, tests, and implements physical database
• Provides extensive experience in troubleshooting hardware, core system software, database environments and application software issues using tools knowledge and experience
• Active DR team participant in implementation of new/modified business initiatives for disaster recovery
• Secondary Development SQL Server DBA - works on building queries, stored procedures, etc. that meet business needs. This is the equivalent of the programmer. Primarily write T-SQL.
• Establish and maintain sound backup and recovery policies and procedures.
• Take care of the Database design and implementation.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Database tuning and performance monitoring.
• Application tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 7×24 supports when required.
• Do general technical trouble shooting and give consultation to development teams.
• Interface with MSSQL/MySQL for technical support.
• Active team member for implementation of business initiatives including brainstorming on new functionality for current systems.

Confidential

DB2 DBA

Responsibilities:

• Primary responsibility for managing and maintaining large database systems for Financial Services:
• Responsible for IBM DB2 database development, implementation, and maintenance in support of project developers as a DB2 z/OS Database Administrator.
• Installation of third-party software
• Responsible for Corporate Data Repository, Data conversion formats
• Responsible for design, coding, testing and implementation of database and database structure.
• Utilized skills in performance and tuning, DASD management and problem solving.
• Developed online CICS programs and batch COBOL programs and enhanced out dated programs
• Created databases and maintain all maintenances jobs using IBM utilities.
• Worked with SQL Server database in test and migrating small databases to production
• Developed DBA Mentoring Programs
• Assisted in the installation, testing and documentation of DB2 v5 to v6
• DB2 products, CA Administration Tools and IBM Administration Tool, Image Copy, Reorg, Unload, Load, Log Analyzer, Omegamon.
• Coordinate the purchasing of Administrative Tools, also wrote a distinguished business case.

Confidential

Business Analyst/Programmer

Responsibilities:

• Responsible for IBM DB2 database development, implementation, and maintenance in support of project developers as a DB2 z/OS Database Administrator.
• Installation of third-party software
• Responsible for Corporate Data Repository
• Data conversion formats
• Responsible for design, coding, testing and implementation of database and database structure.
• Utilized skills in performance and tuning, DASD management and problem solving.
• Developed online CICS programs and batch COBOL programs and enhanced out dated programs
• Created databases and maintain all maintenances jobs using IBM utilities.
• Translated business requirements into functional requirements
• Participated in data mapping sessions and provided analysis on data integrity issues
• Developed data schemas for use by database administrators
• Performed analysis and design for documenting and understanding reporting requirements
• Created ad-hoc and metrics reports
• Built, modified, and managed tables as well as entire relational databases
• Coordinated 12-month migration and release testing schedule
• Responsible for assigning and managing change controls
• Developed processes and procedures to ensure the most efficient/effective implementation of requirements
• Responsibilities included analysis, design, development, maintenance and testing of and IBM mainframe-based package
• Coordinate physical changes to mainframe databases; and codes, tests, and implements physical database