Gupta - Oracle DBA - Chennai, TN, India

Nishtha Gupta

Chennai, TN, India


Oracle DBA

  • Full time
  • Part time
  • One time
  • Contract
  • Temp


Working as an Oracle DBA, experience in PL/SQL and Forms and Reports, Oracle Database Administartion Activities on 9i, 10G and 11G databases, Administartion activities plus Performance Monitoring and tuning.

Work History

SQL Developer, LINUX Editors, Oracle Enterprise Manager, GRID

Polaris Software Labs

From February 2012

Company Profile:
Founded in 1993 and publicly-listed, Polaris Software is the world's most sophisticated banking and insurance software company. Polaris is the chosen outsourcing partner for 10 of the top 15 global banks and 6 of the 10 top global insurance companies. Polaris offers state-of-the-art, comprehensive solutions for core banking, corporate banking, wealth & asset management and insurance. Over the last two decades, Polaris has implemented its solutions and services among 200 of the world's largest financial institutions. Polaris Software is also recognized by the world's top analysts (Forrester and Gartner) as global leaders in banking and insurance software.

Oracle DBA

January 2011 - December 2011

Project #1:

Consultant, Oracle DBA


January 2011 - June 2011

Company Profile:
Zensar is a full spectrum IT solutions organization serving a global clientele and provides IT services that covers five key industry verticals. An end to end IT solutions organization with a broad portfolio to suit clients distinctive IT needs. Zensar's IT solutions have been built to provide a consolidated portfolio of services in the IT and BPO space driving maximum value to its customers through quantifiable productivity improvements, innovation driven service delivery and optimized business models.

System Engineer. (Oracle DBA - Performance Analyst)

March 2010 - November 2010

Project #1:

Database Performance Analyst


March 2010 - November 2010

Platform: UNIX Servers
Database: Oracle 9i and Oracle 10G (Both Standalone and RAC Databases)
Role: Database Performance Analyst
Modules: QACC

a) Database Instance Monitoring on the TEST Servers (Using Customized Scripts, Oracle 10g Grid Control and Toad Optimizer Tool).
b) SQL Performance Monitoring, and Tuning.
c) Generating AWRs, ADDMs, ASHs, Generating Session Level and Application Level Traces,
d) Analyzing the TKPROFs, Analyzing SQL behavior giving own recommendations besides implementing Segment Advisor and SQL Advisor recommendations.
e) Handling Oracle Database Instance Monitoring and Tuning Issues.
f) Understanding, Analyzing, gathering and Managing Optimizer Statistics.
g) RAC Performance Monitoring and Tuning.

Company Name: KPIT Cummins Infosystem Ltd, Hinjewadi , Pune
Company Profile:
It's an Indian based IT consulting and offshore software development company offering on-time, on-budget and cost effective extended enterprise, e-business and other software solutions leveraging the web to globally deliver end-to-end solutions. A company providing software development solutions to clients in the domains of Finance, Education and Hospital Management

Oracle Application DBA


September 2009 - February 2010

Modules: EBU Tech, Parts & Services (Security), CORP

a) User and Session management.
b) Deployment of scripts on Staging and Production Servers.
c) Database monitoring and taking relevant actions.
d) SQL Performance Tuning, Generating AWRs, ADDMs, Analyzing and implementing Segment Advisor and SQL Advisor recommendations,
e) Generating Application and session level traces, analyzing the TKPROFs.
f) Data Refresh (Export/Import) from production to staging and staging to development.
g) Managing and Scheduling Jobs.
h) Handling Query Tuning issues.
i) Performance & Security Review and Approving deployment Requests.
j) Providing assistance to application development staff.
k) Develop environment specifications, benchmarking performance scenarios, and monitoring environments

Company Name: IFFCO Fertilizers
Company Profile:
IFFCO is a leading player in India's fertilizer industry and is making substantial contribution to the efforts of Indian Government to increase food grain production in the country.

Software Engineer. (Oracle DBA - Development)

Brande, Denmak (EUROPE)

May 2007 - February 2010

At KPIT Cummins I worked for the client Best Seller for 2.5 years. Bestseller is a renowned garments retail chain in Europe with head office at Brande, Denmak (EUROPE). Here at offshore we are having a team of 17 members providing support for all the products related to Oracle DB administration starting from development DBA activities to Operations and Applications or E-Business Suite too. I am working as an Oracle DBA related to DB Operations which include the major activities like Backup, cloning, performance monitoring and SQL optimization.

Project #1:

Oracle Developer DBA


May 2007 - September 2009

a) Reviewing the RA (Requirement Analysis) and DB Design documents for all modules ready to be deployed on Production.
b) Implementing the process flow for design and deployment.
c) Involved in Query Optimization and tuning for optimizing their performance on the Production and Test Instances.
d) Monitoring the Top Activity SQLs and sessions using the OEM 10g tool. Actions to be taken by Operations DBA.
e) Monitoring the Alert Logs of the Production and Test Instances using OEM and Baretail tools.
f) Also got an opportunity to work under the SCRUM Methodology recently adopted by the client. I participated as a DBA Resource in SCRUM Teams.
g) Taking PROACTIVE Measures to keep the Database Healthy:
a. Checkng INVALID Objects.
b. Checking UNUSABLE Indexes
c. Checking Table, tablespace and Schema Level Fragmentation Level in the Database.
d. Monitoring Free and available spaces in Tablespace.
e. Defining Alerts and Warnings (OEM)

Project #2:

Software Engineer cum Developer DBA(Oracle Forms & Reports)

Think Computers, Lucknow

September 2006 - May 2007

Duration: 15 September 2006 - 26 May 2007
Designation: Software Engineer cum Developer DBA(Oracle Forms & Reports)

Job Profile: Responsible for handling project 'Evikas'. The job involves application development related 'Handling and Transportation (H&T)' deals with online data entry operations and Generation of Bills and Reports using Forms and Reports 6i.

a) Undertaking the below mentioned Database Management Activities:
➢ Data modeling (Forward/Reverse engineering) and Develop physical data models as needed.
➢ Defining Entities, Data types and their Relationships, implementing Business Rules at appropriate places.
➢ Mapping of the Entities, and Joins with respective Table structures.
➢ Creation and maintenance of database.
➢ Creation of databases objects/tablespaces/tables/indexes/etc
➢ User management and space management.
➢ Running Database Utilities.
➢ Running advisories to check the DB performance issues:
* SQL Tuning Advisor
* SQL Access Advisor
* Segment Advisor
* Undo Advisor
➢ Monitoring Database for fragmentation and coalescing in segments.
➢ Monitoring Deadlock/timeout and resolution, and user session management.
➢ Security administration for database objects (Granting Revoking Privileges)
➢ Data Refresh and Cloning using Export/Import Utilities.
➢ Perform Backup and Recovery operations.
➢ Providing assistance to application development staff on Query optimizations and SQL designs.
➢ Develop environment specifications, benchmarking performance scenarios, and monitoring environments.

b) Handling Change request, report automation for the entire module.
c) Redesigning legacy forms, modules & testing and integration with parent forms.
d) Forms and Script Deployment on Application and Database Servers (Staging and Production).
e) Knowledge of EM Grid control
f) I was spearheading the project documentation.

Company Name: Think Computers, Lucknow.
Company Profile:
Think Computers is an interdisciplinary, professional consulting...

Software Engineer cum Developer DBA (Oracle Forms & Reports)

March 2005 - September 2006

Job Profile: Application development using Forms 9i & Reports 6i.

a) Worked as an Oracle D2K Programmer.
b) Responsible for S/W Development activities, including Implementation, Testing and Maintenance.
c) Database Administration activities involved Database Designing, User, Roles, Profile management, deployment on Development and Staging environments.

Qualifications & Certifications

Computer Application

Indira Gandhi National Open University


Lucknow University

Central Board of Secondary Education


St. Mary's Convent High School affiliated

Skillpages has been acquired by! is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Are you sure that you want to leave?