Data Systems Administrator Iii Resume
New, BremeN
SUMMARY
- me am the consummate Oracle Professional, having entered the field as a Developer, led a team as Designer, mastered the Application Server and Middleware as well as the role of DBA (Database Administrator).
- me has saved two failed or failing implementations of Oracle installations.
- me has worked from scratch in several start - up companies, creating stable and scalable database environments on short notice.
TECHNICAL SKILLS
- Oracle database version 7.2 through 12c
- including VLDB (Very Large Databases - up to 32TB)
- SOA Suite
- Fusion Middleware
- Oracle Service Bus & Oracle Weblogic
- TOAD
- Oracle Enterprise Manager
- SQL Navigator and SQL*Plus
- Linux
- Unix
- and Windows Server
- PL/SQL
- SQL*Loader
- Pro*C.
PROFESSIONAL EXPERIENCE
Confidential - New Bremen
Data Systems Administrator III
Responsibilities:
- Provide guidance to SQL Server DBAs in charge of 4 instance Oracle DB
- Diagnose & Resolve business issues revolving around all-encompassing corporate-wide application
- Trouble-shoot Infrastructure technical issues regarding application & databases
- Provide technical & business knowledge to restructuring server infrastructure for corporate-wide application
Confidential
Senior Oracle Database Administrator
Responsibilities:
- Underwent extensive security clearance before hiring was finalized
- Primary DBA for Sample data collected towards shutdown of weapons grade uranium enrichment facility
- Managed several Oracle databases at security-sensitive site
- Ensured 24/7 operations & up-time to meet DOE Standards
- Migrated 4 databases from 11g to 12c
- Migrated Weblogic/Forms&Reports servers from 10g to 11g
Confidential
Oracle Database Administrator
Responsibilities:
- Primary DBA for both Water Works & Metropolitan Sewer District
- Managed both MS SQL Server & Oracle Databases
- Migrated Oracle 11gR2 databases to 12c
- Managed & Migrated Oracle Weblogic from 10g to 11g
- Project Management support for the planning of the Middleware system upgrade.
- Ensuring scalability and cause/TEMPeffect diagrams.
- Responsible for working across multiple teams and organizes for successful launch.
- Environment included six main Oracle databases handling Customer Service, Finances, PeopleSoft, Maximo, etc. and twenty-seven SQL Server instances handing various smaller units of data collection.
Confidential, Kevil, KY
Senior Oracle Database Administrator
Responsibilities:
- Worked remotely, on-the-road after being urgently hired while on vacation
- Came into project with no background and within 12 hours had achieved greater movement with data evaluation than previous DBA in three weeks, according to client.
- Over four week period discovered, evaluated, imported, assessed, rejected, and recycled gigabytes of secured data regarding plant maintenance for a National Nuclear Diffusion plant. Working with my system admin we scrubbed the data, requested new working exports, matched data to applications.
- Managed & Migrated from legacy systems to Oracle Database & Weblogic Middleware.
- Successfully brought majority of applications and data online with no prior knowledge of any scope of the systems as they existed prior to our being handed them.
Confidential
Senior Oracle Database Administrator
Responsibilities:
- Perform database monitoring and tuning to ensure databases run at peak performance;
- Troubleshooting performance issues for databases and with Applications Team.
- Use Oracle Grid Control to monitor & trouble-shoot all databases
- Installs, configures, trouble-shoot, Upgrade, Security Patch Oracle Database products.
- Document entire Oracle Environment, which had not been done in 8 years of existence
- Provide expertise to all aspects of application development in-house and with 3rd party vendors
- Responsible for Disaster Recovery Planning & Execution
- Managed & executed migration of middleware to the Oracle Weblogic Server.
- Responsible for Incremental, Daily & Weekly RMAN Backups and Restoration Testing
Confidential
Independent Oracle Administrator
Responsibilities:
- Project Management support throughout project.
- Provided L3 on-project Senior Production DBA support for Oracle VLDBs hosting critical aircraft engine monitoring applications
- Advised client staff in efforts of performance tuning.
- Worked in established client protocol for implementing tweaks to reduce bottlenecks, streamline coding efforts & establish Oracle Best Practices in performance
- Guided DEV Layer in best practices for VLDB
- Managed Middleware layer of Oracle Weblogic Server
- Utilized Oracle Enterprise Manager Grid Control 11g for monitoring & manipulation of VLDBs
- Utilized Precise/I3 for monitoring of VLDBs
Confidential
Senior Oracle Production DBA
Responsibilities:
- Managed VLDB (32TB & 2.5TB) Database for Client
- Filled role of Senior Production DBA experienced with RAC & clustered environments for Client
- Worked closely with client staff to determine & fill needs in project resources for management of VLDB databases relative to upgrades of applications and databases
- Guided DEV Layer in best practices for VLDB
- Set-up & Utilized Monitoring tools on VLDB Database, including Oracle Cloud 12c
- Worked with Storage Support Layer in troubleshooting RMAN backups to faster hardware
- Worked with Server Support Layer to implement SUN Cluster for new Oracle hardware
Confidential
Senior Oracle DBA
Responsibilities:
- Install, upgrade and maintain Oracle Databases supporting system-wide applications and related products for educational client in Cincinnati.
- Work closely with client staff to identify their technical needs.
- Technical responsibilities include installation and configuration of Oracle database and application servers, backup and recovery planning and implementation and troubleshooting, patching and upgrading.
- Supported development, training and production environments from installation through go-live and beyond
- Set-up & Utilized Monitoring tools on Established Database & Application Servers
Confidential
Oracle DBA
Responsibilities:
- Oracle & SQL Server DBA for all in-house database systems
- Creation, installation, configuration, support & management of Oracle 11g for JDEdwards, Demantra & Hyperion on Windows 2008
- Supported Oracle 9i/PeopleSoft database systems on Sun Solaris
- Provided management & backup for SQL Server databases
- Provided expert Oracle support for all levels of corporate customers
- Troubleshoot, tune, install, upgrade and maintain all Oracle 9i/10g/11g databases
- Provided for Backups, backup integrity and stability during physical migration of all database servers
- Managed database user accounts, space management, schema modifications and performance monitoring and tuning.
- Tools used: OEM, TOAD, HP Data Protector.
Confidential
Oracle DBA
Responsibilities:
- Guided the introduction of their coding and ensured all parties involved in the process were organized and prepared.
- Primary Oracle DBA for two disparate Application teams and their databases
- Provided expert Oracle support for all levels of corporate databases for my application teams
- Troubleshoot, tune, install, upgrade and maintain 30+ Oracle 9i/10gR2 databases
- Provided for Backups, backup integrity and stability during physical migration of all database servers
- Managed database user accounts, space management, schema modifications and performance monitoring and tuning.
- Setup UC4 jobs & shell scripts to automate tradition daily or weekly responsibilities of DBA
Confidential
Oracle SOA, Application Server & FUSION Administrator
Responsibilities:
- Established the roles of Oracle SOA, Application Server & Middleware Administrator where their had been none. Consolidated all responsibilities for the various tiers and components
- Has worked with disparate Development Teams to open up targeted SRs with Oracle Support, gaining all the teams reliability and access to their BPEL and ESB Consoles, regaining lost productivity
- Resolved Performance Issues surrounding both BPEL and ESB containers which were causing JVM crashes and Application Server lock up.
- Resolved issues regarding ESB Manual Recovery not working properly through troubleshooting
- Installed Collaboration Suite, migrating data from ContentDB into Content Server component
- Recovered corrupt Metadata Repository utilizing irca utility
Confidential
Oracle Development DBA
Responsibilities:
- Automated Application Deployments through Grid Control
- Maintained Development Environment, Monitor and adjust disk & tablespace usage, Identify run away sessions, Kill processes caused by locks
- Install, patch & secure Database & Application Server in RedHat Linux environment
- Trouble-shoot Application Issues with Development Teams
- Coordinate Releases with Development Teams and End-Users
- Install, configure & manage RMAN (Recovery Manager)
Confidential
Oracle DBA
Responsibilities:
- Hired to replace two individuals in charge of Oracle database & PL/SQL programming
- Stabilized Oracle TEXT Database prone to bi-weekly failures
- Implemented an Oracle RAC environment for High Availability
- Established RMAN process to backup database
- Collaborated with Lead Developer in troubleshooting Oracle TEXT Indexing Issues effects of same on application performance
- Worked with Lead Developer in re-engineering Application
- Re-designed Database to better query TEXT for application
Confidential
Senior Oracle Application Server (FUSION) Administrator/DBA
Responsibilities:
- Hired on contract to do development work.
- Requested to take over 9iAS Admin duties 3 days into contract due to upgrade project failing at the hands of the 2 Administrators, who had been fired. Immediately stabilized new 9iAS environment (13 9iAS servers)
- Successful completion of move to 9iAS, tuned servers as well as trouble-shot issues with connectivity (dropped sessions) with positive results.
- Troubleshooting Forms & Reports issues for Industry-leading Application (RxHome) residing on 9iAS servers. Utilized TOAD for querying & maintenance of Metadata Repository
- Provided Oracle 9iAS Standalone servers & 10g AS Clustered Servers for various JAVA applications, conducting deployments through Enterprise Manager as well as command line.
- Provided Accredo with gains in user productivity, allowing realization of 10 million dollars savings in labor hours over the past year.
- Installed, maintained, tuned Metadata Repositories as well as provided for Secure Backup utilizing Oracle RMAN (Recovery Manager) on various tiers.
- Worked with DBAs to implement RAC across database & mid-tier environments for High Availability
- Moved Workflow & InterConnect products onto newer versions of Oracle Application Server 10g (904/10.1.2x) for increased stability and integration.
