Oracle Manager
Resume:
Tejas Patel
ORACLE DBA
**************@*****.***
SUMMARY:
. About Seven years of experience as an ORACLE DBA(8i/9i/10g/11g) on
different Unix and Windows environments like - Linux, AIX, HP-UX,
Sun Solaris, Windows NT/2000/2003.
. Installed and configured 2, 4, 6 node server side load balancing RAC
(Real Application Clusters) databases on HP UNIX and Linux with ASM
(Automatic Storage Management) and Data Guard.
. Experience in Upgrade from oracle 8i, 9i to oracle 10g, 11g and
Migration of oracle database from red hat Linux, Window platform to
Linux on development, integration and production environment using
Oracle Data Migration Assistant.
. Experience in full life cycle of database administration. Worked both
as a Development and Production Support DBA on a 24x7 Basis. Willing
to work beyond regular hours.
. Successfully implemented physical standby database using Oracle Data
Guard featurefor High availability configuration.
. Experience in Installation, upgrades, patches, TAR support. Duties
included database creation, backup/recovery, user and security
management, auditing, general troubleshooting, and configuring
servers.
. Designed and implemented backup and recovery strategies. Extensively
used conventional and RMAN for backup and recovery. Logical backup
using and full/ partial export/import and Data Pump.
. Experience in Performance Tuning of database, instances, SGA, I/O, and
Rollback segment using different methods and detecting locks.
. Efficient in SQL query optimization and instance tuning using
STATPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports,
gathering statistics, pinning the objects, Running scripts.
. Troubleshoot Database performance issues using Automated Workload
Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
. Experience in maintaining and monitoring databases By Oracle
Enterprise Manager (OEM).
. Design and Implement Database security, schema management, Back-up,
Restore, Scheduling and Maintenance task in SQL SERVER.
. Experience on Parallel Execution, Advanced Compression.
. Knowledge of Oracle Application Server (OAS).
. Knowledge of NetApp experience.
. Experience with FTP,SFTP,PSFTP,SCP files on cross platform
. Experience with OEM agent and GRID control Installation and
configuration.
. Working knowledge of DATAWAREHOUSING tools like ETL (Extraction,
Transformation and Loading).
. Experience in VM Ware Oracle Server administration, installation.
. Expertise in loading data from flat files using external tables,
SQL*LOADER.
. Designed logical and physical Data Models using ERWIN into DDL and
executed on large scale to create database.
. Strong analytical and problem solving skills with ability to work
within team environment and independently when needed.
. Result oriented, self-motivated, Team player, ability to work
independently and within a team.
TECHNICAL SKILLS
OPERATING SYSTEM HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX
5.1, 5.2,
Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows
NT/2000/2003.
DBMS ORACLE 8i/9i/10g/11g, SQL SERVER, MS ACCESS
TOOLS Oracle Migration Workbench, SQL-Navigator, OEM,
Power Designer, ERWin, TOAD, SQL* Loader, Crystal
Reports, RMAN
LANGUAGES SQL, PL/SQL, UNIX Shell scripting, Perl scripting
ETL SQL Server Integration Services(SSIS)
Certifications
Oracle Database 11g Administrator Certified Associate (OCA)
Oracle Database 11g Administrator Certified Professional (OCP)
Oracle Application Database Administrator Professional (E-Business Suit
R12)
Professional Experience
CGI, Fairfax, A
POSITION: Sr.ORACLE DBA DEC 2011 -
present
Description: CGI is a global information services company has multiple
project Commonwealth of Virginia agencies (COVA), institutions and public
bodies conduct procurement business through a web portal, thus capturing
the efficiency and effectiveness of a virtual centralized organization.
This procurement solution enables the Commonwealth of Virginia to obtain
goods and services easier, faster, and at the best value.
Responsibilities:
< Installation and configuration of oracle 10g, 11g database on Linux,
AIX and Sun.
< Creation and configuration of Oracle database of various sizes 200GB
to 500 GB, and 2TB in Dev, ITG, Model and Production environments.
< Cloned databases from oracle 10g on Solaris 10 to oracle 10g on
Solaris 10 on development, integration and production environment.
< Support database platform are AIX, Hp-Unix, Solaris, REHL and Window.
< Create UNIX shell scripts that automatically monitored all databases
on all servers for alert log messages, table space growth and process
scheduler problems.
< Create table with Daily Range partition as per the requirement.
< Create Clone databases using user-managed as well as RMAN.
< Support the development staff for implementation of database objects.
< Schedule jobs in crontab including RMAN backup and other memory
maintenance, security jobs.
< Tune and optimize SQL Query, SGA, and Disk I/O using Oracle Enterprise
Manager and by monitoring the AWR and ADDR report generated from
snapshots taken at the peak business hours.
< Integrated the Backup status reporting for the entire database in the
enterprise to enable the web reporting using Oracle SQL, PL/SQL, SQL
performance tuning and korn shells, Unix shell Scripting.
< Managing Instances redo log files, Table spaces, Data files, Indexes,
Undo Segments, and Temporary segments.
< Extracted data from Oracle database into XML format for EDI
requirement.
< Worked on logical backup using and full/ partial export/import and
Data Pump.
< Involved in disaster recovery planning; detailed out the processes and
procedures of implementing disaster recovery; implemented database
backups and disaster recovery strategies using RMAN.
UBS, Stamford, CT
POSITION: ORACLE DBA March 2011 - NOV2011
Description: UBS is a premier global financial services firm offering
wealth management, investment banking, asset management and business
banking services to clients. The project was to provide Oracle DBA support
for multiple large databases in production, development and test
environments for various types of databases.
Responsibilities:
< Installation and configuration of Oracle 10g, 11g databases on Linux
5.4.
< Implement Oracle 10g Release 1 RAC on Enterprise Linux 5.4 in a Test
environment.
< Migrated databases from 9i to 10g, 11g and 10g to 10g on different
platform.
< Creation and configuration of Oracle database of various sizes 200GB,
400 GB, and 2TB in Dev, ITG, Model and Production environments.
< Cloned databases from oracle 10g on Solaris 10 to oracle 10g on
Solaris 10 on development, integration and production environment.
< Support database platform are AIX, Hp-Unix, Solaris, REHL and Window.
< Create UNIX shell scripts that automatically monitored all databases
on all servers for alert log messages, table space growth and process
scheduler problems.
< Create table with Daily Range partition as per the requirement.
< Create standby database and worked with data guard to provide high
availability.
< Create and Manage user, table spaces, data files and archive log.
< Monitor, tune and maintain overall database.
< Create Functions, Procedure, triggers, synonyms and profiles.
< Work with Flash Recovery Area.
< Create and implement backup and recovery strategies using RMAN
configuration.
< Provide troubleshooting and problem solving support to application
developers.
< Create Clone databases using user-managed as well as RMAN.
< Support the development staff for implementation of database objects.
< Schedule jobs in crontab including RMAN backup and other memory
maintenance, security jobs.
< Tune and optimize SQL Query, SGA, and Disk I/O using Oracle Enterprise
Manager and by monitoring the AWR and ADDR report generated from
snapshots taken at the peak business hours.
< Transported table spaces and data exports from production and staging
databases.
< Applied client patches and other patches as required.
< Support production databases on 24x7 on call basis.
Environment: Oracle 9i/10g/11g, RAC, TOAD, SQL Plus, Oracle Enterprise
Manager (OEM) Grid Control, ERWIN, RMAN, Solaris 10, UNIX and Linux.
Mentoring Of America, Chatsworth, CA Sep 2010 -
March 2011
ORACLE DBA
Description: MOA is an established software development company
specializing in high end database applications targeted to the financial
and foreign exchange markets.
Responsibilities:
. Installation and configuration of Oracle Database Software 10g.
. Creation and configuration of Oracle database.
. Migration of database (from 9.2.0.5 to 10.2.0.1) on SUN Solaris 2.7.
. Installed and Configured RAC on Red Hat Linux Advanced Server with 4
nodes server side load balancing using Automatic Storage Management.
. Written Stored Procedures and Triggers for database maintenance and
management using PL/SQL.
. Production support of Databases on HP-UNIX.
. Worked on FTP, ZIP files on cross platform.
. Involved in disaster recovery planning; detailed out the processes and
procedures of implementing disaster recovery; implemented database
backups and disaster recovery strategies using RMAN.
. Performance tuning of SQL queries and advising the application
programmer of the opportunities in tuning the application.
. Involved in performance monitoring and tuning of the database by fine
tuning the database implementation.
. Successfully implemented physical standby database using Oracle Data
Guard featurefor High availability configuration
. Designed and Implemented database security using Oracle roles and
privileges.
. Troubleshoot Database performance issues using Automated Workload
Repository(AWR) and Automatic Database Diagnostics Monitor (ADDM).
Tuned database for optimum performance.
. Communicate and coordinate with Oracle using TAR system for major
database issues/ problems; apply the required patches, test (unit test/
system test) and roll out and implement the patches into production.
. Configured Oracle Streams (Advanced Replications) and exchanged data
between two databases in remote locations.
. Schedule jobs in crontab including RMAN backup and other memory
maintenance, security jobs.
. UNIX Shell scripting for backup and monitoring of databases.
Environment: Oracle 10g/9i, SUN Solaris 2.7,Red Hat Linux, Hp-Unix, Windows
2000/2003, TOAD, OLTP, RMAN.
UIH INC., FORT LAUDERDALE, FL
POSITION: ORACLE DBA JAN 2010 - AUG 2010
Description: UIH is a vertically integrated insurance holding company,
which covers all aspects of insurance underwriting, distribution, claims
processing and exposure management.
Responsibilities:
. Installation and configuration of Oracle Database Software 9i.
. Creation and configuration of database.
. Performance tuning of application by identifying the SQL, which are
not written well; providing inputs to the application programmer;
correcting and implementing the right components.
. Upgrading database from Oracle version 8i to 9i and migration of
data.
. Integrated the Backup Status Reporting for all the databases in the
enterprise to enable the web reporting using Oracle SQL and PL/SQL.
. Worked with UNIX scripts for monitoring and backup of the database.
. Communicating with Oracle to get the necessary patches required to
fix up the database changes needed using TAR support and
coordinating the patches and implementing the necessary changes.
. Schedule jobs in crontab including RMAN backup and other memory
maintenance, security jobs. Worked on DBMS SCEDULER.
. Identifying issues/ bottlenecks that could potentially cause issues,
involving the right teams (such as server admins or application
developers) and take a corrective action to rectify the issues.
. Written extensively UNIX Shell Scripts &PL/SQL Stored Procedures and
Triggers.
. Performance tuning for Oracle Day-to-day maintenance and management
of the different databases in development, test and production
environments.
Environment: ORACLE 9i, AIX 4.3, OEM, RMAN, Tkprof, PL/SQL, UNIX.
Nypro Inc., Clinton,MA
POSOTION: ORACLE DBA Aug 2008 - Nov
2009
Description: Nypro is the leading global solutions provider in the field of
manufactured precision plastic products. The project was to migrate and
upgrade the database and to perform day to day DBA activities.
Responsibilities:
< Installation and configuration of Oracle 9i on AIX 5.2.
< Creation and configuration of database.
< Participation in designing data model for administration system.
< Upgrading database from Oracle version 8i to 9i and migrate data on
diverse platform.
< Troubleshoot Database performance issues using TKPROF, STATPACK,
EXPLAIN PLAN. Tuned database for optimum performance.
< Develop difficult PL/SQL script to perform error managing and
reporting.
< Change databases designs for many purposes such as data migration,
data warehouse, and online transactions.
< Installation of software on a wide range of platforms, for large
number of clients.
< Schedule jobs in Crontab including RMAN backup and other memory
maintenance, security jobs.
< Maintain and monitor multiple databases using Oracle Enterprise
Manager.
< Provides services in the identification and resolution of database
issues.
< Setting up of RMAN configuration on the database to perform necessary
back-up.
< Proactively monitoring production environment for any exceptions/
issues.
< Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures and
Triggers.
Environment: ORACLE 9i/10g, OEM, SQL, PL/SQL, RMAN, TKPROF, AIX 5.2,
WINDOWS 2000.
SunTrust Bank, West Palm Beach, FL Jul '06
- Aug'08
POSITION: Oracle DBA
Description: SUNTRUST provides a wide array of banking solutions and
services to help individuals and businesses meet their financial goals,
delivered with the personal attention.
Responsibilities:
. Installation, configuration and troubleshooting of Oracle Database
Software 9i and 10g on RHEL 3.0 and 4.0 environment and RAC setup with
ASM.
. Upgrading database from Oracle version 9i to 10g and migration of
data.
. Worked on backup, recovery and disaster recovery strategy using RMAN.
. WrittenStored Procedures and Triggers for database maintenance and
management using PL/SQL.
. Integrated the Backup status reporting for the entire database in the
enterprise to enable the web reporting using Oracle SQL, PL/SQL, SQL
performance tuning and korn shells, Unix shell Scripting.
. Managing Instances redo log files, Tablespaces, Data files, Indexes,
Undo Segments, and Temporary segments.
. Extracted data from Oracle database into XML format for EDI
requirement.
. Worked on logical backup using and full/ partial export/import and
Data Pump.
. Involved in disaster recovery planning; detailed out the processes and
procedures of implementing disaster recovery; implemented database
backups and disaster recovery strategies using RMAN.
. Involved in applying patches as per the requirements of the client and
upgrade Oracle and DBMS software under Oracle and SQL server.
. Performance tuning of application by identifying the SQL, which are
not written well; providing inputs to the application programmer;
correcting and implementing the right components.
. Tuned Production database performances and instrumental in SQL tuning
that improved application response and supported the Production DBA
Team and analyzed each project in the production environment.
. Involved in the project of implementing and configuring Real
Application Clusters (RAC) on Oracle 10g.
. Developed and maintained logical schema, physical records and SQL
queries for Oracle applications 9i databases.
Environment: Oracle 9i, HP-UNIX, Sql-Loader, UNIX Shell Programming, SQL,
PL-SQL, Stored Procedures, Functions and Triggers, TOAD
Virgin Mobile USA, NJ
Dec'04 - Jul '06
OracleDBA
Responsibilities:
. Installed and supported Oracle 9i for Production, Test and Development
databases.
. Upgraded from Oracle 8i to Oracle 9i.
. Performed cloning to create test and development databases.
. Developed scripts for database backup and recovery including HOT and
COLD backup with and without RMAN.
. Set up RMAN catalog for all the databases.
. Involved in the process of tuning and refining SQL queries and
analyzed TKPROF, Explain Plan outputs for improving the performance.
. Achieved replication by creating and refreshing SNAPSHOT/Materialized
Views.
. Configured listeners with Net Manager and created SQL*NET server
configuration files such as tnsnames.ora and listener.ora and started
the listener for making database available to users.
. Created databases using DBCA, OMF and manually.
. Provided security and implemented various auditing techniques.
. Created table spaces, tables, indexes, triggers for custom
applications.
. Database export/import using export and import utilities.
. Performed data loads from flat files using SQL loader utilities.
. Performed database administration tasks like space management, users,
roles, profiles, schema management.
. Wrote scripts to monitor the alert log and listener.log files for ORA
errors.
. Compiling invalid objects using utlrp.sql.
. Monitored database for fragmentation and corrected them.
. Experience in writing Shell scripts to run various Cronjobs.
. Involved in maintenance tasks at sever level.
. Involved in contacting Oracle support about technical issues through
Metalink.
Environment: ORACLE 9i and 8i, LINUX 2.x, SUN SOLARIS 5.8, Windows XP
Contact this candidate