We provide IT Staff Augmentation Services!

Sr. Oracle Database Administrator Resume

Jacksonville, FloridA

Professional Summary

  • Over 10 years of experience in IT with expertise in Systems, Databases and Application Administration and management
  • Expertise in Oracle 11g/10g/9i/8i administration and management
  • Experience with DB2 UDB LUW 8.x/7.x and SQL Server 2005/2008 administration and management
  • Expertise in Siebel 6.x/7.x/8.x Server installation, configuration and administration, Siebel Application Administration, Siebel upgrade, WMQI/WBI Administration, MQ Administration, NetegritySiteminder Administration, Siebel Administration on AIX, Windows and LINUX,Automation using Shell, Batch and Perl scripting, Application and Database Performance tuning for Siebel on DB2 UDB databases, Application & Server Monitoring using Foglight, Siebel Analytics and OBIEE installation, configuration and administration
  • Excellent working knowledge of RDBMS, ETL processes and reporting tools
  • Excellent technical, analytical, problem solving and communication skills
  • Excellent knowledge of SDLC and change management process
  • Excellent documentation and mentoring skills

Relevant Work Experience

Confidential, Jacksonville, Florida 06/04 - Present Sr. Oracle Database Administrator

  • Worked on installation of Oracle 11g/10g/9i/8i databases on AIX, WINDOWS and LINUX operating systems
  • Worked on management and maintenance of enterprise OLTP and OLAP databases
  • Worked on data ware housing databases required for ETL processes and reporting tools
  • Worked on instance, objects, server, network and I/O tuning
  • Worked on tuning the database environments using Automatic Workload Repository (AWR) reports, STATSPACK reports, OEM, Active Session History (ASH) reports, Automatic Diagnostic Database Monitor (ADDM) reports
  • Worked on performance tuning of sqls using Explain Plan, Tkprof, STATSPACK, AWR, SQLTrace and ADDM utilities
  • Performed daily health checks using OEM and manual methods
  • Used Oracle Enterprise Manager 11.2 on Oracle 11g and Oracle Enterprise Manager 10g R5 Grid Control on 10g to administer manage and maintain Oracle database environments
  • Worked on database design, capacity planning and performance monitoring
  • Worked on Upgrading databases from 9i to 10g and 10g to 11g
  • Worked on Migrating data from 9i to 10g databases
  • Installed and configured Oracle 10g/11g RAC high availability
  • Worked on implementing Disaster Recovery Plan for Oracle databases
  • Implemented DATAGUARD for high availability/disaster recovery purpose
  • Knowledge of Golden Gate
  • Worked on database backups and cloning
  • Used RMAN for full and incremental backups
  • Worked on using Flashback technology to return database objects to a previous state
  • Experience with Automatic Storage Management (ASM)
  • Worked on Configuration and maintenance of OLTP databases
  • Worked on monitoring spaces and extents, cache System Global Area (SGA)
  • Worked on Oracle Virtual Directory
  • Performed systems administration activities including monitoring operating system’s resources usage on Unix
  • Worked on troubleshooting infrastructure problems including those related to SAN
  • Worked on identification of performance bottlenecks on high volume transaction systems
  • Daily tasks scheduling using control-m and crontab utilities
  • Used SQL*Loader for migration and loading of data into oracle database
  • Provided support to fine tune applications followed by performance testing of the applications and worked on improving application performance by adding indexes and tuning the queries that cannot be modified
  • Worked on UDB DB2 LUW administration
  • Worked on SQL server Administration
  • Knowledge of PL/SQL programming
  • Worked on shell, batch and Perl scripting
  • Excellent knowledge of Oracle processes dependency on AIX & Windows OS
  • Involved in UNIX & Windows administration
  • Involved in monitoring AIX systems using BMC & Mercury BMC

Lead Systems Administrator

  • Worked on Siebel 6.x/7.x/8.x Server installation, configuration and administration, Siebel Application Administration, Siebel upgrade, WMQI/WBI Administration, MQ Administration, NetegritySiteminder Administration, Siebel Administration on AIX, Windows and LINUX
  • Worked on OBIEE/Siebel analytics installation, administration and development
  • Worked on Hyperioninstallation and administration
  • Experience on Oracle Application Server administration involving Weblogic server

Environment: Oracle 9i/10g/11g, RAC, Oracle Enterprise Manager 11.2, Oracle Enterprise Manager Grid Control 10.2.0.5.0, RMAN, AIX 6.1/5.3/5.2, WINDOWS 2000/2003, LINUX4, DB2 UDB 8.1.6, SQL Server 2005/2008, Shareplex, RMAN, Datapump, TOAD, SQL*Loader, TKPROF, RDA, AWR, STATSPACK, SRDF, BCV, Autosys, SQL BackTrack, VeritasNetBackup, Tivoli Storage Manager, ASM, Dataguard , Siebel7.5.x/7.7.x/7.8.x/8.x, LINUX4, DB2 UDB 8.1.6, Windows 2000/2003, LINUX4, IIS Web Servers, Actuate Reports, NetegritySiteminder, PMI policy Servers, Resonate, Foglight, Trillium, Spotlight, WMQI V2.1, WBI V5, WMB V6, MQ V 5.3 Infrastructure, True Comp, Informatica 7.1.1, Candle EBP, Stellent, Google Searches, Siebel Analytics 7.x, OBIEE 10.1.3.4, Hyperion 9.x/11.x, Oracle ASpplication Server, Weblogic, SQL Server 2005/2008

Confidential, San Mateo, CA 08/03 - 05/04 Siebel Database Administrator

  • Worked on siebel 7.5 and 7.7 installations and configurations
  • Provided support to the development, test & production environments
  • Installed Siebel tables on Oracle Database
  • Configured, managed and maintained Oracle database for siebel
  • Performed Oracle database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs in cron, creation of users, schemas, backup and recovery, tablespace and extent management
  • Worked on performance tuning of sqls using Explain Plan, Tkprof, STATSPACK, AWR, SQL*Trace and ADDM utilities
  • Worked on tuning siebel database for best performance
  • Worked on installation of siebel client & tools
  • Worked on siebel remote
  • Provided 24/7 on call support in rotation
  • Worked on Actuate server installation & configuration
  • Worked on resonate load balancing
  • Worked on web server load balancing
  • Worked on shell, batch and Perl scripting
  • Excellent knowledge of Oracle processes dependency on AIX & Windows OS
  • Involved in UNIX & Windows administration

Environment: Siebel 7.5.x/7.7.x, Windows NT/2000, AIX 4.3, Oracle 8i/9i, RMAN, IIS 5.0

Confidential, San Mateo, CA 04/02 - 08/03 Systems/Database Administrator

  • Worked on installations of siebel GW, application, db servers & swse for 7.0.4/7.5.x
  • Worked on configurations & maintenance of siebel 6.0.2, 7.0.4, 7.5.x
  • Installed new siebel builds and patches 7.5.x
  • Worked on the upgrade of siebel from 6.0.2 to 7.0.4
  • Installation, management and maintenance of Siebel tables on UDB DB2 database
  • Installation, management and maintenance of Siebel tables on Oracle database
  • Worked on installation of siebel client & tools
  • Worked on siebel remote
  • Worked on setting up siebelfile system on samba share
  • Worked on Actuate server installation & configuration
  • Worked on resonate load balancing
  • Worked on shell scripting
  • Worked on shell, batch and Perl scripting
  • Excellent knowledge of Oracle processes dependency on AIX & Windows OS
  • Involved in UNIX & Windows administration

Environment: Siebel 6.0.2/7.0.4/7.5.x, Windows NT/2000, AIX 4.3, DB2 UDB 7.2, Oracle 8i/9i, IIS 4.0, Actuate 5

Technical Skills

Data Bases: Oracle 11g/10g/9i/8i, DB2 UDB 8.1.6/7.2, SQL Server, Oracle, MS Access CRM Technology: Siebel 6.x/7.x/8.x CRM Third Party Tools: Resonate, Foglight, Trillium, Spotlight, Actuate Reports, SiteminderNetegrity, LDAP, Cisco CTI MQ Family: WMQI V2.1, WBI V5, WMB V6, MQ V 5.3 Infrastructure Programming Languages: C, PASCAL, COBOL, my SQL Web Technologies: HTML, JSP, XML, Client/Server Programming Version Control: PVCS Tracker, Clear Case Front-End Tools: Microsoft Front Page, Visual Interdev, Dream weaver Engineering Tools: Auto CAD, MATLAB, SAS Graphics: Computer Graphics/CAD Operating Systems: Windows 95/98/NT/2000/2003/XP, UNIX/AIX/LINUX

Education Bachelor of Technology in Engineering

References Available upon request

Hire Now