Experience as an Oracle DBA.
Experience in Data Modeling, Design, Development & Production Support.
Experience in working with International teams using offshore, onshore model.
Experience in managing large OLTP/OLAP and Data warehouse databases of size multiple TB (100.)
Experience widely in performance tuning, Memory Tuning and Application Tuning.
24 X 7 Production database administration, support, monitoring, proactive problem recognition and resolution of database issues.
Experience in configuration, implementation of oracle 10g/11g RAC with ASM disk on Linux servers
Implemented Golden Gate.
Oracle advanced Security to mask and secure sensitive Data DB Vault.
Experience in upgrading databases to Oracle 10g/11g
Providing day to day support in extensive Golden gate enviornment (Target/Source- Both Sides.)
Experience in Agile methodologies.
In depth experience in Oracle database architecture, Oracle database development, Oracle database administration, database/SQL performance tuning, Data Warehouse
Experience in Oracle E-Business Suite 11i & R12
Experience in process improvement, Database Design, Database creation, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Standby Database (Data Guard), Replication, Real Application Clusters, Automatic Storage Management (ASM)
Exposure to Exadata and Big data
Experience in Multi Node RAC cluster design, administration and support.
Experience in analyzing the Database Migration requirement and providing an efficient and workable solution. Worked with Project Managers to understand different clients requirement and provide an efficient solution keeping in mind the methodology, duration and resources.
Experience in analyzing and translating business requirements to technical requirements and architecture.
Experience in VERITAS I/O on oracle database.
Good knowledge about the technical aspects of telecom Industry and Insurance sector
Experience in Oracle 9i, Oracle 10g,11g software installation and configuration.
Experience in upgrading databases to Oracle 10g/11g.
Installation and Maintenance of Standby (Dataguard) database.
Installation, Configuration and Administration of Oracle 10g RAC.
Applied patches to Oracle Databases.
Experience in NETBACKUP on oracle database and NETBACKUP for oracle advanced BLI.
Cloned Oracle Databases for development and testing.
Proficient in SQL, PL/SQL programming and performing SQL tuning and assist developers with coding PL/SQL. Expertise in AIX shell scripting.
Experience in optimization and tuning SQL queries using SQL_TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR.
Experience in design and implementation of Backup & Recovery procedures.
Experience in using RMAN for backup and recovery. Experience in implementing Hot, Cold and Logical backup plans.
Customization and development of Korn shell scripts.
Experience in the management of schemas, de-fragmentation and partitioning the tables & indexes to improve the performance.
Responsible for setting and managing user accounts, granting required privileges to users.
A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Strong listening, interpersonal and analytical skills.
Result oriented, self-motivated, Team player, ability to work independently.
HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3
Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, Linux SuSE, and Windows 95/98/ME/NT/2000/XP.
RDBMS Oracle 11g RAC/10g/9i MySQL, SQL Server 2000/2005
Languages SQL, PL/SQL, UNIX, Perl Scripting, Shell Scripting, Delphi, C, C++
Tools RMAN, OEM, SQL*Loader, SQL NET, EXP, IMP, expdp, impdp, TOAD,VB, ORADEBUG, RACDIAG, DBMS APIS, SRVCTL, CRSCTL, OCRDUMP, CDC, Data Modeling Power Designer, Erwin, Golden Gate
Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Oracle Tuning Pack
Other EMC, NetApp, Streams, Veritas NetBackup, TSM, HP Data Protector, Shareplex, NetApp filers, DataStage, Pentaho,Informatica
oracle DBA, RMAN,golden gate,RAC, NETBACKUP