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.