srikanth-2015_resume
- 1. 1 NAME: SRIKANTH MOBILE: 8050186579 MAIL ID : srikanthoracledba2015@gmail.com To associate myself with professionally driven esteemedorganization by pursuing, challenging, dynamic, responsible role. I wish to use my skills and be a part of a team that helps achieve the organization's success. Having 3+ years of experience as an Oracle Database Administrator Extensive Knowledge on Oracle Architecture Familiar with Table space level issues and User level issues. User management and providing security to the databases. Experience in handling production database support and maintenance as well. Excellent Team player with good communication. Experience in installing different versions of Oracle on Linux and OEL Taking scheduled backup as per backup strategy using RMAN. Experience in working with ASM Switchover, Failover, Activating the Standby to Primary and No data loss & Monitoring the DR Site Configured and maintaining RMAN to take backup of the Oracle databases Experience in taking regular off-line, on-line and logical Backup Experience in Flashback a Database Experience in Backups like Logical Backups(Exp,Imp,DataPump). Experience in Offline and Online backup. Monitoring performance using AWR Reports Installed 2 node 10g RAC using RAW devices and ASM. Installed 2 Node RAC using Ocfs2 and ASM lib(on RHEL AS4) B-Tech (CSE) from Sana Engineering College in 2012 Currently Working as Oracle DBA in Tata ConsultancyServices, Bangalore OperatingSystem : RHEL, OEL, OfficeSuite : Microsoft Word, Excel, Power Point Objective Technical Skill Set Professional Summary Educational Qualification Work Experience
- 2. 2 Database : Oracle 10g/11g Programming Language : SQ Project 2: Client Northern Bank Role Oracle Database Administrator Organisation Tata ConsultancyServices Duration Jan 2014 to till date Environment OEL 5.5, RHEL 4, Oracle 10g, Oracle 11g. Description: Northern Bank offers a full range of financial products and services, which are designed for the needs of both business and personal banking customers. For making better business strategies and decisions, and to have an edge over its competitors this bank wants a Data Warehouse for the better decision-making purpose. Roles and Responsibilities:- Interacting with client and team to resolve queries Resolving user’s day-to-day issues. Resolving the tickets. RMAN Backup validations which was scheduled. Generating AWR Report for database performance Health Check. Performed DatabaseCloning and refresh on to Test environment Understanding execution plan of top sql statements by using Explain plan,Auto trace and Tkprof Patched and upgraded from 11.2.0.2 databaseto 11.2.0.3. Monitoring and optimizing the performance of the Database through AWR. Configured Data guard for production Database Incorporating user’s requests as per mails. Allocating and reorganization of table spaces Backing up database using export/import. Maintenance and monitoring of Database and Listener. User creation and providing necessary Roles, Privileges and quota as per the Requirement Installed & configured 2-Node RAC using OCFS as cluster file system and ASM lib. Administrating and maintain existing 2 node 10g RAC production environments. Troubleshooting day to day issues in RAC environment . Professional Profile
- 3. 3 Monitoring various database activities like number of users, memory usage, alert log file, trace files Monitoring the ASM Disk Groups. Performed INDEX rebuilding. Project 1: Client JP Morgan BANK Role Junior Oracle Database Administrator Organisation cognizanttechnology solutions Duration July 2012-Dec 2013 Environment OEL 5.5, RHEL 4, Oracle 10g, Oracle 11g. Description: As per Banking Domain below process needs to be follow as part of Oracle Project Team With the IDP doc all stock holders have a meeting (bridge) about first PEW(Program estimation work station),Based on the requirement every team has to be prepare their own workbooks and In second PEW Project can review the workbooks, For Oracle builds & DBA related workbooks singed off by Tower Lead, As per the Project SLA time lines work have been assigined by Project manager. If anything needs to be change in production, project team needs to raise a CMR(change management request) and then according DBA could raise the Break Glass Request(oracle password) after all testing done by lower Environments. Roles and Responsibilities:- CreatedTablespaces ,Datafilesand adding,resizing of datafiles Tablespace reorganization and management. Created Users and giving roles,profiles and privilages to users. Monitoring and performing daily incremental backups, weekly backups using RMAN Monitoring Alert logs for any errors, problems or processes running Taking the backup of the database regularly using Logical, Cold and Hot Backups Resolving Tickets Coordinating With team and resolving User level issues Managing undo tablespaces, temporary tablespaces, and redo log groups Check the performance of the database and tune as when requires using tools AWR, Explain Plan Performed Schema Management, Index rebuilding, Analyzing the tables and indexes.
- 4. 4