We provide IT Staff Augmentation Services!

Database Specialist Resume

SUMMARY

  • Over 8 years of experience in developing and implementing software applications using RDBMS concepts adhering to strict Industry and Client standards.
  • Experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, documentation, implementation and maintenance
  • Expert in the development of PL/SQL Procedures, Functions, Triggers and Packages in PL/SQL to implement business logic.
  • Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques, and Indexes
  • Experience in using Composite Data Types in Oracle.
  • Expertise in working with Oracle 11g/10g/9i, TOAD, SQL * Loader for both development and customizations as per client specifications.
  • Experience in migration and conversion from Flat Files/MS Access/SQL - Server to Oracle using Oracle SQL* Loader
  • Experience in Tuning SQL statements using EXPLAIN PLAN and TKPROF to optimize the performance of the batch processes.
  • Good understanding of Oracle Data Dictionary, ER Diagrams and RDBMS.
  • Work closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications;
  • Great learning skills to adapt the rapid changing technologies and implementing the same at work.
  • Expertise in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts.
  • Strong Ability to handle multiple tasks and work independently as well as in a team.
  • Have Strong analytical skills with ability to follow project standards and decision-making capability.
  • Experience with Sybase IQ database 12.0 and 12.5.
  • Exceptional ability to quickly master new concepts and applications.

TECHNICAL SKILLS

Programming: C, C++, JAVA, SQL, PL/SQL.

Database: ORACLE 9i/10g/11g, 12c.

Platforms: Windows family, DOS, UNIX.

IDE: ORACLE SQL Developer, PL/SQL Developer, TOAD

Other: MS Office (Word, PowerPoint, Excel, Visio).

PROFESSIONAL EXPERIENCE

Confidential

Database Specialist

Responsibilities:

  • Designed database involving creation of about 150 tables to migrate from Sybase to Oracle.
  • Developed several ETL procedures and functions to migrate data from Sybase.
  • Designed various key database schemas as required.
  • Fast paced development Involving daily scrums and team meetings based on the issues.
  • Created master and transaction tables using the functional requirements.
  • Interacted with Business users to understand the expectations of the system against documented requirements.
  • Created several complex Oracle PL/SQL packages for business activities using Oracle collection objects.
  • Used various database DML triggers using PRAGMA AUTONOMOUS technique to track data changes.
  • Extensively used USER and DEFINER rights to optimize code reuse from various schemas.
  • Developed several automation scripts to move data between staging area and other schemas related to the application.
  • Code Management using GIT.

Environment: Oracle 11g, Sybase, SQL Developer, SQL*PLUS, SQL Loader, Interactive SQL.

Confidential

Database Specialist

Responsibilities:

  • Understand the business requirements provided by the business analysts and interact with them to in corporate them into Design Specifications to be implemented into coding.
  • Develop the core functionality in a supportable and maintainable infrastructure to ensure system reliability. Write complex queries using joins, inline functions, and analytical functions.
  • Create a new functional and supportable system that provides for the complaint process, investigations process, monitoring process and include modules to provide pre-programmed and ad-hoc reporting capabilities and final actions data tracking.
  • Develop new modules as per business requirements using Collections, Bulk Binds, REF Cursors, Dynamic SQL, FORALL and BULK COLLECT and PL/SQL logging etc.
  • Write high performance tuning queries to improve the performance of existing. Code Management using GIT.
  • Develop Packages, Procedures, functions, Sequences, Triggers tables, views, synonyms in a highly-normalized Sybase database comprised of more than 300 tables .

Environment: Oracle 11g, Sybase, SQL Developer, SQL*PLUS, SQL Loader, Interactive SQL.

Confidential, Bartlesville, OK

Senior Oracle PL/SQL Developer

Responsibilities:

  • Understand the business requirements provided by the business analysts and interact with them to in corporate them into Design Specifications to be implemented into coding.
  • Develop PL/SQL objects - Packages, Procedures, functions, Sequences, Triggers tables, views, synonyms. Write complex queries using joins, inline functions, and analytical functions.
  • Create Audit Log Triggers to track the changes made to system.
  • Enhancement of existing modules and develop new modules as per business requirements using Collections, Bulk Binds, REF Cursors etc.
  • Write high performance tuning queries to improve the performance of existing.
  • Coordinate with the team at onsite for a smooth deployment and change management using Redmine.
  • Schedule the oracle jobs in a sequential order to process several programs.
  • Using Jenkins for moving code in a pipeline from one Environment to other.
  • Using TFS (Team Foundation Services) for Code Management.
  • Followed Agile Methodologies and SaFE (Scaled Agile Framework).
  • Worked on Upgradation and Migration of Oracle Database from 11g to 12c.
  • Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings to extract the data from multiple source systems that comprise databases like Oracle 11g, SQL Server and then to the Data Marts.

Environment: Oracle 12c/11g, SQL Developer, PL/SQL Developer, SQL*PLUS, Toad, Unix.

Confidential, Irving, TX

Oracle PL/SQL Developer

Responsibilities:

  • Involved in requirement analysis and design and development of new Reports.
  • Involved in development and testing Oracle Stored Procedures, Functions and Packages for several reports.
  • Involved in creating trigger tables for tracking loan population.
  • Involved in creating historical and staging tables for tracking contract instances of loan population.
  • Involved in tuning queries in Oracle SQL and PL/SQL.
  • Analysis and Business Requirements Gathering for the HMP-2MP Dashboard Report and other 2nd lien dashboards.
  • Functional/Business Requirements gathering of majority of the manual reports that are sent to the Business Team on Daily Basis.
  • Optimization of various Manual Reports
  • Analysis/Enhancements to the Field Chase Report (PRIME LOSS MITIGATION)
  • Troubleshooting minor user/business questions on the 120Plus Loss Saves Tracker Report.
  • Developed ETL framework for processing and monitoring import of flat files.
  • Preparation of the Modification Related Documentation for the Chase Owned Reporting Team (Write up based on the Master Table).

Environment: Oracle 11g, SQL, PL/SQL, SQL*PLUS, TOAD, SQL*Loader.

Hire Now