- Featured in:
Additional Data Systems Administration Resume Samples
Oracle Database Developer Resume Samples
No results found
0-5 years of experience
Worked closely with customers, programmers, account executives and management resulting in customer satisfaction and increased revenue.
- Created web based sales promotions resulting in targeted sales opportunities.
- Developed several in-house web site applications improving product and equipment tracking.
- Wrote procedures to capture and process customer extended warranty information.
- Maintained and modified client supplied mailing lists for direct mail campaigns.
- Created C and FoxPro programs that properly formatted data prior to mailing.
- Worked with Project Coordinators and Account Executives to insure quality products.
- Promoted to Database Developer.
0-5 years of experience
Freelance database developer in Oracle PL/SQL, Forms and Reports to customize and improve the integrated management system created to provide support business administration and talent management to commercial and financial organizations
- Developed interfaces to migrate data from integrated system to Data Warehouse environment, providing availability of information in real time
- Designed and developed regulatory and statistical reports for regulatory organizations and high level decision makers
- Maintained Integrated Management System providing high quality of new forms and reports
- Improved response time to queries up to 40 percent by reviewing and improving indexes, partitioning tables, and fixing coding issues for the Integrated Management System
0-5 years of experience
Developed Oracle PL/SQL packages and stored procedures for data warehouse that consolidated loan information from disparate systems and platforms. (System developed on Sun Unix platform using Oracle 7.3 as a database).
- Created analysis and design documents as part of major project to migrate DB2 tables to Oracle.
- Managed team of 3 programmer/analysts who supported client/server distributed applications.
- Managed implementation of SBO 2000 software package that tracked [company name] loans serviced by other companies.
0-5 years of experience
Database Development
- Analyzed data requirements and developed data logical models.
- Developed data model to accommodate all business data requirements using ERWIN.
- Conducted and improved database performance tuning by SQL statements, index tuning, creating materialized views, and data warehousing.
- Migrated legacy databases by using ETL tools. Developed custom PL/SQL packages for gaps found in the ETL tools.
- Created shell scripts to automate data pull from remote FTP servers and imported the data through SQL Loader.
0-5 years of experience
- Integrated Oracle 11g products into existing large scale DoD environmental application Hazardous Material Management System (HMMS).
- Led team that designed & developed 50+ PL/SQL data quality improvements for leading DoD app.
- Created and implemented 30+ custom maintenance patches using Oracle SQL and PL/SQL.
- Created ETL data analysis and data correction software using Oracle SQL, TOAD, and TFS.
- Created full range of documentation of new software modules for deployment and support teams.
- Resolved complex and unusual escalated issues (3rd and 4th level support).
0-5 years of experience
Led in the development of a billing and sales system that deals with agencies, ads, scheduling, and receipts
- Analyzed existing transactional database schemas and designed star schema models to support the users'
- Participated in writing Database Procedures, Functions, Packages and Database Triggers
- Developed scripts for various reports base on end user requirements
0-5 years of experience
Served as Oracle DBA for group of 10+ software developers in an Engineering development environment. Installed and upgraded development workstations from Oracle 9i to 10g.
- Developed SQL scripts to upgrade database and install new Oracle environment which utilized Windows Authentication for security.
- Provided direct support to the engineering department to resolve Oracle problems.
- Researched and developed Oracle configuration and performance tuning recommendations for [company name]'s banking software product.
- Utilized TOAD, UltraEdit, and SQLPlus for development and Oracle Metalink for problem research.
0-5 years of experience
Managed, implemented and tested applications in Informatica, Oracle, Autosys and Opalis.
- Liaised with the business analysts to translate business requirements into mapping specifications.
- Provided Knowledge Transfer to level two support teams to enhance independence.
- Developed and executed unit tests
- Analyzed applications for possible failures across time zones due to daylight saving time changes.
- Developed performance monitoring processes and worked with data architect on future strategies.
- Debugged and trouble shooted applications.
0-5 years of experience
Lead database developer for VSPTS-Net and PCTS database systems for Immigrations and Customs Enforcement (ICE)
- Met with analysts and Java developers to specify and create a database design to meet client needs
- Collaborated with customer to develop standardized reporting
- Produced and maintained ERDs and relevant documents to comply with DHS' Software Development Life Cycle
- Represented [company name] in architectural review sessions
- Analyzed legacy PCTS database to uncover entity relationships
- Improved integrity of the database design
- Developed a data migration plan and scripts to convert the existing legacy system
0-5 years of experience
Assisted in the design and development of proprietary reporting architecture to report customer conferencing data, using PL/SQL, XML and Java.
- Developed web service API methods using PL/SQL, SQL/XML and XML to enable conferencing resellers to write their own clients to interface with our web conferencing platform.
- Analyzed and fixed issues with billing, provisioning and web-conference flow.
- Collaborated with cross-functional teams on new products and product support.
0-5 years of experience
New development / enhancements / Maintenance / and Production problem fixes for numerous International and North America Application databases.
- Project lead for North America Release builds and deploys efforts.
- Project Lead for Test Director Software change request assignment and resolution effort. Changes implemented by new development, enhancements, and maintenance modified the database architecture of two enterprise databases.
- Oracle Database Development: Oracle 9i; PL/SQL; SQL; XML.
0-5 years of experience
Developed Oracle scripts and packages to support daily business requirement
- Served as backup Oracle DBA
- Supported client's ERP system PeopleSoft Enterprise One - J.D. Edwards
- Developed customized JDE reports and applications with advanced JDE programming techniques such as Processing Options, Business Functions, and Event Rules.
0-5 years of experience
- Designed logical and physical data bases using SQL and PL SQL for the back end and Oracle developer for the GUI
- Coordinated data base development as part of project team.
- Wrote, designed and produced queries for data base implementation
- Applied knowledge of data base design standards and data base management system in both database design, re-engineering and data migration
0-5 years of experience
Designed, develop, and tested (using Agile methodology) complex set of Oracle programs to report differences between new generated Ratings/Outlooks/CreditWatch and existing for Primary and Secondary Markets for various business scenarios.
- Designed, develop, and tested complex set of Oracle programs for Non-Rating Score Master database. Non-Rating Score Master database is designed to store the various types and values of scores and their supporting components (components, factors, sub-factors) that are assessed for various types of analytical entities.
- Created various UNIX shell scripts for automate process of loading data
- Designed, develop, and tested complex set of Oracle programs to populate primary Participant Evaluation Group tables from staging tables.
- Designed, develop, and tested complex set of Oracle programs for Dependent Rating Notification services.
- Developed various Oracle PL/SQL programs for rating services to help investors perform efficient credit risk-driven investment analysis.
- Performance tuning complex views and PLSQL programs.
0-5 years of experience
Worked with Oracle databases to manage data for development, training and production environments.
- Wrote PL/SQL Functions and Stored Procedures to provide APIs to front-end developers to manipulate the database.
- Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
- Created SQL reports, data extraction and data loading scripts for different databases and schemas.
- Used TOAD to run SQL and PL/SQL code to manipulate the databases in all environments.
0-5 years of experience
Worked with Oracle databases to manage data for development, training and production environments.
- Wrote PL/SQL Functions and Stored Procedures to provide APIs to front-end developers to manipulate the database.
- Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
- Created SQL reports, data extraction and data loading scripts for different databases and schemas.
- Used TOAD to run SQL and PL/SQL code to manipulate the databases in all environments.
0-5 years of experience
ETL developer responsible for the cleansing, transforming and loading of Chief Business Office (CBO) production data into a 9+ TB data warehouse on a daily and monthly basis using Oracle 11g, SQL*Loader, Import/Export, UNIX Korn Shell scripts, SQL, PL/SQL, etc.
- Created and maintained the PL/SQL packages, functions and procedures used for the ETL process, and more recently started using Informatica for new ETL development
- Responsible for data validation and accuracy so as to deliver end-user reports on a daily basis by 10:00 am and on a monthly basis by the 10th of each month
- Created web-enabled reports using Oracle Express and more recently OBIEE
- Responsible for maintaining the Client Website to ensure Performance Metrics and Daily ETL loading status/reports are available and up-to-date
0-5 years of experience
Provided support for Java Development team and programmed backend PL/SQL objects, including functions, procedures, packages, collections, and triggers.
- Maintained and improved backend objects for UNICOM system databases.
- Tracked database performance and tuned SQL statements and PL/SQL blocks.
- Offered support for production integration, bug fixes, and new enhancement development.
- Accountable for production release and version control management, database consolidation testing/patching, batch processing, and reporting development and maintenance.
0-5 years of experience
Agile team member responsible for ETL and special projects.
- Worked with users to create jobflows/graphs/requirements documents for ETL processes.
- Designed and created PL/SQL packages/tables/views/queries for implementing client loads and extracts.
- Tuned existing packages/tables/queries for faster ETL processing.
- Converted production jobs from existing barcoding tool to SmartyStreets, from Pentaho to CloverETL, and from Oracle to Amazon RDS.
- Designed graphs in CloverETL to replace Pentaho components such as SQL*Loader functionality.
- Created tables in Amazon S3/Redshift used for Kentico access with nightly updates via Clover.
- Modified SSRS reports and SQLServer extracts/packages.
0-5 years of experience
- Created and modified schemas in Oracle 11g Database needed for new electronic banking systems by working with Project Managers staying within the schedule.
- Worked with other internal IT Groups by exporting dump file from Oracle Golden Share Database importing into 11g Oracle Database.
- Created Tables, Views, Procedures and Packages to meet the project specifications. All emails, scripts, log files, test verification files, and design documents were updated and maintained in CVS repository.
- Created deployment steps for all projects using multiple environments (DEV, BAT, SIT, PAT, PRD, and TRN). Created and modified Software Design Specifications and Software Requirements Specifications when required.
0-5 years of experience
Led the migration of functionality and data of Weight Watchers current B2B Call Center Application (NELLY) from a legacy system a new CS Portal application platform.
- Designed new database schemas in order to integrate newly proposed design.
- Developed packages, stored procedures and functions to accommodate required design and processes.
- Took part in WeightWatchers global functionality expansion, particularly into France and Canada.
- Created and managed new BackOffice and FrontOffice processes, running in OLTP based environment.
- Worked closely with Front-End development team, designing a more robust National and Corporate client based solutions.
- Utilized Oracle 11G stored procedure, packages and functions. Extensive usage of Oracle SQL, PL/SQL features
- Played an integral part in maintenance and administration of overall WeightWatchers database infrastructure and design. Provided advice and assistance with optimization related issues.
- Serve as a liaison between various development teams and their database related counterparts.
- Provide advice and general expertise on database development, design and performance tuning aspects.
0-5 years of experience
As a developer, was involved in the Development & Maintenance of various Oracle PL/SQL procedures, Functions, Packages, triggers, views, sequences, synonym, Index for the application.
- Preparation of Test plans for the converted data & applications.
- Performance tuning of the data conversion scripts.
- Responsibilities include - Design, development, maintenance, performance tuning, query tuning, testing and support. Oracle 10g environment
- Extensive experience of performance and SQL tuning, PL/SQL development, development of stored procedures, packages, database design
- Reduce the upload time from 6 hrs to 20 min, using java collections, stored procs
- Significantly improve the performance of trading system by converting the backend COOL:Gen code to Oracle stored procedures
- Developed the application in java to read data from database and generate the accounting file in XML format depends on transaction type, clearing member and venue which is used by DME (Dubai Mercantile Exchange)
- Generate rate cards for the product contracts traded on the exchange using MS Excel VBA
0-5 years of experience
Re-platformed and re-designed existing system to .NET and Oracle.
- Worked with Business analyst to refine business requirements and changes to the existing system.
- Analyzed the existing Power Builder application and database design to understand and define the functionality required for new development.
- Developed stored packages and procedures for .Net developers using PL/SQL.
0-5 years of experience
Collaborated with database architect on the partial redesign of database schema to reflect current business rules and application functionality. Developed SQL scripts to create new schema objects, migrate data and to rollback database to prior production state.
- Initiated exploration into employing Python to query Oracle database using the cx_Oracle extension module to mine and graph network monitoring device performance data.
- Provide database support for multiple development teams. Responsibilities include development and maintenance of SQL scripts and PL/SQL packages.
- Designated liaison between client database / architecture team and Scrum development teams.
- Responsible for peer code reviews to ensure code performance, reliability, maintainability, and consistency.
- Provide training to team members on client coding practices, standards, and protocol.
0-5 years of experience
- Developed, debugged, tested, and released database-driven software for both the United States Army and United States Navy.
- Designed and implemented Oracle PL/SQL tables, queries, stored procedures, indexes, packages, and views.
- Debugged and upgraded existing Oracle PL/SQL tables, queries, stored procedures, indexes, packages, and views.
- Designed and implemented new functionality using ASP.NET, C#, JavaScript, and Oracle PL/SQL to enhance existing Army and Navy data systems.
- Debugged and upgraded existing Army and Navy data systems using ASP.NET, C#, JavaScript, and Oracle PL/SQL.
- The position required a Department of Defense Secret Security Clearance.
0-5 years of experience
Analyze, design, code, test, document and implement scalable back-end application systems using SQL & PL/SQL modular approach development on a Linux platform for a multi-tier business application.
- In charge of database support and daily DBA tasks such as troubleshooting alerts, monitoring top activity performance tuning, user management, space management and backups using OEM and other tools.
- Responsible for ETL from various sources using FTP, Shell Scripts, Oracle SQL*Loader, and external tables.
- Maintain and modify existing production code to improve performance.
- Provides ad-hoc reports upon request.
0-5 years of experience
[company name]. (Credit): Employing MFCOBOL/Oracle under UNIX, enhancements were made to the Private Issue brand of the "Card Member Posting and Billing System".
- New contract terms level activated provisional rate for delinquent accounts. Cash Back Bonus option was capped by restructuring incentive tiers.
- Analysis, design, detail specifications, programming, testing, and implementation were performed for those enhancements.
- Production problem analysis and resolution was also performed.
0-5 years of experience
- Develop Oracle stored procedures, functions, triggers and PL/SQL
- Develop ETL modules using MirthConnect, processing XML and HL7 files
- Create GoldenGate database transformation and replication processes
- Install Oracle database, patches and new software releases to local test server and remote fail over sites
10+ years of experience
Evaluate, recommend, implement, and maintain IT architectures and tools
- Analyze, design and document functional and technical specifications
- Design and development ERP, Supply Chain apps and interfaces using Oracle PL/SQL
- Provide data support for ERP and PKMS distribution system
- Design, development and maintenance of APIs using Cold Fusion
- Perform SQL tuning for applications and reports
- Support for Business Objects and EDI environments
- Train team members and users in Oracle related technologies
- Administer Oracle databases
0-5 years of experience
Design oracle-based database as per the demands of the clients
- Test and verify that databases can be easily accessed and operated by the end users
- Ensure storage capacity of the system matches with the user requirements
- Draft the technical design documents as per the component's functionality
0-5 years of experience
- Develop Oracle stored procedures, functions, triggers and PL/SQL
- Develop ETL modules using MirthConnect
- Create GoldenGate database transformation and replication processes
0-5 years of experience
- Development for enhancements of applications in Informatica, Oracle, Autosys and Opalis.
- Liaising with the business analysts to translate business requirements into mapping specifications.
- Knowledge transfer to level two support teams to enhance independence.
- Development and execution of unit, integration, system and regression tests.
- Integration and optimisation of data across Bank Global Asset Management.
- Analysing applications for possible failures across different time zones due to daylight saving time
- Developed performance monitoring processes and worked with data architect on development of future strategies.
- Debugging and troubleshooting of various applications. Managing, implementing and testing
0-5 years of experience
Move Oracle Database from a Microsoft Windows operating system (OS) based single instance configuration with DataGuard for data protection/disaster recovery to a Sun Solaris OS based RAC/High Availability (HA) implementation.
- Provide capability to document current system/database configuration and scripted capability, to include database security issues/requirements, to load database as a structured/ consistent environment into a development/testing/production system.
- Having primary responsibility for implementation of Oracle 10g RAC configuration on a Sun Solaris 10 network, provide input to establishment of requirements for implementation/maintenance of to-be configuration. Collect configuration of as-is system to ensure operations from legacy platform and enhance the operations on the to-be system.
- Supported Oracle replication of current Oracle Databases at two (2) locations in support of failover requirements, until RAC environment is transitioned into production.
0-5 years of experience
For each and every release of Apple POS (Point of Sales) we need to design/redesign the Database objects like Procedures, Functions, Triggers, Packages, Collections and Object Types that are being involved for the respective release functionalities.
- Involved in review of all the PLSQL Code, which was developed for each and every release, which is going to test Instance (QA) and then sign-off to Production Instance.
- Involved in verifying Explain Plans of modified or new SQL Statements, tracking the DB object changes, preparation of the DB Rollout & Rollback Plans, which are parts of the releases.
- We are responsible to prepare the Development & QA DB instances for the new releases or projects coming up by applying all the previous project/release changes with the respective privileges to the application and other users.
- We are the responsible to scrub all the sensitive data came from production when DB refresh to the Test and Development instances.
- Involved in creating new or modifying the existing Shell scripts for generating the reports on daily basis or release specific.
- Analysis, Enhancement, Maintenance and providing the resolutions for the defects raised by QA Team.
- We are responsible to make sure all the Autosys Jobs, Inbound and Outbound interfaces to/from Up-streams/Down-steams and vice versa are up and running and Data flow is going smoothly thru the interfaces.
- We are responsible in handling the DBA activities like copying the data, importing/exporting the data across the databases, providing the grants to specific users/roles/DB objects, etc.
- Involved in providing the supporting to QA for each and every release and make sure everything thing works fine at Application level.
- Mentoring and supporting the teams in resolving the issues, implement the desire functionality and furnishing the end user reports.
0-5 years of experience
Correct database errors
- Input data to the Database using SQLLOADER
- Create Oracle and My SQL Database tables
- Utilize SQL*PLUS to create queries