Professional Summary:

• IT Professional with 15 years experience specializing in Oracle application database architecture, administration and database lead. Works best with assignments that include ownership of applications and is a member of development team that highlights HANA, Web-based applications, JAVA, BI data marts and DWs.
• Proficiencies in architecting Oracle schemas in the role as lead Data Architect using logical and physical modeling with design/ddl generation tool PowerDesigner 16.5
• Expertise in Oracle SQL and PL/SQL performance and tuning using tools such as Toad DBA Suite. Self-starter and independent contributor in the areas of It Infrastructure, database design, QA testing and Web applications, data marts and data warehouse performance.
• Experienced with training staff with other proficiencies who are migrating to Oracle to become database developers and production support staff using best practices to stay corporate compliant. Finds this work type of technical staff development especially rewarding and enjoys seeing the growing of his team. Training topics include database design, SQL, PL/SQL, SAS Programming language and new UI interface, SAS EG and the various Linux versions.
• Interacts with JAVA Developers, Linux and Widows Administrators, Infrastructure DBA's to communicate application requirements and capacity planning. Identifies future hardware and disk storage purchases as detail on the application platform's roadmap.

Confidential

Sr. Database Developer Consultant

• Accenture/Artech Project, Mortgage Asset Servicing
• Lead Project Analyst for Sybase ASE 15.7 upgrade with white paper deliverable.
• Performance analysis of Oracle 11G application production issues.
• Analysis of JAVA /code packages using Elipse including interfaces to Oracle and Sybase.
• Experience migrating JAVA application from Development thru Production.
• Composed detailed Shell Scripts to automate Production workarounds and to monitor data delivery.
• Developed expertise with Elipse, RapidSQL, JAVA code baselines, AutoSys and source code distribution.

Confidential

Oracle Application DBA Staff

• Application DBA in a multi-project environment for an international non-profit company.
• Performance Tuning SQL, PL/SQL, BODI Data Flows. Detailed analysis of query performance using TOAD DBA Suite 12.1 tools.
• Maintained physical models in PowerBuilder , generated Oracle DDL code using PowerBuilder base, and managed changes to application data models so developers and operations DBA could focus better on development and database maintenance, respectively.
• Programmed Business Intelligence Dashboards using Oracle's OBIEE.
• Served as liaison between developers and Operations DBA staff. Focused on issues concerning operations and making recommendations to both Operations and Development staff based on mutual goals of security and performance.
• Trained Oracle Database developers in Oracle architecture, DDL/DML SQL, PL/SQL and Physical Data Modeling.
• Performed detailed analysis of Sybase 15.7 12.5.3 system for performance improvement opportunities. Created detailed report highlighting existing coding style, issues currently being experienced, possible causes and potential solutions. Overall analysis given based on stated objective of converting applications/code to Oracle database.

Confidential

• Hedge Fund Developer, Fixed Income Consultant Programmer
• Python Programmer Analyst for a confidential company.
• Developed advance Financial Models for International Government Bond trading using LIBOR rate data.
• Programmed Fixed Income applications using Sybase 15, Python, Perl, Excel and C .

Confidential

DB2/SQL Server DBA Consultant

• Managed data migrations in a Sybase UNIX , DB2, Oracle and SQL Server environments.
• Development: Used C to retrieve data from legacy Sybase system and store it into DB2 and SQL Server
• Setup SQL Server SSIS Perl, and C data migration programs in the .net environment.
• Tested data migration code against specifications.

Confidential

Sybase/Oracle Professional Consultant

• Developed and optimized of Sybase UNIX Stored procedures and scripts for regular production rollout as per ongoing business requirements.
• In this position, my role is for Sybase UNIX , Oracle, Linux , SQL Server and DB2 including performing backups and restores, database schema migrations, performance tuning and production support.
• Provided monitoring and production support for Sybase Rep server.
• Performed Sybase database creation, space expansion and rep server configuration using Perl and shell scripts.

Confidential

Oracle/Sybase/SQL Server 2005 Professional Consultant reporting directly to the Data Architect

• Production Support and development for 200 Sybase, SQL Server and Oracle 11g on Linux database servers.
• Developed Sybase store procedures and triggers for Offline Fulfillment applications.
• Developed SQL Server 2005 stored procedures, clr's, triggers, DTS and SSIS packages for new ETL file tracking application.
• Implemented new PL/SQL stored procedures for Invoice Imaging application.
• Sybase ASE 12.5 15.03 System Administrator and Application DBA.

Confidential

Sybase Professional Services Consultant

• Sybase ASE 12.5 and 15.03 system administrator role in a UNIX environment.
• Sybase IQ: Sybase ASA 12.7 DW sa role and implementation.
• Best practices for T-SQL Stored Procedure performance.
• Query Plan analysis and tuning applied to improve store procedure performance.
• Sybase Replication Server performance tuning.
• UAT and Production readiness preparation.

Confidential

Oracle Sybase DRM DBA Appix Professional Consultant

• Sybase ASE 12.5 Oracle 10g Application DBA .
• Sybase DBA for the applications: Loan Delivery, CE, Consolidator.
• Worked with DSM and UNIXSUPP groups to implement new servers for CE application.
• Create SOX compliant database schema, performed database migrations and maintain ER/Studio data models. Oracle DBA for the WRAP application.
• Performance and Tuning projects on Sybase and Oracle queries.
• On Oracle, wrote cron jobs to monitor tablespace size and alerts to DBAs when 90 full.
• Used Embarcadero DBArtisan, Change Manager and ER/Studio tools to support a large scale Oracle and Sybase applications.
• Write UNIX Shell Scripts with ksh, csh and bash to automate DBA tasks.

Confidential

Sr. Sybase DBA in Portfolio Trading Support UNIX

• Portfolio trading floor support for International Global Trading application
• Sybase ASE 12.5 performance tuning and support

Confidential

Senior Sybase/Oracle DBA Production Support Specialist

Sybase DBA Development and Production Support Specialist. My role at Merrill was to support traders on the floor. Sybase configuration, performance tuning and managed database changes. Managed upgrades of Merrill's Equity Derivatives application and new code versions generated by 50 developers. New York, London and Japan.

Confidential

Senior Specialist - Systems Administration, Sybase Development Managed and supported Rational ClearCase environment for over 300 developers. Managed the Sybase development and releases for Instinet's Equities Trading system. UNIX System Administration Used BMC Patrol and Event Manager for server monitoring and capacity analysis.

Skills Summary rated on a scale