SUMMARY

• Having 10+ years of experience with Oracle 8i, 9i, 10g, 11g R1, 11g R2,12c,19c working as Oracle Developer and developing back - end modules, such as packages, functions, procedures, triggers, object types, views, and snapshots for multitier business applications, OLTP systems, in SQL and PL/SQL.
• Expert in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL.
• Creating and Managing the Database Objects Such as Tables, Indexes and Views
• Experience in data loading, export/import, Data Pump and backup/restore, session monitoring, providing technical support to Oracle users, Oracle Client installation, and network environment setup.
• Good Experience in using SQL*Loader, Export, Import and Data Pump.
• Extensive usage of Autosys Tool for the scheduling the Extract Jobs and monitoring the jobs which are scheduled and running.
• Extensively used the Data Pump Utility to export/Import the tables from one schema to other schema and Different Environments.
• Having Good Experience of using External Tables as a file to read the CVS files.
• Having Good Experience of Generating the Explain plan and execution plan for tuning the top SQLs and reduce the cost for Cost Based optimizer.
• Good experience of Performance Analysis and SQL query tuning, response time reducing, while designing scalable applications from scratch and maintaining existing ones, using AWR, EXPLAIN PLAN and TKPROF.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Extensive and very intense SQL coding, database modeling, and development experience for OLTP database and OLAP database.
• Experience using SQL*Navigator and TOAD for query building and analysis and manipulations of databases for checking compatibility and integrity of RDBMS.
• Involved for Writing Redhat Linux/Unix Shell Scripts for backups and batch/job scheduling.
• Experience in supporting the various production issues addressed by the users from the client side and providing them with required solutions.

TECHNICAL SKILLS

Oracle Tools: SQL*PLUS, TOAD, ORACLE, SQLDeveloper, D2K (Developer 2000)

Oracle Utilities: Export/Import, Data Pump, SQL*LOADER

Languages: Shell Scripting, SQL, PLSQL, Java

Databases: Oracle 19c/12c/11g/10g/9i

Scheduling Tools: Control-M, Autosys

Operating System: UNIX, Red Hat Linux, Windows 9x/XP

PROFESSIONAL EXPERIENCE

Oracle Database Developer

Confidential, Sunnyvale, CA

Responsibilities:

• Study and Understand the Existing data model like logical (LDM), physical (PDM) and entity relationship diagrams (E-R) for master, transactional and security Databases.
• Extensively created the tables, views, and Indexes in the development Environment for US Datacenter.
• Developed the PL/SQL Objects like Stored Procedures, Packages, and Functions for POS applications based on different GEO conditions.
• Worked extensively on creating tables, External Tables, Indexes, Views, stored procedures, functions, and packages as for the Business Logic of the application.
• Extensively working as Oracle 12c for Developing the oracle Database Objects in development and qa Environment.
• Extensively moving and Migrating the Database objects which are created in oracle 11g to oracle 12c.
• Creating and supporting the Database for oracle 11g and oracle 12c.
• Generating the AWR Report and Identifying the top SQL’s In the Database.
• Understanding and Analyzing the AWR report and Explain plan/Execution plan and Tuning the sqls by applying the Hints.
• Study and Understanding of the AWR Report and Identifying the Physical and logical Reads, Gets/Reads, wait events of the Database.
• Extensive usage of Autosys Tool for the scheduling the Extract Jobs and monitoring the jobs which are scheduled and running.
• Monitoring the scheduled Jobs in the Autosys and Identifying for the Job Delays and Issue for root cause Report Generation.
• Extensively Used the shell scripts to run the Extract jobs for Generating the Daily Report for different Geos.
• Working with entire POS team members and collecting the db changes which are planned for qa and higher environments as for releases.
• Good Experience in using SQL*Loader, Export, Import and Data Pump.
• Extensively used the Data Pump Utility to export/Import the tables from one schema to other schema and Different Environments like from qa to dev and Integration.
• Having Good Experience of using External Tables as a file to read them. csvs and fpmls.
• Having Good Experience of Generating the Explain plan and execution plan for Tuning the top SQLs and reduce the cost for Cost Based optimizer.
• Co-coordinating with team members and fixing the errors which occurred on Integration Environment and making sure those should not occur in Higher Environments (qa/it/prod).
• Creating the Database objects (Tables, views, Indexes, packages, functions, and procedures) In development Environment and making sure all the db objects sync with Integration environment.
• Implemented the Unit test by posting the .csv files and validating the Data into the tables and making sure they are working as per the requirement.
• Finding the db Exceptions in all environments (qa/pre-prod/prod) by querying Exceptions table and Finding the root cause for Exceptions.
• Finding the Failed/Exceptional trades in the log files by connecting the Linux servers and Identifying the failed trades for root cause.
• Creating the table backups before creating the partitions on the database tables which required partitions.
• Applying Indexes and database Hints for Database objects and tuning them for performance.
• Implementing the better Explain plan for long running sqls by applying the oracle hints and order of execution.
• Writing the sqls for Data fixes and implementing the sqls through dbas and production databases

Environment: Oracle 19c, SQL Developer, Toad Autosys, SQL plus, Linux/Unix, shell script, Java, GIT

Oracle Database Developer

Confidential

Responsibilities:

• Involved extensive interaction with the users to determine their requirements.
• Requirement gathering, analysis, designing, programming and unit testing.
• Study and Understand the Existing data model like logical (LDM), physical (PDM) and entity relationship diagrams (E-R).
• Created, Monitored, and implemented the solutions as required in a Service Request (SR’s).
• Created the Control Files to load the data from flat files to oracle systems Using SQL LODER.
• Worked with Import and Export of the Database Utilities for taking the backup of the tables and loading into Different environments.
• Created the explain plan for long running sqls and applied hints and changed for better plan.
• Extensively Used the shell scripts to run the for-Batch jobs for Generating the Daily Reports.
• Good Experience in using SQL*Loader, Export, Import and Data Pump.
• Extensively used the Data Pump Utility to export/Import the tables from one schema to other schema and Different Environments.
• Having Good Experience of using External Tables as a file to read the Mainframe flat files.
• Having Good Experience of Generating the Explain plan and execution plan for Tuning the top SQLs and reduce the cost.
• Modified the PL/SQL Stored Procedures, Packages, and Functions & Database Triggers to support and Enhancements or changes in the Existing open systems Application.
• Worked extensively on creating tables, Indexes, Views, stored procedures, functions, triggers, and packages As for the Business Logic of the application.
• Written the Complex SQL Queries As for the data Request from the client and Open System Developers.
• Extensive usage of Control-M Tool for the scheduling the Extract Jobs and monitoring the jobs which are scheduled and running.
• Monitoring the scheduled Jobs in the Control-M and Identifying for the Job Delays and Generating the Daily Reports.
• Written SQL and PL/SQL Involving in Tuning Complex SQL Queries for Better Performance in Database Objects.
• Generating the AWR Report and identifying the top SQL’s In the Database.
• Understanding and Analyzing the AWR report and Explain plan/Execution plan and tuning the sqls by applying the Hints.
• Study and Understanding of the AWR Report and Identifying the Physical and logical Reads, Gets/Reads, wait events of the Database.
• Extensive Usage of Toad and SQL Developer for Execution of the database Objects (Procedures and Functions) and to Develop changes or Modifications for Existing objects in Different Environments.
• Good Exposer and Involved for Writing Unix/Linux Shell Scripts for Scheduling the oracle jobs and Batch jobs and backups.
• Involved in creating and modifying the existing database packages stored procedures and Functions as for the Enhancements and changes for the application.
• Written complex queries and stored procedures using sql *plus and monitored databases using TOAD.
• Experienced in creating Materialized views and tuning them.
• Created tables, indexes, views, sequence, synonyms.
• Implemented the code involved in modifying the database records using nested queries and PL/SQL routines.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native dynamically created SQL within Procedures Dynamic SQL.
• Developed Complex system and application triggers using PL/SQL for data integrity and enforcing business rules.
• Improved performance of Application using PL/SQL Packages and Oracle in built Packages.
• Manipulated Complex Data types within PL/SQL using collections.

Environment: Oracle 11g, SQL Developer, Toad, Control-M, Linux, SQL plus, PL/SQL Developer, .NET.

Oracle Database Developer

Confidential

Responsibilities:

• Involved extensive interaction with the users to determine their requirements.
• Requirement gathering, analysis, designing, programming and unit testing.
• Involved in the design of the flow and entity relationship diagrams.
• Created, Monitored and implemented the solutions as required in a SR.Developed packages for inserting values into various tables.
• Develop PL/SQL Stored Procedures, Packages, and Functions & Database Triggers to support the upgrades in the application.
• Good Exposer and Involved for Writing Unix/Linux Shell Scripts for scheduling the oracle jobs and making Schedules for logical backups using Export/Import Utilities.
• Performed database tuning with Stats pack and AWR.
• Written complex queries and stored procedures using sql *plus and monitored databases using TOAD.
• Worked extensively on creating tables, Views, stored procedures, functions, triggers and packages using PL/SQL.
• Involved in creating and modifying the existing database packages stored procedures and triggers.
• Created tables, indexes, views, sequence, synonyms.
• Planning and implementation of security user access and privileges for database objects/application data, Control user privileges within a database.
• Implemented the code involved in modifying the database records using nested queries and PL/SQL routines.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex system and application triggers using PL/SQL for data integrity and enforcing business rules.
• Improved performance of Application using PL/SQL Packages and Oracle in built Packages.
• Manipulated Complex Data types within PL/SQL using collections.

Environment: Oracle 11g, Toad, Crystal Reports, SQL Plus, PL/SQL Developer

Oracle Pl/Sql, Developer/DBA

Confidential

Responsibilities:

• Responsibilities: Involved in requirements study technical analysis and database design & tasks identification.
• Created tables PL/SQL procedures, functions, Triggers, and packages wherever required for the application.
• Writing the stored procedures and checking the code for efficiency, tuning sql queries to get best response time.
• Performance tuning was extensively done using EXPLAIN PLAN and TK PROF to reduce the execution times of the queries.
• Developed Interfaces using PL/SQL.
• Develop procedures, functions, packages using Inline views, Materialized views, Dynamic Sql to create reports and views for the Hyperion planning and Essbase system.

Environment: Oracle 10g, PL/SQL, Java, ADF (Application Development framework), D2K(Forms and Reports)

Oracle Pl/Sql, Developer/DBA

Confidential

Responsibilities:

• Extensively involved in PL/SQL programming on Oracle 9i database engine.
• Provide database design support for new system development set.
• Set oracle standards for object names and usage.
• Worked extensively on creating tables, Views, sql stored procedures, functions, triggers and packages using PL/SQL.
• Used TOAD as an Oracle developer tool.
• Extensively worked on database cursors and collections in Oracle database.
• Proficient in using SQL* Loader and external tables to transfer data from operating system flat files to the Oracle database.
• Tuning SQL queries & use of range/list partitioning and materialized views.

Environment: Oracle 9i/10g, D2K (Forms and Reports)