We provide IT Staff Augmentation Services!

Senior Oracle Pl Sql / Db2 Developer Resume

SUMMARY

  • Having 14+ years of experience in IT, involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
  • Experience in Relational DBMS in, Oracle, DB2 and SQL Server by creating Database diagrams, stored procedures, functions, triggers, views, constraints, indexes and query optimization & CTE
  • Served as a Subject Matter Expert, guiding the development, maintenance, and support of a variety of applications
  • Handled performance tuning related in many projects
  • Developed unit and integration test plans and automated unit tests
  • Expertise with Oracle Collections (Associative arrays, Nested Table & VARRAYS)
  • Good knowledge of Data warehouse concepts
  • Experience in Application Development Life Cycle (Agile, Waterfall)
  • Performed production support to ETL informatica Jobs scheduling, execution and debugging
  • As ETL Informatica specialist, I'm expertise in informatica 9.6.1 and 10.1 Version
  • Experience in Automation of repetitive tasks
  • Lead multiple Team with an experience in working with onshore/offshore model with multiple time zones
  • Experience in working with version control tools like PVCS, TFS, CVS & SVN
  • Highly adaptable in quickly changing technical environments with strong organizational and analytical skills
  • Excellent communication and interpersonal skills with ability to interact with individuals at all levels and can work as a part of a team as well as independently
  • Extensive experience with analysis, design, development, customizations and reporting
  • Experienced in Dev - ops including setting pipe line for continuous delivery
  • Expertise in Unix Shell Scripting
  • Expertise in Java, JavaScript and JSON
  • Strong Experience in front-end and back-end development using Forms 12c/10g, Reports 12c/10g
  • Have exposure on AWS concepts
  • Flexible and versatile to adapt to any new environment and work on any project
  • Excellent understanding of DataStax Cassandra Architecture
  • Commendable knowledge on read and write processes, including SSTables, MemTables & Commit log
  • Experience with querying on data present in Cassandra cluster using CQL (Cassandra Query Language).

TECHNICAL SKILLS

Relational Databases: Oracle 10G/11G/12c, DB2 9.7/10.x, and SQL server

Scripting Language: Unix and Linux

Big Data: Datastax Cassandra

Programming Language: Core Java, JavaScript and JSON

DB Languages: SQL, PL/SQL and DB2 SQL

Database Tools: Toad, SQL Plus, SQL Developer, SQL Query Analyzer, SQL DBX, SQL profiler

Reporting Tools: Tableau, QlikView & Oracle reports

ETL Tools: Informatica 9.6.1 and 10.1

Version Control: PVCS Serena Library Management, SVN & CVS

Operating Systems: Windows 7/Vista/XP/2000/NT/98, UNIX, Linux, AIX

IDE: Oracle Forms

Work Flow Tools: MSOffice suite, Service Now & Team track, HP ALM, Visio, Autosys, Rational Portfolio Manager, Rational Clear Case, Rational Application Developer & JIRA

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle PL SQL / DB2 Developer

Environment: Oracle 12C, Rest API, IBM Db2, JavaScript, XML, UNIX, Autosys, Toad, SQL Developer, SSH & JIRA

Responsibilities:

  • Participate in all phases of the Software Development Process including design, development, testing, deployment and maintenance
  • Develop and document technical requirements for database-related developments from functional requirements requested by the business
  • Translate requirements into technical specifications including the physical and logical data modelling, designing and data flow diagrams
  • Develop new Stored procedures, triggers and functions using SQL and Modify existing SQL, procedures, triggers and functions
  • Create database tables, indexes, views, triggers and other objects as per requirements
  • Develop and execute complex SQL Queries to retrieve data from the database to validate aggregate data
  • Created Unix script to call the SQL procedures
  • Create high level design of the solution (macro-design), Low level micro-design, Coding, Unit Testing, Quality Assurance & User Acceptance Testing support
  • Create a reliable, performant, scalable architecture and effectively communicate with stake holders and teammates
  • Performed informatica session tuning by query changes and optimizing informatica parameters.
  • Worked on informatica cluster services
  • Performed Informatica B2B execution and CDC setup for informatica power Center
  • Have Experience in Informatica DVO for data validation
  • Produce ad-hoc queries and develop reports to support business needs
  • Review database code and queries
  • Plan and coordinate data migrations between systems
  • Develop robust SQL statements. Optimize them for maximum performance by analyzing the execution plan and changing them as needed
  • Execution of the unit Test Cases through ALM tool
  • Collaborate with other developers and DBAs to promote changes from the development environment to QA and UAT environments
  • Work on automation to improve the business functionality
  • Create scalable, reusable, modern architecture and functional design specification documentation

Confidential

Senior PL/SQL Developer

Environment: Oracle 12c, Oracle Forms & Reports, Java, JavaScript, JSON, UNIX, Autosys, Splunk, Tableau, Toad and SSH

Responsibilities:

  • Designing tables & Development of Stored Procedure, Function, Views and Triggers
  • Created Oracle Materialized Views Scheduled Refresh to be used in the reports
  • Used Oracle Instead of triggers on the views to update the base tables
  • Created Oracle External tables for data validations for the flat files
  • Developed stored procedures using Oracle Bulk Collections for huge data sets
  • Developed stored procedures to perform row by row computations using Oracle Cursors and used as an output from the procedures / functions
  • Improved performance by creating required indexes, table partitioning.
  • Coding, unit testing, moving components to Production, Rollout and Back out Plans
  • Experienced in writing complex programs that work with different file formats like Xml, JSON
  • Performance Tuning of Stored Procedure and SQL queries
  • Handling Incident, Problem, change tickets & Demands
  • Onshore/Offshore coordination
  • Created Unix script to call the SQL procedures
  • Created Unix script to archive log files
  • Created CRON jobs in UNIX server for claim creation, Bank Feed, etc process.
  • Used tools like awk, sed, grep & find command in the Unix scripting
  • Interacting with customer for new requirements and critical issues
  • Support improvement (FCR) and ticket monitoring
  • Developed Data Flow Diagrams for business scenarios for reviews with business users, test team and developers
  • Performed informatica session tuning by query changes and optimizing informatica parameters.
  • Worked on informatica cluster services
  • Performed Informatica B2B execution and CDC setup for informatica power Center
  • Have Experience in Informatica DVO for data validation
  • Developed and executed complex SQL Queries to retrieve data from the database to validate aggregate data
  • Extensively analyzed financial data from various data sources and assisted in updating the Data validation rules and Data mapping document for Securities Data Mart. Additionally, developed SQL queries to validate the Data transformation process from these sources has loaded relevant and accurate financial data
  • Performed executions of Autosys jobs in UNIX which involved scheduling, monitoring and troubleshooting in case of job failures
  • Participated in Defect review meetings with the team members and worked with overall team to meet project goals
  • Debugging and diagnostic skills in batch processing
  • Contributed to Production Readiness Review efforts and extended assistance by testing and validation to release Readiness document and Production Deployment Plan

Confidential

Senior PL/SQL Developer

Environment: Oracle 10G, Java, XML, Oracle Forms & Reports, Unix

Responsibilities:

  • Created stored procedure for the business logic as per the technical specification
  • Developing, Testing and deployment of codes in all the regions
  • Worked on Complex SQL queries according to business requirements
  • Created stored procedures with Ref Cursor as out parameters and return types for functions
  • Created & Used Oracle objects to store the customer address information
  • Replaced the hard-coded values with Oracle Bind Variable in SQL tuning
  • Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow
  • Build mappings to extract data and load into the database
  • Created test data subsets for testing
  • Responsible for identifying the missed records in different stages from source to target and resolving the issue
  • Written complex queries to find/fix the data issues
  • Working with business/users to ensure the delivery of projects

Hire Now