Oracle Consultant Resume Profile
3.00/5 (Submit Your Rating)
Houston, TX
Summary
Accomplished Database Administrator DBA with extensive experience in managing databases on multiple platforms in a variety of industries including energy, banking, engineering.
Professional Experience
Confidential
Oracle Consultant
- Managed Oracle 10g, 11g databases for airport operations. These Oracle databases reside in HP/UX, Sun Solaris, Windows Linux servers. Duties include 24x7 on-call production support, DB refresh, upgrade and patch.
- Wrote a Unix/SQL script to roll off older data, rebuild indexes collect statistics from data warehouse databases. This script runs un-obtrusively every month to reclaim disk space.
- Trained other DBAs on various tasks, e.g., troubleshoot, refresh, upgrade, promotions, scripting, etc..
- Constantly looking for ways to do things better, simpler, or take manual tasks out of the equation.
- Assisted in resolving problems due to network and server outages. Oncall 24x7.
- DB Management tools used - OEM 12c Cloud control, Toad, SQL Developer, etc..
Confidential
Sr. Oracle DBA
- Manage Oracle Databases 10g, 11g DBs for all areas in the organization. Duties include 24x7 on-call production support.
- OEM 12c Cloud Control Quest Toad were used for monitoring, job scheduling, database SQL tuning. Tailor monitoring thresholds to send out warnings alerts. Set corrective actions to automatically fix problems.
- Install and pushed OEM 11g, 12c monitoring agents.
- Apply quarterly Oracle patches PSU CPU .
- Use RMAN extensively for backup, recovery refreshes. Employ Dataguard technology for resiliency.
- Install, manage maintain LDAP servers for Oracle connectivity. Migrated Oracle names service to LDAP service.
- Package/test Oracle Client applications before deploying to PCs.
- Participate in database disaster recovery tests by employing various technologies e.g. BCV, RMAN, SRDF, SNAP, flashback, etc. . Documented issues corrective actions in runbooks.
- Document work processes, user guides, disaster recovery procedures store in SharePoint for sharing with team members.
- Collaborate with application teams to tune SQL database for performance.
- Work with users to decommission databases schema whenever possible to recycle disk space.
- Exercise sound judgment best practices. Adhere to security, SOX, software promotion guidelines.
- Custodian of Payment Card PCI Personal ID Information PII databases.
- Strive for clear, precise communication verbal written . Maintain friendly respectable relationship with users internal customers.
- Offer help readily to team members. Provide assistance coverage during crunch times.
- Assisted in the recovery of power plants by offering expertise in Oracle connectivity, PCs, Workstations, servers, etc.
- Occasional management of MS SQLServer 2012, 2008, 2005. Generated reports in Visual Studio.
Confidential
Oracle Consultant
- Managed Oracle Databases 8i, 9i, 10g DBs for the enterprise. Duties included 24x7 oncall production support. OEM, Grid Control, AppWorx Toad were used daily for monitoring, job scheduling, database tuning SQL tuning.
- Participated in periodic disaster recovery tests. These involved simulation of down server at a city, switching to the DR server standby DB at another city. Documented issues corrective actions.
- Participated in penetration testing in which third party auditors tried to test the vulnerability of production DBs during business hours.
- Prepared SOX reports for periodic system security auditing. Strict security guidelines were implemented through database auditing, user profiles, user creation expiration.
- Decommissioned DBs schema to save memory space.
- Assisted in implementation of Interactive Voice Response IVR system for gas station ordering. Wrote Korn shell script. Worked with IVR Nortel network engineers to ensure all components worked seamlessly. Assisted with testing troubleshooting.
- Applied Oracle patches upgrades to tighten security ensured DBs are running optimally.
- Created DB for Energy Exchange Re-platform project. Assisted global clients to overcome issues with firewall, network, connectivity, etc.
- Assisted users in SQL tuning. Monitored index usage. Tuned databases.
Confidential
Lead DBA
- Managed student records, endowment, helpdesk financial DBs. The enterprise universe comprises close to 100 Oracle DBs, using PeopleSoft as front end. Installed managed PeopleSoft Application Servers, process schedulers, report server web servers. Duties included Oracle PeopleSoft version upgrade, patches, 24x7 production support.
- Managed Oracle 10g OEM for monitoring servers, databases. DBAs are alerted by early signs so corrective action can be taken.
- Created RMAN repository for recovery management.
- Programmed extensively in PL/SQL Unix shell scripts for backup, recovery security maintenance. Automated refreshes of DBs by authoring RMAN duplication scripts.
- Migrated all Oracle DBs to 10g on new Sun clusters SAN. RMAN was used extensively for migration, duplication, data refresh, creation of standby DB, backup recovery.
Confidential
Senior Database Administrator
- Custodian of a Jumbo Syndicated Loans database that had a 170 Trillion portfolio. 50B changed hands every month. This application was used by loan managers to originate loans, syndicate loan partners, wire money, document loan payment, etc.. This DB was replicated Oracle Advanced Replication to 2 other servers to provide 24x7 availability. Assisted in migrating this DB to new Unix hardware using Dataguard/Standby technology.
- Participated in periodic DR tests of critical applications by switching over to standby databases.
- Participated in periodic DB auditing by gathering data generating audit reports.
- Oracle DBA. Managed an environment that comprises more than 50 DB instances. OEM is utilized to ease monitoring tuning. Used Recovery Manager RMAN for backup, recovery, DB refresh, migration duplication.
- Sybase DBA. Managed ATM, Commercial Loan, Home Mortgage DBs. Assisted in migrating these DBs to Oracle.
- MS SQL Server DBA. Managed various commercial loan, accounts payable, credit approval DBs.
- MS Access DB design programming.
- Implemented new standards in Oracle Connectivity Oracle Names Server, LDAP User Security PL/SQL scripts .
- Developed a system in Visual Basic to scan, store check images for commercial loan payments. Two contractors had given up before I was hired to diagnose the logic to get the system working. Data was stored in Oracle uploaded to mainframe nightly.
Confidential
Database Consultant
- Customer Support in resolving administrative issues of monitoring Sybase, Oracle, MS SQL Server, UNIX Windows servers using BMC Patrol.
Confidential
Project Manager
- DBA. Administered environment that consists of MS SQL Server, Sybase DB Server, DB Gateway, Infopump ETL, SNA Server, Windows NT Server, UNIX/AIX server. Duties included managing user access, server planning management, installation of software drivers, application software integration implementation, DB monitoring tuning
- Developed the EDI Strategic System in VB Sybase for claims filing by medical providers.
- Developed SAS Applications on IBM mainframe to extract process Medicaid claims provider data. Automated data transferred between the government agencies, data service companies, Prudential. Employed various data transport mechanisms such as bulletin board, mainframe NDM, FTP, etc.
- Managed Financial Databases for both Managed Care Indemnity products. Developed applications for transaction processing generation of financial reports.
- Implemented a sales commission system.
- Administered the Group Provider System DB. Data were synchronized between DB2 Sybase.
Confidential
Senior Systems Analyst
- Placed first in company's Quality Award for diagnosing fixing problems in the Payroll System. The system had not printed paychecks for >2 pay periods before I was hired to fix it. Platform: COBOL, Oracle, TSO/ISPF, IBM Mainframe.
- Maintained enhanced the Assignment Tracking System used by management to track projects forecast man-power needs. Platform: FORTRAN, RDB.
- Maintained enhanced the Phone/Directory System used widely for on-line search of employee phone numbers office location. System also generated building space planning reports paper phone books.
- Maintained integrity confidentiality of company's mission-critical financial DBs Personnel, Payroll, Organization, Project, Assignment . Generated Oracle reports for managers, usually on short notice.
Confidential
Senior Systems Analyst
- Designed the Integrated Business System for requisitioning, purchasing inventory of material services, which eliminated overstocking resulting in savings of > 1 billion a year. Used CASE tools in all phases of software design development. Prototyped business reports, graphical user interface logic. Gathered documented business requirements, data validation logic. Created data models, data flow diagrams.
- Programmed financial reports with business graphics for all management levels.
- Developed GKS graphics primitives in C language for the Parallax Graphics workstation. Migrated existing geophysical software from Integraph to Parallax enabling scrollable 3-D seismic display.
- Led a software team, designed implemented seismic signal processing programs. Worked closely with engineers to determine requirements tuned DB designed test procedures.
- Part of a research team that invented Bright Spot Analysis leading to discovering natural gas oil deposits offshore.
- Published a signal processing algorithm to apply KF-filter to enhance marine seismic multiple signal. Wrote a Fortran program to implement this algorithm which became a precursory step in marine seismic processing.
- Certified well log analyst.