Sybase Database Administrator
with Oracle and MS SQL Server

Summary:

More than 15 years experience in database design, development and implementation including most recently, experience with Sybase using up to version 15 of Sybase. Full life cycle application development. UNIX shell scripting using Bourne and C shells. Strong written and oral communications skills as well as analytical abilities.

Highlights of expertise:

• Successful track record in dealing with all facets of relational database administration and technology with focus on Sybase Adaptive Server Enterprise Technology including Replication Server.
• Extensive experience with database design, development, production steady state support and performance tuning.
• Capable in database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Logical and physical database design for optimum performance.
• Proven experience with database performance and tuning techniques to enhance database optimization plans, configuration management, space planning, database modeling and design and dataserver configuration parameter settings.
• Installed, upgraded and patched multiple versions of Sybase ASE and Sybase Replication Server. Upgraded from Sybase version 12.5.4 to 15.5. Migrated from Sybase version 12.5.4 to MS SQL Server 2008.
• Worked on Sun Solaris, AIX, and Red Hat Linux platforms.
• Experience in high availability and disaster recovery solutions.
• Worked closely with third-party vendor for software releases. Coordinated database maintenance with application support teams.
• Highly adept at performance tuning at both the dataserver level as well as the database level.
• Assisted SQL coders in increasing the speed to retrieval of result sets and in processing data faster.
• Deployed a multitude of database changes to Development, User Acceptance Testing, System Integration Testing, and Production environments hundreds of times, conforming to change control requirements.
• Reviewed and optimized other's code during Database Engineering Code Review Meetings.
• Installed and verified dataserver upgrades and patches.
• Prepared deployment documentation and requested management approvals per Change Control Process.
• Knowledge of Sun UNIX/Solaris platforms, HP platforms, AIX platforms, Linux platforms, and Windows platforms.
• 10 years of experience in coordinating efforts of team members in order to deliver projects according to plan.
• Performed cost analysis for reducing the costs of dataservers and massive amounts of storage to save more than $350,000 in payables.
• Identified high risks and took actions to avert or mitigate adverse impacts under various scenarios.
• Participated in Engineering Review Board Meetings and Product Review Board Meetings to ensure that the proposed solution was optimum.
• Provided input and proposed solutions during system design meetings.
• Worked overnight and on weekends to ensure work completion and system functionality.
• Managed product development and releases, coordinating activities with Application End-User Groups, Development Teams, Configuration Management Department, Testing Department, and various Production Support / System Administration Departments.
• Ability to work effectively in a team environment and collaborate with others focused on business priorities. Adept at prioritizing requests and advancing long-term projects throughout the day to meet business objectives.
• Successful track record at global financial services institutions including Barclays Capital and Prudential.

Sybase Adaptive Server Enterprise capabilities (up to version 15):
Installation, configuration, setup on Sun Solaris platform. Support and maintenance. Backup and recovery. Failover strategy & disaster planning. Security and permissions. Performance tuning. Referential integrity maintenance. Index structuring. Utilized bulk copy utility. Management of batching for complex transactions. Utilized capabilities of optimizer.

Sybase Replication Server capabilities (up to version 15):
Installation (on Sun Solaris).
Configuration including changes to default parameter settings.
Definitions for replication of tables, stored procedures, and hybrid replication.
Subscriptions, publications, articles.

Oracle and Microsoft SQL Server:
Secondary support and maintenance in these environments.

Database SQL Programming:
Application Development Team Leader for large, complex Web development project with back-end database at Lockheed Martin Mission Systems.

Database Design, Development, and Product Release:
data mapping, physical and logical database design in a complex schema, business rules, stored procedures, triggers, cursors, system integration testing under replication, data archiving, error processing, installation support for production system, post-installation modifications for production system

EXPERIENCE:

Confidential 1/08 - Present (assignment)
Production Support DBA (24/7). Maintained and troubleshooted instances of Sybase Adaptive Server Enterprise and Replication Server on AIX hosts which were part of TriZetto's Facets application as well as Oracle and MS SQL server systems for Workers Compensation system. Performed backup and recovery using BMC's SQL-BackTrack onto IBM's Tivoli Storage Management system. Changed configuration parameters of dataservers to increase speed of result sets using sp_sysmon, other utilities for stored procedure analysis, and general performance tuning guidelines. Performance tuned both ASE (at the levels of both the server-and the database) to optimize performance for real-time transaction processing, batch (overnight) processing, and database maintenance work. Replicated data to IBM's DB2 UDB and troubleshot transaction problems. Archived data. Provided information used in capacity planning for the live production system and the data archive.

Confidential 3/2007 - 9/2007 (assignment)

Production Support DBA (24/7). Troubleshot production problems. Migrated changes to large, complex production environments, coordinating with a multitude of departments. Created scripts to automate database refreshes involving the transfer of subsets of data. changed configuration parameters of dataservers to optimize performance.

Confidential 10/2006 - 12/2006 (assignment) 
Troubleshooting problems with dataservers in a complex, heterogeneous environment.

Confidential 3/2006 - 10/2006 (assignment) 
Production Support DBA (24/7). Migrated Sybase Adaptive Server Enterprise and Sybase Replication Server from version 12 to version 12.5 on a Sun Solaris platform. Configured parameters for optimum performance of the Servers. Maintained and troubleshooted existing instances of ASE and Replication Server. Performance tuned both ASE (at the levels of both the server-and the database) as well as Replication Server. Created replication definitions and subscriptions. Performed backups and loaded new database instances. Monitored overnight batch jobs and dumps. Archived data into a data warehouse. Transferred subsets of data into new databases. Increased database size and cleared directory space as needed. Controlled access. Audited database use. Performed DBA work associated with quarterly releases of new software which accessed data from multiple dataservers and databases. Utilized Unix utilities for Sybase. Wrote Unix shell scripts to automate tasks. Troubleshooted Sybase Open Client problems.

Confidential 2/2002 - 3/2006
Production Support DBA & development work was performed associated with ongoing maintenance of Sybase ASE versions 12 and Sybase Replication Server versions 12. Backup and recovery. Failover strategy & disaster planning. Security and permissions. Performance tuning. Referential integrity maintenance. Index structuring. Utilized bulk copy utility. Utilized capabilities of optimizer. Wrote SQL code.

Confidential 1/2000 - 11/2001
Production Support DBA (24/7) to enable the smooth operation of the day-to-day activities of the investment bank. Providedglobal as well as local support for database systems in a Sybase replicated environment and also a Microsoft SQL environment. Management of batching for complex transactions. Installation, configuration, setup on Sun Solaris platform. Created and scheduled autosys jobs.

Senior Sybase Engineer 
Confidential 9/1998 - 3/2000
Defense Information Systems (assignment)
Sybase Adaptive Server 11.5; Sybase Replication Server 11.5
5,000 database objects, production environment of 65 gigabytes replicated across 4 nodes in two geographic sites

Project:Global Air Transportation Execution System (GATES), an interface which is part of the Global Transportation Network (GTN), a logistics management system which is valued at $1.4 million.

Customer:United States Transportation Command (USTRANSCOM)

Summary of activities:

Team lead of Sybase Developers.
Data mapping, physical and logical database design in a complex schema, business rules, stored procedures, triggers, cursors, system integration testing under replication, database administration, data archiving, error processing, installation support for production system, post-installation modifications for production system

Replication: 
Assisted with work associated with creation of replication definitions and subscriptions, creation and mapping of function strings, and user-defined functions. Re-started data queues on Replication Server which had stopped due to errors. Monitored Replication Server.

Database Design, Development, & Administration: 
Modified schema to create new columns and tables to properly relate entities which were previously unstored in such a way as to allow for a high speed of retrieval of query results. Created a multitude of stored procedures to process the data feed in a replicated environment as well as having created tables, indexes, and keys. Worked with the processing performed by triggers to ensure that they were fired in all necessary cases. Re-considered the means of data archiving and worked on the data archiver. Created cursors as part of the database testing phase in order to run a multitude of specified cases to ensure that no erroneous processing occurred. Participated in code modifications for an error processing tool used by the customer. Used the bulk copy utility (bcp) to load the database with large amounts of data. Set permissions for accessing data. Utilized showplan, forceplan, statistics io, and statistics time to optimize code. Selectively introduced data redundancy to speed the return of query results.

Data Modeling & Schema Design Tools: ERWin Data Modeler, Sybase PowerDesigner Data Architect
Reporting Tool: Crystal Reports

System Integration & Testing: 
Participated in and coordinated activities related to system integration testing for the replicated system. Made modifications to correct processing. Performance tuning. Created UNIX shell scripts in order to run tests automatically and to perform routine tasks such as re-creating the database. Worked in a system environment under the control of configuration management systems. Involved in code modifications through several rounds of system integration testing in a replicated environment through to the final Customer Acceptance Test.

Tools:
Change & Configuration Management / Version Control: Rational Clearcase

Installation Support:
Provided the installation instructions for the main release, the release of patches, the version description document, and the data archiver for the database code. Provided support during the installation on the live production system which included working on weekends and late into the evening.

Product Reviews:
Participated in Peer Review meetings (about 30 reviews) by reviewing code and providing feedback as to corrections and improvements for other projects as well as our own. Represented the GATES project team as the expert on the details related to the database code in Engineering Review Board meetings and Product Review Board meetings.

Quality Assurance: 
Ensured that the entire team followed all necessary processes and procedures which were streamlined. Both the quality of our code as well as its associated documentation and the timeliness of our delivery of the product to our customer, the United States Transportation Command (USTRANSCOM), were commended by the Quality Assurance department which audited us several times.

Miscellaneous: 
Provided information used in capacity planning for the live production system and the data archive.

Confidential 9/1988 - 9/1998
(most recent work is described below)

Sybase SQL Server Administration for Versions 10 and 11:

Upgraded from Sybase version 10.x.x to 11.x.x
Installed and configured SQL Server 11.0.x (UNIX & NT) for production, warm-backup, development/test, as well as disaster recovery.
Set up UNIX shell scripts and cron jobs to perform the database administration activities for each server.
Examined error logs throughout each day to ensure servers were running at optimal levels.
Verified each morning that the databases were properly dumped the night before in order to maintain up-to-date backups.
Monitored growth of databases and altered their size when the amount of available free space was low.
Added/removed users from the Sybase servers and user databases to maintain security.

Performance & Tuning:

Troubleshooted and corrected performance problems by performing a variety of diagnostic checks or further utilizing the capabilities of the Sybase Server to improve performance:

Optimizing performance to reduce the limitations of I/O, CPU, networking, or screen delay.
Searched for suspended processes on the UNIX level.
Examined the setup and configuration of the Sybase server.
Placed the tempdb database in memory to reduce disk i/o.
Worked with developers to decide which tables/indexes of a database to place in memory.

Database Design / Development / Administration:

Creating and using tables, primary and foreign keys, indexes, views, stored procedures, cursors and triggers as well as maintaining referential integrity.
Mapping of database to proposed new business process to ensure accounting for all the data.
Adjusting database design selectively to a denormalized form to improve speed of information retrieval yet still avoid modification anomaly.

UNIX Shell Scripting:
Korn, Bourne, Bourne Again, C shells used to convert files to appropriate formats. Pattern matching; editing (vi, sed); awk scripting language for processing databases fields; formatting text files using nroff & troff; Source Code Control System to track revisions.

Education:
Confidential, Bachelor of Engineering, May 1986
Confidential, Post baccalaureate Program in Computer Science.
Project Management Certification: Passed the examination for certification as a Project Management Professional (PMP) given by the Project Management Institute (PMI), 1998.