9 years of overall experience in the IT field. This includes strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 11g and 12c. Experience in Information Security Analysis, combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
- Implementation of high availability solutions with Oracle 11g RAC, Standby Database Data Guard.
- Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES 12c Monitoring.
- Creation of Active Directory groups, users, and adding users to Active Directory groups.
- Creating and managing Linux users, adding them to Linux groups.
- Experience in Upgrading databases and applied patch sets to multiple databases.
- Expertise in Database Space Management, Expertise in troubleshooting and performance tuning.
- Excellent analytical and problem-solving skills, Sound judgment and use of initiative.
- Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
- Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
- Experience in using OEM, TOAD, Data Migrations using export/import.
- Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
- Database performance tuning using STATPACK, Explain Plan, AWR, ADDM, ASH.
- Experience on working with data guard physical standby databases.
- Extensive performance tuning experience, specializing in tuning, Oracle 10g and 11g RAC tuning, Load balancing.
- Expert in configuration and Installation of RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
- Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
- Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
- Upgrade/Migration of Databases from Oracle 10g to 11g as well migrating experience over cross platforms from Linux to Solaris, AIX to Solaris and from windows to Linux.
- Skilled in dealing with RAIDs on local server (Via RAID card BIOS) in ASM environment such as installation, taking backup, migration of database from Non –ASM to ASM environment.
- Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup.
- Excellent Written and verbal Communication skills with a customer service oriented attitude. Knowledge on Oracle Support processes for technical requests with Metalink.
Technical Skills
- Operating systems
- LINUX, SOLARIS, MS-DOS, Windows Advanced Servers 2003/2008R2, HP-UX, AIX.
- Databases
- Oracle 11gR2, 12c RAC, Microsoft SQL Server 2008/2012/2014, Sybase, DB2, Teradata, MySQL
- Oracle Database Tools
- SQL*Loader, TKPROF, Toad, SQL Developer, Grid Control
- Tools & Utilities
- Export/Import, RMAN, Data Pump, Winscp3, ERWIN, Remedy.
- Languages
- SQL, PL/SQL, Java, C++, JavaScript, jQuery
- Web Tools
- Other Tools
- Microsoft Office Suite, VMware Workstation 10, Active Directory