SUMMARY:

• More than 15 years of experience designing, building and supporting Sybase databases and in areas of database design, development, Performance & Tuning, and administration.
• Strong skills in developing and tuning stored procedures and T-SQL.
• Strong skills in determining, analyzing and tuning performance problems within the database.

TECHNICAL:

Sybase (10, 11.x, ASE 12, 12.5.x), Sybase Replication Server 11.5, 12.6, 15, MS SQL Server (2000,2005), Erwin 4, DBArtisan, SQL-Backtrack, HP-UX 10, 11, Solaris, Linux, Windows 2003

EXPERIENCE:

Confidential, Stamford, CT

Sybase & MS SQL Server Consultant

Responsibilities:

• Confidential support for Sybase ASE (12.5.4) and MS SQL Servers (2000, 2005), single point of contact for all Sybase related issues.
• Install ASE 12.5.4 on Solaris, ASE 15.0.3 on Windows. Configure ASE failover capability.
• Work with business IT in establishing database requirements pertaining to hardware, database sizing and deploying database instances to production.
• Work with Unix SA for database space requirements, high availability configuration (VCS) setup.
• Work with QA Confidential in promoting code to production.
• Create maintenance scripts for Sybase databases (re-indexing, dbcc checks, database space monitoring, long-running locks/blocks reporting, sysmon reporting, etc.)
• Create scripts for database and tran log backups used by autosys jobs.
• Created detailed documentation comprising database administration procedures and troubleshooting documentation for co-workers in the group.
• Support application IT developers and application support staff in database related issues, and in troubleshooting and resolving database performance problems.
• MS SQL server installs and created linked servers to Sybase databases, setup jobs on MS SQL servers. Deploy MS SQL server code in production. Also tested MS SQL server 2008 database compression feature.
• Work with Sybase vendor in obtaining pricing and licensing costs.

Environment: Sybase ASE 12.5.4, ASE 15.0.3 Solaris 10, MS-SQL servers (2000, 2005), RedHat Linux

Confidential, New York, NY

Sybase Consultant

Client is a provider of risk measurement solutions for money management firms.

Responsibilities:

• Set up an ASE 12.5.3 instance on Linux, and migrated ASE 12.0 (Solaris) databases to the new environment. Setup replication between the old 12.0 and new 12.5.3 to segregate transaction processing from reporting.
• Involved in capacity planning, performance tuning, offer SQL tuning recommendations to developers, working with developers in analyzing and tuning query bottlenecks.
• Created utility scripts and documentation to ease day-to-day tasks (replication queue monitoring, rowcount comparision, extract exceptions, generate rs subcmp, find repdefs, etc)
• Implement MDA in production, and performance enhancing features like multiple tempdbs, cache partitions, cache bindings.

Environment: Sybase ASE 12.0, 12.5.x, RepServer 15, Solaris 2.5, SUSE Linux 2.6.5

Confidential, New York, NY

Sybase Consultant

The Confidential group ensures 24*7 availability of databases and support, working closely with Application development teams within the bank.

Responsibilities:

• Administer Production, UAT and development ASE/rep servers and MS SQL Servers.
• Build and configure ASE, MS SQL, Repservers, set up replication.
• Set up auditing and MDA tables.
• Provide on-call Confidential support for production and UAT ASE/Replication servers.
• Troubleshoot database performance and replication issues and offer SQL tuning recommendations to Application Build teams.
• Participate in Disaster Recovery testing drills.

Environment: Sybase ASE 12.5.x, RepServer 12.5, 12.6, Solaris 2.8, MS-SQL 2000, Sql-Backtrack

Confidential, New York, NY

Sybase Consultant

The Global Confidential team ensures a standard operating environment for all databases firm-wide, and is also responsible for distributing Confidential tools, interfaces, client software, UAT'ing, and supporting tools developed by database engineering.

Responsibilities:

• Provide DB infrastructure support within the Confidential organization.
• ASE, RepServer administration, performance tuning, capacity planning, maintenance of Production and UAT databases.
• Worked on projects to consolidate Sybase interfaces and maintain a single source of distribution for Client tools and interfaces.

Environment: Sybase ASE 12.0, 12.5.x, Solaris 2.5, 2.8

Client - Confidential, Long Island, NY

Lead Sybase DBA

Confidential is an Insurance company that underwrites high-risk insurance for private passenger and commercial automobiles. Managed production and development Sybase database servers for various applications used by Confidential .

Responsibilities:

• Installations/Upgrade of database servers to ASE 12.5.
• Perform full scope of administrative and monitoring tasks related to the management of databases.
• Administration, monitoring and troubleshooting the production environment.
• Develop, implement and maintain programs, scripts and routines needed to automate database administration.
• Database capacity planning, performance tuning, disaster recovery setup.
• Promote databases from development to UAT environment and production.
• Implement dataserver-level security, object access privileges.
• Participate in analysis, design, and migration projects.
• Support development and application support teams to fulfill database requirements.
• Perform query tuning exercises and address data access issues.

Environment: Sybase ASE 11.9.2.5, 12.5.0.2, HP-UX 11.0, RepServer 12, Veritas NetBackup

Confidential, New York, NY

Sr. Sybase Consultant - Migration Lead

(Migration, Performance & Tuning, Data Modeling, SQL Development)

Confidential is a web-based Futures & Options Clearing application that lets JPMorgan clients globally generate a variety of reports pertaining to trades and positions that clients clear through JPMorgan.

Responsibilities:

• Modeled and designed database for regulatory reporting application (Client Money).
• Developing stored procedures for processing dataflow into the system, integrity checks and report generation.
• Optimization (performance tuning) of trade reconciliation stored procedures to reduce execution time for large volumes of trades and positions.
• Lead in migration of Sybase servers from Sybase 11 and 11.5 to ASE 12. Documenting migration plan for production Sybase servers. Managing timelines for production cut-over.
• Identifying disk space requirements for new databases. Performing sizing for migrated databases.
• Identifying and addressing tuning and maintenance requirements.

Environment: Sybase 11, ASE 11.5, 12, Rep Server 11.5, 12, Erwin 4.0, Solaris 2.8