SUMMARY

• Senior Database Administrator with extensive experience in critical production and development/testbed environments. Highly skilled in global implementation and support initiatives involving heterogeneous database systems. Hands - on experience leading all stages of database development efforts, including requirements definition, design, testing and integration. Key strengths include:
• Oracle 19c/12c/11g/10g & Oracle RAC installation and maintenance.
• Oracle replication involving DataGuard and Snapshot replication.
• Backup and recovery expertise utilizing RMAN and OS/Hardware solutions.
• MySQL installation and administration.
• Sybase ASE 15 database administration and performance tuning.
• Logical and physical database design.
• Extensive business continuity / disaster recovery expertise.
• 24x7 production support for high availability Very Large Database (VLDB) servers.

TECHNICAL SKILLS

Operating Systems: Linux, Microsoft Windows.

Database Systems: Oracle 19c/12c/11g/10g, MySQL v5.5-v8, MS-SQL, Sybase ASE

Languages: Linux Shell Scripting, Transact-SQL, PL/SQL.

Tools: DB-Artisan, Oracle Enterprise Manager (OEM), Oracle Grid Control, SQL*Plus, SQL*Loader, RMAN, MySQL Workbench, SQL Server Management Studio, Microsoft Office.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior Database Administrator

Responsibilities:

• Support multiple development groups utilizing Oracle, MySQL & MongoDB database platforms.
• Implement & administered DataGuard and snapshot replication on Oracle database systems for HA & DR capabilities.
• Responsible for database migrations from Oracle 11g to 18c & 19c utilizing multiple pluggable databases (PDB) per container database (CDB).
• Participated in database server moves between datacenters.
• Provide 24x7 Production and Development support for Oracle, MySQL & MongoDB database systems.
• Responsible for all aspects of database maintenance; installation, patching, migrations, upgrades and tuning.

Confidential, Ledgewood, NJ

Director, IT Operations

Responsibilities:

• Managed installation & technical support groups providing on-site and remote access customer support.
• Participated in high-level weekly, monthly and quarterly meetings with the CEO in order to provide strategic advice and input to specific projects.
• Occasionally attended selected trade shows and sales meetings to develop client relations.
• Managed a team of technicians and developers responsible for migrating stand-alone customer MS-SQL databases onto replicated AWS cloud computing infrastructure.
• Responsible for the workflows between development & technical support groups involving application enhancements, testing and production implementations.
• Responsible for interviewing, hiring and training of new technicians and developers. Provided ongoing coaching to meet productivity and support goals.
• Established service level agreements and metrics while making infrastructure changes when needed to improve performance.
• Developed internal processes and procedures to ensure maximum uptime while minimizing technology disruptions.

Confidential, New York, NY

Manager, Database Administration

Responsibilities:

• Managed DBA groups located in US & UK supporting Price & Reference Data (PRD) products.
• Supervised and supported database environments running Oracle RAC, MySQL and Sybase ASE. Responsibilities included schema design, database installation and generation, development & production support, performance tuning, backups and upgrades/patching.
• Responsible for the migration of all PRD Oracle, MySQL & Sybase database systems to new primary and secondary data centers in order to achieve cost saving initiatives.
• Managed multiple projects to upgrade Oracle RAC databases from 10g/11g to 12c & MySQL 5.5 to 5.7
• Coordinated the production rollout of all PRD database releases from various development groups, attaining 100% success rate across all supported database platforms.
• Collaborated in the deployment & administration of Oracle Exadata database systems and provided support to development groups launching new applications on the Exadata platform.
• Provided 24x7 Production and Development support for Oracle, MySQL & Sybase database systems.
• Conducted scheduled business continuity and disaster recovery tests to ensure minimum data loss and product outages.

Confidential, New York, NY

Manager, Database Programming & Operations

Responsibilities:

• Managed DBA groups located in US & UK supporting company’s Price & Reference Data products.
• Designed, implemented & administered Data Warehouse utilizing Sybase IQ & ESP technologies.
• Supported multiple development groups utilizing Oracle RAC, MySQL & Sybase database platforms.
• Responsible for the creation and maintenance of MySQL Production, QA & Development database systems housing Corporate & Reference data.
• Provided 24x7 Production and Development support for Oracle, MySQL & Sybase database systems.
• Deployed Oracle Enterprise Manager (OEM) to monitor all Production and Development Oracle & MySQL databases.
• Created multi-node Oracle RAC clusters utilizing Active DataGuard to satisfy high availability (HA) requirements for critical financial applications.

Confidential, New York, NY

Senior Database Administrator

Responsibilities:

• Supported multiple development groups utilizing Oracle, MySQL, MS-SQL & Sybase database platforms.
• Implemented & administered snapshot replication on Oracle database systems for HA & DR capabilities.
• Planned & forecasted CPU, disk and network capacity for server and database environments.
• Provided 24x7 Production and Development support for Oracle, MySQL & MS-SQL database systems.
• Responsible for all aspects of database maintenance; installation, patching, migrations, upgrades and tuning.

Confidential, Hauppauge, NY

Lead Database Engineer

Responsibilities:

• Managed the production rollout of all Fixed Income application and database releases from various development groups, attaining 100% success rate.
• Instrumental in building and maintaining Business Continuity / Disaster Recovery site in Geneva, for master Fixed Income database based in New York, minimizing product risk.
• Ensured the successful integration of newly acquired company, by building test environments, which allowed data analysts to validate business logic and content.
• Collaborated in the design and implementation of Sybase and Oracle database systems, utilizing off-the-shelf and in-house replication technologies.
• Designed trigger based auditing & reporting capability in order to capture external client server usage, allowing product groups to analyze and update client-pricing schemes.
• Involved in the database upgrade from Oracle v8.1.7 to v10.2.0.2.
• Planned & forecasted CPU, disk and network capacity for server and database environments.
• Provided 24x7 Production and Development support to multiple On-shore/Off-shore projects.

Confidential

Database Administrator

Responsibilities:

• Installed, maintained and upgraded multiple Sybase SQL Server environments for both Development and Production organizations.
• Provided 24x7 support, performance monitoring and tuning for all production Sybase databases.
• Migrated Sybase Development & Production database servers from version 4.9 to System-10 and System-11.
• Assisted in the migration of database applications from VAX/VMS to Alpha OpenVMS.
• Managed replication of Fixed Income data from Sybase databases to flat file systems using Sybase OMNI Connect gateway.
• Created, tested and implemented system & database releases for development and production environments.

Confidential

Systems Administrator

Responsibilities:

• Created and implemented system and database backup strategies, ensuring the safety of all development work and data. These strategies were later adopted for Production Support.
• Participated in the initial launch & synchronization of a relational Fixed Income database, with replicate sites in New York, London and Tokyo utilizing VAX/VMS and Sybase SQL-Server technologies.