Oracle Manager
Resume:
JYOTIN ARORA
SUMMARY
Over ** years’ experience as ORACLE RDBMS DBA (8i/9i/10g/11g) on different Operating systems including: AIX,
Linux, Red Hat Enterprise Linux, Unix-AIX, HP-UX, Sun Solaris (5.6/5.7/5.8/5.9,10) and Windows 2000/NT/XP.
• Support of Oracle 9i, 10g and 11g, SQL Server, and DB2 Databases on AIX, HPUX, LINUX, and Windows
platforms.
• Responsible for providing database support and performance tuning on both an online-transactional and
online-analytical processing environment.
• Developed rules and standards for the access and maintenance of shared data resources using Oracle.
• Designed technologically advanced solutions to meet customer's mission, objectives, and requirements.
• Improved automation, operation stability, and performance by researching new features and functionality with
each release.
• Ensured database configurations comply with published standards.
• Developed transaction logging and backup/recovery facilities.
• Participated in defining and implementing data security and logical to physical database mapping and table
parameters.
• Created database schemas and sub-schemas and Work with application development teams to ensure
efficient data access in application programs and to review test benchmarks and statistics.
• Reviewed overall physical database structures for data integrity, performance quality, recoverability,
maintenance, and space requirements.
• Assisted in technical support in the definition and resolution of database problems.
• Tuned and improved application SQL code, database configuration parameters and system disk
configurations.
• Acted as the primary interface between the Critical Systems team and the middleware/DBA team.
• Provided complete documentation on developed recommendations and solutions.
• Provided technical assistance to IT support staff.
PROFESSIONAL SUMMARY
State of New Mexico
Jun 2012- Jan 2014
Oracle DBA Architect (Deloitte)
Responsibilities:
• Project was about migrating all the from its old legacy health care system to new Exadata Quarter Rack
system. This included migrating the Medicare and Medicaid Members, Enrollments, Providers, Contracts,
Claims/Encounters, Service History and Authorizations and Utilizations to the new system from the Legacy
Systems.
As a database architect, I was involved in the end to end system planning, design, mapping and data delivery
for the Core and Care Applications from Business as well as IT perspective. Initiated and coordinated the
analysis and design requirements for ODS (operational Data Source) including schema and ETL scripts.
Worked closely with Oracle BI Suite on the system configuration and reporting compliance requirements to be
implemented as part of the Business Intelligence reporting application.
Worked with different Business Units (viz. Provider Management, Claims Processing, Payment Processing,
Services and Membership etc.) to capture gaps and functional requirements.
Worked with Vendors to setup various Environments for project implementation.
Coordinated with various Vendors and the EDI teams to Load data to applicable EDI interfaces.
• Provided input to activities for the ASPEN/ Development teams on issues they may be working on, or to any
INT, QAT, UAT and PROD issues that needs addressing from an application perspective as well as from the
database side.
• Responsible for migration of all the 11.2.0.2 (Image Now) & 11.2.0.3(ASPEN/YESNM) databases from Single
Instance residing on VBlock to Quarter Rack Exudates for which we have 2 Database Machines – One is high
capacity and other is high performance to 11gR2 RAC databases.
• Performed RMAN duplicates and cloning of databases which were re-created as ORACLE RAC Databases.
• Responsible for promoting the code to all the higher environments specifically Database Changes and Data
Fix Scripts using the DB Build Process. Besides performing the Database Builds, also perform Batch Builds &
Online Builds after a successful DB Build.
• Setting up of 11g Physical Dataguard using OEM12c as well as manual creation of Physical Standby database
for High Availability.
• Resolving all Exadata related technical issues – By opening SR of severity Level1 with Oracle Platinum
Support.
• Tuning of slow performing SQL’s using OEM12c advisors as well as SQLT Tool.
• Ensured database objects (views, stored procedures, triggers, constraints, etc.) and SQL statements met
performance and security objectives.
• Implemented Database Vault and Audit Vault and defined appropriate realms and rules sets along with the
DOIT state DBA group.
Worked on database migrations from NON-RAC to RAC and pumped data using data pump at schema level
exports/table level exports and imports.
Environment: Oracle 10g R2, 11g R1/R2,RAC,DATAGUARD, ASM, Red Hat Enterprise Linux Server release 5.8
(Tikanga), Windows XP/Server 2000, UNIX Shell Scripts and Perl Scripts, Tivoli Manager, VERITAS NET
BACKUP,TOAD for Oracle 10, ORACLE SQL DEVELOPER 2.1, Tkprof and L*Net/Net8 and Exadata Quarter Rack.
GovDelivery Inc
Apr 2012- Jun 2012
Oracle Data Architect
Responsibilities:
• Data Warehouse Architect responsible for the design, building, testing, and documentation of an Enterprise
Data Warehouse integrating several source system schemas using Oracle Warehouse Builder (OWB 11gR1)
and Oracle 11g. Designing and implementing the ETL process using several staging schemas and an
Operational Data Store for reporting using Business Objects. Dashboards are being implemented for
monitoring the job feeds as well as monitoring data quality. The stage and target star / snowflake schemas are
being designed and modeled using ERWin as a data modeling tool
• Designed and implemented stage, vault, and datamart schemas using Oracle
10g database, Oracle Warehouse Builder11gR1
• Developed several Oracle database standards documents including schema
design, installation+patch, feed system designs, database configurations, as well
as installation documents and security. .
• Provided input to activities for the teams on issues they may be working on, or to any production issue that
needs addressing.
• Reviewed all tables in the eprd and mprd database where the clob columns are used. For the clob columns
that are not compressed, review and make recommendations on addition tables/clobs that would benefit from
compression. Made sure to review the usage patterns for all the tables where clob columns are used.
Researched on how the table and its clob column are used by the application and if the clob compression is
appropriate. Reviewing the top sql reports was a good starting point for this activity.
• Reviewed Oracle's Exadata techology as it relates to Hybred-Columnar Compression (HCC) and its
applicability to our current database schema design. If we were to migrate to an Exadata system, provided
recommendations to the tables that would benefit from HCC, and if and how the HCC would work with
standard clob compression. Reviewing the top sql reports was a good starting point for this activity.
• Reviewed the eprd and mprd databases for space shrinking/coalescing opportunities. The application team is
implementing more data purging and data archiving activities, which is creating more storage maintenance
work. We may need to be more active in maintaining free space storage. Provided a review of the current
shrinking opportunities and those tables that might need it in the future base on current sql work loads.
Reviewing the top sql reports was a good starting point for this activity.
• Created sql tuning sets to provide aggregate overview of sql performance during peek and off-hours windows
for the GD3 database. Created a set of two tuning sets. One for daily work starting from 6am to 6pm. And
one for nightly work from 6pm to 6am and had this integration for (eint/mint) and production (eprd/mprd)
databases. Currently there are a few tuning sets already created, pmr_ts and daily_sts - Dropped these and
created new ones in the integration and production environments.
• Reviewed the impact of changing the SDU size at the SQLNet layer for the production eprd and mprd
database to a 32k value. Researched the current work load on the eprd and mprd database and provide a
listing of the most likely sql statement that will benefit from that change. Additionally, also provided an
estimate of the possible improvements for those sql statements.
Environment: Oracle 11g R1/R2, MySql 5.5 Enterprise 5.5, Java, Ruby on Rails, RAC One Node, Exadata, Red Hat
Enterprise Linux 5.4, OEL 5.8, 6.2, Windows XP/Server 2000, TOAD for Oracle 10, ORACLE SQL DEVELOPER 2.1,
Tkprof and SQL*Net/Net8, Dell R910 Servers, SunFire x4150 DB Servers, F5 Big IPS LTM (Local Traffic Managers)
used for Load
Balancing and High Availability of MySql. Exadata - One production high-capacity Rack (48T), one non production
high-capacity rack (48T), full-on two-node RAC, compression, partitioning, tuning/diag, etc, for both, one ZFS backup
device.
Wells Fargo Home Mortgage Headquarters
Sr Oracle DBA V
June 2011-Mar 2012
Responsibilities:
• Installed, configured, upgraded, migrated and patched Oracle 9i/10gR2/11g databases in heterogeneous
environment.
• Extensive worked on the production piece of Oracle 10gR2/11g environment including RAC, PL/SQL, OEM
Grid control, Data Guard, ASM, RMAN, Partitioning, database tuning and troubleshooting.
• Planned implemented and maintained Disaster Recovery methodology for all production databases and also
suggested best practices to ensure High Availability at all times.
• Technical Team Lead for other Database Administrators which also included Sybase and Sql Server DBA
groups for Lending Mortgage DBA Group.
• Worked extensively with technical architects and developers to ensure data model met the platform's
requirements from the business and technical perspectives.
• Defined business object/database table mappings and structures, fail-over strategies and distributed data
strategies.
• Ensured database objects (views, stored procedures, triggers, constraints, etc.) and SQL statements met
performance and security objectives.
• Ensured database migration scripts and programs meet data integrity, performance and security objectives by
testing them in DEV, UAT & Pre Production environments.
• Maintained and published the database installation/operation guide and other pertinent documentation for the
technical and application teams.
• Developed, reviewed and enforced database standards as laid out by Oracle.
• Wrote Perl scripts and PL/SQL scripts to fetch, parse and load data from the external sources. Supported
databases were on Linux and Solaris.
• Planned, implement and tested company’s disaster recovery strategy using RMAN.
• Worked on Oracle Virtualization using Oracle VM for x86 machines.
Environment: Oracle 10g R2, 11g R1,RAC,DATAGUARD, ASM, Red Hat Enterprise Linux, Windows XP/Server 2000,
UNIX Shell Scripts and Perl Scripts, Tivoli Manager, VERITAS NET BACKUP,TOAD for Oracle 10, ORACLE SQL
DEVELOPER 2.1, Tkprof and SQL*Net/Net8.
Walmart Corporate Headquarters /Infosys
Jan 2011-June 2011
Sr Oracle DBA
Responsibilities:
• Working and troubleshooting all kinds of technical issues related to SAMS CLUB databases and Online
Customer Orders Management System.
• Provide 24x7 on call Support for Remedy issues and tickets and interact with Off-Shore teams and drills in
India.
• Handle all aspects of ORACLE RAC clusters and Data Guard and maintain a High Availability Architecture with
preferably zero downtimes.
• Handle and troubleshoot all aspects of Oracle Enterprise Manager Grid Control and Agents.
• Interacting with Client DBA team and teams in Brisbane, CA to work on Production issues and database
refresh.
• Activities and testing and switching over of existing DATAGUARD physical standby databases.
• Working on a migration plan to upgrade database applications from 10g to 11g platform.
Environment: Oracle 10g R2, 11g R1,RAC,DATAGUARD, ASM, Red Hat Enterprise Linux, Windows XP/Server 2000,
UNIX Shell Scripts and Perl Scripts, Tivoli Manager, VERITAS NET BACKUP,TOAD, ORACLE SQL DEVELOPER 2.1,
Tkprof and SQL*Net/Net8.
Royal Bank of Scotland (RBS)
Aug 2010- Jan 2011
Sr Oracle DBA
Responsibilities:
• Configured optimal Oracle 10g/11g RAC architecture and Golden Gate Replication.
• Performance Tuning for Oracle Real Application Clusters (RAC).
• Prepared plans for upgrading of all critical Production Databases from 10g to 11g on Linux and ACTIVE
ACTIVE DATAGUARD implementation with RAC.
• Interacting with Vendor support to resolve issues
• Worked on changing NLS Character sets
• Resolution of production issues which included interacting with Oracle Support as we as Metal ink Usage.
Environment: Oracle 10g R2, 11g R1,RAC,DATAGUARD, ASM, GOLDENGATE, Red Hat Enterprise Linux Windows
Server 2000, UNIX Shell Scripts, VERITAS NET BACKUP,TOAD, Tkprof and SQL*Net/Net8
Golden Living Inc.
May 2010-July 2010
Sr Oracle DBA
Responsibilities:
• Installation, upgrading and maintenances of Oracle databases on Linux and Windows platforms.
• Performed upgrades with the team and upgraded all machines from Oracle 9i to Oracle 11g.
• Administered Oracle 9i and infrastructure support using Oracle OEM and Oracle 11g OEM.
• Responsible to test and implement the new features of Oracle 11g including: working on aspects of Database
Replay, partitioning, Transaction Management, SQL Performance Analyzer, etc.
• Explored and worked on innovative new features of Oracle 11g in terms of Automatic Health Monitor,
Automatic Diagnostic Repository and other resiliency features
• Provided system support for both development and 24/7 production environment.
• Strong and extensive use of DDL and DML tools. Maintained database schemas and dictionaries.
Environment: Oracle 9i/11g, AIX 4.3/5L, Sun Solaris (SUNOS 5.9), Toad, WINDOWS NT/2000, RMAN, ERWIN 3.2,
SQL*Plus, UNIX Shell Scripting, SQL*LOADER, Oracle OEM.
Wells Fargo Bank
Apr 2008 – Apr 2010
Los Angeles, CA
Sr Oracle DBA
Responsibilities:
• Installation, upgrading and maintenances of Oracle databases on Linux and Windows platforms.
• Performed upgrades with the team and upgraded all machines from Oracle 10g to Oracle 11g.
• Responsible to test and implement the new features of Oracle 11g including: working on aspects of Database
Replay, partitioning, Transaction Management, SQL Performance Analyzer, etc.
• Explored and worked on innovative new features of Oracle 11g in terms of Automatic Health Monitor,
Automatic Diagnostic Repository and other resiliency features.
• Backup of database using Logical and Physical (hot and cold) procedures and also RMAN.
• Configured optimal Oracle 9i/10g RAC architecture.
• Performance Tuning for Oracle Real Application Clusters (RAC).
• Performed database monitoring, capacity planning and performance tuning.
• Managed database security. Create and assign appropriate roles and privileges to users depending on the
user activity.
• Performed logical design, modeling, E-R diagram activities using Data Modeling Tools, normalization, indexing,
foreign key, and constraints.
• Implemented and tested backup strategies.
• Ran scripts to check the status of databases such as growing table sizes, extent allocation, free space, used
space, fragmentation, etc.
Environment: Oracle 9i, 10g RAC, Red Hat Enterprise Linux Advanced Server, Windows Server 2000, UNIX Shell
Scripts, Toad, and SQL*Net/Net8.
Pennsylvania Power & light (PPL) Apr 2007 – Mar 2008
Sr Oracle DBA
Responsibilities:
•Set up and maintained Oracle disaster recovery site using DATAGUARD.
•Performed performance tuning by using Oracle utilities like Stats Pack, Tkprof for addressing performance
bottlenecks.
•Utilized RMAN for backup and recovery strategy.
•Performed database tuning by using various tools like: Oracle Enterprise Manager and STATSPACK.
•Performed daily monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, users, tablespaces,
memory structures, rollback segments, logs, and alert.
•SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor.
•Installed and configured 10g Enterprise Manager and Grid Control.
•Established database backup/recovery strategy for different databases.
•Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
•Setup and support of Oracle replication (replication and conflict solution).
•Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as
configuration and storage allocation to support application enhancement.
•Developed Shell scripts to monitor the storage usage and object status for daily job.
Environment: Oracle 9i /10g, HP-UX 10.2/11.0,SUNOS 5.8, Windows NT 4.0, Windows Server 2000, Erwin 4.14, Unix
Shell Scripts, TOAD and SQL*Net/Net8.
FannieMae
May 2006-Mar 2007 Oracle DBA
Responsibilities:
• Administered all database installation, creation, modification, and tuning issues of Oracle.
• Database Security Administration involved: creation of users and management of their roles and privileges.
• Configured databases using latest features of Oracle 9i like Undo-Tablespace, Locally Managed Tablespace,
and Sorting Parameters.
• Experience with installing/configuring and maintaining Oracle 9i Real Application Cluster Database for high
availability, scalability and performance which included: determining the Cluster architecture, choosing the best
MPP RAC servers and hardware and configuring the raw disks for Oracle RAC.
• Analyzed the database to allow Oracle optimizer to choose best plan in executing the queries.
• Implemented Oracle Replication to enable database fail over in the event of system or database crash.
• Database activities included: allocation and maintenance of Rollback Segments, Automatic Undo
Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Experienced in using utilities like Export/Import and SQL Loader.
Environment: Oracle 9i/10g RAC, Linux Cent OS, SUNOS 5.7, WINDOWS NT/2000, RMAN, SQL*Plus, SQL*LOADER,
Oracle OEM, Import/Export Data pump, STATSPACK.
Reebok International Ltd.
Apr 2005 – Feb 2006
Oracle DBA
Responsibilities:
• Performed Database performance tuning and monitoring.
• Designed and implemented security policies.
• Utilized Oracle Export and Import utilities to perform logical database backup and recovery move Oracle data
from one machine, database or schemas to another and to detect database corruption.
• Controlled and monitored user access to the database.
• Used File Transfer Protocol to transfer files from one location to another on local disks and across the Internet.
• Created schemas with partitioned external tables for a production environment using SQL Plus.
• Administered Oracle 9i and infrastructure support using Oracle OEM.
• Configured and used Oracle Log miner and Oracle Flash Back for minor recovery of the objects.
• Populated Oracle tables with data from external and non- Oracle files using SQL*Loader utility.
Environment: Oracle 9i/10g, AIX 4.3/5L, Sun Solaris (SUNOS 5.9), Toad, Oracle OEM, RMAN
WINDOWS NT/2000, ERWIN 3.2, SQL*Plus, UNIX Shell Scripting, SQL*LOADER
Tata Consultancy Services Limited Feb 2003 –
Mar 2005
Oracle DBA
Responsibilities:
• Responsible for Oracle 8i logical and physical databases design, implementation and maintenance on UNIX.
• Installed, upgraded and patched Oracle software. Set up brand new machines including Oracle software
installation.
• Migrated and upgraded databases from version 7 to 8i.
• Developed some UNIX Shell scripts to automate database operation and database monitoring.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to
implement Oracle backup and performed a number of times of disaster recovery.
• Installation and configuration of Statspack and analysis of Statspack performance report and subsequent
tuning of production databases.
Environment: ORACLE 8.0/8i, HP-UX, Sun Solaris (SUNOS 5.6) RS 6000, ODBC, TOAD, SQL
*PLUS, RMAN, Shell Scripts, Korn Scripts.
Videsh Sanchar Nigam Ltd. (VSNL)
Aug 2001-Jan 2003
Junior Oracle DBA
Responsibilities:
• Installed and maintained Oracle 9.x/8.x for development, testing and production purposes.
• Implemented database refresh with the hot backup using DUPLICATE or full export
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Worked extensively on database sizing, rollback segments and queries.
• Created and maintained UNIX scripts for Oracle maintenance and statistics.
• Created stored procedures and triggers using PL/SQL for database managing utilizing TOAD developing
environment. Worked with SQL queries in the Oracle database.
• Oracle installations/upgrades/backup and recovery.
• Configured databases for adequate performance and availability.
• Helped developer to install Oracle Client, troubleshot and established the connection to Oracle database.
• Implemented backup/recovery and database monitoring strategies using Unix Shell scripts and Oracle
enterprise manager (OEM).
Environment: Oracle 8.x, 9i, SQL, Sun Solaris, Windows NT/2000, OEM, Statspack, Rman, ftp, SQL*Loader, ERWIN.
CERTIFICATIONS:
Sun Certified Java Programmer (SCJP), OCP 9i/10g & 11g
EDUCATIONAL QUALIFICATIONS:
PHD Computer Science (University of Southern California) --- In progress
MS Computer Science (New Jersey Institute of Technology)
MCA (Masters in Computer Applications, IGNOU), India.
Bachelors in English Honors (Delhi University), India.
Contact this candidate