Description
SUMMARY * More than 16 years' Oracle DBA experiences with OCP 9i and 10g Certificated (on Sun Solaris/IBM AIX/HP-UX/RHEL and Windows platforms) * 8 year experience of Oracle RAC and 6 year experience with 11g RAC. * Installed and configured Oracle RDBMS (From 8i to 12c). * Evaluated and tested the new features from Oracle 8i through 12c RDBMS. * Set up and configured RMAN for backups and recovery (9i, 10g and 11g). * Developed, tested and documented disaster recovery plan (DR plan). * Designed, configured, implement and managed Data Guard (9i, 10g and 11g) environment via DGMGRL utility. Tested switchover and failover procedures in regular interval. * Capacity plan, Space growth trend monitoring * Upgraded Oracle databases from 8i onward to 11gR2 * Migrated SQL Server and MySQL to Oracle database * Build replication system with Oracle Golden Gate and Streams (10g and 11g). * High level sed, awk programming skills to solve some special problems * Excellent skills in SQL and PL/SQL development. warning and conditional compilation, parallel processing, unit testing, bulk collection operations, result cache * Expert skills in Database Modeling with strong knowledge of SDLC * Logical and physical database design with UML and implementation * Application, Database and SQL, PL/SQL performance tuning * Install, configure and manage 10g/11gR2 RAC with ASM storage. * Senior level skills for ADDM and AWR report analysis. * Designed, tested, implemented and documentation Disaster Recovery Plan. * Good experiences of ANT, Python and PERL programming in scrip development * Excellent skills of SQL*plus and some other command-line utilities * Superb skills in shell scripting to automate all possible operations in database management and data handling and monitoring system. * Experience of VLDB with Oracle partitioning technology to improve the performance. * Some development knowledge with PHP, JSP, PSP and Java. * Worked with QA, Development teams to resolve Dev., QA or UAT environments' issues. * Data warehouse and mart design, development, implementation and performance tuning. * Oracle Resource Management design and implementation * OLTP and OLAP application database design, development and implementation. * Application and script Version control with Subversion (SVC) * Worked in Hadoop Distribution FS for big data analysis projects with R/MapReduce * 3 years MySQL management (Install, admin, tuning, backup and troubleshooting), * 5 years management experience with SQL Server (7, 2000 and 2005) * 7x24 On-call support of production environments
Accomplishments
Highlights:
Job Skills
Keywords
- Oracle DBA/Dev
- PL/SQL
- Data Guard
- RAC
- Golden Gate
- Shell Scripting
- Python/Ruby
- Tuning
- Star Schema
- Data Warehouse
- Oltp (Online Transaction)
- Oracle Database Administration
- Perl Programming Language
- Star (Sys Testing App Req
- Sun Solaris Operating System
- Application Design
- Disaster Recovery
- ETL
- Extract Transform Load Tools
- Inventory
- Microsoft SQL Server
- Database
- Database Design
- Management
- Oracle
- Oracle Database
- Linux
- SQL Loader
- Structured Query Language
- Microsoft Windows
- Oracle PL/SQL Programming language
- cron
- Dba (Database Admin)