SUMMARY

• Over 20+ years of experience as a Senior Oracle Architect and Oracle DBA professional.
• This includes Information Systems analysis, design, development, backup/recovery, and deployment of Relational Database Applications such as Database Architect, Database Administrator, and Database & Application Tuning. Industries include Telecommunications, Banking, Government, Computer Hardware, Wholesale and Retail Consumer, Automotive(SOX), and Benefits/Payroll.

TECHNICAL SKILLS

OPERATING SYSTEMS: Database/Unix Administrator (Oracle7.x, 8.x, 8i, 9I(Release 1/Release 2 Real Application Clusters(RAC) 9.2.0.1.x w/ BCV Technology*, 10G(10.2.0.x)(RAC),11G,12C Sun - Solaris, HP-UX, AIX, SCO-SCO Open Desktop, Windows/NT,Macintosh VMS,NOS,OSF1(V4.0),NCR(UX),OS/390(IBM), WINDOWS 2000(w/Advanced Server),Linux(Red Hat 2.1/2.4.9AS/i686),SUN Clusters(E-10K).

Software: LOTUS 1-2-3, WordPerfect and WordStar

Network Packages: TCP, X-ONE, NOVELL, ZOO

Applications: ScreenMachine, Asterex, Unisolutions, Look-Glass, Motif Requirements Tracability Management(RTM), Interleaf, Cadre, Ada-Cast-Target, Team Conference CA-Unicenter, PCMS, PVCS, SIEBEL, DOCUMENTUM,ESSBASE(5.02 Patch 10), FileFax, ColdFusion, BroadVision (E-Commerce/E-Business), PeopleSoft(HR), TERADATA, FedBrands (OLTP Foreign Buy), FMA(DataWareHouse), FedFLO(DSS, Logistics, DSS Datamart, Reporting), LOGISTICS (RDS Filemart), FileNET(IMS)/SAP, OLAP, Plumtree Enterprise Portal(4.5 ws), Connection 2000, .NET

Technical Skills: Unix, Ada, Networking Principles, Solaris 2.x Administration, C-SHELL PROGRAMMING, ORACLE,SQL WINDOWSDesigner2000, Oracle Enterprise Manager(OEM), ERWIN, PCS,FTZ(Foreign Trade Zone),Data Replication, Oracle Parallel Server, VERITAS(SunOS 5.x),Oracle Call Interface(API),Discoverer 3i/4I,Oracle Applications11I, Visio Architect.

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Duties include to provide support for assigned enterprise applications and their respective Oracle databases. Apply upgrades and patches to the databases. Troubleshoot/performance tuning and provide functional support and user administration.
• Perform database object migrations in a three-tier environment.
• Install, upgrade, and patch all Oracle instances(12C,18C,19C); ensure proper security levels are maintained; tune; clone; and perform day-to day maintenance to ensure a high level of reliability and stability.
• Provide assistance to application developers in the effective use of database query and programming languages and work with other department personnel to ensure all activities associated with the Oracle databases function smoothly and efficiently.
• Provides support for assigned enterprise Oracle applications and their respective databases
• Linux shell scripting for database automation
• Provide functional and technical support for end-users of the assigned enterprise applications, including but not limited to, applying upgrades and patches, ad-hoc querying, data manipulation and managing end user service tickets.
• Perform troubleshooting and resolution of system issues and providing functional level support to campus end-users.
• Serve as the liaison between functional users and technical support staff.
• 19c upgrade from 12.1.x
• Maintain records and documentation to meet departmental and audit requirements.
• Creation of user accounts, assigning security access, and annual review of user accounts to ensure compliance to audit standards.

Confidential

Oracle DBA

Responsibilities:

• Provide day-to-day support for Oracle databases(11g/12c)
• Provide database administration for a variety of mission-critical custom and packaged software applications
• Experienced in performance tuning and optimization analysis, troubleshooting/best practices and procedures
• Design storage strategies around backup and recovery for complex database environments, physical structures, and specialized database applications
• Understanding of stored procedures, SQL, SQL queries and performance optimization
• Implement and monitor database functionality to ensure stable environments
• Linux shell scripting for database automation
• Review AWR/ASH/ADDM reports. Generate Explain Plans to identify performance bottlenecks and make recommendations to development teams.
• OEM Cloud Control monitoring
• Perform routine database migrations(ie.: Upgrades/Quaterling Patching)
• Support of Java applications
• Mentor DBA team members
• Bi-weekly code deployments into production
• Installation/Administration of Golden Gate
• Assist production control team with monitoring/troubleshooting issues.
• 19c upgrade from 12.1.x

Confidential

Oracle DBA

Responsibilities:

• Provide support for customers as well as internal databases. Build and maintain Oracle databases in new solutions, including all production, backup and development files, creates and supports databases across internal and end-user applications, improves database integrity through quality assurance and manages change control processes Troubleshoot and resolve performance issues related to Oracle databases 11g,12c.
• Work with internal teams to identify root cause of system and data related issues including but not limited to slow database performance, RMAN failures, and deadlocks
• Review AWR/ASH/ADDM reports. Generate Explain Plans to identify performance bottlenecks and make recommendations to development teams.
• Support of Java applications
• PeopleSoft DBA responsible for database reorgs,performance tuning,backup/recovery of the database
• Perform routine database migrations(ie.: Upgrades/Quaterling Patching)
• Work with other DBA resources to maintain a disaster recovery solution for 100+ oracle instances. create shell scripts in Linux environment. database backup and disaster recovery procedures
• Create SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, User Defined Data Types and Functions
• Query optimization & performance tuning. Use SQL Profiler, Explain Plan, AWR report.
• Creating database instances from cold backups or by using DBCA. recovering databases using RMAN. reloading database schemas using Oracle data pump utility

Confidential

Oracle DBA

Responsibilities:

• Supported multiple development teams with all database related activities
• Advising team members on database concepts and functionality
• Work closely with team offshore DBA's to ensure continuous support provided to development teams
• Created and maintained physical and logical data models
• Research and solve problems discovered by users
• Review AWR/ASH/ADDM reports. Generate Explain Plans to identify performance bottlenecks and make recommendations to development teams.
• Assist production support team (24x7 support environment) with troubleshooting
• Perform routine database migrations(ie.: Upgrades/Quaterling Patching)
• Debugging PL/SQL scripts and stored procedures
• Apply Oracle software patches in the Development environment

Confidential

Oracle DBA

Responsibilities:

• Senior Oracle DBA support for Tier 3. As a member of Tier 3 my job involved authoring MOPS/SMOPS for Tier 2 implementation as well as oncall support.
• Building of MOPS/SMOPS in database repository so that they could be readily reused in future iChanges. Taking part in customer conference calls to resolve performance-issues/outages.
• Performing RCA’s to in ensuring same issues wouldn’ Confidential persist. Working with the internal AOTS ticketing system.
• Had to cross-train on various database technologies(ie. DB2,SYBASE,MySQL,MongoDB). Golden Gate was used as replicator with clients. Ensure that compliance training was current.
• Overall team-player who responded to issues/incidents when called upon. Performed 12C upgrade from 11G on RedHat Linux with Dataguard.
• Applying quarterly CPU/PSU updates. Administered Exadata databases. Performed failover from primary to standby and back to original primary.
• Performed Golden Gate installation/configuration.
• Administer databases on Exadata platform(ie.Datapump,tablespace configuration,backup/recovery,performance tuning) Performed as secondary DB2 DBA.
• Troubleshoot GG lags,configuring extracts/replicats. Applying quarterly CPU/PSU updates. Administered Exadata databases(12C).
• Perform database maintence which includes upgrades and quarterly patching.
• PeopleSoft DBA that performed backup/recovery,table reorgs,software deployments.
• Review AWR/ASH/ADDM reports.
• Generate Explain Plans to identify performance bottlenecks and make recommendations to development teams.

Confidential

Oracle DBA (Consultant)

Responsibilities:

• Implemented Oracle 10g RAC on Sun Solaris UNIX operating system.
• Completed SQL tuning using dimensional data modeling techniques for end user reporting and analysis applications including data warehouses and/or data marts Database Design.
• Used knowledge of database normalization theory, STAR schema design, Enterprise data warehousing, heavy PL/SQL tuning and data modeling techniques.
• Completed data security skills including relational database security and role-based security while being responsible for all problem solving and managing properties and workflow of Strong UNIX & Shell scripting.
• Review AWR/ASH/ADDM reports.
• Generate Explain Plans to identify performance bottlenecks and make recommendations to development teams.

Confidential

Oracle DBA (Consultant)

Responsibilities:

• Responsible for supporting over 400 databases. Performed proof-of-concept with 11G (11.1.0.6.0) on Solaris 10.
• Used Veritas Clustering as the file system manager for OS/Application support. Was responsible for destructive/performance/load testing of 11G RAC(ASM), UNIX shell scripting, and DataGuard and RMAN support.
• Built production instances, monitored key financial applications, and was administrator of Golden Gate.
• Perform database maintence which includes upgrades and quarterly patching. Review AWR/ASH/ADDM reports.
• Generate Explain Plans to identify performance bottlenecks and make recommendations to development teams.

Confidential

Database Server Consolidation

Responsibilities:

• Consolidated/upgraded databases and hardware from 32 servers to 16.
• This large task was completed under a strict corporate deadline.
• Also provided support of Linux-based servers and monitored new applications on new Oracle RAC farm (8TB).
• Perform database maintence which includes upgrades and quarterly patching.

Confidential

Advanced Product Support

Responsibilities:

• Was member of Advanced Product Support (APS), delivering post-sales support and solutions to the Oracle customer base while service as advocate for customer needs.
• Built/tuned Oracle databases, acted as expert member of the problem solving/avoidance team, and implemented RAC (9.x/10.x) across various platforms with Oracle customers.
• Worked with all facets of IT to ensure acceptable delivery per contract verbiage.
• Perform database maintence which includes upgrades and quarterly patching.

Confidential

Consultant

Responsibilities:

• Tuned Oracle Database for more efficient data retrievals. Reviewed Essbase configuration and outline to ensure faster cube builds.
• Also tuned Oracle SQL statements, confirmed server kernel parameters were in sync with Essbase and Oracle configurations, and built Oracle RAC Databases (3TB).