Information Technology Software Development

Tomy Abraham

**** * ***** ***** ***. Valrico, FL 33594

518-***-**** ***********@*****.***

Professional Summary

Oracle Database Administrator with over 10 years of experience, specializing in Oracle Exadata environments. Proficient in RMAN, Data Guard, Datapump and RAC technologies. Strong background in SQL and Linux/Unix scripting, with extensive knowledge of database structure and design. Over 15 years of experience in writing stored procedures and triggers, along with a deep understanding of the Software Development Life Cycle. Excellent analytical, problem-solving, communication and logical thinking skills, with the ability to quickly learn and adapt to new technologies and processes.

Key Skills

Oracle Database Administration

Oracle Exadata

Performance Tuning

Backup and Recovery (RMAN)

Data Guard and RAC

SQL and PL/SQL

Datapump

Unix/Linux Scripting

Database Design and Structure

Client-Server Applications

Stored Procedures and Triggers

System Analysis and Design

Software Development Life Cycle

Analytical and Problem-Solving Skills

Communication skill

Adaptability to New Technologies

Professional Experience

Information Technology Specialist 4 (Oracle DBA)

New York Statewide Financial System (SFS)

August 2017 – June 2025

Monitored and tuned 50+ Oracle databases, responding to errors and alerts, and reviewing logs.

Coordinated with Oracle support to document solutions and perform software installation, patches, and upgrades.

Managed backup and recovery, user account maintenance, and the creation/maintenance of system-level and schema-level database objects.

Installed, configured, and administered OEM, ASM, RAC, RMAN, Oracle Data Guard, and Oracle Clusterware.

Reviewed database data and log files for growth, managed appropriately, and created/maintained procedure documentation.

Environment: Oracle Enterprise Edition 19c, Oracle Exadata, Oracle SQL Developer, Oracle TOAD, AIX, UNIX, Linux.

Information Technology Specialist 3 (Oracle DBA)

State of New York Office of the State Comptroller (OSC)

October 2016 – August 2017

Monitored and tuned Oracle databases, responding to errors and alerts, and coordinating with Oracle/OSC support.

Managed software installations, patches, upgrades, backup/recovery, and infrastructure requirements.

Created and maintained system-level and schema-level database objects, custom scripts, and shell scripts.

Installed, configured, and administered OEM, ASM, RAC, RMAN, Oracle Data Guard, and Oracle Clusterware.

Assisted developers in identifying, analyzing, and tuning problematic SQL in applications and reports.

Environment: Oracle 11g, Oracle SQL Developer, Oracle TOAD, AIX, UNIX, Linux.

Information Technology Specialist 3 (Oracle DBA)

NY State ITS/NYBE Project

April 2014 – October 2016

Monitored and tuned Oracle databases, responding to errors and alerts, and coordinating with Oracle/ITS support.

Managed software installations, patches, upgrades, backup/recovery, and infrastructure requirements.

Created and maintained system-level and schema-level database objects, custom scripts, and cron jobs

Installed, configured, and administered OEM, ASM, RAC, RMAN, Oracle Clusterware.

Assisted developers in identifying, analyzing, and tuning problematic SQL in applications and reports.

Environment: Oracle 11g, Oracle SQL Developer, Oracle TOAD, AIX, UNIX.

Information Technology Specialist 3 (Database programmer)

NY Statewide Financial System (SFS)

November 2010 – April 2014

Assisted in implementing system configuration changes and validating requested changes.

Supported the SFS Configuration Management System, including implementing and testing conversion programs and data.

Established and enforced standard policies and procedures for enterprise-level master data management.

Assisted with the classification and control of data, risk management, and risk mitigation.

Provided technical support for all SFS program areas and supported management in routine project responsibilities.

Environment: PeopleSoft 8, Oracle 11g, Oracle SQL Developer, Oracle DataMover, Oracle TOAD, WinSCP.

Information Technology Specialist 3 (Database programmer)

NY State Workers’ Compensation Board

March 2001 – November 2010

Designed and developed applications for internal use, using PowerBuilder and various versions of Sybase ASE.

Developed stored procedures and triggers to support performance measure systems and database design/modeling.

Managed ad-hoc requests, application migration efforts, and the development/maintenance of performance reports.

Provided user training and support, and optimized database queries.

Environment: Sybase ASE, PowerBuilder, MS Windows, ErWin, MS Visio.

Information Technology Specialist 2

NY State Workers’ Compensation Board

March 1998 – March 2001

Developed small applications and co-developed an application named DBDC using PowerBuilder.

Migrated PowerBuilder applications to higher versions and supported ad-hoc data requests.

Developed performance measure reports for MIRROR.

Environment: PowerBuilder, Sybase, MS Windows.

Information Technology Specialist 1

NY State Workers’ Compensation Board

September 1997 – March 1998

Supported ad-hoc data requests and developed stored procedures using operational databases.

Environment: PowerBuilder, Sybase, MS Windows.

Contact this candidate