Senior Oracle DBA Resume Profile

Skills:

Languages: C , JAVA, PL/SQL, COBOL, UNIX scripting Oracle Tools and Utilities: RAC, Dataguard DR and GoldenGate Replication, Oracle Enterprise Manager 12c, numerous Database Design tools, VMware hypervisor 1 and 2 Systems: All types of Unix variants. All window releases. Databases: Oracle 12c, 11g,10g, 9, DB2, Sql Server and Teradata

Work Experience Summary:

Senior Oracle DBA

Over 20 years experience with Oracle RDBMS products and 30 year IT experience I possess experience which includes machine capacity planning, determining disk/array requirements, application schema design using ErWin and Oracle Designer, backup and recovery using RMAN, High availability design using RAC, Data Guard, and Golden Gate.
I am open to full-time or contract work. I am very interested in relocating to the following states AK, MT, ID, WY, CO, AZ, UT, NV, NM, FL, SC, NC, GA, OR, WA, TX .

Work Experience:

Senior Database Engineer

Perform all tasks associated with Oracle databases this includes design, installation, hardware selection, capacity planning and assisting developers with SQL performance.
Install quarterly PSU/CPU patch sets.
Part of on-call support team which oversees 90 plus Oracle databases on Linux, Windows and Oracle appliance machines.
Tasked with performance evaluations using 12c inmemory option and various compression options.
Attended SQL Server training.

Senior Oracle DBA

Attached to support group to support Telecommunication servers running Oracle 10g and 11g databases.
Lead DBA responsible for all oracle database related issues, instance failures, performance issues, capacity issues and maintaining security.
Works with system administrators to tune machine and operating system parameters to maximize Oracle performance.
Performs SQL tuning for applications.
Expert in targeting performance bottle necks using AWR, Statspack, TKProf, and OS performance monitoring tool such as TOP, and TOPAS.
Maintain, monitor and improve Data Guard DR sites. Includes synchronization, repairing archive gaps, re-building when needed.
Very experienced in dealing with Oracle Support to solve complex issues.

Senior Oracle DBA/Designer/Data Modeler

Lead designer and modeler for next generation FAA databases. Databases include weather tracking and storage procedures and airplane flight scheduling.
Using Stratus 6300 servers, Oracle ODA servers and HP Blade servers. Running Redhat 5.5, 6.1 and Oracle Linux 6.3 OS's. Using Oracle 10gR2, 11gR2 as DBMS. Using oracle RAC, Data Guard, and Golden Gate.
Built servers on HP blades for 9999's operation. Used VMware ESXi to partition machine
Responsible for maintaining all oracle legacy database which include after hours support.
Mentoring several FAA government employees on becoming DBA's to support new nextgen systems after they are built.
Responsible for building all prototype machines from the ground up including hardware, installs, Operating System installs, Oracle installs, array/san configuration.
Built fully automated process to build Data Guard systems using the Broker option with the launching of a single script. Script uses target machines RMAN backup and builds on destination machine, sets up Broker.

Confidential

Prototyped NextGen platform using IBM, HP and Sun machines. Built numerous configurations to determine optimal platform. Mission was to build tough fault-tolerant Telco servers capable of supplying five 9's uptime.
Designed replication logic to support our horizontal Master/Slave s concept of load balancing. Wrote scripts to re-sync replication across all nodes when needed.
Designed Database Architecture that controls all database link accesses during instance and node failures. This system shunts access from downed nodes in an instantaneous manor, much faster than waiting for TAF and TCP-IP timeouts.
Measure system wide performance along with Product Performance Engineering group using statspack, client tracing, tkprof, Spotlight and OEM.

Oracle DBA

Supported PeopleSoft HR and AR modules. Performed Peoplesoft application upgrades when needed.
Worked with team to set up Enterprise class HP and Enterprise Array systems for medical and pharmaceutical industry.
Worked with PeopleSoft application programmers to tune queries and troubleshoot database access code.
Managed Oracle WebServer and firewall plug-ins to provide internet access to our field sale group to our Warehouse and DSS databases behind our firewall.

Oracle DBA

Part of Integration team responsible for testing and tuning Oracle 7.0.3 instances on Sun and Compaq Alpha servers to support military messaging system.
Wrote scripts to automate testing procedures and to load test machine nightly with new schema builds.

Designed and coded a client/server JAVA application to remotely control and monitor a sophisticated data acquisition instrument
Responsible for fine-tuning the performance of a database at 500 gigabytes/485 tables
Streamlined database versioning release process by reverse-engineering the database into Erwin, altering the tables, the exporting DDL into BMC Alter for final construction

Senior Software Engineer

Normalized and designed complex relational database schema and introduced Erwin data modeling tool into Conrail's software development toolset
Pioneered the use of referential integrity for enforcing constraints in DB2 databases
Designed and supervised complex, dynamic DB2 sql for rail car rating lookups against VLDB's
Created car tracking application in C which interfaced with DB2 database
Completed Oracle training classes
Created Teradata databases for data warehouse functions

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship