Description
EXPERIENCE SUMMARY PROFESSIONAL SUMMARY: * Over 4+ Years of total Oracle Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals exclusively Telecom, Financial, Pharmaceutical, Insurance Industries. * Participated in planning and implementation of off-site Disaster-Recovery planning and testing * Worked with development and operations staff in resolving problems quickly and efficiently * Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures. * Expertise in using oracle Export/import, Datapump utility to migrate data across schemas. * Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DW databases. * Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features. * Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature. * Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN. * Experienced in using 11g features Data pump, AWR, ASM, ADDM, Grid Monitoring, and Oracle * Enterprise Manager. Installation, administration and maintenance of Oracle 11g * Designed and tested Backup solutions using RMAN and NetApp Snapshots/Flex Clones. * Tuned Oracle databases, application programs and operating system. * Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment * Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT. * Carried out migrations between different environments including production using STAT / Manually. * Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases. * Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates.. * Team player with excellent interpersonal, analytical and communications skills * Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility. * Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE, 11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities. * Strong experience in configuration of RMAN, Planning and scheduling Backups using CRONTAB. * Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments. * Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical Standby database (Data Guard), Materialized views, VCS, Streams Replication, Golden Gate. * Experienced in Oracle Support processes for technical requests through Oracle and other Support. * Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service Extensive experience in 7 24 production database support. * Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning. * Design, development, and testing of backup and recovery to ensure complete recoverability. * Solid experience in disaster recovery, routine maintenance for Oracle databases. * Security management for database, network, and operating systems. * SQL Net installation/configuration/troubleshooting (Server and Client side). PROFESSIONAL SUMMARY: * Over 4+ Years of total Oracle Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals exclusively Telecom, Financial, Pharmaceutical, Insurance Industries. * Participated in planning and implementation of off-site Disaster-Recovery planning and testing * Worked with development and operations staff in resolving problems quickly and efficiently * Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures. * Expertise in using oracle Export/import, Datapump utility to migrate data across schemas. * Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DW databases. * Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features. * Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature. * Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN. * Experienced in using 11g features Data pump, AWR, ASM, ADDM, Grid Monitoring, and Oracle * Enterprise Manager. Installation, administration and maintenance of Oracle 11g * Designed and tested Backup solutions using RMAN and NetApp Snapshots/Flex Clones. * Tuned Oracle databases, application programs and operating system. * Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment * Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT. * Carried out migrations between different environments including production using STAT / Manually. * Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases. * Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates.. * Team player with excellent interpersonal, analytical and communications skills * Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility. * Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE, 11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities. * Strong experience in configuration of RMAN, Planning and scheduling Backups using CRONTAB. * Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments. * Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical Standby database (Data Guard), Materialized views, VCS, Streams Replication, Golden Gate. * Experienced in Oracle Support processes for technical requests through Oracle and other Support. * Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service Extensive experience in 7 24 production database support. * Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning. * Design, development, and testing of backup and recovery to ensure complete recoverability. * Solid experience in disaster recovery, routine maintenance for Oracle databases. * Security management for database, network, and operating systems. * SQL Net installation/configuration/troubleshooting (Server and Client side). Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design. * Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines. * Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations. * Installed & configured Oracle Management Server (OMS) & Oracle Grid Control. * Extensive knowledge in maintain Oracle Cluster ware using Srvctl, Crsctl, has, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage. * Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning. Responsible for maintaining the Database environments under SOX compliance and attend the SOX audit once in a year with all the evidences * Apply the oracle security patches (CPU patch / PSU patch) on standalone database, Oracle RAC and clusterware (oracle 11g - Grid Infrastructure) * Providing Level 2 operational support for the database tower * Keeping the databases up to date with respect to Latest PSU's and comfortable in applying patches. * Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control * Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment. * Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM * Monitoring and troubleshooting database issues with OEM grid control. * Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues. * Resolving RAC specific issues such as node evictions * Performed proactive and reactive tuning/managing database space utilization and growth * Implementing Oracle ASM and resolving ASM related issues * Detailed analysis of the business and users requirements by doing various information gathering techniques. Environment: Oracle 10g, 11g, 12C, Unix shell script, Grid Control, Data Guard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR and Statspack Reports, EXPDP/IMPDP, EXP/IMP, PL/SQL, RMAN, Crontab, Tivoli Storage Management for DB tape backups, BMC Patrol for DB monitoring.
Accomplishments
Highlights:
Keywords
