Senior Oracle Developer Resume
5.00/5 (Submit Your Rating)
SUMMARY:
Expert database developer with significant experience designing and implementing complex SQL and PL/SQL Systems Oracle OCP skilled in implementing logical an physical database schema, tables and user access. Successful in analyzing data flow from design to development.
COMPETENCIES:
- PL/SQL Development on large scale systems
- 10+ years supporting Oracle from versions 8i through 10g
- Installation and configuring Oracle on Windows and Unix platforms
- Oracle upgrades
- Linux / Unix certified
- Crystal Reports / Oracle Reports
PROFESSIONAL EXPERIENCE:
Confidential
Senior Oracle Developer
Responsibilities:
- Provided Oracle development and DBA support for the Confidential
- Upgraded Oracle from 9i to 10g in terabyte environments
- Produced databases from logical design
- Client liaison to telecom companies for billing changes and upgrade analysis
- Provided technical support during project development
- Primary contact with clients to analyze feasibility of proposed projects
- Developed metadata
- Developed database applications using PL SQL
- Created packages, procedures, functions, triggers in Confidential ’s large data systems
- Wrote inline and materialized views for billing systems
- Created and maintained documentation
- Designed and implemented database schema, tablespaces and tables for new and existing clients working with large data sets for Confidential telecom clients
- Skilled in supporting legacy and new development in Perl and UNIX scripting.
- Supported DBA functions for distributed systems
- Provided backup processes using RMAN
- Installed and configured servers
- Provided data weekly using SQL Loader
- Successfully improved performance of billing system output by 25%
Confidential, Boulder, Colorado
Oracle Developer
Responsibilities:
- Supported SQL and Pl/SQL environment for back - end of newly written financial programs
- Expertise in Oracle development (PL/SQL and Oracle SQL
- Liaison to vendors for feasibility of smooth transition from existing local to web based donor system upgrade
- Planned and Implemented data conversions including upgrades to existing database systems for both hardware and software installations
- Lead for development of test codes to facilitate data conversions
- Provided data transfer using SQL Loader
- DBA support using Oracle Enterprise Manager
- Unix scripting for CU data
- Key player in meetings with vendors involved in converting CUF's existing donor input system to work out final product specifications
Confidential, Boulder, Colorado
Programmer / Analyst
Responsibilities:
- Expert Oracle PL/SQL developer with responsibility for supporting Confidential ’s Oracle backend for the company’s in-house applications
- Formal and practical knowledge of relational databases—Oracle 9i through 10g S
- Wrote high-end PL/SQL programs for local and client server applications
- Designed and implemented database schema, tablespaces and tables for new and existing clients working with large data sets for Confidential ’s clients
- Provided installation, configuring and testing for servers used by Confidential client throughout the South East on both Windows and Linux platforms
- Trained new users in Confidential ’s in-house ‘Offendertrak’ system
- Created databases, tables, packages, procedures, functions and triggers for front end processes
- Wrote required Unix and Linux scripts
- Wrote reports in Oracle Reports and Crystal
- Strong skills in solving complex problems
- Established and led newly formed Oracle development team
