Oracle Dba Resume
Mountain View, CA
PROFESSIONAL EXPERIENCE
Oracle DBA
Confidential, Mountain View, CA
Responsibilities:
- Oracle Production Database Administrations & Support (24x7)
- Install, configure, and maintain Oracle Databases and Applications
- Manage and Administer Oracle RAC in Unix/Windows Environment.
- Upgrade/Migration of databases (windows - Linux)
- Database Duplicates/Cloning from production environment to test/development environments
- Database Point-in-Time Recovery and Flashback Features
- Creating & Managing Database objects
- Applying patches (Server side and Client side).
- Oracle 11g RAC installation, configuration and support
- Online performance monitoring-Examine information as transactions processed, and point out trouble spots using OEM Grid Control.
- Analyze data & identify potential performance bottlenecks in databases using ADDM and OEM in teh AWR- Proactive Monitoring.
- Standby Database (Data Guard) setup and configuration.
- Security Auditing
- Working alongside programmers and contributing to teh development process
Environment: Oracle 11gR2, RDBMS, OEM, SQL Developer, SQL*Loader, Import/Export, Data Pump, ASM, PL/SQL, SQL, Linux, & Windows Environments.
Oracle DBA
Confidential, Sterling, VA
Responsibilities:
- Configuration of Standby database for maximum performance & availability (Data Guard)
- Installation, configuration, and support of Oracle 11g R2 databases
- Database Migration, Duplicates, & Cloning
- Bug Fixing-Perform rolling patch upgrades on RAC environment
- Regular Database Management, Backup & Recovery using RMAN (Daily incremental backup, weekly full backup)
- Loading data into database tables using SQL*Loader
- Create & Manage Users, Tables, and Tablespaces
- Performance monitoring and tuning
- Analyze data & identify potential performance bottlenecks in databases using ADDM and OEM in teh AWR- Proactive Monitoring
- Monitoring alert log/system log and Managing Database Locks and blocking sessions
- Startup & Shutdown Automation on Development/Test & Production Databases
Environment: Oracle 11gR2, RDBMS, OEM, SQL Developer, SQL*Loader, Import/Export, Data Pump, ASM, PL/SQL, SQL, Linux, & Windows Environments.
Oracle DBA
Confidential, Dallas TX
Responsibilities:
- Backup and Recovery Strategy Plans & Implementations.
- 24 X 7 Production Oracle database support, administration, as well as on call rotation.
- Worked on database refresh using user managed backups and RMAN backups.
- Configure Oracle grid control to manage different databases in centralized location.
- Plan and Query Performance, Session Tracing on SQL.
- Oracle Database Tuning for concurrent jobs using STATS package, TKPROF
- Application Tuning, Identifying teh SQL causing I/O bottlenecks, of high cost and recommendations to teh development teams.
- Analyze data & identify potential performance bottlenecks in databases using ADDM and OEM in teh AWR- Proactive Monitoring.
- Create & Manage Users, Tables, and Tablespaces
Environment: Oracle 11gR2, RDBMS, OEM, SQL Developer, SQL*Loader, Import/Export, Data Pump, PL/SQL, SQL, Linux, & Windows Environments.
Internship-Oracle DBA
Confidential, Dallas TX
Responsibilities:
- Create and manage oracle users, roles, privileges and profiles to maintain database security
- Oracle Application installations & upgrades
- Responsible for monitoring alert logs, memory, Disk I/O, CPU, and database network connectivity
- Oracle database administration
- Exposure to SQL Tuning
- Experience wif PL/SQL, Workflow, Forms, Reports, Interfaces.
- Ensuring daily RMAN and export backups are completed and valid for restore and recovery, as well as teh daily Export Data Pump activity ran successfully
Environment: Oracle 11gR2, RDBMS, OEM, SQL Developer, SQL*Loader, Import/Export, Data Pump, PL/SQL, SQL, Linux, & Windows Environments.
