Resume

Sign in

Oracle Sql Server

Location:
Snoqualmie, Washington, 98065, United States
Posted:
March 24, 2011

Contact this candidate
Sponsored by:
TalentDesk
Post Jobs to
Multiple Job Boards &
Get more Candidates
Try it Free!
Start your 30-day
Free Trial

******* *****

***** ** ***** **

Snoqualmie, WA 98065

Phone: (206) ***-****

Email: *********@*******.***

Objective:

Seeking a challenging environment where I will tune my existing skills.

Also, an environment offering new learning experiences to expand my current

skill set.

Qualifications:

. Implemented database Backup and Recovery procedures for Oracle 8, 8i,

9i and 10g and Sql Server 2000 databases.

. Responsible for supervising technical staff for migration of primary

systems to Data Center.

. Responsible for planning and supervising in training support staff on

upgraded ticket system

. Analysis and solving database errors.

. Currently responsible for migrating a major customer's systems to new

hardware. And supervising the migration of backend database to new

hardware, OS and Database version.

. Responsible for keeping CEO and Executives informed on progress of

project and technical hurdles to overcome.

. Responsible for new application release's to production. Working with

QA, Dev, Ops and Customers to plan the release.

. Performance Tuning on Sql Server databases

. Motivating staff on hitting deadline targets set by Executives and

CEO.

. Project Management of upgrade of job scheduler system.

. Responsible in getting a technical team assembled for driving

requirements for including tools and reports from Hubspan Application.

. Implementation, Verification and Maintenance of Oracle 11g Grid

Control.

. Use of Oracle Grid Control in management of databases and

troubleshooting database issues

. Kept databases up on current bugs and patches.

. Informed management on how bugs will affect the system.

. Defined database tuning needs.

. Assisted in daily database operations and data loads.

. Provided general database support.

. Wrote Stored Procedures for Oracle and SQL Server databases.

. Installation of Oracle and Sql Server on Windows NT, 2000, 2003,

Solaris and RHEL 5.1.

. Migration of database from Oracle 7.3.4 to Oracle 8.0.5.

. Migration of database from Oracle 8.1.7 to Oracle 9.2.0

. Migration of database from Oracle 9.2.0 to Oracle 10.2.0

. Implemented program for disaster recovery situation at the Hanford

Nuclear Reservation.

. Use of Streams in Migration.

. Excellent communications, problem solving, and organizational skills.

. Effective writing skills for reports, business letters, memoranda and

documentation.

Technical Qualifications:

. Hardware: Dell Servers, Laptops and Workstations

. Operating Systems: Windows NT, Windows 2000, Windows 2003, UNIX, HPUX,

Red Hat Linux

. SAN EMC 500, 380 and 480

. Tools: SQL, PL/SQL, Server Manager, Oracle Enterprise Manager, Oracle

Export-Import utilities, Oracle Management Server 9i, Oracle Sql

Analyze, Oracle Top Sessions, Oracle Top SQL, Oracle Performance

Manager, Oracle Change Manager, SQL Navigator, DB Artisan, ER Studio,

Unix Shell Scripts, Oracle Grid Control, RMAN, TOAD

. Administration: Oracle 7.3.4, 8.0.5, 8i, 9.2.0.6, 10.2.0.3, 10.2.0.4,

SQL Server 2000 and 2005

. Languages: SQL, HTML, PL/SQL, C, C++, TSQL

. RDBMS: Oracle 7.x, Oracle 8.x, Oracle 8i, Oracle 9i, Oralce 10g, SQL

SERVER 6.5, SQL SERVER 2000, SQL SERVER 2005, Access 97, Access 2000

and 2007

. Applications: MS-Office 98, MS Office 2000, MS Office 2003, MS Office

2007, MS Visio, MS Project, Grid Control, Net8, Enterprise Manager,

SQL Plus, Designer 2000, Sharepoint

. Networking: Adding hardware to a WAN network, mapping drives, etc.

Experience:

Hubspan Inc. April 2005 to

Present

Seattle, WA

Title: Oracle DBA

. Worked with Client Services, Development and QA on application issues,

data retrieval and rollout of application upgrades.

. Database Application Tuning

. Involved in implementing PCI requirements

. Migration of Sql Server and Oracle databases between datacenters

. Involved in Datacenter move planning and execution.

. Developed Metrics reporting system for Exec Team.

. Installation and configuration of Oracle 9.2.0.6 and Oracle 10.2.0.4.

. Migration from 9.2.0.4 to 9.2.0.6, 9.2.0.6 to 10.2.0.4

. Migration of database from Windows to RHEL 5.1

. Project management of Database version, OS and Datacenter migrations

. Project Management of Migration of Autosys upgrade.

. Administration of Bug Tracking Application, Change Request Application

and Job Scheduler Application

. Performance tuning of databases Oracle 9.2.0.6 and 10.2.0.4.

. Creation and Maintenance of Databases.

. Creation of logins and user id's and setting up privileges and

procedures for protection of data.

. Maintaining large databases with LOB's.

. Involved in Planning, Testing, Implementation and Production Rollout

of various 3rd Party applications.

. Estimate storage requirements for applications.

. Estimate database storage requirements for server.

. Involved in improving performance in SQL, PL/SQL, SGA tuning.

. Developed Project Plans for 3rd party application upgrades or rollouts

. Developed Project Plans for Application upgrades and rollouts.

. Plan and perform database backup.

. User Maintenance and Support.

. Using RMAN and exports, automated Oracle Offline backups and Oracle

exports for Production, Test and Development databases.

. Performed Oracle Recovery using Offline Backups in conjunction with

Archive logs.

. Perform Oracle database restore and recovery using Oracle RMAN

backups.

Bechtel Corporation October 2002 to

April 2005

Richland, WA

Title: Oracle DBA

. Oversee over 160 databases.

. Instituted Oracle Replication for Disaster Recovery.

. Plan and implement 24 hour 7 days a week Notification System.

. Installation of Oracle 8i and 9i RDBMS.

. Performance tuning of databases with Oracle 9i Oracle Management

Server Tools

. Creation and Maintenance of Databases.

. Creation of logins and user id's and setting up privileges and

procedures for protection of data.

. Maintaining large databases.

. Involved in Planning, Testing, Implementation and Production Rollout

of various Bechtel applications.

. Estimate storage requirements for applications.

. Estimate database storage requirements for server.

. Implemented Oracle Multi Threaded Server.

. Involved in improving performance in SQL, PL/SQL, SGA tuning.

. Create users with roles and privileges using SQL Plus and OEM.

. Plan and perform database backup.

. User Maintenance and Support.

. Automated Oracle Offline backups and Oracle exports for Production,

Test and Development databases.

. Performed Oracle Recovery using Offline Backups in conjunction with

Archive logs.

. Performed over ghost backups of over 500 workstations

. Migrated over 200 workstations from Windows NT 4.0 to Windows 2000

Lockheed Martin Corporation November 2000 to

January 2001

Richland, WA

Title: Oracle DBA (on contract)

. Installed Oracle 8 RDBMS on server and configured the database for

Client/Server.

. Creation and Maintenance of Databases.

. Creation of logins and user id's and setting up privileges and

procedures for protection of data.

. Maintaining large database tables and indexes

. Estimated storage requirements for the application

. Involved in improving performance in SQL, Memory tuning

. Created users with roles and privileges using SQL Plus and OEM.

. Planned and performed database backup.

. User Maintenance and Support.

. Performing Backups & Recovery for Development and Production

databases.

AIDS Healthcare Foundation May 2000 to November

2000

Hollywood, CA

Title: Oracle DBA (on contract)

. Developed new centralized database for AIDS patients

. Performed analysis of foundation informational.

. Backup of Oracle database on Novell using Veritas NetWare.

. Worked with Logician Medical software utilizing an Oracle Database.

. Performed analysis and upgraded Service Request database.

. Utilizing E/R Studio (developed by Embarcadero Software) for design,

creation, and reverse engineering of foundation databases

. Developed reports to pull information from Logician database.

. Interacting with senior managers on exploring their departmental

needs.

Northwest Administrators April 1999 to May 2000

Seattle, WA

Title: Oracle DBA

. Sought solutions for database problems ranging from data corruption to

disk space issues.

. Established Connectivity to the Servers.

. Configured the database, created users, space allocation, and security

management of the users.

. Implemented company wide database upgrade from Oracle 7.3.4 to 8.0.5

. Consolidated three area offices Teamster Union Pension Oracle

databases to a single Oracle database

. Upgraded Personal Oracle 7.3.4 to Oracle Personal Edition 8.0.4 on 45

laptops and 9 desktops

. Upgraded hardware to Dell 500mhz Latitude notebooks and Dell 450mhz

Optiplex desktops

. Rebuilt Tables and Indexes

. Performed Backup and Recovery on Oracle Database

. Planned and Implemented Oracle 8 Backup and Recovery Plan

. Involved in decision process in determining guidelines and basic

requirements for database and hardware upgrades

. Optimized Dell 4300 Server for Oracle 8.0.5 database by configuring

partitions and independent hard drives

. Configured Listener and Tnsnames so area offices could connect with

centralized server using Net8.

. Developed procedures to facilitate users to use database functions

. Developed security protocols for database access

. Developed stored procedures for SQL Server 6.5 database

Transnational Computer Technology January 1998 to February

1999

Los Angeles, California

Role: Work study program. Working with Senior consultant.

. Created tables with primary and foreign keys

. Identified table space memory requirements

. Developed Backup and Recovery methods for Metropolitan Transportation

Authority

. Implemented security procedures for Oracle Database

. Determined Oracle Networking configuration

. Analyzed Oracle errors and consulted with MTA

. Developed documentation on Backup and Recovery methods for MTA

MKJ Internet Services August 1996 to May 1997

Waco, Texas

. Developed WebPages on the internet using Java and HTML for local

businesses

Education:

. California State Polytechnic University Pomona, CA

Oracle 8 DBA Certification Courses

Sept. 1998 to January 1999

. Oracle Education

(Order Entry and Inventory) - Oracle Financials April

1998 and June 1998

. Baylor University Waco, TX

BBA in Information Systems and Marketing December

1997



Contact this candidate