Telkar Anil Kumar
Having 5 years of experience as an Oracle Database Administrator with exposure on Production Systems Analysis, Design, Development, Implementation and Testing of Relational Database Management Systems for Business Solutions.
Experience in Administration activities such as Installation, Configuration, Client/server connectivity, Creating and Managing Repositories, Users, User Groups, Folders, User Roles, Profiles and Privileges.
Experience on creation and implementation of Backup and Recovery methods and disaster recovery methods using RMAN, logical, hot backups, Flashback Recovery and performed full, incremental and Cumulative backups using RMAN.
Extensive experience in Application Development, Database development and 24x7 production system support handling large databases using Oracle 12c, 11g, 10g, 9i on various platforms like AIX, Solaris, Red hat EL, UNIX and Windows.
Experience in Configuring Single Instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
Strong skills in Data Guard management, ASM and Oracle RAC for providing critical solutions.
Experience in upgrading RAC and standalone databases from 10gR2 to 11gR1 and from 11gR1 to 11gR2 and from 11gR2 to 12c in production and non-production environments.
Effective volume management using Oracle Automatic Storage Management (ASM).
Experience in providing Level-1, Level-2 support for the database issues.
Experience in configuring and managing GoldenGate on multi-node RAC environment.
Experience in capacity planning, space management, Rollback segments and Undo segments.
Experience in using 11g advanced features like Active Database Duplication in instantiating the standby database from Primary.
Experience in using Flashback feature of Guaranteed Restore point for application to perform testing or to perform large schema exports without impacting Mission Critical Primary databases.
Experience in implementing Oracle TDE to protect data at the operating system level.
Experience on Performance Tuning – proactive and reactive for optimal performance to meet Business SLA*s. Database performance tuning (Oracle 9i, 10g, 11g), SQL tuning (using AWR report, SQL Turning Advisor, v$ tables, ASH, ADDM report, OEM).
Export and Import of database objects using Data pump utilities EXPDP and IMPDP.
Experience in partitioning the tables to improve the performance.
Experience in configuring and performing Switchover using Active Data-guard.
Experience in shell scripting and scheduling jobs using crontab utility.
Configuration of TNSNAMES.ora, LISTENER.ora for SQL*NET connectivity and resolving connection problems.
Strong skills in Database Management tools like Grid and OEM.
Experience in cloning the databases on various platforms.
Experience in creating the database using DBCA for Oracle 9i, Oracle 10g and Oracle 11g/12C.
Possess technical ability and self-initiative to learn and implement new concepts in short duration.
A very good team player, self motivated, dedicated in any work environment with 24x7 support.
Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
Excellent communication, documentation and coordination skills.
Master of Computer Application
Databases : Oracle 12c/11g/10g/9i/8i, SQL Server 2008 R2/2012
Oracle High Availability : Data Guard, ASM, 10G/11G RAC
Oracle Tools : SQL* Plus
Oracle Utilities : RMAN, Expdp/Impdp, SQL* Loader, Crontab
Operating Systems : RHEL/OEL/Solaris/AIX/Windows
Languages : SQL, PL/SQL & Visual basic
Scripting Languages : Shell Scripting
Other Tools : MS-Office, TOAD, SQL-Devloper, Erwin
Client : AT & T
Position : Oracle DBA
Duration : Nov’12-Present
Location : Richardson Tx
Responsible in providing 24*7 On call support for Production Databases.
Responsible in managing large-scale OLTP databases 6+TB size in HA and DR setup.
Installed and configured 4 node Oracle 11gR2 RAC for production environments.
Installed and configured 11g and 12c Databases and responsible for upgrading 11g RAC to 12c RAC on Linux/Solaris/AIX.
Involved in migrating production databases on single instances to RAC environments.
Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard.
Responsible in configuring, managing and monitoring Physical standby database using Data Guard and have hands on experience on Active Dataguard.
Performed planned switchover and failover to physical standby database with and without Data Guard Broker to verify availability status.
Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 12c) for migration and logical backup of database.
Responsible in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import allowing users to quickly move a user Tablespace across Oracle databases.
Responsible for Creating Users, Roles, Profiles and assigning the users to roles and grant necessary privileges to the relevant roles.
Managing Security Management, Schema Management, Instance Management, Storage/Space Management.
Configured data replication over DB links for maintaining the data consistency across multiple databases using datapump.
Performed Oracle database migrations, upgrades, applying patch sets, database releases and code deployments.
Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
Performed RMAN database cloning with ACTIVE duplication.
Performed FLASHBACK features to handle efficient database recovery.
Performed database monitoring activities using Oracle Enterprise Manager (OEM) and TOAD.
Administrating RAC Databases using SRVCTL, CRSCTL.
Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD.
Experienced in performance monitoring/tuning/troubleshooting.
Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, SQL TRACE, SQL Tuning Advisor.
Experience in system Monitoring and Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
Responsible in tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF.
Daily Health Check Up of the Databases and applications.
Enforced corporate business rules through adequate user/resource/object management.
Security implementation through basic and advanced security techniques like applying recent patches and upgrades, appropriate user grants, permissions and profile management.
Detailed analysis of the business and users requirements by doing various information-gathering techniques.
Environment: ORACLE 11g/12c, LINUX/SOLARIS/AIX, RAC, ASM, DATAGUARD, RMAN, EMPDP/IMPDP, PL/SQL, FLASH BACK, AWR, ADDM