Senior Oracle Dba Resume
SUMMARY
- Working as senior Oracle DBA for more than 12 years
- Strong troubleshooting skills, analytical, hardworking, leader, proactive, results - oriented, self-study, committed, good communication, work under pressure with minimum supervision.
TECHNICAL SKILLS
Databases: Oracle 8i,9i,10G, 11G RAC,12C RAC SQL Server 2005 2008R2, MYSQL
Operating Systems: Red Hat Linux, HP-UX, Solaris, Windows Server 2000-2008
Languages: Java, HTML, Visual Basic
SQL Languages: PL-SQL, Transact SQL, ANSI SQL, SQL Tuning
Other: Shell scripting, AWK, WebLogic Server, Development Technical Project Leader, and Database Migrations Leader, Relational Database Modelling, Query Optimization, Oracle Database Performance.
PROFESSIONAL EXPERIENCE
Confidential
Senior Oracle DBA
Responsibilities:
- Performing Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts
- Currently designing and implementing Disaster Recovery plan using Oracle Data Guard and Active Data Guard
- Refreshing databases using RMAN
- Creating Unix shell scripts to automate database backup jobs, performance monitoring
- Installing and configuring Oracle Golden Gate, unidirectional and bi-directional
- Performing Data Recovery on Flashback databases
- Performing Backup and Recovery through RMAN
- Performance tuning of SQL statements using AWR, TKPROF, Explain Plan and SQL Trace
- Physical and Logical database design
- Installing, migrating, configuring and testing Oracle RAC databases in various environments
- Applying Quarterly CPU (CRITICAL PATCH UPDATES) on Oracle RAC databases
- Configuring and Managing ASM disks and disk groups thru both Grid Control and ASMCMD utility
- Understanding of DB internals
- Oracle RAC, ASM, Exadata, Export and Import
Confidential, San Francisco, California
Oracle DBA and Unix System Administrator
Responsibilities:
- Successfully installed Oracle 11g software and built multiple databases
- Successfully Upgraded from Oracle 10g to Oracle 11g database
- Successfully installed and managed Oracle 10G database on Window 2003 for Vista application
- Implementation of the Backup and Recovery Databases strategy
- Data migration testing between old and new database tables
- Configured production primary and standby database
- Wrote Unix shell scripts for database management
- Participated in on call rotation
- Hands on Unix systems administration
Confidential, California
Oracle DBA Consultant and QA engineer
Responsibilities:
- Hands-on installed, administrated and maintained Oracle 8i, 9i databases on Linux and Solaris systems
- Deployed application schema, Created, modified, and managed data and storage structures for production database
- Created and executed test cases for functional modules
- Created and automated test cases with Mercury Quality Center platform
- Performed browser and platform compatibility testing
- Involved in integration testing across multiple systems
- Verified data in the Oracle Databases using SQL queries to compare the results
- Wrote Unix shell scripts for automation
Confidential, California
QA engineer
Responsibilities:
- Developed test cases for functional and regression testing of the application based on the analysis of business requirements
- Tested browser and operating system compatibility (Windows, LINUX, MSIE etc )
- Tested performance, usability, navigation, links, images, forms, etc
- Developed test cases and test suites for the designated areas of testing
- Verified bugs fixed in new releases
- Provided intensive regression testing of software updates before uploading them to Production Server
Confidential, California
QA engineer
Responsibilities:
- Installed Oracle8i server and Oracle tools on Sun Solaris
- Compared the data of QA Environment and production Environment during regression testing in each release
- Executed and updated test cases for various projects
- Wrote Test Plan and Test Cases
- Conducted functional, regression, GUI, Unit, performance, cross browser testing of the e-commerce application
- Reported Bugs using in-house proprietary bug tracker system and monitored the status
- Tested and verified bug fixes