Senior Oracle/application Dba Resume
Seattle, WA
SUMMARY:
- Over 16 years of experience as an Oracle Data Base Administrator (DBA) in manufacturing and public sectors. Provided full life cycle support to bring applications into production, from development through testingInstalled, configured, and implemented Oracle 9 Application Server (9iAS) and Oracle 10g Application Server (10gAS), including Oracle 9iAS and Oracle 10gAS Http Server. Managed Oracle 9iASand Oracle 10gAS containers and Apache Web Servers. Upgraded and maintained databases utilizing Oracle Financials
- Provided the highest level of end - user satisfaction at Weyerhaeuser paper Co. and at Confidential by demonstrating excellent communication skills
- Designed, implemented, and administered databases in multiple instances (of Oracle 7, Oracle 8, Oracle 8i, Oracle 9i and Oracle 10g) spanning several physical environments and operating systems (HP, SUN Solaris, Windows). The administration activities included backup and recovery using RMAN, statpack, and OEM
- Managed a team of six DBAs and two consultants
TECHNICAL SKILLS:
Databases: Oracle 7, 8, 8i, 9i, and 10g
Hardware: Apple, PC, HP, Sun, and MicroVAX
Operating Systems: NT 4.0, Windows 2000 & 2003, UNIX (Sun Solaris, and HP - UX
Oracle Tools: SQL*Plus, PL/SQL, Pro*C, Developer 2000, 11i Apps, 9iAS, Oracle Forms, OEM, RMAN, SQL* Loader
Quest Tools: Erwin
PROFESSIONAL EXPERIENCE:
Confidential - Seattle, WA
Senior Oracle/Application DBA
Responsibilities:
- Maintaining, deploying and tuning applications for US Govt. Departments of DHS and TSA. (Oracle Financials and J2EE). Responsibilities include: administration, performance tuning and availability of mission critical production databases (24/7); application of patches and custom code development, testing, UAT and brining it to production.
- Supported in maintaining third party applications like Dun & Bradstreet, Plateau
- Deployed new web applications into system integration and into production after their testing. Managed troubleshooting of all production issues and recommended enhancements to the applications. Tested and implemented several security patches on the databases upgrades (Oracle Financials and Application Servers).
- Performed cold and hot backups and recovery using RMAN. Performed import and export using Data Pump.
- Monitor database using Grid Control and maintaining standby databases.
- Working and troubleshooting with Oracle 10gAs components.
Confidential
Senior Oracle DBA
Responsibilities:
- Led the company's transition to Oracle10g by establishing the environments for development, testing and production. This effort included: server and client software installations, software upgrades, developer and end-user, backup and recovery procedures, instance and application tuning, database security, and migration scripts
- Provided functionality outside of the core development effort by utilizing special software like SIEBEL and TREMA
- Developed procedures to load data from several main frame systems into Oracle, using PL/SQL, other database packages, SQL*Loader and UNIX shell scripts
- Significantly improved the performance of databases through development and execution of scripts. Before tuning queries took 5 to 8 minutes to return the results. After tuning, they took few seconds to get the results
Confidential - Culver City, CA
Oracle DBA
Responsibilities:
- Planned and coordinated the upgrade of databases from Oracle 8 to Oracle 9i including development, testing and system integration
- Performed data uploads to upgraded applications; monitored resource usage; collected and reported operational metrics; and implemented Data Guard feature for standby databases
Confidential - Reston, VA
DBA Team Lead
Responsibilities:
- Being the primary DBA for Oracle Financials, led a team of 8 DBAs and responsible for maintaining, deploying and tuning applications for US Govt. Departments of DHS and TSA. (Oracle Financials and J2EE). Responsibilities included: administration, performance tuning and availability of mission critical production databases (24 hour, 7 days/week); application of patches and custom code development, testing, UAT and brining it to production
- Deployed new web applications into system integration and into production after their testing. Managed troubleshooting of all production issues and recommended enhancements to the applications. Tested and implemented several security patches on the databases upgrades (Oracle Financials and Oracle 9iAS Application Servers)
- Installed and maintained a three node cluster RAC database
- Performed cold and hot backups and recovery using RMAN
- Mentored DBAs in resolving a variety of DBA issues including troubleshooting of applications
Confidential - Reston, VA
Technical Manager, Production DBA (Oracle)
Responsibilities:
- Supervised the Reston Production DBA group that provided technical expertise to customers on production databases
- Administered database functions, including user account creations, user account deletions, control access and resources, data management and restoration, backups, and connectivity to databases. Coordinated after-hours user support and the on-call schedule for the technical services support team.
- Responsible for performance monitoring and tuning of applications.
- Managed all the system administrative functions including software configurations and installation, security management and disk space management.
- Conducted courses for developers with new features of Oracle 8i, including performance tuning topics.
Confidential - Reston, VA
Technical Manager, Production DBA (Oracle)
Responsibilities:
- Supervised the Reston Production DBA group that provided technical expertise to customers on production databases
- Administered database functions, including user account creations, user account deletions, control access and resources, data management and restoration, backups, and connectivity to databases. Coordinated after - hours user support and the on-call schedule for the technical services support team
- Responsible for performance monitoring and tuning of applications
- Managed all the system administrative functions including software configurations and installation, security management and disk space management.
- Conducted courses for developers with new features of Oracle 8i, including performance tuning topics