We provide IT Staff Augmentation Services!

Sr. Oracle Developer Resume

0/5 (Submit Your Rating)

Ny, NY

SUMMARY:

  • Over 30 Years Experience in Information Technology 18 Years as Oracle Developer Managed Teams and Led High - Profile Projects to Successful Results Earned Promotions for Exemplary Performance
  • Accomplished, outcome driven software developer with a proven track record in successfully leading challenging project development to full production life cycle.
  • Ability to achieve results in a dynamic, fast paced work environment.
  • Self-motivated, reliable & loyal employee who utilizes team-oriented approach in attaining project goals.

TECHNICAL SKILLS:

Database: Oracle 10g/9i/8i/7; MySQL (Brighthouse & MyISAM engines); Postgres

Programming Languages: PL/SQL; Unix Shell (C,Bash,Korn); Perl; Java; Pro*C; C/C++; Fortran 77

Tools: OEM; SQL*Plus; SQL*Loader; ETL; AWR; BulkLoader; Data Modeler

Operating Systems: Solaris 10; Windows XP; Linux SUSE/RedHat;

Productivity Tools: TOAD; PLSQL Developer; Pentaho 3.5 ETL & BI; Eclipse; SVN; SCCS

PROFESSIONAL EXPERIENCE:

Confidential, NY, NY

Sr. Oracle Developer

Responsibilities:

  • Responsible for enhancements to Assets Under Management system. Coding is done using PL/SQL Stored Procedures.
  • Set up plan for migration to QA environment for full regression testing.
  • Rewrote Unix Shell Scripts for migration of Ariba system to internal environment.

Confidential, Jericho, NY

Sr. Oracle Developer

Responsibilities:

  • Developed applications for the Executive Committee, Compliance, Accounting and Trade Support departments. Programs were written in PL/SQL, Perl, and Unix shell scripts.
  • Re - engineered file structures, database table definitions, data file transfers and processes for conversion to new Back Office Clearing firm.
  • Developed PL/SQL procedures to calculate Trader s commissions, and compensation. Other procedures written include adjusting positions per Corporate Action, and automating position reconciliation.
  • Developed and tuned PL/SQL packages to efficiently process trades for risk management and clearing to Prime Broker. Real-time database has successfully processed up to 4% major market total daily volume without latency.
  • Developed, in Perl, web-based dash board application for monitoring trade load latency, illegal short sale alerter and custom reports for SEC audit requests.
  • Developed regulatory required report for Best execution in Perl. It is used to evaluate firm s executed price against industry-wide executions.
  • Managing hands-on technical activities for database development team. Reviewed and deployed all updates to applications and database objects.
  • Developed triggers for table auditing, and materialized views for data consistency across different databases.
  • Responsible for Oracle 9i/10g logical and physical database designs, implementation and maintenance.
  • Optimized memory configuration by tuning the SGA with Shared Pool (Library, Dictionary and Buffer Pool caches). Configured Keep Pool to maximize pinned objects in memory.
  • Re-engineered real-time production database for migration from local disk storage to Fibre channel on SAN.
  • Developed Unix Shell scripts to automate all database operations including monitoring tablespace usage, nightly backups, performance with Statspack, and syncing of backup and test databases.
  • Provides on - call production database support 24/7.
  • Administered database security by granting roles and privileges to users. Incorporated VPD for security for users querying the database over our intranet.
  • Managed Data Warehouse used for historical reporting for Management, SEC audits for Compliance, and trends for Quantitative Analysts.
  • Utilized Pentaho 3.5 ETL to migrate Oracle Data Warehouse to MySQL Brighthouse engine DB.
  • Successfully shutdown and migrated History Data Warehouse DB to MySQL via ETL tools.
  • Cited with for redesign of DB trade load process when volume exceeded initial requirements.
  • Wrote early warning mechanism in Perl for alerting Compliance of illegal short sale trades.
  • Played key role in designing, coding data transfers for conversion to new Back Office firm.

Confidential

UNIX Project Leader/DBA

Responsibilities:

  • Achieved goal of 50% IT cost reduction by shutting down mainframe data center in favor of distributed UNIX environment supporting Oracle and C programming.
  • One of 2 employees chosen to represent Grumman at Westinghouse for $16M project.
  • Full production accomplished to automate machine tool data to shop floor network.

Confidential

Programmer

Responsibilities:

  • Participated in the design, programming, testing and implementation of the Individual Life maintenance system. Responsible for original program coding in COBOL and JCL.

We'd love your feedback!