Oracle Database Developer Resume Samples

An Oracle Database Developer is a specialized IT professional who designs and manages various areas relating to the spectrum of work of Oracle. The job description entails creating, modifying, testing codes, and scripting that allow systems to run on various applications. Core duties are mentioned on the Oracle Database Developer Resume as – conducting trial runs of software applications; performing systems analysis, reviewing programs, correcting errors in programs, and preparing workflow charts.

While the duties of the developer vary according to their roles and employer’s requirements, the needed skills are common and include the following – proven work experience, a solid understanding of data management, knowledge of software development and user interface web applications; hands-on experience with SQL; familiarity working with Oracle, and the ability to understand front-end users’ requirements. A degree in the field of IT or computer science is required. Oracle qualification is a must.

Oracle Database Developer Resume example

Oracle Database Developer Resume

Summary : Responsible for Collaborating with IT department transfer Oracle Discoverer reports to Microsoft Power BI reports; validating reports are correctCreating scripts and sorting tools and reports for Corsair Database.

Skills : PL/SQL, SQL, ETL, Data Modeling, Java, Python, Reporting.

Description :

    1. Built, tested, and delivered software using Agile Methodologies.
    2. Designed and implemented database solutions within architectural, security, and code quality guidelines considering performance, scalability, and sustainability.
    3. Troubleshoot and tuning complex PL/SQL statements and making recommendations on indexing strategies.
    4. Worked closely with application developers to ensure proper design and implementation of database systems.
    5. Participated in database architectural review and design discussions.
    6. Analyzed complex data requirements - Must be strong in working with complex queries.
    7. Performed code reviews, learning from your peers, and sharing your knowledge with them in a positive, friendly way.
                Years of Experience
                Experience
                7-10 Years
                Experience Level
                Level
                Executive
                Education
                Education
                Diploma


                Oracle Database Developer Resume

                Objective : Responsible for ensuring integrity and security of all data backups, Resolving database capacity, replication, and response issues.

                Skills : Management Skills, Database, Multitasking.

                Description :

                  1. Actively participated in promoting company culture.
                  2. Experienced with relational database design and SQL Server Architecture.
                  3. Experienced with Microsoft SQL Server Reporting Services (SSRS).
                  4. Experienced with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).
                  5. Experienced and knowledgeable of database programming concepts including Structured Query Language, stored procedures, and triggers.
                  6. Wrote and maintained new and existing programs.
                  7. Designed, coded, tested, and debugged program logic.
                                Years of Experience
                                Experience
                                2-5 Years
                                Experience Level
                                Level
                                Executive
                                Education
                                Education
                                Diploma


                                Oracle Database Developer Resume

                                Summary : Dynamic individual with more than 9 years of professional experience in the fields of Software Development, System and Requirement Analysis, and enterprise application testing (Oracle Database, SQL Server, Salesforce, MicroStrategy, Oracle Financials, Siebel, and PeopleSoft). Combined with industry best practices experience, I am able to blend well within the organization to bring success to the next level.

                                Skills : Oracle, SQL, PL/SQL, Database Design, Oracle Apex, Oracle Forms & Reports.

                                Description :

                                  1. Designed/developed/Modified tables, views, materialized view, stored procedures, packages, and functions.
                                  2. Coded PL-SQL packages and procedures to perform data loading, error handling, and logging.
                                  3. Tied the procedures into an existing ETL process.
                                  4. Tuned database SQL statements and procedures by monitoring run times and system statistics.
                                  5. Inserted hints and rewrote code as required.
                                  6. Used SQL loader to load the data from the files provided by the interfacing applications.
                                  7. Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
                                Years of Experience
                                Experience
                                7-10 Years
                                Experience Level
                                Level
                                Management
                                Education
                                Education
                                BS

                                Oracle Database Developer Resume

                                Headline : Oracle Database Developer with experience of over 8 years in Oracle SQL, PL/SQL covering versions 8i through 11g. Involved in all phases of Software Development Life Cycle from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines. Extensive experience in writing PL/SQL Packages, Stored Procedures, Functions, Triggers using Oracle latest features.

                                Skills : SQL, Analyzing SKills, Designing SKills.

                                Description :

                                  1. Designed and created entity-relationship diagrams (ERD) for Oracle-based applications and interfaces.
                                  2. Wrote complex SQL queries using sub-queries, analytical functions, and inline views Used Bulk Binding for better performance and easy retrieval of data by reducing context switching between SQL and PL/SQL engines.
                                  3. Handled different types of predefined and user-defined exceptions.
                                  4. Created PL/SQL packages for reconciliation report generation.
                                  5. Designed, developed, and maintained oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.
                                  6. Managed the packaging and release of applications across environments.
                                  7. Deployed database objects (procedures, triggers, tables) to production.
                                Years of Experience
                                Experience
                                5-7 Years
                                Experience Level
                                Level
                                Executive
                                Education
                                Education
                                Diploma

                                Oracle Database Developer Resume

                                Summary : Over 8 Years of IT experience in various roles as Sr. Oracle PL/SQL Developer, Oracle Consultant/On-Site Coordinator with a solid understanding of Business Requirements Gathering, Business Process Mapping, Evaluating Data Sources, Data Modeling, Data Mapping, and translating requirements into specifications.

                                Skills : Developing Skills, Documenting Skills, Database.

                                Description :

                                  1. Interacted with various teams to understand their Process and Created a Centralized Database with a New Data Model and Multiple Schemas to handle the Business Rules.
                                  2. Translated Business Requirement Documents into Data Models.
                                  3. Created Multiple Subject Areas for Various Schema Creations in Database for handling different modules in the project for Front end teams / Back end teams to understand and access data in an Optimal Way.
                                  4. Proficient in all phases of System Development Life Cycle (SDLC) including Design, Analysis, Development, Testing, and Implementation using Oracle 11g / 10g.
                                  5. Translated Business Process flows and Requirements in Possible Dimensional and Fact Tables with Several Dimensional Tables in the Star Schema.
                                  6. Created Dedicated Table Spaces for handling Various Layers Tables.
                                  7. Designed Physical and Logical Data model and Data flow diagrams.
                                Years of Experience
                                Experience
                                7-10 Years
                                Experience Level
                                Level
                                Management
                                Education
                                Education
                                BS

                                Oracle Database Developer Resume

                                Summary : A Technology-driven IT professional with over 8 years of experience in designing and developing Complex applications, using SQL in a large-scale relational database environment. Experience in gathering business requirements and converting them into functional, technical specifications and developed mapping documents to map source systems to the Data Warehouse Model Expertise in writing SQL Queries, PL/SQL Stored Procedures, Functions, Packages, Database Triggers, SQL Trace on Oracle databases.

                                Skills : Database, Management Skills, Communication Skills.

                                Description :

                                  1. Created database objects like tables, synonyms, sequences, views.
                                  2. Developed ETLs to pull data from various sources and transform it into reporting applications using PL/SQL.
                                  3. Documented Technical Specs, Dataflow, Data Models, and Class Models.
                                  4. Performed integration testing with frontend reporting infrastructure.
                                  5. Wrote shell scripts for automating the process of data loading.
                                  6. Documented requirements gathered from stakeholders.
                                  7. Completely redesigned the database process in PL/SQL to be able to configure variables in database tables as opposed to code and developed system alerts to proactively notify about discrepancies in data.
                                Years of Experience
                                Experience
                                7-10 Years
                                Experience Level
                                Level
                                Management
                                Education
                                Education
                                BS

                                Oracle Database Developer Resume

                                Objective : Hardworking, organized, Oracle Database Developer professional with a proven background delivering sensible business technology solutions on time and under budget while working as a team member or team leader.

                                Skills : Planning SKills, Developing Skills, Multitasking.

                                Description :

                                  1. Formulated procedures, functions, and packages.
                                  2. Ensured that the quality, programming, and project management standards were met.
                                  3. Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested Tables, and Index of Table Used Bulk Collect feature to improve performance.
                                  4. Improved the performance by using the performance tuning tools like EXPLAIN_PLAN, creating indexes.
                                  5. Created indexes on tables for fast retrieval of data.
                                  6. Worked on Partitioning and indexing on the tables to optimize the SQL query.
                                  7. Creation of interfaces between two systems using PL/SQL.
                                Years of Experience
                                Experience
                                2-5 Years
                                Experience Level
                                Level
                                Executive
                                Education
                                Education
                                BS

                                Oracle Database Developer Resume

                                Headline : To establish a long-term career in a company where I may utilize my Oracle Database Developer professional skills and knowledge to be an effective Oracle Database Developer and inspiration to those around me.

                                Skills : Designing Skills, Writing Skills, Database.

                                Description :

                                  1. Tuned The PL/SQL queries with the help of Analytic functions in SQL.
                                  2. Handled the maintenance related issues in codes.
                                  3. Worked on the migration of data from subsystem database to system database using PL/SQL.
                                  4. Designed database workflows for CMS's MEDICAID and CHIP program approval process.
                                  5. Wrote complex SQL queries involving multiple tables, using sub-queries, analytical functions, and hierarchical queries.
                                  6. Wrote Oracle packages, procedures, functions, triggers, and all other oracle database objects to support MacPro Application for Centers for Medicare and Medicaid.
                                  7. Investigated complex database issues, identifying slow-running SQL and PL/SQL code and optimize it using query optimization (executions plans, hints, indexes), partitioning, Oracle Collections, bulking techniques, partition utilization, and materialized views.
                                Years of Experience
                                Experience
                                5-7 Years
                                Experience Level
                                Level
                                Executive
                                Education
                                Education
                                Bachelor Of Engineering

                                Oracle Database Developer Resume

                                Headline : Responsible for Designing, developing, maintaining, and testing databases and applications using Oracle, SQL Server, RAC, ASM, Data Guard, OEM, Mongo, SQL, Crystal Reports, etc. Configure, maintain Oracle database architecture.

                                Skills : Planning Skills, Multitasking, Communication Skills.

                                Description :

                                  1. Maintained Backups and Snapshot of the database using MS SQL Server Management Studio.
                                  2. Provided technical expertise to junior team members and consult with other application developers to come up with best coding practices, data mapping, program logic, and flowcharts in conformity with Northrop Grumman's Agile (scrum) software development practices.
                                  3. Maintained version control of database entities and staging DDLs for deployment from Development all the way to Validation and Production.
                                  4. Interfaced with end users/project owners from Medicare and Medicaid (CMS) for requirement gathering as well as product demonstrations.
                                  5. Worked on documentation of creating Technical and design documents with ETL Mapping Pulling data from Salesfroce.com and using it for data reconciliation.
                                  6. Customized report from the legacy company in Pentaho Developed code in MySQL and integrate with Pentaho data integration Working on Pentaho ETL transformation and jobs Developing UNIX shell script enhancements and code.
                                  7. Worked on Bitbucket and GIT version control Working on end to end waterfall SDLC Creating procedures in plsql for reporting purpose.
                                Years of Experience
                                Experience
                                5-7 Years
                                Experience Level
                                Level
                                Executive
                                Education
                                Education
                                BS

                                Oracle Database Developer Resume

                                Headline : Highly qualified race Database Developer with experience in the industry. Enjoy creative problem solving and getting exposure on multiple projects, and would excel in the collaborative environment on which your company prides itself.

                                Skills : Planning Skills, Communication Skills, Writing Skills.

                                Description :

                                  1. Worked on creating database stored procedures and packages Involved in Database management like partitioning, SQL queries tuning, and application performance.
                                  2. Worked on UNIX shell scripting for processing provisioning components.
                                  3. Completed the assigned CDRlive IWOS (Integrated Work Order System) requests before the commit date.
                                  4. Called Detail Records (CDRs) analysis, and Load CDRlive summary data Worked on archiving scripts to archive the data and drop old table partitions.
                                  5. Worked on performance and fine-tuning of the application.
                                  6. Worked on the scope to perform a lookup on SCDR usage to get serving location and cell information.
                                  7. Worked on shell script which provides statistics by usage date (earliest record opening time) and processed data.
                                Years of Experience
                                Experience
                                5-7 Years
                                Experience Level
                                Level
                                Junior
                                Education
                                Education
                                BA