Database Administrator Administration
Resume:
Telkar Anil Kumar phno:789-***-****
ORACLE AND Azure DBA consultant email:**********@*****.***
Summary : 10+ years of experience as a Database Administrator (DBA) with extensive experience in database administration, performance tuning, testing and supporting next-generation database high availability solutions in 24x7 Oracle enterprise environments. Proficient in an assortment of technologies, including Oracle 10g/11g, Windows Platforms, and Red Hat Linux.
Skills : Windows XP, Windows 2003 Server, Red Hat Linux 5.4 Virtual Machine: Oracle VM VirtualBox 4.2.6 Tuning Utilities: SQL Trace, TKPROF, Explain Plan, ADDM, AWR, ASH, ADRCI Backup Tools: RMAN, Cold, Database Management, Microsoft Administration, and Linux Systems Administration.
Description :
Expertise in Oracle Data Guard and standby databases and creation
Expertise in Oracle Enterprise Manager grid control (OEM), TOAD,
Experience in Logical and Physical Design of Databases for OLTP and Data Warehouse.
Expertise in handling Very Large Database (VLDB) and OLTP environment.
Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database Tuning – Tuning Applications, Tuning Memory, Tuning Disk Usage, Tuning OS
Experience in Oracle 11g/10g – Installation, Migration and implemented new features.
Experience in capacity planning, space management, database upgrades/migration
Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN
Creating and managing access privileges using roles, controlling access to the database using operating system and Oracle security features.
Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
Installing & configuring Oracle cluster ware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole Administering database security by creating user logins to different project staff with appropriate roles, monitoring the user accounts, created groups and granted privileges to users.
Monitoring and executing RMAN backup and recovery, flashback technology, hot/cold backups, archived redo log files and fast recovering area (fra).
Performing day-to-day activities: such as daily error checks and database health monitoring of physical resources (disk space, memory, CPU, etc. ) and performance parameters adjustment as needed.
Utilizing RMAN to perform weekly level 0 full backups and daily cumulative incremental level 1 backup.
Configuring oracle enterprise manager (OEM) to schedule automatic backups.
Involving in database backup and disaster recovery strategies using RMAN and data guard.
Providing logical backup of data using oracle data pump utilities (EXPDP and IMPDP) to transfer data from a database or schema to another.
Performing database refreshes, cloning, and duplication from one oracle database to the other.
General database administration including management of instances, redo logs, tablespaces, temp space, rollback/undo segments and schema management.
Coordinating with engineering and database architects in analyzing automated workload repository (AWR) reports and ADR diagnostic utility to improve database response times.
Professional Experience:
Working as a Software Consultant in Neudesic technology, Hyd from Mar 2022 to present.
Worked as a Oracle Dba in Accion labs,Hyd from Jun 2020 to Feb 2022.
Worked as a Oracle Consultant in Humint global, Hyd from July 2019 to Jun 2020.
Worked as a Database Administrator in siebrains techonologies,Hyd from Jan,2019 to July,2019.
Worked as a Software Engineer in Techmahindra, Pune from Nov 2012 to Apr 2018.
Projects:-
Present Client:- The Brock Group Company: Neudesic Technologies
Expertise in Oracle Data Guard and standby databases and creation
Expertise in Oracle Enterprise Manager grid control (OEM), TOAD,
Experience in Logical and Physical Design of Databases for OLTP and Data Warehouse.
Expertise in handling Very Large Database (VLDB) and OLTP environment.
Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database Tuning – Tuning Applications, Tuning Memory, Tuning Disk Usage, Tuning OS
Experience in Oracle 11g/10g – Installation, Migration and implemented new features.
Experience in capacity planning, space management, database upgrades/migration
Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN
Creating and managing access privileges using roles, controlling access to the database using operating system and Oracle security features.
Having experience in configuring Virtual machines using Azure portal.
Having experience in creating the alerts for VMs using Azure Portal.
Reviewing the Activity logs and troubleshooting the errors.
Having knowledge on configuring managed disks and unmanaged disks in Azure.
Configured Log Analytics for Virtual Machines and SQL AZURE Pass databases.
Client: AT & T Company:Accion labs
Database administration, managing tablespaces, objects.
Configuring archive log mode for Database. Generated Test Results in a formal Analysis Report according to documentation standards.
Managing redo logs, checking alert log and trace files for errors.
Suggesting Improvement areas in terms of Functionality enhancements.
To take Daily Backup, Disk Space management and user management.
Analyzed and rebuilt backup and recovery strategy.
Tuned Server Parameters and some applications to improve performance.
Creation, scheduling of snapshots, generating reports.
Population of the MIS tables using External Tables.
Review and modification of SQL queries for performance enhancement.
Assisting in the administration, and day-to-day operations of different Database, altering database and provide user support.
Taking backups, disk space/ user management along with security management and ensuring scheduled/unscheduled Backups as per backup plan and restoration.
Installation, configuration and troubleshooting the Oracle RDBMS in UNIX as well as Windows NT environment.
Designing, creating, operating, maintaining, troubleshooting & Administration of Oracle Application & databases
Installation, configuration and troubleshooting the Oracle Real Applications Cluster in UNIX as well as Windows NT environment.
Planning and performing offline as well as online backups.
Client: Franklin Templeton Company:Humint Global
Standby Database administration, managing tablespaces, objects.
Bringing databases in sync
Verifying the reports of 10 databases.
Using STATSPACK for performance reports.
To take Daily Backup, Disk Space management and user management.
Analyzed and rebuilt backup and recovery strategy.
Taking logical backup.
Review and modification of SQL queries for performance enhancement.
Assisting in the administration, and day-to-day operations of different Database, altering database and provide user support
Installation, configuration and troubleshooting the Oracle RDBMS in UNIX as well as Windows NT environment.
Client: NTT DATA Company: Sie brains Technologies
Review and modification of SQL queries for performance enhancement.
Assisting in the administration, and day-to-day operations of different Database, altering database and provide user support
Installation, configuration and troubleshooting the Oracle RDBMS in UNIX as well as Windows NT environment.
Review and modification of SQL queries for performance enhancement.
Assisting in the administration, and day-to-day operations of different Database, altering database and provide user support
Standby Database administration, managing tablespaces, objects.
Bringing databases in sync
Verifying the reports of 10 databases.
Using STATSPACK for performance reports.
To take Daily Backup, Disk Space management and user management.
Analyzed and rebuilt backup and recovery strategy.
Taking logical backup.
Client: AT & T Company: TECH Mahindra
Database administration, managing tablespaces, objects.
Configuring archive log mode for Database. Generated Test Results in a formal Analysis Report according to documentation standards.
Managing redo logs, checking alert log and trace files for errors.
To take Daily Backup, Disk Space management and user management.
Analyzed and rebuilt backup and recovery strategy.
Tuned Server Parameters and some applications to improve performance.
Creation, scheduling of snapshots, generating reports.
Review and modification of SQL queries for performance enhancement.
Assisting in the administration, and day-to-day operations of different Database, altering database and provide user support.
Taking backups, disk space/ user management along with security management and ensuring scheduled/unscheduled Backups as per backup plan and restoration.
Weekly and monthly Status reports preparation
Proficient in performance tuning of single instance and clustered database (OPS/RAC)
Application and database upgrades
Strategy planning and development of automated Backup & Recovery solution on Oracle 10g
Maintained standby solution for the Oracle9i system on the production database support.
Disk Space management and user management.
RAC Database has been implemented over ISCSI with storage capacity 1TB.
Installed red Hat Linux ES4.0 on both the nodes after creating necessary
Installed Oracle 10.2.0.1 CRS (Cluster Reddy Service) in first phase of Installation to provide High availability.
Using Virtual Internet Protocol Configuration Assistant (VIPCA) Configured virtual IPs
Installed RDBMS Software for creation of Database in Second Phase of Installation.
Created ASM Instance to Access the Raw Partitions form the Oracle database.
Enabling the Second Node and putting the database in archive log mode. Created redo log Thread and undo tablespaces for second node.
Configured Recovery Manager (RMAN) for Backing up.
Certifications:
Oracle autonomous certification.
Azure 900 certification.
Education:-
Completed Master of Computer Application from JNTU Hyd University.
Completed Bachelor of Computer Science from Osamania University.
Contact this candidate