We provide IT Staff Augmentation Services!

Database Engineer Resume

4.00/5 (Submit Your Rating)

San Francisco, CA

SUMMARY

  • Over Nine years (9+) of experience as a Database Developer / Data Analystin Analysis, Design, Implementation and Testing of Business applications using Relational Database Management System (RDBMS).
  • Extensively worked on Client - Server architecture, Data Warehouse applications using Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008/2016/2017.
  • Proficient working experience with SQL, PL/SQL, T-SQLusing database objects like Stored Procedures, Functions, Triggers, Packages, Type Objects, RefCursors, Dynamic SQL, Oracle Supplied packages, PL/SQL Collections, Temporary tables and Exception Handling.
  • Extensive experience in DB utility tools likeSQL Plus, Toad, PL/SQL Developer, SQL Developer, SQL* Loader, SSIS, SSRS.
  • Extensive experience in identifying issues, debugging and performing tuning teh application using Explain Plan, SQL Trace, TK Prof, and AWR Reports to optimize teh cost and for achieving higher performance.
  • Strong experience in Partitioning tables, creating Indexes, using database Hints for faster data retrieval.
  • Experience in Database upgrades of Oracle and MS SQL.
  • Experience in AWS cloud infrastructure and deploying required instances using playbooks.
  • Experience with Designing Data Flow Diagrams (DFD’ Confidential ), Database Normalization and Denormalization techniques, Entity relation modeling and design techniques.
  • Working Experience in Creating Physical and Logical data models usingvarious tools likeErwin, ER-Studio and MS Visio tools.
  • Working knowledge of Data warehouse and ETL tools likeInformatica, Cognos.
  • Extracting data from source database, Cleaning, mapping and loading data into teh target database, validating and analyzing teh data loaded for reporting purpose using Informatic.
  • Working experience of Amazon redshift, Snowflake Databases.
  • Good Knowledge of Data Visualization using Tableau and Python 2 programming.
  • Experience inmonitoring and automating tasks using UNIX Shell scripting andhands on experience in Perl Scripting.
  • Documenting system related changes in procedures/policies along with teh new issues and teh solutions along with technical specifications.
  • Experience with Agile based development environment and participated in Scrum sessions.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11i, MSSqlServer 2005/2008/2012/2016/2017 , MySQL 4/5, MS-Access, Amazon Redshift, Snowflake Data warehouse, Teradata, Hive, NoSQL

DB Utilities: SQL*PLUS, Toad 9.x, SQL Developer, PL/SQL Developer

Languages: SQL, PL/SQL, T-SQL, Shell Scripting, Perl, Python 2

Operating Systems: Windows, UNIX, Linux, Sun Solaris

Others: Ansible, YAML, Oracle Forms and Reports 6i, Oracle 10g Dev Suite, Informatica, Tableau, Crystal Reports, Cognos, SSRS, SSIS, AVAYA, ER-Studio, Erwin, Microsoft Visio, UML, Rational Rose, Subversion SVN, Tortoise, Git,Serena Dimensions, Rally, Jira, Oracle Apps, Salesforce, JDBC, D / X HTML, XML, XSL, CSS, AJAX, JQuery, JavaScript, WordPress 2.9, XAMPP, WAMP, Zend, Kohana, PHP4/5, VBA, Visual Studio.NET (2005/2008/2012 ), C, Core Java, C#, ASP, Excel, MS Power point, Eclipse, pycharm.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Database Engineer

Responsibilities:

  • Performed on Database upgrade from SQL Server 2008 r2 to SQL Server 2017.
  • Worked on Ansible playbooks, modifying existing files and creating new files according to teh requirement.
  • Worked in AWS cloud infrastructure, created instances in AWS using automated scripts.
  • Troubleshooting teh issues related to slow running queries.
  • Working on teh user reported issues on priority basis, root cause finding and bug fixing.
  • Configured and maintained SQL server pull, push replication for data flow from Dev to QA.
  • Worked on implementing GDPR framework in teh email product.
  • Created and modified existing unit tests.

ENVIRONMENT: MS SQL Server, Ansible, YAML, AWS Cloud, Linux, DBFit, Python3

Confidential, San Ramon, CA

Sr. Data Analyst

Responsibilities:

  • Involved in writing SQL queries and PL/SQL programmingaccording to teh requirements.
  • Extracting, Loading and Transformation of Data loads and managing batch jobs.
  • Optimize existing procedures and queries to improve teh application performance.
  • GeneratingAdhoc reports using SQLbased on teh client requirement.
  • Responding to teh incidents and resolving them, with appropriate response which may involve in finding teh root cause for issue and providing teh bug fixes.
  • Preparing teh required documentation on teh changes.
  • Unit testing teh code changes for teh new releases.
  • Providing user support by identifying requested data sets from different applications.
  • Supporting teh migration project, upgrading from Oracle 11 to Oracle 12 and Redhat Linux 6.9 to 7.

ENVIRONMENT: Oracle 11g / 12C, SQL, PL/SQL, Excel, Toad 12.8, VB, Excel, Redhat Linux 6.9 / 7.0

Confidential, Memphis, TN

Sr. Data Analyst / Database Developer

Responsibilities:

  • As a part of teh ETL team, involved in Extracting data from different databases (Oracle, Teradata and Salesforce) and loading it in to SQL Server database.
  • Validating teh data loaded in to SQL Server database and comparing it with teh source DB for reporting purposes.
  • Partitioning tables, data compression and created Indexes for faster retrieval of data.
  • Tuning teh queries for teh faster retrieval of teh data from teh source database.
  • Involved in Creating, Scheduling and monitoring teh data load jobs and troubleshooting any issues occurring during teh loading data.
  • Analyzing data and writing queries to extract data and creating appropriate reports.
  • Data Visualization and analysis using Tableau.

ENVIRONMENT: Oracle 11g, SQL Server 2008/2012, SQL, T-SQL, Visual Studio 2008, Teradata, Python3, Salesforce CRM, Rally, Hive, Excel, Tableau 10.

Confidential, Jersey City, NJ

Sr.Database Developer

Responsibilities:

  • Responsible for requirements analysis, database design, development and unit testing of teh application.
  • Modifying teh existing DB design using Erwin tool according to teh new requirements.
  • Involved in Creation of DB objects like Tables, partitioning tables, Indexes, sequences, views.
  • Involved in writing SQL queries and PL/SQL programming and tuned existing procedure and queries using Explain plan and SQL Trace.
  • Worked on SQL Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for teh business application development.
  • Developed database triggers, packages, functions, and stored procedures according to teh requirement and modifying teh existing DB objects.
  • Created Indexes for faster retrieval of teh customer information and enhance teh database performance.
  • Extensively used teh advanced features of PL/SQL like collections, ref cursors, and dynamic SQL, nested table, varrays, ref cursors, materialized views, Hints and dynamic SQL.
  • Used AWR reports to collect teh DB statistics and tuning teh long running queries.
  • Worked on database development, maintenance and production support, wrote Functional and Technical Specifications documents.

ENVIRONMENT: Oracle 11g, SQL Server 2008, PL/SQL, SQL, T-SQL, Informatica, TOAD, SQL Developer, PL/SQL Developer, Visual Studio, SQL*PLUS, Solaris 5.10, UNIX, Windows 8, Erwin, Putty, Java, Eclipse.

Confidential, New York, NY

Sr. Database Developer

Responsibilities:

  • Involved in writing SQL queries (Sub queries, Correlated sub queries and Join conditions) and PL/SQL programming.
  • Modified teh existing database packages, triggers, functions and stored procedures using PL/SQL and maintained scripts for various data feeds.
  • Extensively used teh features of PL/SQL like collections, ref cursors, and dynamic SQL and varrays.
  • Created Indexes for faster retrieval of teh data and enhance teh database performance.
  • Used Analyze and Explain plan for tuning and Optimization of SQL Queries.
  • Utilized SQL*Loader to perform bulk data loads into database tables from external data fields.
  • Providing reports on loading data into database and according to teh client requirement.

ENVIRONMENT: Windows 7, Sun Solaris,Unix, Oracle 10g / 11g, Toad, SQL Developer, PL/SQL, SQL*Loader, UNIX, Putty, Excel.

Confidential, New York, NY

Sr.Database Developer

Responsibilities:

  • Responsible for Requirements analysis, Design, Development and unit testing of teh application.
  • Performing hands-on analysis, manipulation and loading of customer-provided data and providing reporting on loading.
  • Worked on designing teh database from scratch and application development in all phases of waterfall model.
  • Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, Data Flow and created Process flow diagrams using MS Visio tool.
  • Involved in writing SQL queries (Sub queries, Correlated sub queries and Join conditions) and PL/SQL programming.
  • Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for teh reports.
  • Developed database packages, triggers, functions and stored procedures using PL/SQL and maintained scripts for various data feeds.
  • Used teh advanced features of PL/SQL like collections, ref cursors, varrays, PL/SQL tables, type variables, dynamic SQL, Temporary tables and External tables.
  • Used Explain plan and auto-trace for tuning teh SQL and Generated session level trace and used teh TKPROF utility to get teh report for teh trace file for tuning and Optimization of SQL Queries.
  • Utilized SQL*Loader to perform bulk data loads into database tables from external data fields.
  • Used Data Pump utility (EXPDP/IMPDP) for taking schema level backup of teh database.
  • Worked on Informatica Source Analyzer, Mapping Designer & Mapplet, and Transformations.
  • Created mappings using different look-ups like connected, unconnected and dynamic look-up with different caches such as persistent cache.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Developed ETL framework for processing and monitoring import of flat files in SSIS for key client.
  • Prepared teh complete data mapping for all teh migrated jobs using SSIS.
  • Worked on formatting SSRS reports using teh Global variables and expressions.
  • Worked on creating UNIX scripts for automating jobs for loading data from data files received from downstream application to upstream application.

ENVIRONMENT: Windows 7, Oracle 10g / 11g, SQL Server 2005, Visual Studio, Toad, SQL Developer, T-SQL, SQL, PL/SQL, SQL*Loader, SSIS, SSRS, UNIX, Putty, Serena Dimensions, Appian, Informatica, Cognos, SQL Loader, Excel, MS Visio, ER-Studio, MS-Visio.

Confidential, Jersey City, NJ

Database Developer

Responsibilities:

  • Participated in all phases of development like System Analysis, Design, Coding, Development and Implementation using Agile-Scrum as an iterative framework for development.
  • Involved in writing SQL queries (Sub queries, Correlated sub queries and Join conditions) and worked on advanced features of PL/SQL like cursors, ref cursors, collections, varray and dynamic SQL.
  • Worked on writing stored procedures according to teh requirement and modifying teh existing scripts.
  • Utilized SQL*Loader to perform bulk data loads into database tables from flat files.
  • Worked on User-defined and System defined exceptions to handle different types of Errors.
  • Created different reports using Excel according to teh requirement.
  • Worked on Perl and Shell scripting according to teh requirement.
  • Designed and developed screen interface using Oracle Forms, Reports.
  • Developed Front end with Forms 6i and wrote DDL statements, PL/SQL Library and triggers in oracle forms.Developed LOV’ Confidential and Triggers for different data blocks.
  • Developed complex Oracle forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications.
  • Managed and resolved design issues during development stage. Worked closely with other developers.
  • Used teh methods provided in teh JDBC API to create, read, update and delete teh data from teh database.

ENVIRONMENT: Windows 7, Oracle 11i, Putty, SQL Developer, PL/SQL, Excel, Perl 5.x, UNIX, Forms 6i, Reports 6i, Windows XP, JDBC 4.0, Java1.6

Confidential, North Chelmsford, MA

Web / Database Developer

Responsibilities:

  • Extensively involved in writing SQL queries (Sub queries, Correlated sub queries and Join conditions).
  • Involved in Creation of tables, views, Indexes, sequences, synonyms, database triggers, packages, functions, and stored procedures using PL/SQL.
  • Used Analyze and Explain plan for tuning and Optimization of SQL Queries.
  • Utilized SQL*Loader to perform bulk data loads into database tables from flat files.
  • UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
  • Worked on User-defined and System defined exceptions to handle different types of Errors.
  • Developed web pages using HTML, PHP, JavaScript, CSS and AJAX.
  • Used Cascading Style Sheets (CSS) to make teh layout of teh application uniform.
  • Worked on Content Management System and Involved in manual testing and cross browser compatibility.

ENVIRONMENT: Sun Solaris 5.10, Windows Server 2003, UNIX, Putty, Oracle 10g, PL/SQL, Toad 9.6, PHP 5.3, HTML, CSS, JavaScript, AJAX, JQuery, Zend Framework, Zend Server, Apache 2.2, Git, Test Mate.

We'd love your feedback!