Senior Oracle / Sybase Developer Resume New York City, NY - Hire IT People

SUMMARY:

Expert in both Sybase and Oracle. 17 years of experience of Sybase SQL(Version 15.7) and Unix Shell scripting, 7 years of Oracle(Version 11g) PL/SQL experience.
Extensive experience designing, developing, and maintaining wide variety of large - scale projects for financial market data databases.
Expertise in data modeling, coding, optimizing query performance, and troubleshooting.
Design, develop, and modify tables, indexes, primary / foreign keys, views, stored procedures, triggers, and functions to perform data loading, complicated data calculation, error handling, logging, and exception handling.
Superior analytical and problem-solving skills, fast learner, and capable of appropriately prioritizing tasks to meet objectives.

TECHNICAL SKILLS:

Strong Knowledge: SQL, isql, bcp, Embedded SQL, Cursor, SQL Advantage, PL/SQL, SQL Plus, Ref Cursor, SQL Loader, dynamic SQL, Oracle supplied packages, SQL Developer, Unix Shell scripting, sed, awk, C language and Lotus Notes

Basic Understanding: Java, XML, HTML, JIRA, Team Track, TOAD, Autosys and financial data

Operating Systems: Windows, Unix

Databases: Sybase and Oracle

Application and System Development: Backend client-server

EXPERIENCE:

Confidential, New York City, NY

Senior Oracle / Sybase Developer

Responsibilities:

Submitted 229 Lotus Notes releases and 15 JIRA releases throughout 17 years, all with high quality and without bugs.
Provided 24X7 production support of market data databases as key member, including EODHIST, chart databases, and Fundamental and Entitlement Replica databases.
Lead redesign and migration of Confidential Sybase databases owned previously by another department to Unix machines and Sybase SQL servers.
Reduced data delivering complication and sped up dumping and broadcasting FIDs to company’s main product, Confidential .
Converted and migrated IBES, Worldscope and Fundamental databases from Sybase to Oracle. Rewrote all programs using Oracle PL/SQL on a 2-year project as a major contributor.
Maintained and supported IBES/Worldscope/Fundamental Oracle databases and PL/SQL programs. Ingested new intra-day files from IBES and added several new functionalities. Provided support for product managers, data quality, and customers for data issues, reacted immediately to incoming requests, resolved issues, and gave detailed explanation for each case.
Designed and developed high-efficient Entitlement Replica Sybase databases. Created a process to wake up every 10 minutes to load delta files to update user entitlement changes. Provided multiple stored procedures for web applications to check user entitlements before displaying final products on the web.
Worked on complicated task of substituting 2 overlapping jobs for Beta calculation with much more efficient and high- performing option using Unix Shell scripting, C language, and Sybase embedded SQL. Finished flawlessly after detailed investigation, analysis, and complex design. Saved more than 1 hour of history job running time during nights.
Maintained and supported big history databases of Unix, C, and Sybase environment. Created stored procedures and triggers to calculate weekly / monthly open / high / low / close prices from daily prices. Utilized parallel calculation of price loading and history fundamental dumps to speed up processes.
Designed and developed Unix and C programs to load international corporate actions from security data company to history Sybase databases. Created stored procedures to retrieve data from databases to be displayed on CorpAction pages, including takeover / reorganization, split, and dividend.
Created Sybase stored procedures for UDAMAS tool that allowed data quality department to fix values for FIDs broadcasted from Confidential and for pricing data in tables of history databases.

We provide IT Staff Augmentation Services!

Senior Oracle / Sybase Developer Resume

New York City, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship