SUMMARY:

• Over 11 years of extensive experience as an Oracle DBA in Banking, Tele Communication, Finance, IT Sectors etc. I am responsible for the Following:
• Experienced in oracle 10g/11g/12C Real Application Clusters (RAC) installation and configuration, monitoring as Primary DBA on Linux and IBM AIX.
• Experienced in Oracle Golden Gate installation and configuration, monitoring as Primary DBA
• Excellent in shell scripting for UNIX environments.
• Effective troubleshooting of performance and tuning problems in Oracle databases.
• Proficient in implementing Backup and Recovery strategies for Oracle databases (Logical - Export & Import, Physical - Online and Offline Rman).
• Experienced in 10g/11g new features (ASM, Data pump, AWR, ADDM, ASH and GRID Control)
• Good understanding and experience of Data Guards and Oracle 10g STREAMS
• Experience in DB upgrades, patches and data migration
• Installation and monitoring oracle Enterprise manager (OEM 12C)
• Experienced in installing Oracle applications, Oracle database servers, Oracle 9i/10g AS and clients.
• Working Experienced with ITIL process (Incident management, change management, patch management, problem management, etc.)
• Working Experience on EXADATA machines and database
• Very strong Production Support (24X7) experience.
• Experienced in handling Large & very large Databases
• Production DBA experience in MS SQL Server 2005 and 2008
• Worked on replication, cluster, mirroring and log shipping in MS SQL Server
• Regular Maintenance activities like Loading, Unloading of data, Repairing of databases, and Purging of Data, Reorganization of data, Database Refreshes
• Work experience in MS SQL database
• Working experience in MySQL Database
• Proficient in SQL, PL/SQL, Java and web technologies.
• Create user and give privileges in oracle 11i (Oracle Apps).
• Patching on oracle apps with opatch and ad patch utility (Oracle Apps).
• Oracle Applications 11i Hot Backup Cloning with Rapid Clone (Oracle Apps).
• Experienced in Sun Solaris, Confidential -UX, Linux, Windows 2000/NT/98/95 environments
• Excellent problem solving, communication skills.
• Highly motivated individual and good team player

TECHNICAL PROFICIENCY:

Database: Oracle 7.x,8i,9i,10g,11g,11i,SQL Server and MS Access, MySQL

Operating Systems: Linux Redhat, IBM AIX, Windows NT/98/2000, Solaris 5.8/5.9, Confidential -UX 11i

Web Technologies: HTML, JavaScript, VBScript, JSP,DHTML,PHP

Tools: TOAD, Exp/Imp, Sql loader, OEM, Sql*net, RMAN, tkprof

Other Technologies: RAC 10g R2, Dataguards, Oracle 9i/10g Application Servers, Oracle 11i oracle Apps, ASM

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Installation, configuration and monitoring oracle databases 12c/11g/10g, Real Application Clusters (RAC), Oracle Golden gate, Dataguard, Oracle Exadata machines, oracle streams
• Implementing Active-Active & active- Passive replication solution using Golden Gate, Dataguard, Oracle Streams, Materialized view.
• Effective troubleshooting of performance and tuning problems in Oracle databases.
• Upgrading and migrating RAC, GI, Databases
• Applying patches and updates on database homes
• Installation and monitoring oracle Enterprise manager (OEM 12C)
• Experienced in 10g/11g new features (ASM, Data pump, AWR, ADDM, ASH and GRID Control)
• Develop & Troubleshoot shell script for UNIX/ Windows environments.
• Plan and configure Backup and Recovery strategies for Oracle databases (Logical - Export & Import, Physical - Online and Offline - RMAN).
• NoSQL Databases (Hadoop, Cassandra, Couchbase)
• Work experience in MYSQL database
• Proficient in SQL, PL/SQL, Java and web technologies.

Confidential

Senior Oracle DBA

Responsibilities:

• Strong Working Experience in oracle 12c/11g/10g Real Application Clusters (RAC) installation, configuration monitoring as a primary DBA on Linux
• Experienced in Oracle Golden Gate installation, configuration, monitoring as Primary DBA
• Golden gate Unidirectional & bi-Directional (active -Active) configuration
• Effective troubleshooting of performance and tuning problems in Oracle databases.
• Experience in RAC, GI, DB upgrades, patches and data migration
• Installation and monitoring oracle Enterprise manager (OEM 12C)
• Working Experienced with ITIL process (Incident management, change management, patch management, problem management, etc.)
• Experienced in 10g/11g new features (ASM, Data pump, AWR, ADDM, ASH and GRID Control)
• Excellent in shell scripting for UNIX/ Windows environments.
• Proficient in implementing Backup and Recovery strategies for Oracle databases (Logical - Export & Import, Physical - Online and Offline - RMAN).
• Good understanding and experience of Data Guards and Oracle 10g STREAMS
• NoSQL Databases (Hadoop, Cassandra, Couchbase)
• Experienced in handling Large & very large Databases
• Regular Maintenance activities like Loading, Unloading of data, Repairing of databases, and Purging of
• Data, Reorganization of data, Database Refreshes via EXPDP/IMPDP, RMAN
• Work experience in MYSQL database
• Proficient in SQL, PL/SQL, Java and web technologies.
• Experienced in Sun Solaris, Confidential -UX, Linux, Windows 2000/NT/98/95 environments
• Excellent problem solving, communication skills.
• Highly motivated individual and good team player

Confidential

Senior Oracle DBA

Responsibilities:

• Strong Experienced in oracle 10g/11g Real Application Clusters (RAC) installation and configuration, monitoring on Linux and IBM AIX.
• Experienced in Oracle Golden Gate installation and configuration, monitoring as Primary DBA
• Effective troubleshooting of performance and tuning problems in Oracle databases.
• Experience in DB upgrades, patches and data migration
• Installation and monitoring oracle Enterprise manager (OEM 12C)
• Working Experienced with ITIL process (Incident management, change management, patch management, problem management, etc.)
• Experienced in 10g/11g new features (ASM, Data pump, AWR, ADDM, ASH and GRID Control)
• Excellent in shell scripting for UNIX/ Windows environments.
• Experienced in installing Oracle applications, Oracle database servers, Oracle 9i/10g AS and clients.
• Proficient in implementing Backup and Recovery strategies for Oracle databases (Logical - Export & Import, Physical - Online and Offline).
• Good understanding and experience of Data Guards and Oracle 10g STREAMS
• Very strong Production Support (24X7) experience.
• Experienced in handling Large & very large Databases
• Production DBA experience in MS SQL Server 2005 and 2008
• Worked on replication, cluster, mirroring and log shipping in MS SQL Server
• Regular Maintenance activities like Loading, Unloading of data, Repairing of databases, and Purging of Data, Reorganization of data, Database Refreshes
• Work experience in MS SQL database
• Proficient in SQL, PL/SQL, Java and web technologies.
• Experienced in Sun Solaris, Confidential -UX, Linux, Windows 2000/NT/98/95 environments
• Excellent problem solving, communication skills.
• Highly motivated individual and good team player

Confidential

Senior Oracle DBA

Responsibilities:

• Production, development and test database support on
• Real application Cluster 11g/10g/9i Installation, Configuration, Monitoring
• Grid Control 10g and 11g
• Data ware housing (Partition, Parallel execution, Materialized view, OLAP, Data mining etc)
• Performance issues, Database installation, configuration, ASM etc
• Dataguard/standby configuration/Monitoring, switchover, failover by manually and DG broker in 9i, 10g and 11g
• Backup And Recovery, RMAN

Confidential

Senior Oracle DBA

Responsibilities:

• Working with ITIL Process (Incidents, Change, Patch and problem Managements etc)
• Installation and monitoring oracle 10G Real Application Cluster on Linux platforms and IBM AIX
• Implementation of dataguards on oracle 9i and 10g
• Has done switchover and failover on dataguards (oracle 9i & 10g)
• Configurations and Monitoring of Oracle 10g streams
• Experienced in 10g new features (ASM, Datapump, AWR, ADDM, ASH and GRID Control)
• Excellent in shell scripting for UNIX environments
• Configuration of databases in RMAN for backup and recovery
• Taking and deciding the suitable kind of backup (Rman, Export, Cold and Hot backup).
• Assistance in restoration exercises & recovery of database.
• Performance tuning for bad queries using Oracle 10g Grid
• Applying maintenance patches, quarterly CPU patches, upgradation, migration of Oracle Server
• Installation and administration of Oracle Database and its Tools on various Operating Systems, such as Windows NT, Unix Server, Linux Red Hat, IBM AIX Monitoring production and development environment
• Maintenance and tuning of databases: Disk I/O optimization through table, index, differentiating table data and indexes in separate tablespaces in separate disks. Monitoring and appropriate sizing of logical structures viz. tablespaces, tables, indexes through appropriate parameters such as pctused, pctfree, initial and next extent values balancing both I/O and space usage.
• SQL tuning through use of optimizer hints within SQL statements.
• Interactions with application developers extensively to maintain and tune performance of Oracle server on IBM
• AIX, LINUX, Windows Platforms
• Working with ITIL Process (Incidents, Change, Patch and problem Managements, etc)
• Assistance in restoration exercises & recovery of database.
• Configuration of databases in RMAN for backup and recovery
• Performance tuning for bad queries using Oracle 10g Grid
• Implementation of dataguards on oracle 9i and 10g.
• Has done switchover and failover on all dataguards (oracle 9i & 10g)
• Monthly Activities like bordereu process, Partitions in DWh Database,
• Supporting 24x7 production databases.
• Installation and administration of Oracle Database and its Tools on various Operating Systems, such as Windows NT, Unix Server, Linux Red Hat, IBM AIX Monitoring production and development environment
• Applying maintenance patches, quarterly CPU patches, upgradation, migration of Oracle Server
• Physical design and implementing the database, including memory and disk space allocation.
• Logical database design including creation and sizing of logical storage structures such as tablespaces, tables and indexes.
• Taking and deciding the suitable kind of backup (Rman, Export, Cold and Hot backup).
• Written scripts for taking the both kind of backups (Online & Offline backup).
• SQL tuning through use of optimizer hints within SQL statements.
• Interactions with application developers extensively to maintain and tune performance of Oracle server on IBM AIX, LINUX, Windows Platforms

Confidential

Oracle DBA

Responsibilities:

• Installation and monitoring oracle 10 G Real Application Cluster on Linux platforms and IBM AIX
• Working with ITIL Process.
• Working on Incidents, Change, Patch and problem Managements
• Maintenance of databases of sizes ranging from 1.2 TB to 3 TB
• Assistance in restoration exercises & recovery of database.
• Configuration of databases in RMAN
• Configured scripts to automate database changes and maintenance.
• Implementation of dataguards on oracle 9i and 10g (Real Application Cluster)
• Has done switchover and failover on all dataguards (oracle 9i and 10g RAC)
• Supporting 24x7 production databases.
• Installation and administration of Oracle Database and its Tools on various Operating Systems, such as Windows NT, Unix Server, Linux Red Hat, IBM AIX Monitoring production and development environment.
• Applying maintenance patches, upgradation, migration of Oracle Server.
• Physical design and implementing the database, including memory and disk space allocation.
• Logical database design including creation and sizing of logical storage structures such as tablespaces, tables and indexes.
• Taking and deciding the suitable kind of backup (Rman, Export, Cold and Hot backup).
• Written scripts for taking the both kind of backups (Online & Offline backup).
• Maintenance and tuning of databases: Disk I/O optimization through table, index, differentiating table data and indexes in separate tablespaces in separate disks. Monitoring and appropriate sizing of logical structures viz. tablespaces, tables, indexes through appropriate parameters such as pctused, pctfree, initial and next extent values balancing both I/O and space usage.
• Use of tuning tools like EXPLAIN PLAN, SQL Trace, and TKPROF, monitoring scripts like UTLBSTAT. Sql and UTLESTAT. Sql etc.
• SQL tuning through use of optimizer hints within SQL statements.
• Development of shell scripts in UNIX to assist in database tuning.
• Interactions with application developers extensively to maintain and tune performance of Oracle server on IBM AIX, LINUX, Windows Platforms
• Production DBA experience in MS SQL Server 2005 and 2008
• Worked on replication, cluster, mirroring and log shipping in MS SQL Server

Confidential

Oracle DBA and Oracle Apps DBA

Responsibilities:

• Monitoring oracle 10G Real Application Cluster on Linux platforms and IBM AIX
• Supporting 24x7 production databases.
• Implementation of dataguards on oracle 9i
• Has done switchover and failover on all dataguards (oracle 9i)
• Database migration from 8i to 9i, 9i to 10g.
• Applying maintenance patches, upgradation, migration of Oracle Server
• Maintenance of primary database storage structures and primary objects, managing undo/rollback segments.
• Day to day performance monitoring and tuning of the database in 24*7*365 environment.
• Maintenance of databases of sizes upto 2.50 TB
• Restoration & recovery of database.
• Monitored system performance and recommended actions for improving the system
• Performed data purging activity in OLTP and Batch processing systems.
• Partitioned table maintenance covering rotation/sorting of partitions.
• Configured scripts to automate database changes and maintenance.
• Managing users, maintaining systems security, controlling and monitoring database access