Oracle Dba Resume
2.00/5 (Submit Your Rating)
Charlotte, NC
SUMMARY:
- Displays a high level of energy, integrity and ethics with the exceptional ability to deliver outstanding bottom line results with short deadlines.
- Extensive experience in Oracle Database Administration.
- Experience in Oracle 8i,9i, 10g, 11g and 12c.
- Good understanding of Oracle 12c new features.
- Experienced in Oracle Data Guard and Oracle Real Application Clusters (RAC), CRS and ASM
- Expert Oracle Enterprise Manager 12c and 13c.
PROFESSIONAL EXPERIENCE:
Confidential, Charlotte, NC
Oracle DBA
- Install and Configured Oracle 10g/11g software on Linux.
- Upgrade several databases from Oracle 10.2.0.1 to 10.2.0.4 to 11.2.0.1
- Apply Oracle Critical Patch Update (CPU) patches on our databases every quarter.
- Installed Oracle 10g and 11g on Sun Solaris 10, Linux (Oracle Enterprise Linux 4 & 5, Redhat 5) and Windows, applied patches; upgrade Oracle server and application tools, maintained the software at the latest stable release level and tested and verified the installed components.
- Use RMAN duplicate command to clone/refresh development database from production.
- Perform database design tasks such as enforcing referential integrity standards; create database tables and table dependencies such as indexes, stored procedures, functions, packages, triggers, views, materialized views etc.
- Knowledge of RAC setup and Experience in RAC environment mostly Oracle 11g.
- Create and managing the ASM databases.
- Create databases and documents procedure to migrate and refresh databases between the development and production environments.
- Use Oracle Transparent Data Encryption to encrypt tables and Tablespaces that contains PII data.
- Use RMAN to perform database recoveries and migration when necessary.
- Use Oracle flashback technology to restore databases and tables as needed.
- Performed various DBA Maintenance task such as rebuilding indexes, validating constraints, reorganizing tables using the move command.
- Setup technical procedures and administrative policies for production, test and development databases physical design, administration, maintenance, tuning, backup and recovery. Allocated system storage and plan future storage requirements for the database systems.
Confidential, Chicago, IL
Oracle Database Administrator
- Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles, etc.
- Automated hot backups using a combination of incremental, differential and full RMAN backups.
- Tracing, troubleshooting with database performance and tuning issues.
- Export/Import of oracle databases
- Tuning SQL queries
- Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
- Analyzing and validating database objects.
- Coordinating with team members.
- On call support 24x7
TECHNICAL SKILLS
Oracle: 12c/ 11g/10g installation, OEM 12c/13c expert, Database Creation, Patch Set Update, Critical Patch Update. Upgrade 8i,9i,10g,11g to 12c, Oracle Enterprise Manager, Toad, SQL*Loader and Autosys
OS: Exadata, Linux RedHat, Microsoft, Windows Server 2003/2008/2012, HP - UX, AIX, Solaris