Professional Summary * 5 years of experience in the field of Database Technology with experience in designing, developing, implementing Databases, Web development and Application development * Proficient in Oracle Database Administration activities such as Upgrades, Patches, my oracle support. * Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing * Oracle Database Administration experience in variety of different environments like HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows. * Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to RAC environment. * Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation. * Migrating and Upgrading the Databases between different environments and versions. * Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases. * Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features. * BACKUP, configure RMAN centralized backup for all database. Create standby database from * Active database using RMAN. Cloning of RAC to Non-RAC database using RMAN. Test & validate restore and recovery for SLA. * Responsible for all database activities such as User management, space management, database * security management. * Design, document, implement, and maintain all backup, recovery including disaster recovery. * DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, tablespaces, indexing, data maintenance, user management, and maintenance and solving critical errors like ORA-600, ORA 7445. * Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts. * Setting up Oracle read only replication with materialized views and developed scripts for automating the rebuilt process of replication. * Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, creating database links, managing user groups and tuning. * Applied CPU patches. * Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another. * Maintained Very Large Multi-Terabyte (VLDB) in Data Warehouse Environment for DSS. Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams. * Good experience in applying Critical Patch Update (CPU Patches) on Databases. * Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 10g and 11g ASM. * Planned and implemented Oracle 10g, 11g, 12c Standby Databases (Data Guard) for High availability and Disaster Recovery (DR). * Patching the databases with CPU/PSU on quarterly cycles or ad-hoc needs. * Creating database objects like tables, views, indexes, constraints. * Installed and configured Oracle Cloud Control and deployed agents on managed targets. * Experience with Oracle Cloud Control, Oracle Grid Control, Oracle Enterprise Manager (OEM), ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor. * Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring. * Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS. * Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes. * Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting. * Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database. 5 years of experience in the field of Database Technology with experience in designing, developing, implementing Databases, Web development and Application development * Proficient in Oracle Database Administration activities such as Upgrades, Patches, my oracle support. * Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing * Oracle Database Administration experience in variety of different environments like HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows. * Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to RAC environment. * Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation. * Migrating and Upgrading the Databases between different environments and versions. * Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases. * Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features. * BACKUP, configure RMAN centralized backup for all database. Create standby database from * Active database using RMAN. Cloning of RAC to Non-RAC database using RMAN. Test & validate restore and recovery for SLA. * Responsible for all database activities such as User management, space management, database * security management. * Design, document, implement, and maintain all backup, recovery including disaster recovery. * DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, tablespaces, indexing, data maintenance, user management, and maintenance and solving critical errors like ORA-600, ORA 7445. * Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts. * Setting up Oracle read only replication with materialized views and developed scripts for automating the rebuilt process of replication. * Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, creating database links, managing user groups and tuning. * Applied CPU patches. * Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another. * Maintained Very Large Multi-Terabyte (VLDB) in Data Warehouse Environment for DSS. Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams. * Good experience in applying Critical Patch Update (CPU Patches) on Databases. * Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 10g and 11g ASM. * Planned and implemented Oracle 10g, 11g, 12c Standby Databases (Data Guard) for High availability and Disaster Recovery (DR). * Patching the databases with CPU/PSU on quarterly cycles or ad-hoc needs. * Creating database objects like tables, views, indexes, constraints. * Installed and configured Oracle Cloud Control and deployed agents on managed targets. * Experience with Oracle Cloud Control, Oracle Grid Control, Oracle Enterprise Manager (OEM), ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor. * Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring. * Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS. * Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes. * Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting. * Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
Description
