We provide IT Staff Augmentation Services!

Database Developer Resume

Timonium, MD

SUMMARY:

  • More than 7 years of experience with 10g and 11g as an Oracle Developer and Oracle Consultant, developing back - end modules such as packages, functions, procedures, triggers, object types, and views for multitier business applications of OLTP systems in SQL and PL/SQL.
  • Worked under a complete Agile/Scrum environment and followed all the Agile methodologies and practices
  • Extensive experience in writing/debugging Oracle SQL, Dynamic SQL, PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links (DBLINKS), Sequences, Synonyms, External Tables and Global Temporary tables.
  • Experience with Partitioning strategy and design and worked with Oracle Redefinition partition legacy tables
  • Performed manual testing and built test script and also worked with the PLSQL Unit testing framework
  • Strong knowledge in using Oracle built-in packages (like UTL FILE, UTL SMTP, DBMS JOB, DBMS SCHEDULER), Cursor management, Exception handling etc.
  • Vast experience tuning Complex Queries and performance bottlenecks (using Explain Plan, HINTS, SQL Trace, TKPROF and SQL Profiler).
  • Experience in version control software such as GIT, PVCS, Clear Case, SVN for code management.
  • Experience in the development of Control M scheduling for batch processing
  • Experience in database concepts, SQL tuning, materialized views, index strategies.
  • Experience in enforcing data integrity using integrity constraints & database triggers.
  • Experience in External Tables, SQL*Loader, Export, Import.
  • Expertise in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle) to Oracle system Using SQL *LOADER, Appropriate Interface tables and APIs
  • Experience in all phases of the Application Development Cycle - Design, Coding, Testing, Maintenance and Documentation.
  • Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
  • Extensive and very intense SQL coding and development experience for OLTP database.
  • Experience using TOAD and PL/SQL Developer for query building, analysis, and manipulations of databases to check compatibility and integrity of RDBMS.
  • Fair understanding & working knowledge of UNIX - Shell Scripts.
  • Experience in supporting the various production issues addressed by the users from the client side and providing them with required solutions.
  • Excellent investigative, interpersonal skills and a team leader with very good communication skills.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g

Oracle Tools: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, SQL*Plus

Data Modeling Tools: Erwin 4.5/4.0/3.5, Designer 2000, Microsoft Visio 2003, ER studio, Power Designer

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing.

Scheduling Tools: Control M

ProgrammingLanguages: Oracle Pl/Sql, Unix, XML, Matlab, Labview, C

CI Tools: Bamboo, Maven

Environment: Sun Solaris 2.6/2.7/2.8/8.0, Red Hat Linux, Windows NT/ 95/ 98/ 2000/ XP,MS DOS 6.22

PROFESSIONAL EXPERIENCE:

Confidential, Timonium, MD

Database Developer

Responsibilities:

  • Research existing database and develop better solution
  • Developed PL/SQL packages and database triggers.
  • Designed partitioning strategy and worked with Oracle Redefinition to partition legacy tables
  • Designed and created tables, global temporary tables, views, materialized views and other database objects.
  • Developed various programs using Native Dynamic SQL and REF CURSORS.
  • Wrote PL/SQL packages, functions, procedures for batch framework jobs automated via Control M
  • Extensively worked in development of Control M batch processes
  • Involved in handling Exceptions through PL/SQL Blocks.
  • Assisted in the initial tuning of several database objects.
  • Extensively worked on all type of Analytical Functions
  • Developed UNIX shell scripts for regular maintenance
  • Conducted peer design and code reviews and extensive documentation of standards, best practices.
  • Loading data into tables from flat file via temporary tables using SQL * Loader and PL/SQL External Tables
  • Developed Database Triggers for the integrity.
  • Did manual testing and build test script and also worked with the PLSQL Unit testing framework.
  • Wrote push and rollback scripts for any database modifications such was creation, deletion or alteration of any database structures
  • Participation in reviewing code and ensuring testing, facilitate code delivery to production environments
  • Worked with Account Receivable systems like FDR and TSYS with functional domain knowledge of Payment domain system
  • Worked under a complete Agile/Scrum environment and followed all the Agile methodologies and practices

Environment: Oracle 11g, PL/SQL, TOAD, SQL Loader, ER Studio, Putty, Bamboo, UTPLSQL Unit Test, GIT, SVN, Eclipse, Control M

Confidential, Round Rock, TX

Oracle PL/SQL Developer

Responsibilities:

  • Developed PL/SQL packages and database triggers for OLTP systems.
  • Designed and created tables, global temporary tables, views, materialized views and other database objects.
  • Developed various programs using Native Dynamic SQL and REF CURSORS.
  • Wrote PL/SQL packages, functions, procedures etc for Online Transaction Process (OLTP).
  • Involved in handling Exceptions through PL/SQL Blocks.
  • Assisted in the initial tuning of several database objects.
  • Extensively worked on all type of Analytical Functions (RANK, DENSE RANK, LAG, LEAD etc.)
  • Developed various UNIX shell scripts for regular maintenance.
  • Conducted peer design and code reviews and extensive documentation of standards, best practices.
  • Loading data into tables from flat file via temporary tables using SQL * Loader and PL/SQL.
  • Involved in the development of a migration tool to convert data from the existing database to the required database format.
  • Developed Database Triggers for the integrity.
  • Did manual testing and build test script.
  • Participation in reviewing code and ensuring testing, facilitate code delivery to production environments.

Environment: Oracle 10g, PL/SQL, TOAD, SQL * Loader, UNIX, SQL*Loader, TOAD, Windows 2000, HP-UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
  • Responsible for installing, upgrading and configuring the Oracle server.
  • Creating databases, objects, roles and privileges.
  • Partitioned large tables to increase the performance.
  • Configured scripts to monitor activity with database.
  • Responsible for optimizing the queries and application tuning.
  • Implement Hot, Cold and Logical backup plans.
  • Designed backup and recovery procedures for OLTP system
  • Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning and coding standards.
  • Use TOAD tool to access the database
  • Used PL/SQL developer to create PL/SQL Procedures
  • Testing PL/SQL procedures against the test cases.

Environment: Windows 98/NT / 2000, HP-UX, AIX, Oracle 9i, TOAD, Database Tools/Utilities, Oracle Enterpris6e Manager (OEM)

Hire Now