We provide IT Staff Augmentation Services!

Database Developer Resume

Dallas, TX

SUMMARY

  • 4+ years of IT experience in Business Requirements Analysis, Application Design, Database design, Data Modeling, Development, Database Marketing, Testing, Implementation, SQL Performance Tuning, Data warehousing ETL process and Client/Server applications for Retail, and Healthcare Industries.
  • Possesses expert skills in the development of applications utilizing Oracle tools including Oracle PL/SQL, SQL Plus, SQL Loader and IBM tools IBM Data Studio, System I Navigator and MySQL Workbench.
  • Extensive experience in developing stored procedures, functions, triggers and packages using tools SQL*PLUS, TOAD, PL/SQL Developer, MySQL Workbench and IBM Data studio.
  • Expertise in Unix shell scripting and automated task scheduling using crontab.
  • Experience in analyzing business rules and coordinating in application design and database design.
  • Used DML triggers to update the tables when any DML event occurs and developed Database Triggers to enforce security.
  • Experience in performance tuning and Optimization of SQL queries using Explain Plan.
  • Expert knowledge in using Data Modeling tools like ER diagrams wif Normalization Techniques for designing database wif Relational technology.
  • Strong Programming and debugging skills in PL/SQL, MySQL, Dynamic SQL, C, Pro*C and Unix Shell Scripting.
  • Extensive experience in Enterprise Data warehousing. Design of Extraction, Transformation & Load (ETL) environment.
  • Good experience on OLTP and OLAP systems.
  • Extensively worked on Code migration from Development, Systest and Production.
  • Demonstrate the analytical ability to understand the business requirement/process, convert the business specification to technical document, data management, develop and integrate solutions to meet the requirement.
  • Strong in Designing, Development (coding), Testing, Implementation and Documentation as per Industry standards.
  • Possesses the ability to work autonomously as well as Team management experience.
  • Strong business analysis skills to fine business problem, process, management.
  • Excellent communication, inter personal, presentation, strong analytical and trouble shooting skills.

TECHNICAL SKILLS

Tools: TOAD, SQL *Plus, SQL *Loader, SQL Developer, Informatica, Pentaho, liquibase, System,iNavigator,dbeaver,IBMDataStudio,GitHub,Tableau

RDBMS: Oracle 11g/10g/9i/8i, DB2 on AS400, DB2 on LUW, Maria DB, SQL Server

Languages: PL/SQL, MySQL, RPG, Unix Shell Scripting, XML, HTML, Perl Scripting and PRO*C.

OS: UNIX (Sun Solaris, AIX), Linux and Windows NT/2000/XP.

PROFESSIONAL EXPERIENCE

Confidential, Dallas,TX

Database Developer

Responsibilities:

  • Worked on projects using AGILE/SCRUM methodology.
  • Involved in entire project life cycle including database Design, Development, Testing, Optimizing, deploying on development and production servers.
  • Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures, Clusters, Triggers and maintaining referential integrity.
  • Performed ETL operations using Pentaho Kettle to design jobs and transformations resulting in data migration.
  • Analyze technical requirements and design new data objects to support our internal SOLR search engine.
  • Actively participated in Database design and functionality implementation of Proquote Module as part of Seller Application.
  • Convert stored procedures and functions from DB2 AS400 format written in RPG to pure SQL on Oracle DB.
  • Actively participated in the data migration during the G1 Applications integration.
  • Extensively worked on pealing out the member, seller and auction modules from DB2 on AS400 to Oracle DB.
  • Extensively worked on Virtual sale project to push to prod, which resulted in the Huge growth of the company sales.
  • Deploying the database objects like tables, views and stored procedures using Liquibase.
  • Maintaining the database objects procedures, service programs, table functions and indexes on tables in DB2 environment, which has been developed using RPG language and converting them to SQL if needed.
  • Providing the field logic to search team to implement the logic in SOLR which improves the performance of application calls to get results faster.
  • Created views, temp tables, pre - migration and post migration scripts as part of G1 2.0 Data Migration across DB2 on LUW and Oracle DB.
  • Actively participated in the data modelling of seller, member and Yard databases as part of G1 2.0 and 2.1 versions development.
  • Good knowledge on using tableau to generate some ad-hoc reports and dashboards.
  • Helping the reporting team to develop their reports and providing the business logic to retrieve the data.
  • Performance tuning and optimization of SQL queries, stored procedures, functions and batch reports.
  • Gathering the metadata from business and load it to databases to support different application teams.
  • Helping the application team during the production bugs and handling major projects deployment to production.
  • Running the Sumo logic queries on production to capture the C2 error logs and Handling the business exceptions.
  • Handling tickets raised for SQL bugs in stored procedures and function by business user and QA team.

Environment: DB2 on AS400, Oracle DB, IBM i series Navigator, Tableau, Pentaho, IBM Data Studio, Liquibase, Unix.

Confidential

Database Developer

Responsibilities:

  • Involved in preparing Database Design, High level and low level documents.
  • Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers, collections and Unix shell scripts.
  • Automated the daily tasks using Oracle backend procedures, Unix shell scripts.
  • Involved in ETL design to convert different file formats into predefined format and automated dis process for different file formats.
  • Improved performance of reporting mart and some ODS processes.
  • Migrated data from Flat Files to Oracle database using SQL*Loader and External tables. Wrote Oracle PL/SQL programs for backend processing.
  • Experience on creating/tracking the change requests and issues using TFS.
  • Worked on developing ETL process to load the files into database and auditing the incoming data based on the business rules
  • Developed warehouse/mart processes using PL/SQL and Unix shell scripts
  • Worked wif Client and Internal SME’s to understand the business requirements and transferring those to technical documents.
  • On-call support on rotation basis.
  • Wrote SQL scripts to generate data for campaigns and to verify the counts wif functional team.
  • Implemented Oracle Table functions and Wif Clause queries in PL/SQL scripts which have written for ETL process.
  • Responsible for SQL tuning and optimization using Analyze, Explain plan
  • Created source to target mappings for data marts using Informatica
  • Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables. Used Cursor Variables to pass query results sets between PL/SQL programs
  • Wrote Unix Shell Scripts to extract and transfer (ftp) files to other systems.
  • Scheduled Unix jobs through Crontab.
  • Responsible for performing code reviews.
  • Testing of all the deliverables done wif User support
  • Client interaction through meetings & presentations
  • System Support - Assisted Client for User Acceptance Test for new releases

Environment: Oracle 11g, SQL*PLUS, SQL, PL/SQL, SQL*Loader, Linux, TOAD, PL/SQL Developer, Informatica, XML, HTML, Unix korn Shell, TFS, Business Objects

Confidential

PL/SQL Developer

Responsibilities:

  • Involved in preparing Database Design, High level and low-level documents.
  • Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers, collections, object types and K-shell scripts.
  • Involved in ETL design to convert different file formats into pre-defined XML format and automated dis process for different file formats.
  • Improved performance of reporting mart and some ODS processes
  • Worked wif DBA in making enhancements to physical DB schema. Also coordinated wif DBA in creating and managing table, indexes, partitions, triggers, db links and privileges.
  • Implemented new process to alert team before the First logic BO directories expiration
  • Improved the performance of existing phone and email merge purge process
  • Automated unica flowchart files QC
  • Migrated data from Flat Files to Oracle database using SQL*Loader and External tables. Wrote Oracle PL/SQL programs for backend processing.
  • Implemented Oracle Table functions and Wif Clause queries in PL/SQL scripts which have written for ETL process.
  • Implemented Oracle Regular Expression functions REGEXP SUBSTR, REGEXP REPLACE, REGEXP INSTR and REGEXP LIKE to parse and extract the strings in PL/SQL procedures.
  • Responsible for SQL tuning and optimization using Analyze, Explain plan
  • Implemented external tables for loading data into database.
  • Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables. Used Cursor Variables to pass query results sets between PL/SQL programs
  • Wrote Unix Shell Scripts to send (ftp) files to other systems.
  • Wrote perl scripts to convert the data in oracle table into XML format
  • Responsible for performing code reviews.
  • Testing of all the deliverables done wif User support
  • System Support - Assisted Client for User Acceptance Test for new releases

Environment: Oracle 11g/10g, SQL*PLUS, SQL, PL/SQL, SQL*Loader, UNIX (AIX 5.3), PL/SQL Developer, XML, HTML, First Logic, Windows NT, Unix korn Shell, Perl

Hire Now