Sr. Oracle DBA Resume

Title
Sr. Oracle DBA

Primary Skills
SQL*Plus, PL/SQL, SQL*Loader, SQL*Net/Net8Oracle Management Server

Location
US-NJ- (will consider relocating)

Posted
Jul-17-07

SUMMARY
A highly dependable and result-oriented professional with more than 8 years of progressive information systems experience with over 8 years of Oracle database administration in heterogeneous system environment including Solaris, Linux, and Windows, supporting a variety of mission critical applications in enterprise and financial environment. Extensive experience with Oracle database administration, RAC, standby, replication, installation, configuration, migration, sizing and space management, backup and recovery, performance tuning and troubleshooting. Broad technical knowledge of infrastructure management (network, systems, web hosting), combined with outstanding leadership ability, project management, and creative problem solving skills in both strategic and tactical areas.


KEY STRENGTHS
• Expertise in Oracle 10g/9i/8i database administration in high availability production environment
• 10g/9i Real Application Clusters (RAC) installation and maintenance
• Extensive experience in production database support
• Expert in backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning
• Solid experience in disaster recovery, routine maintenance for Oracle databases
• Solid experience in Oracle Recovery Manager (RMAN), advanced replication, and standby database using Data Guard 9i/10g
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
• Employing Oracle Enterprise Management (OEM) with standard management, diagnostic, tuning, and change management packs to perform various administrative tasks. Setting-up and configuring Oracle Management Server (OMS) to monitoring database operation.
• Data transferring with export/import utilities and Data Pump and SQL* Loader.
• Performance monitoring/tuning/troubleshooting on Oracle, Unix, Linux, and Windows NT/2000/2003 servers
• Installation, configuration, upgrading and migration of Oracle software (9i, 10g) and tools. Applying patches under UNIX, Linux and Windows platform.
• Security implementation through Single Sign-On (SSO) and Oracle Internet Directory (OID)
• Unix Shell scripts for hot backups, SQL*Loader, export and import of database
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, monitor users, tablespaces, memory structures, rollback segments, logs, and alerts
• System administration on Windows
• Excellent interpersonal and strong analytical, problem-solving skills




TECHNICAL SKILLS
• Operative System
Unix, Linux, Windows

• RDBMS
Oracle Database 10g/9i/8i

• Tools
SQL*Plus, PL/SQL, SQL*Loader, SQL*Net/Net8, Oracle Management Server, Oracle Enterprise Manager (OEM), EXPLAIN PLAN, TKPROF, STATSPack, Solaris/Unix/Linux Shell Scripting, Export/Import, RMAN

• Hardware
E10K, F15K, Sun E4500/E6500, HP9000, RS/6000, Sun SPARC Servers, DRS-6000, IBM RS 6000, IBM p690

• Protocol
TCP/IP

• Languages
English, Spanish, Portuguese


PROFESSIONAL EXPERIENCE
First National Bank, Ames, IA 9/2006-04/2007
Senior Oracle DBA, Consultant

Job Responsibilities:
• Installed, configured and maintained Oracle 10g Real Application Cluster (RAC).
• Set up and maintained oracle disaster recovery site using DataGuard.
• Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.
• Utilized RMAN for backup and recovery strategy.
• Completed export and import of different databases using Oracle Export / Import utilities
• Table fragmentation tuning, partitioning the large table by date.
• Installed, configured and maintained Oracle database 10g, and upgraded Oracle 9i to 10g.
• Provided all kinds of DBA support to development teams as well as production support to various applications.
• Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Trouble shooting and resolving any database and/or application issues or errors that occurred
• Performed database tuning by using various tools, like Oracle Enterprise Manager and STATSPACK
• Monitored the various database activities by developing shell scripts and using various tools.
• SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor.
• Patched Oracle Database Server 9i and 10g using Opatch.
• Established database backup/recovery strategy for different databases
• Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Setup and support of Oracle replication(replication and conflict solution)
• Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Developed scripts to monitor the storage usage, object status for daily job
• Provided on-call support regarding production-related database problems
• Worked with IT managers and application developers to ensure the database integrity , high availability and security
• Configured Single Sign-On (SSO) and Oracle Internet Directory (OID) to increase security and lower cost

Environment: Sun Solaris 9, Red Hat Linux AS4, Oracle 9i/10g/10g RAC


GEICO, Des Moines IA 05/2006-08/2006
Oracle DBA, Consultant

Job Responsibilities:
• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software Legato troubleshoot and backup testing.
• Managed and resolved design issues during development.
• Moved database Schema changes to stage or production.
• Migrated and upgraded databases from version 9i to 10g.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Performed database tuning using Explain Plan, Toad, PowerExplain, and Enterprise Manager.
• Provided on-call production database support.
• Tested and documented some Oracle10g new features, such as Automatic Storage Management (ASM).
• Created materialized views.

Environment: Oracle (10g/9i) on Solaris 9, Linux, 9i/10g Oracle Enterprise Manager (OEM), Toad

Texas Star Bank, Dallas, TX 12/2005 - 05/2006
Senior Oracle DBA
Texas Star Bank is the oldest finical service in Texas which offers online banking, automated bill paying and Visa check cards. It also provides mortgage and loan services to consumers and businesses of all sizes. The most ongoing project is Soffront Help Desk CRM project. DBA responsibilities involve test/dev/production instance planning/configuration/installation with on-going tuning process to ensure the completion of each project phase. Also support the develop team to install, test and deploy the new release of the new function/components of the Soffront Help Desk CRM software. The daily job also includes to monitor and tuning 28 Oracle databases (OLTP and hybrid) and SQL Server on various platforms.
Production support for Oracle database 9i/10g/10g RAC and SQL server 2000
Database capacity planning for the new project based on the SRS.
Database support through the project initialization, pilot to production phase
Full preparation of go live date
Analyzed the business and application requirements. Prescribed set of processes to design the accurate model by Erwin
PL/SQL programming
New database setup and creation for 9i/10g
ASM installation for 10g/10g RAC
CRS installation and new database creation for 10g RAC
Standby database setup via Dataguard for Database Disaster Recovery
Security Administration included creating & maintaining Users and Roles
Upgrading and Patching the 9i/10g/10g RAC
Shell Scripts(Korn Shell, Bash Shell) coding for backups, SQL Loads, export and import of database
Trouble shooting for the different database problem
Monitoring & managing the instance using OEM, Quest Spotlight
Set up the backup strategy for different database
Using RMAN to perform the HOT/COLD Database Backup and Restore.
Database refresh
Performance tuning via OEM, STATSPACK/AWR for 9i/10g/10g RAC
Table fragmentation tuning, Partitioning the exist large table by range via dbms_redefinition
Building the indexes for new tables
Rebuilding all indexes every weekend
SQL Tuning using Explain Plan, tkprof with sql trace, SQL Tuning Advisor
I/O tuning via OEM, STATSPACK
SGA/PGA tuning via OEM
Stream data between 2 nodes through the use of Oracle Streams
Database clone, rename between different platform
Peoplesoft 8 installation and configuration
Manage the Sql Server 2000 Database
Environment SUN Solaris 9, Red Hat Linux AS 2.0, Oracle 9i/10g/10g RAC, Windows 2003 Server, SQL Server 2000
Oklahoma Panhandle Telecom, Goodwell, OK 10/2004 - 11/2005
System Administrator
Oklahoma Panhandle Telecom is a high tech start-up company selling a new, patent-pending technology service to Fortune 1000 companies. My duty was to deploy, monitor and maintain applications, servers and network infrastructure to support an international application service provider environment. Additionally, the administrator participated in systems/network design and policy related activities, and worked with the research and development group on selected projects.
Deployed, monitored, managed, and maintained both customer and internal network and systems elements.
Deployed, monitored, and maintained applications related to our service.
Managed operating system and software patches and upgrades.
Ensured backups and reporting were carried out as per policy.
Administered security and access control policies.
Maintained facilities, systems, and network documentation.
Contributed to engineering, policy, and development projects.
Handled network and systems failures and outages, escalations internal and external.
Responsible for disaster recovery and business continuity planning and testing
Performed all duties with an emphasis on achieving maximum stability and security, while maintaining performance and customer satisfaction.


Allied Insurance, Des Moines IA 08/2003-09/2004
Oracle DBA, Consultant

Job Responsibilities:
• Monitored and tuned AppSever performance
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems
• The tools used mainly are TKPROF, Explain Plan, and some scripts
• Created new databases and users, setup RMAN backups, Export, and other monitoring scripts
• Provided 24x7 on call production support

Environment: Oracle (10g/9i) on Solaris 9, Linux, 9i/10g, Windows


Principal, Des Moines IA 03/2002-08/2003
Oracle DBA, Consultant

Job Responsibilities:
• Coordinated database backup and recovery strategies and performance and storage monitoring
• Tuned parameters for a large monthly SQL* Loader job resulting in 90% reduction of operation time.
• Oracle database installation, upgrades, instance configuration, tuning, schema maintenance, troubleshooting, and production monitoring support
• Created a self-tuning procedure for adjusting SGA memory components based on application processing needs
• Monitored RMAN backups and tested various RMAN recovery scenarios for production databases

Environment: Oracle 9i on Solaris 8, Linux, 9i/10g


State Farm Insurance, Des Moines IA 05/2000-03/2002
Oracle DBA, Consultant

Job Responsibilities:
• Involved in Database high availability planning and deployment
• Involved in Database/System tuning
• Involved in the Design, creation and administration of the production, development databases
• Involved in documenting the environments and processes
• Involved in Development support and SQL/SQL Tuning
• Responsible for refreshing Stage databases with production data
• Implemented backup strategy using RMAN

Environment: Oracle 9i on Solaris 8, Linux, 9i/10g


EDUCATION
• MS Management Information System Iowa State University


Certifications
Oracle Certified


You must be logged in and have a current resume access subscription. Login or Register »

| Resumes in New Jersey

View other Sr. Oracle DBA resumes, Database Administrator resumes