Sr. Oracle Developer Resume Profile, NC - Hire IT People

SUMMARY:

Sr. Oracle Developer, Data-Architect/Modeler and Application DBA specializing in performance-based, scalable, big-data, database solutions supporting high-availability, low-latency web-clients as well as CPU/IO-intensive ETL processes using both ETL tools Informatica, etc. and shell-scripting. Heavy focus on development and optimization of SQL PL/SQL, stored procedures, functions, tables and indexes. Also proficient in 'Big Data' using Oracle's Exadata appliance.
Heavy experience in design and implementation of enterprise Data Warehouse solutions throughout full project life-cycle SDLC , including Business Requirements Document BRD review to generate Technical Requirements Document TRD . Change Management/QA/Release Management as well as Project Management responsibilities. Well-versed in Kimball/Inmon Data Warehouse design and methodologies.
Past efforts in role as both technical-lead and project-lead in liaison with PMO, QA and end-user internal/external communities in both loose- and tight-matrix organizations. Experience with PMBOK, ITIL and CMM/CMMI focus and concerns. Expertise in established Agile methodologies including GoF-style, pattern-based development and refactoring methodologies.
Strengths include E/R data modeling logical and physical , server-side scripting Korn shell, JavaScript, PHP, Perl as well as extensive prior experience in UI development.
Business line experience predominately in insurance, financial services and brokerage fixed income, derivatives, equities etc. .

OPERATING/NETWORKING SYSTEMS:

Unix SunOS/AIX
Windows All versions through 7

PROGRAMMING / SCRIPTING LANGUAGES IDEs:

Oracle PL/SQL 8i/9i/10g/11gR 1/2
Unix Shell scripting C, Bourne, Korn
PHP4.x/5.x, Perl 5.x, etc - Apache/IIS

DATABASE / APPLICATION / WEB SERVERS IDEs:

Oracle 8i/9i/10g/11g, Oracle Exadata Appliance, JQuery, XPath
Toad 8/9, SQL Optimizer, Benchmark Factory, SQL Loader/SQL Plus
Informatica ETL, Cognos
Microsoft SQL Server 4.2x/NT/6.x/7.x/2000/2005
DBArtisan, ER Studio, Rapid SQL, Embarcadero Change Manager etc.
MySQL 4.x, DB2 NEON Shadow Direct, etc.
Sybase Adaptive Server Enterprise 11.5/12.0/12.5/15, Sybase SQL Server 4.92/System X/XI

Confidential

Sr. Oracle Developer

Oracle Application DBA/Developer on global effort to aggregate positions and transactions from all regions for both data warehouse and associated data marts.
Created tablespace mgmt system used to facilitate quick restore in the event of DataGuard failover. This included mirroring data in a separate schema and the ability to switch back-and-forth between normal production schema and failover schema reduced data-set .
Responsibilities also included data modeling using PowerDesigner of Data Marts used for real-time, ad-hoc reporting using Cognos .
Design and implementation of all tables and indexes including parallelism and/or partitioning to be used by tablespace mgmt system.
Developed real-time synchronization mechanism whereby data is compressed on Oracle's Exadata in the 'separate' schema as it is in the main schema.
Responsibilities also included SQL tuning and optimization in DB2.

Confidential

INDEPENDENT CONSULTANT

Developer and Production Technical Support Technician responsible for analysis with an emphasis on help-desk ticket resolution effort for all Oracle 11gR2 data-related issues.
Responsible for determining root-cause of all data-defects and notifying UI development teams of same.
Responsible for optimization of Oracle PL/ SQL exceeding CPU/IO limits set for selected user accounts.
Responsible for analysis of stored procedures, triggers, functions and packages for performance optimization and production defect resolution.
Responsible for quality assurance and performance testing of all anonymous PL/SQL block-scripts submitted to Production DBAs to resolve open tickets.
Responsible for monitoring performance of Web Servers HP Application Performance Monitor going against Oracle database servers.
Responsible for monitoring and resolving all Oracle performance issues with regard to processing claims and claim bundles.
Responsible for development of 20 Oracle 11gR2 stored procedures/anonymous blocks used to repair defects in data.
External/internal issue-based call-logging performed using HEAT. Issue-tracking and script-based solutions submitted to DBAs using JIRA for inter/intra-departmental workflow.
Oracle 11gR2 90 and SQL Server 10 schemas 100 composed of 1000 tables.
Database development and support performed using TOAD, SQLNavigator, and SQL Plus. Additional tools WinSCP, PuTTY.

We provide IT Staff Augmentation Services!

Sr. Oracle Developer Resume Profile

NC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship