SINDHUSHA PATURU

Email: adbyfv@r.postjobfree.com

Phone: 636-***-****

Professional Summary:

More than 9 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.

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 & Utilities

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.

Education:

Master of Science in Computer and Information Science from The University of Alabama at Birmingham (Jan 2017 – May 2018)

Bachelor of Technology in Computer Science from JNTU, India (2007 - 2011)

Certifications:

Oracle Certification Program as an Oracle Database 11g Certified Associate.

AWS Certified Solutions Architect Associate.

Professional Experience:

Verizon, Alpharetta, GA Oct 2018 – present

Role: 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.

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.

Wells Fargo, Charlotte, NC Aug’2017 – Aug’2018

Role: 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.

Monsanto, Chesterfield, MO Jan 2017 – July 2017

Role: 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.

Netcracker Technologies, India Sep’2015 – Dec’2016

Client: Dupont Pioneer, Louisville - KY

Role: 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.

Tech Mahindra Limited, India Jan’2014 – Aug’2015

Role: Oracle Developer

Client: NEC Corporation (UK)

Project: NEC NMS KPAM for FOXCONN

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.

Tech Mahindra Limited, India Feb’2013 – Dec’2013

Role: Oracle Developer

Client: NEC Corporation (UK)

Project: KPAM Customization for IUH

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.

Tech Mahindra Limited, India May’2011 – Jan’2013

Role: Oracle Developer

Client: NEC Corporation (UK)

Project: Graphical KPI Tool

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.

iTree Computer Services Pvt. Ltd, India Jan’2010 – Apr’2011

Role: 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.

Contact this candidate