We provide IT Staff Augmentation Services!

Database Developer Resume

City, NY

SUMMARY:

  • A performance oriented Database/ETL Developer experienced in design, development, implementation and maintenance of various Databases in various domains like Banking, Healthcare, Telecom and Public Sector.
  • Proven ability and expertise in processing big data, performance tuning, automation of data processing, as well as, developing and automating ETL processes.
  • Relational Database Management and Data warehouse systems.
  • Data analysis, logical, physical and dimensional data modeling techniques.
  • Developing ETL processes in Informatica, Talend and PL/SQL.
  • Developing Database Applications with various software development techniques such as; SDLC, Waterfall, Agile (SCRUM, Kanban)

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, PERL, JAVA, UNIX, C, C++, C #, VB.NET, HTML

Databases: Oracle, MySQL, SQL Server, Teradata & MS - Access

ETL Tools: Informatica, Talend

Data Modeling: Physical, Logical, Relational and Dimensional Modeling

Operating Systems: Unix, Sun Solaris, HP-UX, Windows

Scripting: Shell Scripting & PERL scripting, Python

Reporting tools: Crystal Reports, Oracle Reports

File Transfer tools: Filezilla, Winscp

Job Scheduler tools: Automic, Control M, DBMS Scheduler

Tools: TOAD, Putty, SQL Developer, Eclipse, Aqua Data Studio, SQL*LOADER, SVN, ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, Garden City, NY

Database Developer

Responsibilities:

  • Developed various Packages, Procedures, Functions to apply the business logic on the back end.
  • Created Materialized View, Inline Views, standard views to support the data fetching for the application.
  • Worked Extensively with Finance team to provide them the data and reconcile the monthly invoices and splits to various brokers.
  • Created DBMS Scheduler jobs to automate the data processing for the daily files received from clients to be stored into the internal database.
  • Extensively used External table and SQL Loader to load data into the system on scheduled basis.
  • Develop and automate ETL processes using Informatica & PL/SQL.
  • Automated various weekly and monthly reports to be sent out via email using PLSQL stored procedures.
  • Extensively used PLSQL exceptions to automatically send emails to the users in case any failure or based on specific conditions.
  • Performed performance tuning for the sql queries and the application to reduce the response time.

Environment: Oracle 11G, Unix, Windows, SQL Developer, WINSCP, Informatica, SQL*PLUS, ORACLE Forms & Reports.

Confidential, NYC, NY

Database Developer

Responsibilities:

  • Created Design Documents from Business Requirement Documents and interacting with Business.
  • Created Stored Procedures and Functions in Oracle packages related to each module.
  • Developed pl/sql code to summarize source data and apply complex business logic for reporting purposes.
  • Extensively involved in performance tuning of the queries to improve application performance.
  • Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
  • Extensively used Partitions & Hints and created materialized views for faster data retrieval.
  • Handled Exceptions based on the business logic to display errors using both oracle built in exception and user defined exceptions.

Environment: Oracle 11G, Unix, Windows, SQL Developer,Cognos Reports,Data Modeler, Visio

Confidential, San Francisco, CA

Database Developer

Responsibilities:

  • Created PL/SQL stored procedures to perform ETL operations.
  • Created various database objects like Views, Tables, Sequences, Packages and Procedures.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  • Used PL/SQL profiler to debug the performance of procedures and identify the bottlenecks.

Environment: Oracle 11g, SQL * Plus, SQL Server, TOAD for oracle, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Microsoft Visio 2007,Data modeler, TOAD Datapoint.

Confidential, Augusta,ME

Database Developer

Responsibilities:

  • Extensively worked on the Adhoc Data requests to satisfy the needs of the program managers to achieve different goals of the project.
  • Extensively worked of Toad Data Point to create automation scripts for the recurring Monthly, Weekly and Daily data requests.
  • Extensively did Quality test plans and reviewed the Quality System Test Plan & Test cases.
  • Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Performed Performance tuning for SQL Queries and the system.
  • Managed the monthly pool of recurring reports and data requests

Environment: Oracle 10g, SQL * Plus, TOAD for oracle, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Microsoft Visio 2007,Data modeler, Informatica Power center 8.x, TOAD Datapoint.

Confidential, Holmdel, NJ,

Oracle PL/SQL Developer

Responsibilities:

  • Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD
  • Develop Oracle PL/SQL triggers and procedures. Set up Oracle PL/SQL package to analyze the tables and indexes, records tables and rebuild indexes.
  • Created database objects, tables, indexes, writing procedures, SQL scripts
  • Worked in Identifying and requirements and developing models according to the customer’s specifications and drafting detailed documentation for the same.
  • Worked extensively in PL/SQL to develop packages, stored procedures, functions and database triggers.
  • Extensively worked towards optimizing the query to enhance the performance.
  • Used %Row type and %type to define data types based on row and column respectively.
  • Loaded external files into our Database through UTL FILE.
  • Developed tables with partitions and created indexes, constraints, triggers, synonyms.

Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX

Hire Now