Database Engineer Resume
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.
