SUMMARY

• Database Systems and Application Support Engineer with a strong background and expertise in database design and development, administration, and operational support.
• Over 25 years of experience with proven analytical and technical skills in support of high performance business applications. Focus has been in teh Telecommunication, Pharmaceutical and Financial Industries.

TECHNICAL SKILLS

Operating Systems: HP - UX B.11.11, MS Windows XP/ NT/ 95/ 2000, Sun Solaris 2.x, Sun OS, Red Hat Linux, IBM AIX 4.1 - 3.2, OSF Unix 2.1 / Digital Unix 3.2.d

Databases: Sybase ASE 15.7, 15.5.x (64 bit), 12.5.x (64 bit), ASE 12.x, Sybase ASE 12.5.4 (Linux), SQL Server 11.x- 10.x, Replication Server 15.6.x, 12.5.x & 11.0.x, MSSQL Server (ver. 2005, 2008, 2008R2, 2012), CA Ingres 2.6, Ingres 6.4, Oracle Financial 9.x

Database Tools: Idera 7.5 - DBArtisan - Rapid SQL, PowerBuilder, ERWIN, ModelMart, iWatch, WebLogic

Hardware: HP 9000, Sun E4000/Blade 1000 / SunFire Series/ UltraSparc, Dell Series, Fujitsu PrimePower 650, IBM RS/6000, IBM AS/400, DEC 3000/600 - 2100 5/250

Software: SQL, Borne & K Shell, MS Outlook 2007, MS Access 2003, MS Excel 2003, AutoSys, Remedy 7.6, Symantec VCS, eXceed, MindAlign, MS Windows, Sharepoint, MS Lync 2010, Tivoli Storage Manager, PERL, MS Visual Basic, PVCS, Visual SourceSafe, IT Central (ServiceNow), Open Air (Resource Management).

Network Storage: IBM SAN, HDS SAN

Backup Software: NetBackup Client, Omniback, IBM Tivoli Storage Manager, SQL BackTrack

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Consultant / Senior Sybase DBA

Responsibilities:

• Technical member of teh Application Database Administrator (ADBA) team, providing Sybase support for all teh Sybase based Applications supported and maintaining Application SLA’s (Service Level Agreement’s).
• Experience with installing and upgrading Sybase software - 12.5.x to 15.x. with teh noledge in migrating Sybase databases from Solaris and AIX to Linux.
• Sybase Replication Server experience.
• Work closely with teh developers performing query analysis and Performance and Tuning.
• Routine tasks included monitoring of Sybase Database Servers including Replication Servers, capacity management, running disaster recovery procedures and maintaining database consistency checks, backups and daily maintenance reports.
• Responsible for system availability (24x7) for teh Production Support environment on a rotational basis.
• Unix Shell (Borne, K-shell, Csh) scripting expertise.

Confidential, New Jersey

Consultant / Senior Sybase DBA

Responsibilities:

• Primary database support engineer for mission critical IVR system which was used for patient screening, patient randomization, drug assignments, drug supply management, patient diary and other clinical trial functions.
• Responsible for system availability 24x7 and successfully maintained a 99.95% uptime SLA.
• Supported five Sybase 11.x environments - Production/Training, DSS, Validation, Development/Test and Disaster Recovery
• Routine tasks included monitoring of Sybase Database Servers including Replication Servers, performance tuning, capacity management, security reviews and upkeep, database consistency checks, backups and daily maintenance reports.
• IVRS application support tasks included rollouts of new IVRS study’s and/or teh modifications to existing study’s using teh Sybase SQL Server database and Replication environments.
• Maintained a clinical study archive of more than 1500 completed studies per FDA regulations.
• Authored all support related Standard Operating Procedures (SOP’s) associated with teh IVRS environment.
• Primary end user support resource for a global operation, including Operating System, Database and Application support.
• Participated in broader IT Disaster Recovery tests and maintained associated IVRS DR plan documentation.
• Participated in teh virtualization project (V2V) to migrate teh Early Development’s business unit - Materials Tracking laboratory application to teh co-location facility. Sybase version - ASE 11.5.1.1.
• Provided technical support for teh global Employee Repository and teh Payroll Application. Data was synchronized between teh US and UK utilizing Sybase ASE 12.5 and Replication Server 12.5.
• Assisted teh Microsoft SQL Server (ver.: 2005, 2008, 2008R2, 2012) team as a secondary DBA as needed.
• Engineered a ETL solution for a centralized data repository called teh Legal Entity Reference Data Hub (LEXI). Teh LEXI process is used to capture referential data elements - general ledger, branch, tax, treasury and country codes. Some of teh designated Data Sources which were used are ASE Database Server’s (12.5.4 Linux), MSSQL Server’s,(2000), MS Excel (2003) and MS Access(2003) to load teh referential data into a single data warehouse.
• Teh hardware platform used was Sun Blade 1000 and OS was Red Hat Linux.
• Coordinated and managed Sybase server builds and teh data migrations. Environments were developed using ASE Server (12.0, 12.5.3), Veritas HA software, DBArtisan, and Rapid SQL. CA Autosys was used to schedule standard maintenance jobs and IBM TSM technology was used for backups.
• Provided “Follow-teh-Sun” Sybase production support using iWatch and Remedy to identify and track problems, and perform changes, and service level management applications.
• Built timings metrics and reports for senior management.

Confidential, NY

Vice President / Senior Sybase DBA: Senior member teh DBA Group for Investment Banking and Securities Division

Responsibilities:

• Developed a toolset for DBA functions that drove operational support efficiencies. Toolset was comprised of KSH, CSH, Perl and third party packages.
• Provided Sybase Server technical support and consulting to Fixed Income developers and end-users for new projects. Tasks included creating design specifications, data models, standards, naming conventions, sourcing, data feeds and refining teh conceptual design requirements into a technical design and logical database design.
• Implemented teh Veritas Storage Foundation for Sybase, incorporating teh High Availability Veritas Cluster Servers and Hitachi SANs for automatic application failover and data protection.
• Administered MS SQL 2000 Servers including teh installation, configuration, backup and recovery, security, troubleshooting performance issues and monitoring teh multiple MS SQL Server’s instances.
• Performed review, analysis, and fine-tuning of teh stored procedures and DTS packages.
• Provided principal support for teh Fixed Income Mortgage Backed Securities Allocation application which interfaces with teh Government and Repo desks.
• With teh use of ERWIN - a data modeling tool, reverse engineered teh Fixed Income databases in a graphical format to identified opportunities for data architecture and design improvements.
• Supported global project to upgrade of Sybase SQL Server 4.9.2 to 11.0.3. for teh Equities-Security Lending group. Components included UltraSparc 2 (Sun OS 4.1.3) to E4000 (Solaris 2.5).
• Standardized scripts, binaries and database objects utilizing SCCS, throughout NY, London, Hong Kong and Tokyo.
• Performance Tuning and Index analysis on teh newly migrated Security Lending application.
• Created and maintained Development, QA, Staging and Production SQL Server environments, which included over 100 databases two RS/6000’s.
• Performed all DBA responsibilities included allocation of raw partitions and disk allocation strategy, creation of database devices & segments, fine tuning and server monitoring, maintained user accounts, roles and permissions, and general server monitoring.

Confidential, NY.

Consultant / Sybase DBA

Responsibilities:

• Developed a Contact Management System for teh Affiliate Sales Group which maintains any and all of teh affiliate information for all of teh cable network systems.
• Used UNIX shell scripts, FTP, AWK, Sybase stored procedures and ISQL on teh RS/6000 platform.
• Upgraded from SYBASE SQL Server 10.0.2.4 to SQL Server 11.0.1.
• Trained staff on SYBASE SQL Server, naming conventions, applications standards, general SQL guidelines, use of stored procedures, message & error reporting, performance considerations and applications architecture.
• Provided technical expertise to teh Global Securities Services groups which were experiencing application performance problems resolving multiple technical issues.
• Supported upgrade from SYBASE SQL Server 10.0.2 to SQL Server 11.0.x.
• Co-designed teh system architecture implementing phase one of teh Securities Pricing System for teh Debt Markets group.
• Responsible for teh following tasks: database programming (SQL & PERL), server and database installation, performance tuning, index analysis, memory structures, new development, system integration, logical data modeling, physical data modeling, media balancing (segmentation), database re-engineering, capacity planning, DBCC’s, backup utility by DataTools (SQL-Backtrack), development of operational technical procedures and security. Teh system was running on teh SUN/OS (4.1.3) platform, networked to multiple Sparcstation 20’s utilizing SYBASE SQL Server (4.9.2 & 10.0.2). Borne & K-Shell and DWB.