SUMMARY:

• Specializing in - PL/SQL Development, Oracle Database Administration, Data Modeling
• Sr. Database Administrator with more than 20 years leading and supporting highly sophisticated database operations for Fortune 500 Companies.
• Strategic leader well versed in Information Management, Digital Performance Marketing (DPM), Business Intelligence (BI) and Managed Operations and leading projects to develop Master Data Management solutions, improve business results and overall efficiencies of IT services.
• Record of accomplishment in building and implementing business processes and governance models.

ADDITIONAL STRENGTHS AND COMPETENCIES:

• Project Management - Requirements Gathering, Analysis, Documentation, Stakeholder Relations | Six Sigma Green Belt
• Cross-functional Leadership | Executive Communications | Data Architecture | Data Migration | Integration
• Oracle Database 8i-11g r2 EE | Clear Quest V7 | Solaris 10 | Apache 2.2 | SQL Server 2008
• Oracle App Server 10g r2 and 11g EE | Oracle Development Tools and Crystal Reports v10 | RabbitMQ 3.4.3.

CAREER HISTORY:

Sr. Data Architect/Development DBA

Confidential, Lewisville, TX

Responsibilities:

• Provided day to day database support and maintenance of development and production database servers.
• Architected many solutions for an existing Supply Chain System.
• Configured and supported 6 Oracle 11g r2 Databases with Active Data Guard and performed switchovers and failovers in the event of server failures.
• Used Oracle Data Guard to set up an Oracle 11g r2 Production Database replication between 2 data centers located on east coast and west coast and supported them daily.
• Improved Performance of a cold fusion web application accessing Oracle databases.
• Acted as SME (Subject Matter Expert) for RabbitMQ (based on Advance Message Queuing Protocol) to make Confidential Applications robust and scalable.
• Introduced RabbitMQ messaging system and delivered high-availability cluster to support 24/7 operations.
• Designed and delivered Web applications using RabbitMQ message broker to handle high message traffic.
• Designed and delivered a high-performance WEB Application for Order Management and Tracking with the ability to deliver results in sub-second time frames.
• Improved the performance of an existing Web Reporting application.
• The processing time improved from 15+ minutes to less than 2 seconds.
• Designed a data model for a telephone system to redirect users to a self-help Web Site.

Sr. Solution Architect/ Development DBA

Confidential, Rochester, NY

Responsibilities:

• Designed and implemented ETL processes and procedures for EPIW data warehouse.
• SME supporting connectivity and related issues for EPIW data warehouse clients.
• Integrated EPIW data warehouse with other databases (i.e. SQL Server and Oracle).
• Designed and implemented OWB (Oracle Warehouse Builder) mappings and process flows.
• Participated in data warehouse infrastructure, data access, code reviews and ETL design to Improve performance, ease of use, access, and availability.
• Documented requirements for new ETL processes and change requests.
• Improved data access performance 10-fold using Materialized Views and Oracle Partitioning.
• Implemented SQL procedures in critical areas and increased disk storage and reduced load time by hours.

Oracle Database Administrator

Confidential, Rochester, NY

Responsibilities:

• Oversaw Data Modeling, Database Administration, and Software Configuration Management Tools.
• Responsible for logical and physical database design for new applications.
• Developed new applications, designed system architecture, selected hardware, and tools.
• Provided database administration for development, test, and production systems using Oracle on Unix serving hundreds of users daily.
• Acted as a technical lead for developers in the application development team.
• Installed and configured Unix and Windows Oracle database servers including automated startup and shutdown, backup and recovery, performance tuning, and upgrade of Oracle databases.
• Installed, configured and administered Oracle App Servers 11g.
• Provided data exchange from Oracle to Oracle and Oracle to other databases.
• Designed, developed, tested, deployed, and supported Clear Quest solutions for various software development groups.

Environment: s supported: Oracle Database 8i-11g r2 EE, Clear Quest V7, Solaris 10, Apache 2.2, SQL Server 2008, Oracle App Server 10g r2 and 11g EE, Oracle Development Tools and Crystal Reports v10.

Sr. Computer Engineer, Data Modeling, Database Design, Application Development

Confidential, Rochester, NY

Responsibilities:

• Responsible for data modeling and database design of a commercial product designed for prostate cancer treatment planning.
• Designed and implemented ASTM (Standard Medical File Format) file parser in Java 1.2
• Designed and implemented data loader using PL/SQL for Oracle 8i.
• Guided the development team in GUI, security, backup/recovery, import/export, design and implementation issues.

Sr. Systems Analyst, System Analysis, and Design

Confidential , Rochester, NY

Responsibilities:

• Project Leader for Sales Force Automation Tools selection, customization, implementation, and training.
• Subject Matter Expert and support analyst for scanning, indexing, and processing of engineering drawings.

Environment: s supported: VISUAL BASIC 6.0, Visual InterDEV 6.0, Front, JBuilder 2 C/S, ACCESS 97, MS Office 97, ORACLE 7.3, SLQ Server 7.0(beta), Windows NT 4.0

Systems Analyst, System Analysis, and Design

Confidential, Rochester, NY

Responsibilities:

• Participated in a global design team to conduct object oriented analysis and design for Confidential 's business process for implementation in a Client/Server environment.

Environment: s supported -- RATIONAL ROSE/C++ (Windows), VISUAL BASIC 3.0/4.0, SOLARIS 2.4, ORACLE 7

Systems Engineer, System Analysis and Design

Confidential, Rochester, NY

Responsibilities:

• Managed and supported five local area networks supporting 100+ workstations and several laptops.
• Fully responsible for data modeling, database design, and implementation of order processing and production search engine performing statewide property searches using laptops; decreased turnaround time from 2 weeks to 24 hours.