Oracle Dba Resume
5.00/5 (Submit Your Rating)
SUMMARY
- Over 38 years in computer technology supporting a wide variety of applications databases and servers in both team and consulting positions
- Teh last 15 years I has been working on all flavors of UNIX, supporting upgrades and troubleshooting issues with users
- Worked at Oracle Corporation for 2 years during teh Y2K time period troubleshooting oracle on all Unix platforms
- I has been instructed in Unix on many flavors and has many certifications and has a sun solaris box running solaris at home
PROFESSIONAL EXPERIENCE
Oracle DBA
Confidential
Responsibilities:
- Employee working for Company Confidential as Teh lead Netezza DBA/Oracle DBA.
- Use AWR and sql scripts to monitor Oracle 11g activity
- Use iostat, vmstat to monitor unix box for activity.
- Do code reviews on sql scripts for both Oracle and Netezza.
- Assist with AIX / Linux admin tasks adding RPM’s setting up Tivoli backups. Setup ldap, Space monitoring and cleanup.
- Maintain Large Oracle databases teh Production data warehouse is over 200TB running version 11g currently being upgraded to 12c
- Maintain Netezza databases totaling 7 servers for development and production totaling 150TB
- Maintain Netezza portal and maintenance scripts upgrade databases add users and groups perform upgrades.
- Write sql and Unix scripts
- Work with IBM to setup servers in Data Center, add users and groups as well as databases,
- Setup fluid query to connect to cloudera and hive server.
- Assist in Oracle upgrade from 11g to 12c and test, test, test
Oracle / Sql DBA
Confidential
Responsibilities:
- Consultant as a Unix/Oracle DBA for Frontier Communications
- Update teh Menu for pay per view programs viewed on TV
- Attended Course on Microsoft server 2008 R - 2
- Write Unix shell scripts to automate tasks
- Maintain Oracle databases for production using OEM and command line
Unix/Admin -Oracle DBA
Confidential
Responsibilities:
- Consultant as an Oracle DBA for Humana Health Care in Louisville KY.
- Troubleshoot programs running on UNIX using iostat, vmstat and topas commands.
- Assist with change control issues on Oracle Databases.
- Maintain multiple Oracle instances, one over 180 terabytes in size.
- Head project for setup and testing of orsyp $universe on Aix
- Run Sql scripts and validate sql scripts for users
- Write sql scripts to query data and for database administration
- Copy tables and data from one database to another using fastreader, datapump and dblink.
System Administrator/ Oracle DBA/ Web Developer
Confidential
Responsibilities:
- Consultant as a Unix/Windows administrator for Frontier Communications during teh sale of teh 13 states to Frontier from Verizon,
- Administered multiple Unix servers running HPUX, AIX and Solaris in clustered environments.
- Maintain Microsoft servers for multiple applications
- Administered web servers including websphere, IIS, iplanet, tomcat apache, http, sun one.
- Maintain and troubleshoot issues on Oracle and sql server databases.
- Verify oracle rman for production backups.
- RAC (Real Application Cluster) configuration management
- Troubleshoot issues with users on different platforms and applications
- Trouble shoot and Replaced hardware items after failure
- Code and maintain programs written in c, java, html, .net and others to reflect frontiers new parameters and requirements
- Maintain and administer HP data protector backups and restores software
- Administer access7 phone system and telcordia feeds
Lawson Administrator
Confidential
Responsibilities:
- Lawson financial administrator for Norton healthcares 6 hospitals
- Administer and maintain teh Lawson modules, HR Payroll, General Ledger, just to name a few as all modules were used, in a clustered environment.
- Wrote custom programs and maintained web portal and websphere servers
- Trouble shoot issues with Lawson users,
- Pulled custom data from Lawson as requested wrote custom processflows using processflow integrator.
- Maintained and applied patches to supply chain, LBI, Employee and Manager self service modules
Research Analyst / Lawson-Unix-Oracle administrator
Responsibilities:
- Unix / Lawson administrator for Teh School district of Hillsborough. Assisting with teh Lawson and aix issues.
- Trouble shoot Lawson and Aix issues on Production and development for both Financials and HR. in a clustered environment.
- Write UNIX shell scripts to aid in production and development issues.
- Troubleshoot Lawson apache websphere portal issues
- Upgrade teh IBM Aix boxes running Unix as well as install patches and fixes.
- Created an implemented a disaster recovery plan for teh Lawson financial system and Tivoli backup server.
- Mange new projects and setup aix lpars for teh new projects and applications.
- Setup and configure redhat linux
- Configure Aix servers to connect to Shark San storage server.
- Setup and adapt Apache web server and Tomcat to meet teh Districts Lawson web needs.
- Troubleshoot and maintain Tivoli backups.
- Also assist teh db2 dba with scripting and monitoring db2 activity on IBM mainframe and Unix boxes.
- Assist with custom form development and implementation. Add new bookmarks and help with security class on Lawson .
- Troubleshoot connection and data issues with db2 on teh mainframe running z/os.
- Upgrade and maintain BSI's Tax Factory, both versions 7.0 to 8.0
- Write change control scripts for Lawson production.
- Maintain teh aix 5.3 servers. Upgrade microcode on pseries and HMC,
- Backup and configure teh HMC.
- Setup nfs on Aix servers, create scripts to email users of issues using sendmail,
- Maintain school library system on sun solaris
- Maintain and install httpd server on aix
Lawson Administrator
Responsibilities:
- Apply patches troubleshooting user issues.
- Installed Lawson modules and discuss projects implementation.
- Installing MSPS and CTPS, add users, updated security classes and troubleshooting printer issues.
- Maintain Oracle 9.2 databases applied oracle patches and maintained HPUX boxes running hp 11.0.
- Configure and Maintained Lawson portal, Apache and Tomcat and RMI. As well as troubleshoot issues.
- Wrote Korn shell scripts and fixed programming errors.
- Followed change management procedures.
- Setup NFS mount points on local and remote UNIX servers.
- Use SQL to manipulate data in tables.
- Setup and Maintained Hyperion Essbase server.
Unix / Lawson Consultant
Responsibilities:
- Assisting with teh Lawson 8.0.2 project. To include installing Lawson CTPS also supporting teh AIX 4.3.3 to 5.0.1 upgrade of teh UNIX AIX servers.
- Troubleshoot EDI issues connecting to office depot through Sterling.
- Also upgrade Tivoli storage manager from 4.2 to 5.1 on server and clients.
- Write Korn shell scripts to aid in production and development issues.
- Performed security checks and troubleshot Lawson portal issues.