Oracle Dba Resume
2.00/5 (Submit Your Rating)
Austin, TX
SUMMARY:
- Over 5 years of IT experience working as Oracle Database Administrator on Linux, Solaris, AIX, Windows platform.
- Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU)
- Extensive experience in implementation, maintenance, installation, administration of Oracle databases 12/11g/10g across various operating systems including UNIX, Sun Solaris, AIX and Windows
- Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views
- Experience in troubleshooting, system analysis, data modeling, logical and physical database design and installation, and performance analysis and optimization.
- Data loading using Logical backups using DATAPUMP
- Upgrading databases to higher versions, applying patches and patch sets Strong experience in Backup and Recovery strategies using RMAN, creating RMAN scripts, Export/Import, Data Pump, Hot and Cold backups
- Move databases from one location to another successfully.
- Participated in on - call (off hours) schedule in providing technical support.
- Experience with SQL, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic
- Experience with Microsoft SQL server 2008/2012/2014
- Experience with AWS and Microsoft Azure
- Extensive Knowledge of PostgreSQL
- Heavy understanding of PL/SQL, SQL, and PostgreSQL
PROFESSIONAL EXPERIENCE:
Confidential, Austin, TX
Oracle DBA
Responsibilities:
- Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future
- Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
- Working with Oracle Support on critical database issues.
- Databases refresh from PROD to DEV environment for application testing and upgrades.
- Worked on Data Guard for advance replication and high availability.
- Monitors and manages databases access, storage and utilization using Grid Control.
- Responsible for restoring and recovering database as required for Oracle.
- Worked on Complete and In-Complete Recovery of production Databases of varying sizes using RMAN copy, RMAN backup sets.
- Used shell scripting for automation of job scripts, for startup and shutdown, Health check of databases, Analyzing of Tables and Rebuilding of Indexes.
- Proactively monitored the database and database access, and maintained the database security.
- Extensively worked under UNIX environment to provide DBA support.
Environment: Oracle 10g RAC, ASM, AIX, Linux, Solaris, Windows, RMAN, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, Data Guard, SQL*LOADER, Oracle OEM, Import/Export Data Pump, STATSPACK, AWS, MICROSOFT AZURE, POSGRESQL
Confidential, Chicago, IL
Oracle DBA
Responsibilities:
- Administer Oracle 10g & 11g databases on Linux Platform.
- Manage ASM and Oracle RAC services.
- Managing nodes and rebuild node following hardware crashes.
- Maintain client SLA for Database availability.
- Maintain data guard and be certain to keep all physical standby databases in sync with production.
- Proactive in Oracle quarterly patches.
- Work on disaster recovery scheduled tests.
- Provide dba support to hosted databases in UNIX, Linux environment.
- Managing RMAN backups. Troubleshooting RMAN backup issues.
- 24X7 on call support.
- Configured Daily backups on standby database in Data Guard environment.
- Supporting Application team with application upgrades.
- Refresh non prod schemas with prod data as needed using Data Pump.
- Upgrading databases adopting out of place upgrades in 11g.
- Patching databases using OPatch utility.
- Manages database security by creating and assigning appropriate roles and privileges to users.
Environment: Oracle 11gR2, 10g, LINUX (RED HAT), RMAN, TOAD, SQL LOADER, DATA PUMP.OEM/Grid Control