Nikhita Desetty

Mobile: 5712297687

PROFESSIONAL SUMMARY:

● 7 years of experience as ORACLE PL/SQL Developer/Production Support in

Analysis, Design and Implementation of Business Application using the Oracle
Relational Database Management System (RDBMS).
● Created Tables, Constraints, Sequence, Synonyms using SQL and PL/SQL.
● Experience in writing Stored Procedures, PL/SQL Packages, functions and good
knowledge in Exception Handling. Also, PL/SQL queries like DML, DDL and
knowledge in Views, Triggers and Cursors using SQL and PL/SQL in Oracle.
● Experience in creating Joins and writing Sub queries and Analytical Functions in
Oracle.
● Basic Knowledge in PL/SQL advanced topics like Collections, UTL_FILE.
● Good conceptual knowledge Oracle 9i/10g/11g/12c.
● Worked with query tools like Toad, SQL Plus, SQL Developer.
● Experience in SQL Performance Tuning for Oracle RDBMS using Explain Plan,
STATSPACK and Index.
● Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space
and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs,
Trace files and backup verifications.
● Creation of databases, instances, table spaces, data files, rollback segments.
● Hands on Experience on informatica PowerCenter tool (Designer, Workflow manager
and Workflow monitor).
● Good at Hadoop using hue tool and capable to work on Splunk and Dynatrace.
● Having good troubleshooting and debugging skills.
● Good knowledge in monitoring pods and analyzing logs in OpenShift tool.
● Possess good interpersonal skills which have put to good use in coordinating with
Project teams and providing customized software solutions.
● Having good analytical skills, excellent communication skills, and ability to
effectively interact with business and technical resources.
● Good at Agile workflow with effective communication skills and abilities in resolving
issues.
● Extensive experience in user interactions, requirement analysis, design, development
and implementations of applications in Oracle technology.
● Good exposure on implementation and providing postproduction support activities
● Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database
monitoring/performance/diagnostics.
● Good experience in writing/editing UNIX Shell Scripts.
● Good experience in PATCHING AND UPGRADATION. Expertise in upgrading
Oracle Development and Production databases from 8i to 9i, 9i to 10g & 11g, 10g to
11g.
● Extensive knowledge and experience on managing very large Data Warehouse
databases.
● Scheduling Jobs and Alerting using SQL Server Agent
● Motivated team player and an adaptable individual with good analytical and strong
interpersonal skills.
● Excellent written and verbal communication skills.

TECHNICAL PROFICIENCY:

SQLPLUS, SQL Developer, PL/SQL Developer, Toad,

Tools/Platforms SQL Server Management, Informatica tool, Hue tool,
WinSCP, CA workstation (ESP), Splunk, Dynatrace,
OpenShift
Languages Oracle SQL, PLSQL
Database Microsoft SQL Database, Oracle
Operating System Windows, Linux

PROJECTS INVOLVED:

Client: Elevance Health December 2021 - Present

Environment Oracle Database, SQLPLUS and SQL Developer, TOAD
Role Oracle PL/SQL developer
● As a part of this project, I have developed application based on
Oracle database.
● Created new tables, Views, Queries for new enhancement in the
application using PL/SQL.
● Used Pragma Autonomous Transaction to avoid mutating
problem in database trigger.
● Handled errors using Exception Handling for the ease of
debugging and displaying the error message in the application.
● Creation of database objects like Tables, Views, Materialized
views, Sequences, Synonyms using tools like SQLPLUS and
Roles and
PLSQL Developer.
Responsibilities
● Used Procedures, Packages for improving Query performance.
● Created and maintained Joins and Sub queries in Oracle.
● Developed PL/SQL Procedures and database Triggers for the
validation of input data.
● Created Indexes on the tables for faster retrieval of the data to
enhance database performance.
● Co-ordinate between Onsite and Offshore interface teams.
● Setup jobs and events using Enterprise Manager(OEM) console,
enrolled users and maintained system security by controlling and
monitoring user access to the database
● Responsible for developing different databases at various stages
of implementation of Projects (Databases for conversion of data,
interfaces, training and development)
● Used Import/Export and SQL * Loader utilities to move data and
objects
● Monitored and maintained database growth and tablespace
utilization
● Devised backup/recovery strategies and implemented it in line
with Business requirements (RMAN)
● Configured and Tested Backups for Oracle Databases by
restoration and recovery
● Involved in the performance tuning and query optimization
● Experience in Performance Tuning by using tools/utilities by
Automated Workload Repository (AWR)
● Installed and Configured Oracle 10g and 11g Real Application
Cluster (RAC) Instances with stand by database (DataGuard)
using CRS and ASM .
● Upgraded Oracle Database from 9i to 10g and 11g
● Code reviews of host and interface applications to ensure
optimum database connections, resource usages, locks, query
response times
● Designed and Implemented Oracle Disaster Recovery Solutions
for customers
● Applied patches in production and test instances
● Managing Database (User management, Table space
management, Performance related issues).
● Knowledge on basic architecture and functioning of Golden Gate
technology.
● Strong hands-on partitioning and performance tuning skills
● Strong SQL and UNIX scripting skills
● 24X7 support for databases and production operations teams
● Assisting Developers in writing and tuning their queries

Client: TATA Consultancy Services November 2019 – December 2021

Oracle Database, PL/SQL Developer, Toad, SQL Server Management,
Environment Informatica tool, Hue tool, Winscp, CA workstation (ESP), Splunk,
Dynatrace, OpenShift
Role Oracle PL/SQL developer/Production support
● I have been a part of various application deployments in this
project.
● Created new tables, Views, Queries for enhancements in the
application using PL/SQL.
● Handled errors using Exception Handling for the ease of
debugging and SP jobs and worked on the failures and issues in
code and application.
● Good at Hdisplaying the error message in the application.
● Creation of database objects like Tables, Views, Materialized
views, Sequences, Synonyms using tools like TOAD and PLSQL
Developer.
● Created mappings using transformations to load the data into the
target.
● Hands on Experience on informatica PowerCenter tool
(Designer, Workflow manager and Workflow monitor).
● Monitored the Eadoop using hue tool and capable to work on
Splunk automation and setting up Dynatrace alerts.
● Installed, configured and maintained oracle databases on Linux
and Solaris environment.
● Created Database as per requirements using DBCA and scripts.
● Startup and Shutdown of individual instance on RAC 2 node
environments.
Roles and ● Implemented and supported two node RAC environments.
Responsibilitie ● Managed ASM diskgroups via asmcmd and database control.
s ● Worked on replication technologies such as Shareplex and
Dataguard.
● Created Database objects like Tables, Tablespaces, Rollback
Segments, Multiplexing Control files, Data files, Redo log files,
Partition tables, Views, Indexes, Clusters, Synonyms, Materialized
views. Audited, Implemented scripts/tools to help rollout and
manage Oracle in a global distributed environment.
● Migrated and upgraded oracle database from 9i to 10g on Veritas
Cluster environment.
● Setup jobs and events using Enterprise Manager (OEM) console.
● Implemented dataguard (physical) for high availability/disaster
recovery solution.
● Used Import/Export and SQL * Loader utilities to move data and
objects Configured and Tested Backups for Oracle Databases by
restoration and recovery
● Wrote shell scripts and scheduled them in CRON for monitoring
and health checks of database
● Monitoring Database growth and space administration.
● Frequent analysis of objects and schemas.
● Experience in developing, maintaining and debugging procedures,
packages and functions using sql developer.
● Export & import at full, schema, tablespace and object level.
Client: Genuine IT Solutions July 2017- August 2019

Environment Oracle Database, OEM, PL/SQL Developer, Toad, Service now

Role Oracle Developer and Database administrator

● I have been a part of application development and worked as DBA
in this project.
● Creation of database objects like Tables, Views, Materialized
views, Sequences, Synonyms using tools like TOAD and PLSQL
Developer.
● Good knowledge in developing Materialized Views and Table
partitioning.
● Creating tables, indexes, synonyms, views, sequences, profiles,
constraints, triggers and procedures.
● Involved in Installation, Performance Tuning, Backup and
Recovery, RDBMS Patching, Oracle Enterprise Manager (OEM),
Standby Database, Database Upgrade from 9i to 11g.
Roles and
● Startup and Shutdown of Individual instances on RAC database
Responsibilitie
using Enterprise Manager.
s
● Setup jobs and events using the Enterprise Manager (OEM)
console.
● Experience in installation and configuration of Oracle RAC.
● Monitoring and managing the use of disk space, memory and
connections, Initializing database devices, Disk mirroring for
recovery, creating, enlarging and removing user database and
transaction log.
● Proactive and efficient in timely delivery of all assignments, always
enthusiastic to take up new challenges.
● Motivated team player and an adaptable individual with good
analytical and strong interpersonal skills.
● Excellent written and verbal communication skills.

Client: IRIS Infosol October 2015 - July 2017

Environment Oracle Database, SQL Developer, PL/SQL Developer

Role Oracle DBA

● Experience in developing, maintaining and debugging procedures,
packages and functions using pl/sql developer.
● Created Database as per requirements using scripts.
● Created Database objects like Tables, Tablespaces, Rollback
Segments, Partition tables, Views, Indexes, Clusters, Synonyms,
Materialized views.
● Monitoring Database growth and space administration.
● Frequent analysis of objects and schemas.
Roles and ● Experience in developing, maintaining and debugging procedures,
Responsibilities packages and functions using sql developer.
● Export & import at full, schema, tablespace and object level.
● 24X7 support for databases and production operations teams
● Managing Database (User management, Table space management,
Performance related issues).
● Strong hands-on partitioning and performance tuning skills
● Assisting Developers in writing and tuning their queries

EDUCATIONAL PROFILE:

● Masters in Cybersecurity from Bay Atlantic university.