We provide IT Staff Augmentation Services!

Sql Database Developer Resume

South, CarolinA

PROFILE:

Twelve Years’ experience in the area of Client/Server and Distributed Multi - tier Application Development including Banking and Insurance applications, Data modelling, Database Design, Data Processing, Data Warehouse and Support mainly with Oracle technology on different platforms.

PROFESSIONAL SUMMARY:

  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance and production support with timely delivery against aggressive deadlines.
  • Exclusively followed Best Practices (Oracle CDM) and Development methodologies/Guidelines.
  • Excellent experience on PL/SQL that includes Cursors, Ref-cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools.
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.
  • Expertise in developing Data Conversions/Migration from Legacy System of various sources (XML, flat files, Oracle, Non Oracle Database) to Oracle system Using Utl file, SQL LOADER, External table and Calling Appropriate Interface tables and API’s.
  • Experienced in OLTP and OLAP System Study, Analysis and E-R modeling.
  • Experience in creating and registering Concurrent executables, Concurrent Programs, Tables, developing Descriptive Flex fields in Custom Applications and defining profile values using Application Object Library (AOL), System Administration in Oracle E-Business Suite Applications.
  • Excellent experience in accessing Webservices using oracle API’s (Oracle Net Services and HTTP). Created common interface to access webservices in other modules.
  • Very good experience in Using AQ-MQ Messaging Process to send message to MQ Server.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • Strong experience in Data warehouse concepts, ETL.
  • Expert on Dynamic SQL, Analytic functions, Parallel execution, Process scheduling, Table partitioning, Oracle supplied packages, Collections , Exception handling, Oracle Hints, PIVOT.
  • Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace , Cost-Based Optimization (CBO) and TKprof.
  • Developed materialized views for data replication in distributed environments.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.
  • Partitioned large Tables using range partition technique .
  • Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
  • Worked extensively on Ref Cursor, External Tables and Collections.
  • Familiar Oracle DBA activities: Managing schema and Maintenance (Table space, Data Files, Tables, Indexes etc.), Database security (Row level security, User Privileges & Roles).
  • Data warehousing and Business Intelligence: Data modeling in dimensional structures - Star/Snowflake schema, ETL, Change Data Capture (CDC), OLAP, OLTP mostly using PL/SQL as manual ETL.
  • Experience with SQL Server Analysis Services (SSAS).
  • Experience in extracting and transforming (ETL process) data using DTS/SSIS Import Export Data from various sources.
  • Proficient in using UNIX, Shell Scripting, SFTP. Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

SKILLS AND KNOWLEDGE:

Languages: SQL, PL/SQL, Mod PL/SQL, C, C++, Java, VB, VB .Net, Ingres, Shell Scripting.

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server, IBM DB2, Ms-Access.

Reporting Tool: Oracle Discoverer 10g, Oracle Reports, Cognos.

Data Modelling: ERWIN, Visio.

ETL tool: Oracle Warehouse Builder (OWB).

Version Control Tools: CA Software Change Manager, Windows Share point, PVCS

Other Tool: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator.

Other Application: Tivoli Workload Scheduler, Lotus Same time, File Handler.

Operating Systems/Hardware: HP-UX, AIX, Sun Solaris, Linux, Windows, Sun Sparc, Intel

PROFESSIONAL EXPERIENCE:

Confidential South Carolina

Senior Database Developer

Roles & Responsibilities:

  • Created data warehouse objects - Fact tables, dimension tables, table partitions, sub-partitions, normal and bitmap indexes, summary tables, materialized views, dimensions, cubes, stored packages, functions and procedures with parallel queries, making indexes unusable and rebuilding local indexes for partition exchange loading (PEL). Modeled Data Warehouse in dimensional structure - Star schema.
  • Created PL/SQL & SQL scripts for the ETL Converting/Migrating data from other systems, Oracle, XML and Flat files into Oracle database tables for Data warehousing and BI purpose. Used Sql loader, external tables and Utl file for the purpose of loading flat file And XML data.
  • Created composite SQL script using Dynamic SQL, Analytical function, PIVOT.
  • Used aggregate routines for views, summary tables, materialized views, reports etc.
  • Utilized business rules for data profiling, data analysing and cleansing.
  • Created ETL procedures to transfer data from legacy sources to staging area and from staging area to data warehouse using Oracle Warehouse Builder.
  • Prepared shell scripts for ETL to run in batch.
  • Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
  • Extract data into Oracle table using SQL*LOADER and EXTERNAL Table.
  • Writing Complex SQL script, Analytical Function.
  • Improved query performance by query optimization - tracing the query execution plan (explain plan).
  • Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
  • Loading data from various claim management application such as Facets, Cosmos, Diamond, DBP and RX Solution etc. for encounter submission.
  • Tested and took measures for maximum performance utilizing optimization hints, processors, storages and query optimization.
  • Resolved Query Level Performance tuning issues using Explain Plan, SQL Trace and TKPROF utilities to pin point time consuming SQLs and tuned them by creating indexes and forcing specific plans.

Environment: Linux Server for Database, Oracle 11g Database, Oracle 11g Web Logic Server, PL/SQL, TOAD, OEM, & Shell Scripts.

Confidential

Senior Database Developer

Roles & Responsibilities:

  • As a Senior Database Developer, I am responsible for Development, Customization & Implementation and production Support of the Oracle based Rwanda Revenue Authority Applications.
  • Designing and modifying of Database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
  • Converting/Migrating data from SQL Server, XML and Flat files into Oracle database tables for Data warehousing and BI purpose.
  • Created Oracle procedures to transfer data from legacy sources to staging area and from staging area to data warehouse.
  • Improved query performance by Query Optimization, Debugging and Tuning using Explain Plan, SQL Trace and TKprof.
  • Created data entry Forms using oracle Forms 10g for entering data related to Engineering Information and inventory.
  • Using Webutil to Create forms that Validate Application Login through LDAP Sever.
  • Support Data warehouse, ETL Process.
  • Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
  • Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
  • Involved in handling Database Security Related issues as suggested by the guidelines set by the company.

Environment: Linux Server for Database, Oracle 11g Database, Oracle 11g Web Logic Server, PL/SQL, TOAD, OEM, & Shell Scripts

Confidential

SQL Database Developer

Roles & Responsibilities:

  • As a Database Developer, I am responsible for Development and Support of the Oracle based Applications in CMC Projects.
  • Application & Database Performance Tuning & Troubleshooting.
  • Prepare DB Scripts for DML and DDL.
  • Writing PL/SQL programs for Java and .Net applications.
  • Writing PL/SQL programs for Batch process. Involved in writing Shell Scripts also.

Environment: Oracle Database, PL/SQL, TOAD, Shell Scripts.

Hire Now