PROFESSIONAL SUMMARY:

• More than 10 years of strong experience in development, implementation and support of Database Applications using Oracle 12c /11g/10g /9i, Postgres, SQL, Analytical Functions, PL/SQL and PL/pgSQL Stored Procedures, Packages and Triggers, Tables, Indexes, Constraints, Materialized Views
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical Functions, Materialized Views, Query Re - Write.
• Good experience of Performance Analysis and SQL Query Tuning using Indexes, Hints, Query Optimizer, Expain PLAN, SQL Tuning Advisor, SQL Access Advisor for designing scalable applications from scratch and maintaining existing ones.
• Efficient in writing SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
• Experience in migrating database from Oracle to AWS Aurora Postgres.
• Experience in Oracle supplied packages, Collections, Dynamic SQL, Records and PL/SQL Tables.
• Experience in Oracle Cursor Management and Exception Handling.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Extensively worked on SQL*Loader, which loads data from flat files into Database tables, UNIX Crontab and writing Shell Scripts for automated monitoring, backup and data loading.
• Creation of Data Warehouse database consisting of Star Schema, Snowflake schema, Fact & Dimensions tables
• Experience in creating logical and physical models as a part of ETL.
• Worked with analyzing data and representing it in various forms using Python and R.
• Experienced in working with various Python Integrated Development Environments like IDLE, PyCharm, Atom, Eclipse, PyDev and Sublime Text.
• Experience with Requests, Numpy, Scipy, Matplotlib, and Pandas python libraries during development lifecycle
• Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.

TECHNICAL SKILLS:

Operating System: Solaris v10,11.2, Linux 6, RedHat Linux RHEL 4.x, 5.x, Windows

RDBMS: Oracle/10g/11g/12c with RAC, Access, OLAP, OLTP, PostgreSQL

Languages: Oracle SQL, PL/SQL, Bash/Korn Shell scripting, Perl, HTML, XML, Python,R

High Availability: Oracle 10g/11g RAC

Database Tools: SQL Developer, SQL Listener, SQL*Loader, SQL*Plus, SQL Navigator, Toad, DBeaver, App Designer, Data Mover, Oracle Grid Control, Goldengate 11.2/12.2, RMAN, Data guard Export/Import, Oracle Data pump(exp/imp), Nexus, Foglight, Blade Logic

Tools: Oracle Import/export utility, SVRMGRL and SQL*PLUS, Oracle Enterprise Manager, Cron, Autosys, DBCA, SVRCTL, CRSCTL

Telnet Tools: PuTTy, Secure Shell, SuperPutty

Ticketing Tools: Service Now, BMC Remedy, Bridge clarify, CMR (Change management request)

Others: NAGIOS, MRTG, SNMP, WinCSP, FileZilla, AWS.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Database Developer

Responsibilities:

• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Worked on Postgres CITUS to help created a distributed system
• Involved in performance tuning which included creating indices, table partitioning, SQL hints using explain plan utility
• Created, debugged and modified stored procedures, functions, packages, tables, views, materialized views and SQL scripts using PL/SQL
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Enviroment: Oracle 12c, Postgres CITUS, Postgres/SQL, PL/SQL, SQL, GitLab, One Jira, TOAD, Performance Tuning, AWS RDS, AWS Aurora Postgres.

Confidential, Alpharetta, GA

Database Developer

Responsibilities:

• Delivery and support of PL/SQL functionalities - packages, cursor management, triggers and exception handling.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Extensive experience in creating and maintaining Database Objects such as Tables, Views, Indexes, Constraints, Sequences, Synonyms and Database Links.
• Monitoring schema objects (tables and indexes) growth, server, instances, users and transactions regarding the database availability.
• Part of technical production support for incident response for three projects and closed the tickets very accurately on JIRA.
• Modifying the oracle code to work on Postgres.
• Working on the migration of data from Oracle to Postgres environment.
• Working on pgsql changes on the migrated data from Oracle.
• Working on PL/pgSQL, including stored procedures, functions, triggers, and views.
• Working on performance tuning of data extraction SQLs for reports generation.

Enviroment: Oracle 12c, Postgres/SQL, PL/SQL, SQL, GitLab, One Jira, TOAD, Performance Tuning, AWS RDS, AWS Aurora Postgres.

Confidential, Charlotte, NC

Oracle Developer

Responsibilities:

• Responsible for writing PL/SQL Packages, Functions, Procedures using PL/SQL Collections, cursors and Dynamic SQL.
• Creating primary objects (tables, views and indexes) once the application developers design an application.
• Written advanced SQL Queries and DML statements using Analytical Functions, Multi Table inserts, inline views.
• Performed SQL Queries Tuning using EXPLAIN PLAIN, SQL Tuning Advisor, V$ views, Hints, Statistics and Query Optimizer.
• Experienced in developing Database Types and Objects for front-end applications and call them using a function.
• Developed Triggers on tables and handled Mutating errors with the help of PRAGMA AUTONOMOUS Transaction.
• Developed Views, Materialized Views based on the requirement and refreshed them periodically.
• Developed PL/SQL Procedures and database triggers for the validation input data and to implement business rules.
• Experienced in Handling Exceptions in oracle Packages and procedures using Oracle Pre defined exception handlers and DML Error Logging techniques.
• Perform root cause analysis on failures. Experienced in Oracle Support processes for technical requests through Metalink.
• Written the Shell(Korn) and SQL Scripts in coordination with system admin for monitoring the alter logs, disk spaces at O/S level, table spaces at DB level, to check the availability of database and listeners, and automated jobs through cronjobs.
• Generated various report using Python Report lab and sent to Business users to improve their decision making.
• Used materialized Views to reduce query execution time and help with Database Performance.
• Monitored and checked the logs files for the file failures or successful processing in various environments
• Experience in KSH, PERL, BASH scripting. Written various shell scripts to monitor database connectivity, Listener Connectivity, Tablespace and File system monitor.
• 24x7 on-call Production support for database activities.

Enviroment: Oracle 11g/12c, PL/SQL, TOAD, RHEL 6,5.8,5.4, Shell Scripting, Python, SQL, Performance Tuning.

Confidential, Chesterfield, MO

Oracle Database Administrator/Developer

Responsibilities:

• Delivery and support of PL/SQL functionalities - packages, cursor management, triggers and exception handling.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Extensive experience in creating and maintaining Database Objects such as Tables, Views, Indexes, Constraints, Sequences, Synonyms and Database Links.
• Defining the database recovery procedures for standalone and RAC environment and developed backup and recovery shell scripts to automate the full(RMAN/DataPump) and incremental backups and scheduled them to execute periodically.
• Monitoring schema objects (tables and indexes) growth, server, instances, users and transactions regarding the database availability.
• Setup of high availability RAC environment with ASM with 3/4 nodes in a cluster.
• Part of technical production support for incident response for three projects and closed the tickets very accurately on JIRA.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Enviroment: Oracle 10g/11g/12c, Oracle 12c/11g RAC, ASM, PL/SQL, TOAD, RHEL 6,5.8,5.4, Perl Scripting, Python, SQL, Performance Tuning.

Confidential, Louisville, KY

Oracle Developer

Responsibilities:

• Delivery and support of PL/SQL functionalities - packages, cursor management, triggers and exception handling,
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Extensive experience in creating and maintaining Database Objects such as Tables, Views, Indexes, Constraints, Sequences, Synonyms and Database Links.
• Deploying the Telecom Operations and Management Service (TOMS) product for various clients as per their requirements.
• Proactively assigning various types of deployment orders and troubleshoot issues within the end time constraint to aid customers with their activities on the new environment.
• Working on different types of orders like creating a new instance, updating an instance, backing up an instance and removing an instance.
• Served as the IT Deployment lead for 5 projects responsible for development, testing and production environments.
• Trained 3 other engineers in deployment activities and other procedures.
• Created DB console for the customer and implemented monitoring alerts and configuring targets and threshold values.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
• Was the only engineer to deploy NetProvision (NetP) product with Informix database document all the procedures.
• Checking Alert Logs Files, Trace Files and System Event Logs for unusual events
• Analyzing the hardware and pre-requisite third party software’s for installation of product to be deployed.
• Configuring system as per user requirement; developing scripts for data manipulation & data archiving.

Environment: Oracle 11gR2, 10g, RMAN, TOAD, SQL LOADER, DATA PUMP, PL/SQL

Confidential

Oracle Developer

Responsibilities:

• Installation of RHEL 6.0/6.4 software and configuring Oracle 10g/11g/12c standalone instances for various development and testing environments.
• Extensively used bulk collection in PL/SQL objects, partitioned the fact tables and materialized views for improving the performance.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Transferred SQL and Korn shell programs into ODI and created data extracts.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Involved in Importing and exporting the Tables, Users, and Schemas.
• Performed various activities, such as database recovery, performance monitoring and tuning, structured query language, operating systems and relevant tools.
• Installation and configuration of Oracle 11gR2 clusterware and database software with ASM for 3 nodes on OEL (Oracle Enterprise Linux) to provide high availability.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Adding and evicting nodes from the clusters when required.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER and CRONTAB to schedule tasks.
• Installation of Oracle Weblogic 11g and domain creation for deploying the build given by the development team.
• Developed shell scripts to automate file system usage, switch archive log destination and database monitoring.
• Creating and maintaining logins, synonyms and access privileges using roles to control access to the database using operating system and Oracle security features.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Part of technical production support for incident response for three projects and closed the tickets very accurately on JIRA.
• Designed and developed complex Procedures, Functions & Packages to handle errors and exceptions at database level using PL/SQL
• Created various database objects like tables, views, materialized views, procedures, functions and packages using oracle tools like Toad, SQL Developer and SQL* plus.

Confidential

Oracle Developer

Responsibilities:

• Automate the oracle installation, configurations and the product installation through shell scripts.
• Writing and modifying stored procedures, functions and triggers to update the internal structures and to reflect the newly loaded data.
• Creating physical and logical design of database using ER diagrams.
• Capturing the data from various sources on a timely basis and performing data assimilation, analyzing and generating strategic reports for management purposes.
• Implemented table partitioning to improve performance and data management.
• Generated AWR and ADDM reports and analyzing the performance statistics.
• Performing load testing with varied number of XML files for the application developed.
• Also used SQL Loader to load data into tables.
• Defining the database recovery procedures for standalone and RAC environment and developed backup and recovery shell scripts to automate the full(RMAN/DataPump) and incremental backups and scheduled them to execute periodically.
• Refreshing the development/testing databases with Export/Import or DataPump to replicate the production database.
• Wrote PL/SQL Packages, Procedures and Functions to implement the business rules and to generate the attribute corrections and parallel comparison reports.
• Used SQL* Loader and PL/SQL stored procedure for data conversion and interfaces processes.
• Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Developed PL/SQL code to fetch data from XML and load into database tables.
• Involved in fine tuning and optimization of different SQL queries to insure faster response time.

Confidential

Oracle Developer

Responsibilities:

• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.
• Installation and configuration of Oracle 11g and creation of databases for development and testing environments.
• Creating and maintaining logins, synonyms and access privileges using roles to control access to the database using operating system and Oracle security features.
• Capturing the data from various sources on a timely basis and performing data assimilation, analyzing and generating strategic reports for management purposes.
• Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security.
• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
• Monitoring schema objects (tables and indexes) growth, server, instances, users and transactions regarding the database availability.
• Responsible for taking hot backups and logical backups at schema, tablespace and database level.
• Created data models which involved star schemas, snowflake schemas, fact and dimension tables.
• Created conceptual and physical data models for the user requirements.

Confidential

Oracle Developer

Responsibilities:

• Collaborated with designers to create clean web interfaces and simple, intuitive interactions and experiences.
• Worked with HTML, XML and JavaScript to create web interfaces.
• Carry out quality assurance tests to discover errors and optimize usability.
• Created necessary database objects for very large databases that has a high transaction rate.
• Made sure that all the data assets were available.
• Created PL/SQL module which was used to integrate the existing data from third parties and on to the database.
• Came up with several programs so as to ensure that there was correct data transfer.
• Researched on various database products and recommended the best ones.