Oracle Rac Dba/production Support Resume
4.00/5 (Submit Your Rating)
Columbia, MO
PROFESSIONAL SUMMARY:
- With over 5 years of strong experience in Oracle database administration/development in heterogeneous system environment including Solaris, UNIX, and Windows.
- Delivering Oracle Database performance - tuning services for customers with Explain Plan, Tkprof, StatsPack, and SQL Trace.
- Excellent experience in Installation and configuration of Oracle 12c,11g, 10g, in UNIX/LINUX and Windows environment.
- • (5) years’ experience SQL Server administration •(5) years’ experience supporting SQL Server environments in production •SQL Server 2008/2012/2014 administration background •Strong knowledge of object creation and manipulation (tables, views, stored procedures, indexes, functions, constraints, triggers) •Strong knowledge of Availability Groups and SQL clustering best practices •SQL Server upgrade implementation from 2008R2 to 2014, both in-place and server migration paths •Windows Server configuration best practices for SQL Server •Oracle, Postgres, and MongoDB knowledge beneficial
- Experience in understanding, writing, editing and debugging BASH SHELL SCRIPTS
- Proficient working with ORACLE SQL*PLUS, PL/SQL, stored procedures, packages and functions experience in RAC installation, configuration and administration
- Upgraded Databases from 10gto 11g and 11g to 12c on various platforms.
- Good understanding of Golden gate installation and administration
- Configure and administer Oracle data guard for disaster recovery
- Proficient in Database administration activities such as user management, space management, Monitoring, Creating Database, Managing Oracle Instance and Database security and Materialized Views.
- Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, TKPROF, SQL TRACE,EXPLAIN PLAN for the better performance.
- Performance Monitoring and Tuning of Database using Grid Control & Diagnostic pack (AWR, ASH ADDM)
- Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).
- Experience in performing point in time recovery at times of necessity.
- Design and implement backup and recovery including disaster recovery structures.
- Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
- Experience in installing and configuring ORACLE ENTERPRISE MANAGER of all versions
- Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and index installed and configured Oracle, 10g, 11g, 12c on Sun Solaris AIX, UNIX/LINUX, HP-UX and Windows environment.
- Synch -up database environments (DEV, QA) after each major release or production change.
- Implemented One node RAC and four node 11g RAC clusters on Linux platform and AIX LPARs having GPFS cooked SAN Storage.
- Provided support to the Database system Infrastructure area that had few critical Business Systems including TR, Bills Order and Tracking, Online Charges.
- Co-ordinate with UNIX administrators and management team for space management, problem resolution, capacity planning, software version control, evaluation and support on various servers.
- Established standby/cloned database via DataGuard for Database Disaster Recovery
- Employed predefined UNIX scripts to clean up database files such as outdated archived redo logs and trace files out of bdump, udump and audit directories.
- Trouble shoot and Configured Sql*Net files according to client and server settings to transfer data.
- Worked on export/import, data pump and SQL Loader.
- Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.
- Experience in conversion of Single Node Instance to multimode RAC with ASM, and adding instance to existing RAC.
- Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.
- Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).
- Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.
- Experience in maintaining DataGuard to provide high availability by implementing physical standby database and snapshot standby and worked with Oracle 11g features, 11g Grid Control.
- Data warehouse analysis and design for diverse legacy system integration.
- Process/workflow analysis, project management from analysis and design for implementation.
- Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
- 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
- Oracle GOLDEN GATE for data sharing using EXTRACT, REPLICAT, DATAPUMP, MANAGER PREOCESS for Bidirectional, unidirectional, Broadcasting and consolidation topologies.
- Installed and configure OEM(oracle enterprise manager) 10g to 13c in heterogeneous environment
TECHNICAL SKILLS:
RDBMS: Oracle 8i/9i/10g/11g/12c.
LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting
SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus
TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM
WEB TOOLS: HTML, XML
PERSONAL SKILLS:
- Very good Communication Skills.
- Working as a member in a team work.
- Ability to work under pressure.
- Time Management.
- Self - learning
PROFESSIONAL EXPERIENCE:
Confidential, COLUMBIA, MO
Oracle RAC DBA/production support
Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12c
Responsibilities:
- Primary DBA for 300+ databases of Oracle and some Sql Server 10g/11gR2 and ORACLE STREAMS, RAC administration on Linux REHL, HP-UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.
- Perform schema refreshes on SQL SERVER, creating users and granting privileges
- RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM. Trouble-shoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.
- Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
- Data guard - configure primary -standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archive logs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.
- Managed Container and pluggable databases
- Cloned 12c database
- Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog , performed complete and incomplete recovery using RMAN.
- Installation of 3 nodes 10g RAC on Linux & Solaris with veritas cluster. Configured ASM, OCFS and RAW devices. Troubleshooting & tracing of RAC processes & CRS components. Relocate service. Tuning of RAC environment. Managing fail-over of instances. Resource utilization on each node. Monitor top objects in cache fusion and traffic.
- Backup by RMAN and data pump. Consistent backup using data pump. Diagnose and repair block level corruption using RMAN. Script and test RMAN backup/restore. Optimizing backup by compressing. Troubleshooting RMAN restore. Used RMAN convert command to transfer datafile from ASM. Duplicate database on remote host using 11g active database command. Hands on Varitas NetBackup. Flashback database.
- Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code which are high intensive resources. Tuning instance by init parameter. Used explain plan and stats pack/TKPROF utility to Improve response time of query. Create/manage local partitioned and bit-map indexes.
- Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
- Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.
- Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
- Migrated VLDB multi terabyte databases around 10TB and redesigned the RMAN backup Strategy.
- Oracle GOLDEN GATE for data sharing using EXTRACT, REPLICAT, DATAPUMP, MANAGER PREOCESS for Bidirectional, unidirectional, Broadcasting and consolidation topologies
- Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
- Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid ControlExtensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tunig Automation, Flashback Database, compression techniques and several others
- Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
- Configuration and implementation of Oracle RAC for high availability.
- Migrated databases from single instance environment to RAC
- Migrating databases from file system to ASM and OCFS
- Implemented downstream capture at the destination database using Oracle Streams.
- Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.
- Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
- Extensively implemented Datapump, conventionalExport/Import (Oracle 11g, 10g) for migration and logical backup of database.
- Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
- Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK,TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
- Experienced in configuration of ASM for RAC and NON- RAC environments.
- Configured Repository and clients for GRID Control and also implemented DB Control for some databases.
- Supported& maintained the Production/Development databases on various servers
- Extensively worked on setting up auditing in many databases we supported
- Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
- Installed ASM environment and migrated databases from NON-ASM to ASM.
- Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12cGrid Control.