Candidates About

           Thrilok Muli                                                                                                                                                                                                                                            

Over 8 years of professional experience as an Oracle Database Administrator having hands on experience in database administration production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation, Setting up and configuring Data Guard, Replications using GoldenGate on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.

SUMMARY OF EXPERIENCE:

·         As Oracle DBA, closely work with Business stakeholders and provide consultative and technical support services for all major database development and system integration tasks including test strategy, version upgrade, migration, performance tuning, space management, implementation of backup and recovery strategy.

·         Gathering and analyzing customer’s technical requirements, development, management, maintenance and production support projects of Oracle Database on platforms like UNIX/LINUX (Sun Solaris, HP-UX, AIX, Red Hat Linux) and Windows. 

·         Good experience in administration, installation, configuration and upgrades of Oracle 12C, 11gR2, 10g and 9i databases including applying patches under Linux, HP-Unix, IBM-AIX and Windows platforms.

·         In-depth knowledge of Advanced Replication (GoldenGate, Oracle Streams), High Availability (RAC) and Disaster Recovery (Data Guard) solutions for business critical applications.

·         Expert knowledge on Oracle tools like oracle migration utility, OEM Grid control (11g and 12c), AWR, Oracle Advisors.

·         Expertise in using oracle Export/import, Data Pump utility to migrate data across schemas.

·         Diagnosed and tuned the latest Integrated Extract, available since release 11.2.0.4 of the Oracle RDBMS, and Integrated Replicat, available since release 12c of the Oracle RDBMS.

·         System administration, Oracle Problem analysis & resolution and active cloning of databases between servers.

·         Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).

·         Proficient with Tuning, SGA, Buffer Cache, Rollback Segments, and Redo Mechanisms.

·         Experience in SQL Tuning, SQL Optimization, cost based optimization and Hints.

·         Strong project implementation using the Oracle Spatial technology.

·         Monitored and Detected Alert Log Files, Redo Log status, Listener Log, trace files for the database. 

·         Experience in Configuring Automatic Storage Management (ASM).

·         Experience in Real Application Cluster environment (RAC) on ASM.

·         Management of Objects, Schemas, Partitioning the tables and Indexes and administration of RAC and DATA GUARD databases in Oracle 11g.

·         First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.

·         Daily health checkup of databases.

·         Experience with Oracle in Healthcare, Financial and Banking industries in both Business Intelligence/Data ware house Systems and OLTP Systems.

·         Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views. 

·         Proficient in raising Oracle Service Request with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.

·         Participate in planning strategies for future database needs for business needs in perspective of capacity planning, performance and available technology. 

·         Migrated databases and upgraded the versions from SQL Server 2005 to 2008

·         Provides ongoing support for MySQL SERVER database servers for systems, which include creation, configuration, maintenance and upgrade. 

·         Strong technical and interpersonal skills combined with great commitment towards meeting deadlines.

·         Experience working in both team and individual environments. Always eager to learn new technologies and implement them in challenging environment.

EXPERTISE

PROFESSIONAL EXPERIENCE:

Sr Oracle DBA                                                                                                     Aug 2015 – Till Date

Performed the role of Sr. DBA / Project Coordinator and successfully implemented critical hands-on technical solutions.

Key Projects:

·         Supported production and development environments for business critical application (2-node RAC, GoldenGate, Data Guard Physical Standby architecture, OEM).

·         Upgrading 11g databases to 12c version of Oracle software.

Details:

·         Upgraded 11g to 12c and Installed Oracle software, installed Oracle RAC on 12c clusters in 2-node configurations, created databases. Created database services for different applications and added nodes to the cluster. Applied rolling patches to fix known bugs as well as PSU and Migrated Grid and database software to higher version.

·         Applied Patching and Upgraded Oracle databases from 11.2.0.4 to 12.1.0.2 and performed cross platform Migration from Solaris to Linux as apart of datacenter migration using GoldenGate and data pump with Zero downtime.

·         Pre-Patch analysis, applying patching in test/development instance

·         Extensive experience in Patching, applying minimum baseline patches for 12c

·         Installed OEM 13c agents and checked database performance and made necessary changes to optimize performance. Install Oracle Agent for Grid Control Monitoring. Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM 

·         Checked health of cell servers, worked with Oracle field engineer to replace failed disks on cell servers.

·         First hands-on skills about Exadata hardware architecture including Storage, Grid and Infiniband.

·         Experience on Exadata features including Data Masking, HCC (Hybrid Columnar Compression), Transparent Data Encryption(TDE), Oracle Audit Vault, Smart Scan, Smart Flash Cache, Storage Index and Storage Management. 

·         Worked with Oracle Support to upgrade Grid and RDBMS software on Exadata half-rack machine.

·         Support both the Database and Storage servers in the Exadata database machine including upgrades and patching.

·         Developed golden gate scripts to achieve zero downtime production migration of mission critical systems to oracle Exadata database machine.

·         Installed GoldenGate software 11g/12c. Configured extract, data pump and replicat processes for single master and multi-master architectures. Performed initial data load into the target database. Added tables to the replication. Included/excluded DDL statements to be propagated to the target to maintain necessary level of replication. Maintained replication, troubleshoot and fixed problems with abended processes. Configured GoldenGate as CRS resource to provide uninterrupted service in case of RAC instance/ node failure. 

·         Monitoring and Performance tuning of GoldenGate sessions at OS level, Database level and GGSCI level and investigate replication failures using ggserr.log, report files and Logdump utility and developed scripts for GoldenGate failover.

·         Performed cross platform Migration from Solaris to Linux as apart of datacenter migration using GoldenGate with Zero downtime.

·         Used GGSCI commands for gathering process evidence. Troubleshoot problems in areas such as extraction, replication, missed transactions, mapping, synchronization, SQLEXEC and file maintenance by using tools like Knowledge Documents, Documentation, SHOWSYNTAX parameter and the Logdump utility.

·         Diagnosed and tuned the latest Integrated Extract, available since release 11.2.0.4 of the Oracle RDBMS, and Integrated Replicat, available since release 12c of the Oracle RDBMS.

·         Configured Data Guard configurations using physical Standby architecture utilizing Data Guard broker with fast-start failover and Observer. Tested different failover scenarios. Troubleshot and resolved issues.

·         Worked on Snapshot standby and coordinated Application testing. Involved in converting physical to snapshot standby, and back to physical standby as per business requirement and also Active Data Guard

·         Performed Zero Downtime Database Data Center Migration using GoldenGate and Data Guard.

·         Configured RMAN backups using Net backup and DDBoost. Restored and recovered databases to resume service as well as to create test environments for dev/app teams.

·         Administration of Backup and Recovery using RMAN. Management of backup pieces and backup sets using RMAN.

·         Created Oracle Tables, Table Partitions, Views, and Materialized Views and automated Statspack/AWR reports.

·         Implements, administers, manages, monitors, and tunes the assigned application databases in development, pre-production and production environments.

·         Worked as a part of AWS team. Launching and configuring of Amazon EC2(AWS) cloud servers using AWI's (Linux/Ubuntu) and configuring the servers for specified applications.

·         Migrate databases from on-premises to AWS cloud with zero downtime by using Data pump and GoldenGate.

·         Administered in Prod, Qual, Test and Development regions. Produced and analyzed performance reports

·         Generated Statspack/AWR reports from Oracle 11g/12c databases and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database performance and

·         Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statement.

·         Designs and implements performance tuning improvements of oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor and advises developers on tuning options. Ensures that data integrity and data security is maintained. Demonstrates advanced troubleshooting and analytical skills through problem resolution.

Environment: Sun Solaris, Linux, Oracle 11g and 12c, RAC, Exadata, GoldenGate, Data Guard, OEM, AWS RDS, EC2, Informatica, Cognos, SQL 2012, PL/SQL, SQL*PLUS, SQL*Loader, Korn, TOAD, Materialized Views 

Senior Oracle DBA                                                                                                           Dec 2013 – Jun 2015

Provided Production Support along with DBA-Architect and Project Management.

Key Projects:

·         Supported pre-production and post-production support to the client during development phase of the system covering environments for 3-node RAC with multiple databases (Oracle 11gR2), Data Guard, GoldenGate, OEM 12c.

·         Support to staging/production setup, Performance tuning.

Details:

·         Architected, Designed, Installed and configured a 3-node RAC Database on Solaris 11, and Linux platforms. Ensure technical documentation is kept up to date (architecture/integration diagrams and documentation)

·         Maintained OEM 12c by Installing and configuring OEM agents and monitored them timely. Supported production, QA and development databases. Monthly, Weekly and daily report generation using AWR and ADDM. Observed AWR and ADDM reports on regular basis and made necessary changes to database's parameters. Worked with developers to tune SQL queries to optimize performance. Implemented production database security to restrict access thru SQL*Plus and Toad to unprivileged users.

·         First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.

·         Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.

·         Extensive experience in Patching, applying minimum baseline patches for 11g and applied Oracle security patches to Oracle 11GR2 databases.

·         Pre-Patch analysis, applying patching in test/development instance

·         Participated in re-design of the existing database environment to move database to more powerful servers. Was one of the major database resources during testing and production cutover.

·         Setup Data Guard for 11g production databases to provide the DR capability. Performed critical Data Guard Recoveries for VLDB database for missing Archive Logs. Performed Data Guard Role Transition for Switchover and Switchback. Successfully implemented Transparent Application Failover (TAF) For Data Guard Connections using Database Services. 

·         Experience on Oracle GoldenGate for data replication for enterprise data centers including 
installation, configuration, administration, performance monitoring. Troubleshot and fixed problems with excessive lagging and abend processes. 

·         Configured GoldenGate BI-DIRECTIONAL replication and replicated tables between instances and used CDR parameters to resolve conflicts and applied business rules in environment. GoldenGate Downstream capture setup and Performance tuning of GoldenGate processes to achieve zero lag time. Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM and OEM.

·         System administration, Oracle Problem analysis & resolution and active cloning of databases between servers.

·         Utilized Oracle 11g Real Application Testing feature (RAT) to capture application workload in production database, move it to staging environment and replay there. Utilized SQL Performance Analyzer (SPA) to compare database performance before and after changes.

·         Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views. 

·         Developed both database and OS-level security policies for data protection and having good experience in Working with Oracle security, Transparent Data Encryption, Oracle Wallet Management and Oracle Identity management.

·         Worked with Informatica team for performing GoldenGate Initial loads.

<span style="font-size:9pt;fon