TECHNICAL SKILLS

Operating Systems: Linux, Solaris, VAX/VMS, Windows NT

Database Systems: Sybase (12.5.4, 15), Oracle(9i), MS SQL (2000, 2005, 2008), Informix

Languages: T - SQL, Unix Shell Scripts (C shell), Perl, C, Java, HTML, COBOL

PROFESSIONAL EXPERIENCE

Confidential, New York, New York

Senior DBA

Responsibilities:

• Senior DBA providing dedicated support to the Prime Services Team, DBMS support includes Sybase ASE, Sybase Replication Server and Sybase IQ in a 24x7 global environment.
• Review/Manage/Implement global application releases.
• Assist developers in resolving performance issues with stored procedures and database design.
• Provide expertise in DB design, architecture and implementation
• Develop in house alerts/monitoring processes to generate proactive/preventative alerts.
• Coordinate with Engineering and App teams for planning, testing, scheduling and executing Sybase ASE and Replication servers patching/ upgrades.
• Remediate security vulnerabilities as identified by SAP.
• Provide SME for database design/modeling.
• Plan/Execute Sybase server migrations and patch upgrades.
• Resolve daily production related support issues with Sybase ASE and Replication server and IQ servers.
• Manage/Train offshore support teams.

Confidential, New York, New York

Senior Sybase DBA

Responsibilities:

• Senior Sybase DBA providing dedicated primary support for a Client Portfolio Management Application, support included Sybase ASE, Sybase Replication Server in a 24x7 environment.
• Work with developers on performance and tuning stored procedures.
• Senior member of GTIS Core Sybase support team providing weekend on call for the global support team, assisted and halp train the off - shore support team in resolving L1 support issues.
• Installed and upgrade Sybase servers and Replication servers (15.5).
• Resolve daily production related support issues with Sybase ASE and Replication server.
• Trained off-shore L1 support teams to monitor and resolve minor DB issues.

Confidential, New York, New York

Senior DBA

Responsibilities:

• Senior DBA providing dedicated support to the Prime Services Team, support included Sybase ASE and Sybase Replication Server in a 24x7 global environment.
• Developed solution for setting up global High Availability environment using bi-directional Sybase Replication.
• Resolve daily production related support issues with Sybase ASE and Replication server.
• Trained off-shore L1 support teams to monitor and resolve minor DB issues.

Confidential, New York, New York

Equities Global DBA

Responsibilities:

• Senior member of DBA support team providing Sybase, Sybase Replication Server and MS-SQL and Oracle support for a 24x7 global environment.
• Reviewed stored procedures for production release.
• Monitor server performance and make recommendations to resolve potential issues with stored procedures and server configurations.
• Resolve daily production related support issues with Sybase ASE, Replication server and MS-SQL.
• Setup Sybase Replication for warm standby and data replication to multiple down stream systems.
• Assist developers with troubleshooting/optimizing/tuning stored procedures and optimized utilization of indexes.
• Manage the daily BAU activities for the NA Equities DBA Team.
• Review and manage the global production releases to APAC, EMEA and NA.
• Successfully rollout the DBA auditing packages to pass the Database SOX audits.
• Assist in merging the offshore DBA support team to handle the Level 1 support.
• Buildout test/uat environments in support of various merger related activities.
• Buildout/upgrades Sybase and Replication servers to V15

Confidential,St, Jersey City, NJ

Senior DBA

Responsibilities:

• Performance and Tuning on Sybase ASE for the Prime Brokerage Group, modified stored procedures to execute with optimal conditions, reviewed tables and index structures.
• Assisted developers in reviewing nightly batch processes to identify bottlenecks and minimize processing time.
• Create application DB releases and worked with production DBA’s to implement changes.
• Analyzed and recommend ASE server configurations.
• Setup and maintained reporting database using Sybase replication server.

Confidential, New York, NY

DBA Lead

Responsibilities

• Managing the DBA resources to support a 24/7 environment.
• Worked with database engineering teams to develop database standards for server builds and monitoring.
• Implemented a DB auditing package in support of the SOX audits.
• Duties included: building, maintaining and optimizing the DBMS. Monitor server activity for signs of possible problems. Maintain contingency and backup server consistency. Develop, optimize and troubleshoot stored procedures and triggers.
• Build and maintain Sybase replication server for warm standby and table-based replication.
• Develop and plan for backup and contingency methodology,
• Provide expertise in DBMS design and architecture for AD.
• Create shell/Perl scripts for database monitoring and server builds/upgrades

Confidential

Developer/DBA

Responsibilities:

• Database modeling using Irwin.
• Design and implemented a Warrants Reconciliation System, Daily Earnings at Risk for Emerging Markets and FX.
• Provide DBA support for development teams.
• Develop and optimize stored procedures, performance tuning.
• Logical and physical database design.
• Develop shell scripts for various system functions.
• Migrate Sybase 4.9 to 11.
• Migrate development systems to production.
• Troubleshoot development and production problems.
• Optimize nightly load procedure from 2 1/2 hours to 20 minutes.
• Automate system maintenance procedures.