Oracle Database
Resume:
Kinjal Thakkar
********@*****.***
Professional Summary:
. 7+years of Oracle DBA experience in development and production
environments.
. Experience in Database Backup and Recovery, SQL Tuning, Storage
Management, User maintenance, Data Guard, Patches, Performance
Tuning etc.
. Knowledge and understanding of Real Application Cluster (RAC) and
Data guard
. Database software installation, patch and upgrade to development,
test and production servers along with other below mentioned
technical expertise
. Creation of databases, table spaces, tables, indexes and other
database objects.
. Use of the import and SQL Loader utilities to load data and
performing exports as supplemental to daily hot, cold and RMAN
backups to be used for database restore and recovery.
. Editing and scheduling shell and batch scripts to execute full
exports for data migration.
. Results-driven IT personnel with skills in team building and
problem-solving with an established reputation for effectively
working with diverse groups of people and adaptability to changing
environments.
. Modify database structures as required by developers due to
business or application requirements, clone development databases
for testing and training.
. Develop capacity and performance metrics as well as maintain,
analyze, and report on a scheduled periodic basis to management on
development progress.
. Set up and manage database security by creating new users, roles,
profiles, and provide required user privileges in development,
test, training and production environments.
. Routine DBA functions like Space Management, Rollback segments,
Undo segments and recompiling invalid objects.
. Backup of Database logical and Physical (hot and cold) procedures
and also using RMAN for complete and incomplete recovery of
database.
. Creating Users, Roles and Profiles, Privilege management with role-
based security.
. Typically involved in database designing, creation and maintenance.
. A self-motivated, responsible and reliable team player with a set
of strong technical skills.
. Strong in solving problems of diverse scope where technical
analysis and evaluation is required.
Technical Skills:
Database: Oracle 11g,10g/9i,MySQL 5.1/5.5
Programming Language: PL/SQL, SQL
Product/tools: Sqlplus, Putty and Toad 9.7.2, SQL
Yog
Utilities: RMAN Log Miner, SQL Loader, Data
Pump
Program High-end Technologies: ASM & RAC.
Operating System: Windows XP/7, Linux, UNIX with
Shell Scripting
Professional Experience:
AT & T, Jan'2012 to Till
Date
Trenton- NJ
Oracle DBA
Responsibilities:
. Installing /Migrating/ Upgrading Oracle 11g/ 10g/ 9i Database
Server as well as Clients.
. Configure physical standby databases for disaster recovery.
. Involved in system study, analysis, design and maintenance of
database.
. Design, configure and database backup policies.
. Database sizing, Capacity Planning.
. Performing backup recovery and database cloning using RMAN, Hot
backup, Data-pump and export/import.
. Database Refreshing / Replicating from production site to testing
site using RMAN Backup
. Installation and configuration of oracle agent for grid control.
. Managing day to day administration and housekeeping activities of
the database.
. Performance tuning of oracle databases.
. Familiarity with Shell Scripting and PL/SQL.
. Disaster Recovery planning & Implementation.
. Installing High Availability uptime for 24*7 databases, Data Guard
in Oracle 9i/10g R1 and 10g R2 .
. Working on Remedy ticketing tool to handle online queries of
developers / users and resolving them remotely and providing them
solutions. .
. Working On call to provide 24*7 remote DBA Support for Database
Administration, Backup/ Recovery, Performance Tuning, Network
Administration
. Enforced need of regular data purging processes from production,
design and development, to deployment.
. Implemented and maintained Oracle 10g Data Guard/standby databases
for fail-over purposes.
. Installation of RAC and Managing RAC Environment efficiently
. Proficient in RAC Performance Tuning.
. Create and maintain materialized views.
. Implementing and maintaining database security (create and maintain
users, roles and assign privileges)
. Database tuning, Application Tuning & performance monitoring. Fine
tuning Initialization parameters, I/O, Memory and Operating System
kernel parameters.
. Managed appropriate use of freespace within tablespaces, reclaimed
space whenever possible. Reorganized tables and indexes within
databases when needed.
. Monitored the production Oracle alert logs for database errors.
Environment: Oracle 11g,10g, PL/SQL, Form 10g, Report 10g, Toad 9.2.0.6
Tata Consultancy Services Aug'09 to
Dec'11
Government of Gujarat
Oracle DBA
Description:
Tata Consultancy Services Limited (TCS) is an India-based IT company.
The Company offers a range of IT services, outsourcing and business
solutions. TCS' segments include banking, financial services and insurance;
manufacturing; retail and distribution, and telecom. It operates mainly in
the USA, Europe and India.
Responsibilities:
. Managed 50+ Oracle database instances, conducted server performance
tuning, backup and recovery, and troubleshooting in Windows XP and
Sun Solaris UNIX platforms.
. Performed Oracle server software installation, database creation,
system configuration and upgrades. Administered Oracle repository
in Designer/2000 for data modeling and database design.
. Participated in the company's business process re-engineering
planning and implementation to integrate desktop applications into
enterprise-wide distributed client/server system. Utilized
Microsoft Visual Basic and Oracle Developer for application
development and support.
. Cloning Oracle databases from production to development
environments
. Performs regular health checkup of production and test databases
and performance of Oracle application system.
. Installation, Designing, creation & Maintenance of MySQL Database
. Migration from oracle to MySQL and vice versa
. Team Lead of Data digitalization team of Police Department Of
Gujarat for HDIITS project.
. Helped in establishment of deployment process.
. Creation of Schema Objects and Space Management.
. Technical support to client and application development teams
. Database design (Logical and Physical)
. Create or clone the Oracle Instance and Databases on ASM. Perform
database cloning and re-location activities.
. Managing table spaces, data files, redo logs, tables and its
segments.
. Maintaining data integrity also managing profiles, resources and
password security.
. Cloning (Hot and Cold) Production Database for reporting and
analysis purposes.
. Documenting the procedures and designing the run books as a part of
standard set of procedures for the team members
. Prepared documentation for ongoing maintenance and support
. Implemented and used Oracle Flash Recovery for recovering the
database from user errors.
. Established database backup/recovery strategy for different
database.
. Applied different recovery procedures for complete and incomplete
recoveries depending on the type of failure.
. Maintaining various version Release of application code and its
deployment.
. Setting up configuration parameter of MySQL Database (my.inf)
. Managing Users, Privileges and Roles.
. Install Oracle software and patches.
. Table Maintenance, Index management and tuning
. Script Management, Version Release through VSS.
. I worked in Online voting System Project which was awarded as Best
Urban ICT Initiative of the year 2011.
Environment: Oracle 11g, 10g, 9i database on Fedora, Red Hat, MySQL 5.1/5.0
in
Windows XP/7
Dynamic Dreamz Jul'06 to Jul'09
Government of Gujarat
Database Administrator
Description:
Dynamic Dreamz is an India-based offshore Web development Company
which provides web design Services, web application Services and E-commerce
Web solution.
Responsibilities:
. Installation of Oracle 9i on Linux platform.
. Creation of oracle Roles, Granting Privileges and Profiles etc.
. Check Alert Log errors and make necessary actions to rectify them.
. Frequent analysis of objects or schemas to improve the speed of the
database
. Export / Import of Objects.
. Using SQL Loader, Statspack, TKProf, NID, Log Miner, DBVerify.
. Monitor the database by collecting statistics using SQL trace.
. Performing Hot Backups and Cold Backups.
. Performing Table Partition.
. Analyzing Tables and Indexes to Rectifying Database Fragmentation.
. Analyze SQL statements using Explain plan.
. Releasing user Locks.
. Managing the physical & logical objects of the Database.
. Rebuilding Index to rectify segment fragmentation.
. Check Alert Log errors and make necessary actions to rectify them.
. Frequent analysis of objects or schemas to improve the speed of the
database
. Checking the Data Files Consistency using DBVerify utility.
. Monitoring the database growth, Re-Organization of Tables.
. Analyzing Tables and Indexes to Rectifying Database Fragmentation.
Environment: Oracle 11g,9i database on Linux Environment.
Education:
Bachelor of Engineering (Instrumentation & Control),
References:
Furnished upon request
Contact this candidate