Oracle Sql Server
Resume:
Purvish Patel
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