Oracle Manager
Resume:
Harry Ronis
Bayside NY *****
*****.********@*****.***
******@*******.***
CAREER OVERVIEW
Solid Oracle 11gR1/R2 RAC experience on Linux (Oracle and Redhat) and HP-
UX including installation, administration, troubleshooting and performance
tuning.
. Experienced in Oracle GRID Infrastructure management and configuration
Skilled in Oracle ASM administration Solid infrastructure knowledge
including high-availability solutions such as Oracle DataGuard,
Goldengate, SAN-based replication technologies (SRDF), etc.
. Excellent SQL & database-level performance tuning skills
. Thorough understanding of backup, recovery and cloning using RMAN,
datapump and export/import.
. Ability to write and maintain SQL and shell scripts as necessary to
support database operations
. Experience with Oracle Enterprise Manager Grid Control
. Experience with Oracle Exadata
24x7 support for existing and future 11gR2/12c databases (RAC and non-
RAC), and 10gR2 databases, on Linux.
Oracle 11g/12c (setup, maintenance, upgrades, troubleshooting).
Oracle Performance analysis and database, application, and SQL
tuning.
Configuring Oracle 11gR2/12c databases for optimum performance.
Oracle ASM (installation and support).
Oracle Clusterware (Installation and support).
24x7 service (encompassing: High Availability (RAC); Backup &
Recovery, Disaster Recovery (Physical Standby, Data Guard, Active Data
Guard).
. Strong Knowledge plus upgrade experience in Oracle E-Business Suite
11i and R12 and Oracle RDBMS 9i, 10g, and 11g environments on Virtual
Oracle Enterprise Linux Environment
. Strong knowledge on best practices to implement standards, processes,
and procedures.
. Experience on Oracle Database tuning methodology using appropriate
tools, RAC, ASM, RMAN & OEM
. Knowledge on using database advisors to tune Oracle Database Instance
. Expertise with Oracle Automatic Workload Repository
. Expert knowledge on Statistic Histograms & Histogram Views
. Expert knowledge of Metrics, Alerts, and Baselines
. Knowledge of managing Baselines with PL/SQL & Baseline Views
. Experience on diagnosis and finetuning of common SQL related
performance problems
. Experience on diagnosis and finetuning of common Instance related
performance problems
. Working knowledge on using Enterprise Manager performance-related
pages to monitor Oracle Databases
Experience managing medium to large scale databases servicing OLTP and
DSS applications.
Solid Oracle 11gR1/R2 RAC experience on Linux (Oracle and Redhat) and
HP-UX including installation, administration, troubleshooting and
performance tuning.
Experience with installation of Oracle 12c in single instance and RAC
environment
Experienced in Oracle GRID Infrastructure management and configuration
Skilled in Oracle ASM administration
Solid infrastructure knowledge including high-availability solutions
such as Oracle DataGuardGoldengate, SAN-based replication
technologies (SRDF)
SQL & database-level performance tuning skills
Thorough understanding of backup, recovery and cloning using
RMAN, datapump and
export/import.
Deep knowledge with Oracle 10g/11g databases, strong RAC/clustering
experience, RMAN, and Data Guard experience .
proficiency in UNIX and able to administer Oracle databases running
in Solaris and RHEL.
Strong troubleshooting/performance tuning skills
Ability to diagnose problems and triage/resolve issues across various
tiers (application,
network,database, server, or storage tiers
Ability to implement automation to reduce manual administrative
tasks through use of jobs,
PL/SQL, cron, or other techniques.
Oracle Enterprise Pack experience - Golden Gate, Database
Vault, Audit Vault, AES .
Ability to write and maintain SQL and shell scripts as necessary to
support database operations
Experience with Oracle VM.
Experience with Oracle Enterprise Manager Grid Control.
Experience with Oracle Exadata.
. experience in managing database on HP-UX, Sun and Windows Platforms
Solid understanding of Oracle database internal architecture
. Database Migration and Replication using Golden Gate.
Hands on experience in large scale cross platform DB migration
projects
Data migration of Oracle 9i,10G,11G Versions of databases.
Data migration of Oracle DBs with Transportable tablespace.
Knowledge of DB performance tuning skills and usage of AWR, ADDM and
Statspack
Knowledge of Oracle RAC and other horizontal scaling techniques.
Strong production support experience Oracle Enterprise Manager/Grid
Control for environment standardization
Skills in PL SQL /Perl/Shell Programming
. Extensive experience with Backup and Recovery using Oracle RMAN.
. Performance tuning of database and SQL statements
. Strong skills in Oracle 10G & 11G with ASM & RAC.; Oracle Enterprise
Manager, Grid Control, Linux, Unix with Shell Scripting Erwin and
Microsoft Office tools
. Oracle RAC experience
Responsible for the day to day support and DBA activities.
Involved in the database capacity planning related to database growth
and system utilization, etc.
Support database application upgrades.
Responsible for the Oracle database and RAC implementation and
troubleshooting.
Setting up and maintaining Data Guard
Experienced in Oracle database and PL/SQL tuning
Must have knowledge in database internals and data structures
Knowledgeable in PL/SQL scrirpting, using RMAN and Oracle Enterprise
Manager Grid Control.
experience in Unix shell scripting.
Oracle Golden Gate experience.
Strong knowledge of Oracle Clusterware
Strong knowledge of RMAN and DataGuard
Strong knowledge of Oracle Clusterware
Strong knowledge of RMAN and DataGuard
. Exadata experience
. Self-starter capability, ability to acquire new skills autonomously.
. Demonstrably solid written and verbal communication skills to drive
projects to successful conclusion.
. Hands on experience in database administration & troubleshooting for
Oracle databases (10g to 11g RAC using ASM/non-ASM) including RMAN
backup & recovery
. Experience in Oracle Dataguard, Streams
. Created new Oracle databases, implemented data replication
strategies using GoldenGate
. Installation and configuration of GoldenGate
. Supported backup and recovery of the databases using RMAN
. Multiple installations of CRS, ASM, and RAC solutions in Oracle 11gR2
on Linux, Aix
. multiple storage platforms, EMC, 3PAR, Hitachi
. Oracle database installation, configuration, tuning and
troubleshooting on versions 9i, 10g, and 11gR1 and R2
. Setting up and modifying Materialized Views
Working in Data Warehouse Environment
Installing, patching, troubleshooting Oracle 11g in Data Warehouse
Environment
Developing and Maintaining Unix Scripting and PL/SQL code
Working in PeopleSoft Environment
Developing, implementing and supporting Data Warehouse processes
Setting up and Maintaining DBLink configurations
Tuning SQL in Data Warehouse or PeopleSoft environment
Tuning using Oracle AWR and ADDM
Performing Database and SQL Performance Reviews
. Implemented Data Guard and Active Data Guard
. Oracle database configuration reviews and audits on all versions and
all platforms supported by Oracle.
. Database Backup and Recovery solutions including RMAN hot and cold
backups, export backups, and backup scripting.
. Oracle Monitoring with Grid Control.
. Performance Tuningdata propagation using Oracle Streams, Oracle
Replication, GoldenGate.
. pl/sql and sql skills
. Applying patches of database and GoldenGate
. Security management at database level
. Monitoring of database and replications using OEM grid.
. Extensive, proven experience working with Oracle database systems on
UNIX and Wintel
. Database replication techniques, automation of Database builds,
database upgrades, Database migrations,
. Experience with OEM & GRID Control for monitoring and
troubleshooting
. Solid Experience IN Oracle 11G, Oracle RAC, Dataguard, Dataguard
Broker, ASM, ACFS.
. Oracle 10g/11g DBA experience (Oracle High Availability experience
using RAC/Veritas Clustering/ Service Guard )
. Experience in Oracle 10g/11g database architecture, automation,
installs, upgrades, backup & recovery, monitoring, and database and
query tuning
. RMAN experience in Oracle 10g 11g.
. Database partitioning, patching, and cloning experience
. Oracle support in Java environment
. Experience using Oracle Grid Control; Experience in highly available
web based OLTP systems; Experience with SQL Server; Experience
implementing/?managing Oracle Databases in a RAC environment;
Experience implementing Grid Infrastructure release 11.2 or higher
on a Unix/?Linux environment; experience implementing ASM cluster
Filesystem with knowledge of how to maintain it
. Knowledge of Best Practices for adding a new disk to an ASM disk
group
. Experience patching grid infrastructure software; experience
implementing instance caging
. Familiar with Oracle database resource manager; familiar with huge
pages on Linux
. Experience supporting a high-availability production database
. experience as Oracle EBS Applications DBA. Experience in design,
installation, configuration and management of Oracle EBS Applications
and related technology stack in a multi-tier environment.
. managing all tiers - web server, EBS12 application server, Oracle 11g
database, concurrent processing, reports server, forms server, admin
server and discoverer.
. Recent experience with Oracle 11g RDBMS, Oracle EBS R12/11i
Applications.
. Knowledge of Oracle Applications database architecture-
schemas/products, database objects, file system structure, tables,
views, packages, procedures, functions, triggers, sequences, indexes,
and constraints. Portal experience in DMZ environment preferred.
. Expertise in Oracle 11g Database Administration experience with
configuration, load balancing, backup/recovery, sizing and space
management, PL/SQL tuning, diagnostics and proficient use of Oracle's
Enterprise Manager tool.
. Experience opening and resolving Oracle TAR's
Experience in
AIX Unix, Solaris, Windows and Linux Operating system
ORACLE 10g and 11g database administration
RAC (Oracle)
ASM (Oracle)
Oracle Golden Gate
SQL / PL-SQL
Unix shell scripting / Perl scripting
Backup/Recovery
Replication
Database performance Tuning
. Oracle RDBMS 11g, 10g Administration
. Oracle Real Application Cluster (RAC)
. Oracle Data Guard (Physical and Logical Standby database )
. RMAN - Backup and Recovery - Disaster Recovery and Business
Continuity
. Experience with web applications, n-Tier systems, Apache, IIS and
Weblogic. Oracle Agile is a plus
. Red Hat Linux and Unix Knowledge
. Database and Applications Performance Tuning
. Oracle AWR, ADDM, ASH, Oracle OEM Grid/Cloud control,, Data Pump,
Imp/Exp, TKPROF
. Logical Data Base Design, Physical Data Base design, Data Analysis
. SQL, PL/SQL, Linux/UNIX Shell Scripting
. Oracle EBS R12 Oracle Applications (Financials/Supply
Chain/HRMS/Manufacturing, etc
. Proficient in using applications utilities ADADMIN, ADRELINK, ADCTRL,
ADPATCH, FNDLOAD
. experience on Oracle e-Business Suite (EBS) R12/11i Installation,
configuration, maintenance troubleshooting and support;
. Oracle DBA experience and in-depth understanding of Oracle Databases
including current 10g/11g;
. experience in Oracle Real Application Clusters (RAC) 10g/11g on UNIX
platform.
. Proficient in all aspects of "system administration " functionality
within Oracle E-Business Suite;
. Hands on experience with applications/tech stack/database upgrades,
cloning, patching, and backups/recovery; a good understanding of
Storage, Network, server technology, operating systems for optimal
application performance is required and experience in supporting
Development and Production environments.
. Installation, configuration, patching and upgrading of Oracle E-
Business Suite
. Manage the installation, configuration, patching and upgrading of
Oracle Core technology products Database, Application servers,
Middleware and Security Management.
. configure server/storage/network components and support and perform
database and application clones, refresh and trouble shoot performance
issues.
. Create project plans and set priorities and provide management reports
on status, technical options, risks and issues.
. Diagnose and solve issues within the Oracle E-Business suite of
technologies, including EBS Finance and Supply Chain modules, GRC,
IPM, BizTalk, Mobile Supply Chain Management, OAM, AD, and Weblogic;
work with the EBS DBA's to diagnose and solve issues with Oracle RAC,
GRID, Business Intelligence and Hyperion products and work with EBS
DBA's to manage the patching of EBS suite of products and will assist
in the planning and execution of the upgrades across the Oracle
production.
. Lead in the Change Manage process to migrate code and configurations
. Experienced in integration of Oracle OAM/SSO with Oracle E-Business
Suite R1
. Concurrent Managers, Programs/Executables/Request Groups
. Custom Responsibilities/Menus/Data Groups
. Custom Tables/Packages/Procedures/Functions
. Custom Printer/Printer Drivers/Printer Styles.
. Strong background working with Oracle technology
. In-depth knowledge of working on Oracle AWR, ASH and ADDM tools.
. Experience in Install, configure of database software and patches
. Experience in the installation of WebLogic Web Server and Apache Web
Server.
. Experience in Oracle database upgrades from 9i, 10g to 11gR2
. Experience with SQL, Oracle PL/SQL tuning and analyze database
performance issues and recommend solutions
. Experience in High Availability i.e. RAC (RAC One Node) and Data
Guard
. Experience in ASM, OEM grid Control, partitioning, SQL*Loader
. Administered Oracle RDBMS system, utilizing the Linux Operating
System, Oracle 10gR2 and 11gR2 with RAC (development, test and
production). Extensive experience with Oracle RMAN (backup,
recovery and cloning). Disaster recovery experience. Linux/Shell
scripting. :
. Analyzed performance issues in different Oracle environments,
orchestrated tuning efforts with different groups
. Understand Database architecture, data management, partitioning,
compression, and devise data archive methodology
. Upgrades and migrations from Oracle 10g to 11g using RMAN.
. Participate in various initiatives like new database builds and
projects.
. Monitor and administer Oracle RDBMS, RAC and Dataguard components,
using OEM, SQL scripts with the ability to use manual methods if
necessary.
. Administer backup, recovery and environment refreshes using RMAN and
scripts, evaluate alternate or hardware strategies as need arises
. Perform upgrades, patches and installations of Oracle RDBMS,
Clusterware and RAC components
. Administration of Oracle ASM and filesystems.
. Project management and customer interaction.
. Supporting large scale Oracle deployments.
. Supporting large Oracle databases servicing OLTP and DSS
applications.
. Solid understanding of Oracle internal architecture.
. Performance tuning of database and SQLs.
. Implementation of enterprise backup and recovery strategies for
databases.
. Designing and implementing database replication strategies.
. Experience in database software management (patch and version
management).
. Case management with Oracle technical support.
. Experience in designing repetitive processes.
. Knowledge of ODBC/OTL
. Experience building new Oracle 11gR2 production RAC databases
. Experience patching existing Oracle11gR2 production RAC databases
. Experience migrating data from existing Oracle11gR2 production RAC
databases to new ones in a non disruptive manner
. Experience deploying Oracle technologies (e.g., ASM, OEM/Grid, RMAN,
Partitioning, Active Data Guard, Advanced Compression) in
production environments
. Experience working with Oracle Support Services to resolve issues
and familiar with Oracle's escalation procedures to use as needed
. TECHNICAL SKILLS
. Hardware: Sun Servers E-450, E-3500, V-880, V-490, V-240, HP 9000,
RS6000, Intel X86, Sun StorEdge
. D1000, Sun StorEdge L7 Tape Backup, IBM AS/400, EMC
Clariion CX300 networked
. storage systems
. OS: UNIX (OELx, Sun Solaris 2.x, 8, 9, 10, HP-UX, HP
Tru64, AIX, Red Hat AS 3.0/4.0/5.0) MS-
. DOS, CITRIX WinFrame Servers, Wintel VMware
. Languages: SQL, PL/SQL, Bourne (Bash), Korn (Ksh), C-Shell, Unix
Shell Scripting, Perl, AWK, SED, C,
. ProC
. ERP: Oracle Applications 10.6, 10.7/10SC/11.0/11i (AOL,
OM, OE, ONT, SHIPPING, ASCP, INV,
. FA, AR, AP, GL, PO, PA, WIP, BOM, MRP, CM, Incentive Comp,
Time and Labor, HR, EDI,
. ALERTS, FSG, ADI), Oracle Applications Manager (OAM),
MAPICS XAR6
. RDBMS: Oracle 7.x, 8.x, 8i, 9i, 10g, 11g, RAC, ASM, SQL Server
7/2000
. Software: Workflow 2.6 and Oracle ADI, Oracle Discoverer,
Oracle Developer 2000, Oracle Forms
. 4.5/3.0/2.3, Oracle Reports 6i/3.0/2.5, SQL*Plus,
SQL*Loader, SQL*Net, Server Manager,
. Oracle Discoverer 10g/9i/4.5/3.1/3i, Web cache, OID/SSO,
Fusion Middle Ware, SQL,
. PL/SQL, Perl, Shell, MS-Project, MS-Access, Oracle E-
Business Suite 11i, AD tools, Tivoli
. Storage Management, RAC, Dataguard, PeopleSoft
. Tools: Enterprise Manager (OEM), OEM Grid Control, Oracle
Applications Manager (OAM), Oracle
. Data Guard, Quest TOAD, Quest SQL NAVIGATOR, SQL*DBA,
Import, Export utilities,
. SVN, PVCS Version Control, ADAIMGR, ADADMIN, ADCNTRL,
ADPATCH, RMAN,
. VERITAS NETBACKUP Server (4.5, 6.0), Tivoli Storage Manger
5.3.
. PROFESSIONAL EXPERIENCE
.
. Hewlett-Packard Contractor July 2013 - Oct
2013
Remote assignement
.Oracle DBA Technical Support in a UNIX and Windows infrastructure
.Upgrade databases: Oracle 9i -11g Oracle 10 - Oracle 11G
.Daily reactive Incident and Service Request support for Oracle
Databases globally via hotline and ticketing systems. Perform
triage, initial troubleshooting, and escalation
.Interface proactively with other Infrastructure support teams such
as UNIX, WINTEL, Network, IT Facilities, Backup, Storage,
Monitoring, Security etc
. Support application development teams with Version upgrades,
application releases, and cloning / creating copies of existing
databases for testing and development purpose
.
. HMG America, New York, NY
Nov 2012 - Feb 2013
. Oracle DBA Technical Support in a UNIX and Windows infrastructure.
. Upgrade databases: Oracle 9i -11g Oracle 10 - Oracle 11G
. Oracle Architecture Design including capacity planning, storage,
clusters, servers with the ability to offer solutions for high
availability, disaster recovery and scalability.
. Daily reactive Incident and Service Request support for Oracle
Databases globally via hotline and ticketing systems. Perform
triage, initial troubleshooting, and escalation.
. Proactively support the ongoing maintenance and optimization of
preventative maintenance activities designed to increase the
stability of the environment and maintain high levels of stability.
. Interface proactively with other Infrastructure support teams such
as UNIX, WINTEL, Network, IT Facilities, Backup, Storage,
Monitoring, Security etc.
. Provide 2nd level support to Oracle vendor teams, including training
. Support application development teams with Version upgrades,
application releases, and cloning / creating copies of existing
databases for testing and development purpose.
. Support day to day maintenance and operation of databases including
table space maintenance, providing expertise and recommendation on
performance tuning, and consultancy requests where application
development teams require Oracle DBA expertise.
. Work with other global Oracle team members to provide follow-the-sun
support and drive global consistency.
. Provide 2nd level support to application support teams managing
Oracle based applications
. Provide on-going assistance to other service providers with new
implementations and support issues
. Demonstrable experience of managing high-performance, high-capacity
databases in a critical production environment.
. Solid Oracle 11gR1/R2 RAC experience including build, general
administration, troubleshooting (Break/Fix) and performance tuning
skills
. Experience in Clusterware (GRID Infrastructure) - CRS management and
configuration
. Skilled in Oracle ASM and Dataguard administration
. Expertise in SQL & Database Level performance tuning skills
. Expertise in backup and recovery and migration using RMAN, DataPump
and export/import.
. Experience on Solaris, Linux and AIX OS including strong shell
scripting skills.
. Strong initiative and sense of ownership.
. Expert knowledge of database scripting and automation technology
. Oracle database architecture installation, configuration, tuning,
review, and troubleshooting on versions 9i, 10g, and 11g.
. IBM, New York, NY
Feb 2010 - Nov2012
. Oracle DBA Technical Support in a UNIX and Windows infrastructure
(Contract)
. Migrated Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 -
64bit Production from Sun Solaris Sparc to Red Hat Linux 5.6.
. Oracle Architecture Design including capacity planning, storage,
clusters, servers with the ability to offer solutions for high
availability, disaster recovery and scalability.
. Oracle database architecture installation, configuration, tuning,
review, and troubleshooting on versions 9i, 10g, and 11g.
. Hands-on Oracle 10g RAC and Data Guard on Linux. Database Backup and
Recovery solutions including RMAN, Backup Scripts and SAN based
backups. Oracle Monitoring with OMS and Grid Control. Strong
knowledge of all primary Oracle platforms including Unix, Linux and
Windows.
. RAC: Setup and maintained a three node Linux (RedHat based) cluster
using CRS (Cluster Ready Services), ASM and Oracle RAC enabled
software.
. Strong Programming skills including at a minimum: Unix Shell
Scripting, PL/SQL.
. Backup and recovery of Oracle databases using RMAN.
. Upgrade databases (when needed) to the desired level.
. Document benchmarks and procedures needed to optimize performance.
Monitor that all guidelines are followed
. Provide input on any design decisions for interfacing or integrating
databases
. Work with the configuration manager to determine change control and
impact analysis for the databases.
. Monitor and manage implementation of Oracle security patches and
required Oracle operating system maintenance
. Monitor database growth sizing trends and develop capacity planning
and data archival strategies
. Plan and execute Oracle level security based audit
. Dataguard setup, maintenance and monitoring.
. Monitoring of Oracle servers including capacity and space
management.
. Extensive knowledge of Oracle database versions 11g, 10g, 9i.
. Proficiency in installation, configuration and administration of RAC
clusters (including Oracle Clusterware, Server side load balancing,
Service based connectivity, Automatic Storage Management (ASM),
Physical and Virtual network address management, patching.
. Extensive use with Oracle Enterprise Manager Grid Control for
monitoring, administration and performance tuning (including
installation and configuration of OMS and mass agent deployment,
custom alerting through Grid).
. Expertise with Oracle Data Guard using Real-Time Apply in a physical
and logical standby environment.
. Planned and built database instances and objects.
. Planned and implemented Oracle backup and recovery via extensive
RMAN scripts.
. Monitored and tuned Oracle database for optimum performance. Assist
in capacity planning of Oracle database servers.
. Frequent Troubleshoot Oracle infrastructure problems.
. Refreshed development/test databases from copies of production.
. Provided technical assistance and guidance to application support
staff and project teams.
. Developed, documented, and implemented operational support
procedures for the Oracle Database.
. Assisted application developers with writing efficient SQL, and
train them on the use of database tools, techniques and concepts.
. Five years of experience in UNIX Korn/Bourne Shell scripting for
automation.
. Reviewed, recommended, tested, and implemented Oracle application
data model creations and/or changes.
. Ensured the high availability, performance and security of the
production database.
. Tuned at the instance and SQL statement level and supported the test
and development database environments.
. Knowledge in Advanced Replication/Materialized Views Partitioning
Dataguard Streams.
. Installed and Configured SQL Server 2005 2008.
. Supported SQL Server 2005, 2008 as DBA with Installation replication
data modeling and moving data around and backup procedures.
. Created Database Snapshots.
. National Grid, Melville, NY
Apr 2007 - Jan 2010
. Oracle DBA Technical Support in a UNIX and Windows infrastructure.
(Contract)
. Oracle 9i and 10g/11g Database Administration and Management on
Solaris and Linux environments
. Good knowledge of Oracle internals worked on VLDB
. Proven track record in supporting development and production
activities simultaneously in a large environment
. Oracle Database Tuning and Performance - usage of stats pack, AWR,
ADDM, ASH and UNIX native commands
. Oracle Data Guard Physical Standby configuration, build and support
including Data Guard Broker
. Storage considerations for Oracle Database Performance
. Oracle backup and recovery configuration and procedures using RMAN
as well as SQL Backtrack
. RAC on Linux OR Solaris
. OID setup, upgrades, troubleshooting and administration
. Oracle Enterprise Manager/Grid Control for environment
standardize
. Oracle Architecture Design including capacity planning, storage,
clusters, servers with the ability to offer solutions for high
availability, disaster recovery and scalability.
. Oracle database architecture installation, configuration, tuning,
review, and troubleshooting on versions 9i, 10g, and 11g. (AOL, OM,
OE, ONT, SHIPPING, ASCP, INV, FA, AR, AP, GL, PO, PA, WIP, BOM, MRP,
CM, Incentive Comp, Time and Labor, HR, EDI, ALERTS, FSG, ADI)
. Oracle ERP 11.5.10, Oracle ERP 11.5.7 releases supported.
. Install, configure, administer and manage Oracle E-Business
applications-11.5.10
. Hands-on Oracle 10g RAC and Data Guard on Linux. Database Backup and
Recovery solutions including RMAN, Backup Scripts and SAN based
backups. Oracle Monitoring with OMS and Grid Control. Strong
knowledge of all primary Oracle platforms including Unix, Linux and
Windows.
. RAC Set up and maintained a three node Linux (RedHat based)
cluster using CRS (Cluster Ready Services), ASM and Oracle RAC
enabled software.
. Strong Programming skills including at a minimum: Unix Shell
Scripting, PL/SQL.
. Backup and recovery of Oracle databases using RMAN.
. E-Business Suite system Support including: upgrading, patching,
cloning, installation, high availability, rapid recovery,
performance tuning, capacity planning, and disaster recovery.
. Experience with shared appl_top.
. Experience implementing Oracle 10G application server.
. Experience with Designer Repository"/"HeadStart for Apps and
OID/SSO.
. Modules supported included IProcurement, GL, AP, AR, FA),
Purchasing, Inventory, HR, Payroll.
. E-Business suite backup and recovery, and maintaining the Oracle E-
business Suite and 9i databases as well as provide level 2 & 3
support on a rotating basis. Proactively identify and correct 11i
performance problems and monitor space usage.
. Upgrading, patching, cloning, installation, high availability,
performance tuning, capacity planning, and disaster recovery.
. Extensive utilization of all ad utilities for E-Business Suite.
. Install various components of database related software and
configure it.
. Upgrade databases (when needed) to the desired level.
. Document benchmarks and procedures needed to optimize performance.
Monitor that all guidelines are followed
. Provide input on any design decisions for interfacing or integrating
databases
. Work with the configuration manager to determine change control and
impact analysis for the databases.
. Monitor and manage implementation of Oracle security patches and
required Oracle operating system maintenance
. Monitor database growth sizing trends and develop capacity planning
and data archival strategies
. Plan and execute Oracle level security based audit
. Dataguard setup, maintenance and monitoring.
. Monitoring of Oracle servers including capacity and space
management.
. Extensive knowledge of Oracle database versions 11g, 10g, 9i.
. Proficiency in installation, configuration and administration of RAC
clusters (including Oracle Clusterware, Server side load balancing,
Service based connectivity, Automatic Storage Management (ASM),
Physical and Virtual network address management, patching.
. Extensive use with Oracle Enterprise Manager Grid Control for
monitoring, administration and performance tuning (including
installation and configuration of OMS and mass agent deployment,
custom alerting through Grid).
. Expertise with Oracle Data Guard using Real-Time Apply in a physical
and logical standby environment.
. Planned and built database instances and objects.
. Planned and implemented Oracle backup and recovery via extensive
RMAN scripts.
. Monitored and tuned Oracle database for optimum performance. Assist
in capacity planning of Oracle database servers.
. Frequent Troubleshoot Oracle infrastructure problems.
. Refreshed development/test databases from copies of production.
. Provided technical assistance and guidance to application support
staff and project teams.
. Developed, documented, and implemented operational support
procedures for the Oracle infrastructure components.
. Developed, documented, and implemented security configuration for
Oracle software and database instances to comply with existing
standards.
. Supported production of database architecture.
. Developed procedures, processes, tools, and documentation to
install, operate, administer, maintain, and provision the Oracle
database infrastructure.
. Major areas of focus: Oracle Database 10g/11g on Unix platforms.
. Analyzed performance issues and recommend solutions.
. Pro-actively automated routine DBA tasks, devise, execute, document
and improve disaster recovery plans.
. Strong experience w/ RAC.
. Assisted application developers with writing efficient SQL, and
train them on the use of database tools, techniques and concepts.
. Five years of experience in UNIX Korn/Bourne Shell scripting for
automation.
. Reviewed, recommended, tested, and implemented Oracle application
data model creations and/or changes.
. Ensured the high availability, performance and security of the
production database.
. Tuned at the instance and SQL statement level and supported the test
and development database environments.
. Knowledge in Advanced Replication/Materialized Views Partitioning
Dataguard Streams.
. Installed and Configured SQL Server 2005 2008.
. Supported SQL Server 2005, 2008 as DBA with Installation replication
data modeling and moving data around and backup procedures.
. Created Database Snapshots.
. Arrow Electronics, Melville, NY
Mar 2006 - Apr
2007
. Oracle Financials/Oracle eBusiness Suite Database
Administrator (Contract)
. E-Business Suite system Support including: upgrading, patching,
cloning, installation, high availability, rapid recovery,
performance tuning, capacity planning, and disaster recovery.
. Oracle ERP 11.5.10, Oracle ERP 11.5.7 releases supported.
. Supported both single instance and RAC enabled Oracle databases
. Proven Oracle Database Administration experience in production (5+
years), including installing, patching, upgrading Oracle databases.
. Strong hands-on experience in monitoring and tuning a database to
provide a high availability service and optimum storage capability,
including: query optimization, init.ora configuration, memory
optimization, tablespace storage optimization, table/index analysis,
tuning long-running processes.
. Fluent with Oracle 10G and RAC environment and configuration.
. Fluent with RMAN backup and configuration.
. Used NetBackup software for all RMAN backups and recoveries.
. Fluent in Unix, shell scripting and Unix/Linux system
administration.
. Fluent with the usage of raw devices and ASM.
. Fluent in SQL and PL/SQL.
. GridApp Systems, New York, NY
Dec 2005 - Mar 2006
. DBA/UNIX
. Worked in a RAC environment setting up Oracle RAC in a 3-node Linux
cluster.
. Installed, maintained Solaris 8-9 in support of Oracle 9i and 10G
Installations.
. Experience with CRS, and ASM to set up clustering.
. Worked on automating the installation of Oracle 9i and Oracle 10G.
. Heavy Korn and Bash scripting to automate repetitive procedures.
. Facilitated automation.
. Assisted with database technical design reviews.
. Used OEM for both monitoring and administrating Oracle 9i
. Tuned SQL queries using Explain Plan, SQL*Trace and TKPROF.
. Used PL/SQL, Stored Procedures, triggers, packages, SQL Loader,
export/import, DataPump utilities.
. MTA, New York, NY
Jan 1990 - Oct 2005
. Senior Software Engineer/Oracle DBA (Under contract to Lockheed
Martin and ACS Computer Systems)
. Functioned as both a DBA and /HPUX/SOLARIS 8-9/AIX/LINUX System
Administrator in support of a PeopleSoft 8.4.4 ERP environment.
. Supported PeopleSoft 8 ERP in installation and customization.
. Helped with the setup of App Servers, Web Servers to support
PeopleSoft 7 8.
. Helped with MULTIPLE PeopleSoft migrations.
. Managed Database Structure, Storage Allocation, Table/Index
segments, Rollback segments, Constraints, Database Access, Roles and
Privileges.
. Configured and gave 24* 7 production support to over 15 Oracle
mission critical instances running on HP, Sun, Linux and AIX
platforms running half a Terabyte.
. Linux Installation and Operational Support for RedHat ES 3, RedHat
ES 4. Linux Operational Support for Suse, Fedora and Slackware.
. Cloned Oracle Instances using both RMAN DUPLICATE technology and
prior to ORACLE 9i, using manual techniques of duplicating instances
and recreating control files.
. Oracle DATAGUARD implemented for Disaster Recover.
. Used both Physical and Logical Standby Databases.
. Installed Oracle modules for various Applications including
PeopleSoft.
. Implemented Oracle Security using standard Auditing guidelines.
. Implemented Virtual Private Databases (VPD) on Oracle 9i.
. Installed Bind NameServers, NFS and LDAP on Linux and Unix Servers.
. Responsible for tuning all databases instance from OS down to
Instance to SQL Level
. Analyzed evaluated, troubleshot and resolved database problems.
. Wrote advanced shell scripts using Perl, SQL, Bash, Ksh and Csh, SQL
Loader, export/import, DataPump utilities.
. Maintained, upgraded, and modified system and disk configuration.
. Responsible for maintaining Oracle 7.3 - 8.1.7- 9.2 on an IBM AIX
platform and on an HPUX platform in a OLTP environment.
. Also supported same on a Sun Solaris 8 environment.
. Provided technical support for all database applications in
development and production.
. Maintained and supported both production and development Oracle
database environments.
. Created and configured Oracle databases and the PeopleSoft three-
tier environment.
. Used RMAN Database backup and recovery, PL/SQL, Stored procedures,
Triggers and Packages.
. Assisted with database technical design reviews.
. Used OEM for both monitoring and administrating Oracle 9i.
. Tuned Offensive SQL by using tools like Explain Plan and TKProf.
. Adhered strictly to Change Control/Change Management policies of the
organization.
. Provided technical assistance to the development team.
. Ensured Oracle data security and integrity.
. Performed administration of all Data Base objects, including tables,
clusters, indexes, views, sequences, packages, and procedures in an
Oracle 8i and 9i environment.
. Upgraded the databases from Oracle 8.1.7 to Oracle 9.2.0.5.
. Used both Export/Import and Oracle Migration Tools to perform
multiple migrations.
. Wrote RMAN scripts to automate the backups.
. Performed Disaster Recovery for all instances at Sungard Remote
Site.
. Planed and implemented Oracle and PeopleSoft backup and recovery.
. Monitored and tuned Oracle databases for optimum performance.
. Installed Oracle 8.1.7 and Oracle 9.2.0.5.
. Created multiple instances to support an PeopleSoft 8.8
implementation.
. Created indexes and configure disc/table spaces to achieve optimal
performance.
. Monitor databases via user written scripts and Oracle Enterprise
Manager.
. Setting up multiple AIX RS6000 computers and multiple HPUX machines
7026/H70s and 7029's running Operating Systems AIX 4.3.3 and AIX
5.2.
. Installed HPUX 11i on an RP7410 and RP7420.
. Part of the team responsible for MC ServiceGuard for Oracle
clustering.
. Documented Standard Operating Procedures and manuals, user guides
and Technical Operating procedures.
. Streamlined error detection and correction as it related to the
database and apps environment.
. EDUCATION
. CCNY, New York, NY
. B.S.E.E., Computer Science
Contact this candidate