SUMMARY:

More than 12 years experience in database design, development implementation, and production support including up to version 15.7 of Sybase Adaptive Server Enterprise and Replication Server on Unix (Linux, Solaris, AIX, HP - UX) platforms. Additional dataservers with which have background include Oracle Database up to version 11G and MS SQL Server up to version 2012 .UNIX shell scripting. 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 on Sybase Adaptive Server Enterprise (ASE) dataservers and Sybase Replication Server (RS).
• Extensive experience with database design, development, production steady state support, capacity planning, performance tuning, backup and restore, database maintenance jobs, database links, account management, and disk replication utilities.
• Installed, upgraded and patched multiple versions of Sybase ASE and Sybase Replication Server. Upgraded from Sybase version 12.5.4 to 15.0 and then 15.3, 15.5 and 15.7 several times.
• Extensive Sybase Replication Server experience including defining replication and materializing data in both homogeneous and hetereneous replication systems using Enterprise Connect Data Access middleware. Monitored queues. Upgraded systems. Knowledge of tuning Replication Server. Deployed High Availability systems using Replication Server.
• Extended databases storage. Planned storage to accommodate anticipate capacity changes.
• Handled Trouble and Incident tickets in problematic systems. Monitored performance. Used DBArtisan, sp sysmon, MDA scripts which I created, Foglight, and Spotlight.
• Extensive UNIX shell scripting in C, Korn, and Bourne shells.
• Experience in high volume, large - sized online transaction processing systems.
• Implemented backup and recovery procedures. Created copies of Production databases for use by Development and Quality Assurance teams.
• Backed up databases using Oracle RMAN, NetBackup, and Sybase native dumps.
• Installed and patched Oracle Database including security patches.
• Utilized autosys and cron for job scheduling. Utilized svn and software packages for version control.
• Capable in database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Worked overnight and on weekends to ensure work completion and system functionality. Performed on-call duties.
• Installed and verified dataserver upgrades and patches.
• Worked closely with third-party vendor for software releases. Coordinated database maintenance with application support teams.
• Identified high risks and took actions to avert or mitigate adverse impacts under various scenarios.
• Provided input and proposed solutions during system design meetings.
• 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.

TECHNICAL SKILLS:

Sybase Replication Server and MS SQL Server also: Cloud, DBaaS, PostgreSQL, Greenplum, Cassandra, MongoDB, CouchDB

PROFESSIONAL EXPERIENCE:

Confidential

Sybase / Oracle Database Administrator

Responsibilities:

• Installed, upgraded and patched multiple versions of Sybase ASE and Sybase Replication Server. Upgraded from Sybase version 12.5.4 to 15.0 and then 15.3, 15.5 and 15.7 several times.
• Extensive Sybase Replication Server experience including defining replication and materializing data in both homogeneous and hetereneous replication systems using Enterprise Connect Data Access middleware. Monitored queues. Upgraded systems. Knowledge of tuning Replication Server. Deployed High Availability systems using Replication Server.
• Extended databases storage. Planned storage to accommodate anticipate capacity changes.
• Handled Trouble and Incident tickets in problematic systems. Monitored performance. Used DBArtisan, sp sysmon, MDA scripts which I created, Foglight, and Spotlight.
• Extensive UNIX shell scripting in C, Korn, and Bourne shells.
• Experience in high volume, large - sized online transaction processing systems.
• Implemented backup and recovery procedures. Created copies of Production databases for use by Development and Quality Assurance teams.
• Backed up databases using Oracle RMAN, NetBackup, and Sybase native dumps.
• Installed and patched Oracle Database including security patches.
• Utilized autosys and cron for job scheduling. Utilized svn and software packages for version control.
• Capable in database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Worked overnight and on weekends to ensure work completion and system functionality. Performed on-call duties.
• Installed and verified dataserver upgrades and patches.
• Worked closely with third-party vendor for software releases. Coordinated database maintenance with application support teams.
• Identified high risks and took actions to avert or mitigate adverse impacts under various scenarios.