MS graduate with 4+ years of experience in Oracle/SQL Database Administration, PHP, JAVA, MYSQL
Over 4+ years of experience as an Oracle Database Exadata Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery (RMAN), cloning, space management, database security, migration and documentation.
Experienced in working on Data Guard, RAC, ASM, OEM Grid Control and Golden Gate.
Worked on variety of environments like HP-UX, SUN SOLARIS, AIX, Red Hat Linux and Windows for Oracle Database Administration.
End to end support for Production Databases ((9i/10g/11g/12C/13C) managing databases up to 15+ TB as well supporting Databases on Development, Testing, Staging & UAT.
Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNS Names, V$ and DBA.
Experience in Installation and Maintenance of RAC on 10g and 11g R2 on Red Hat and Oracle Enterprise Linux with ASM and non-ASM.
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. Benchmarking of clustered database.
Migrated existing databases into RAC configuration.
Experience in data loading utilities like SQL*LOADER, Logical backups using full export, import and DATA PUMP.
Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATA GUARD.
Experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
Implemented RMAN backup (Full, incremental and cumulative) and Incomplete recovery and disaster recovery using Standby database or Data Guard.
Implemented automated backup strategy using the UNIX shell script.
Involved in applying the CPU and PSU patches in non-prod and prod environments.
Experienced in Python with Machine Learning Techniques
RESEARCH ASSISTANT, UNCG- Aug18 to Present
Analyzed the riskiness of patients using electronic patient record and doctor notes using Machine Learning techniques and Python programming language
Online Book Store: Created web pages for all activities included in purchasing books using languages PHP and HTML and using MYSQL databases to store and fetch data
Simulation of TCP/IP Layers: Created a TCP/IP Layers(Computer Network) simulation using JAVA and JAVAFX as the ball moves from Application layer to the Physical Layer
Assignment Management: Using JAVA and POSTGRESQL, created multiple pages where the assignment can be uploaded, submitted and graded through different accounts as student, teacher and grader
SENIOR SYSTEM ENGINEER
Infosys Ltd (client: Pfizer)– July 2014 to Nov 2016
Experienced in Oracle Real Application Clusters(RAC), Automatic Storage Management(ASM)
Experienced in handling in large amount communicated/shared data across several entities in LINUX and Unix database environments
Designed schemas for OLTP and OLAP databases using MySQL and Oracle database solutions. Experienced in Data Integration, data movement.
Managed and created Oracle large-size databases manually and through DBCA
Installed Oracle Home, Agent and Client software as required
Managed Listeners, registered Databases to OID
Managed user Accounts: Creation of database users, default table spaces and temporary table spaces: Assigned quotas, roles, privileges and profile to users
Managed creation of database objects like table, views, indexes etc.
Maintained multiple Database Instances running on Windows environments
Managed and monitored the Tablespaces and Data files Growth
Set Blackout during Database level activities
Analysed Tables & Schemas, collected System Statistics, and rebuilt Indexes
Deployed database objects between developments, QA, production, monitor storage, backup database tables with data and structures for selected schemes
Performed Trouble shooting and provided continuous support in the production environment
Handled Space alerts, Performance tuning, MEDIUM/HIGH/CRITICAL priority incidents for mission critical servers
Performed Database schema retirement and Database retirement
Worked with services and tools like HP Service Centre ticketing tool, TOAD, Oracle Meta link
Infosys Ltd (Client: Pfizer) –May 2012 to July 2014
Responsible for Complete range of Oracle DBA activities including Day-to-Day Production Database Monitoring, Backup & Recovery using RMAN, Troubleshooting production issues, Performance Tuning
Experienced in supporting Production environments (24/7) for Oracle 9i/10g/11g Databases on multiple platforms like UNIX, Linux, Windows and Solaris
Experienced in Database administration, co-ordination with software development team, project implementation and technical support
Experienced in handling outages over weekends and setting the blackouts for agent and handling alerts monitoring through OEM and changing memory parameters with outage and without outage in the databases
Provided extensive support for Application Development Team for resolving the issues concerning the databases in Oracle
Experienced in working with transactional logs, recovery models in Microsoft SQL server
Retired Databases\Instances\SQL server from standalone and cluster servers
Experienced in Database creations and monitoring the server health
Created backup plans for user defined and system databases
Performed Database backup and restoration activities
Configured alerts for disk space, database size, log and data file growth using site scope monitoring tool
Provided access to user, database roles and database object level
Performed Table\Schema\Database refresh using Import\Export Wizard
Deploying and executing SSIS packages using integration services
Implemented Log shipping, mirroring
Master’s graduate in Computer Science (Tentative 2019) from UNIVERSITY OF NORTH CAROLINA GREENSBORO
Bachelor’s Degree in Computer Science Engineering (2012) JNT UNIVERSITY, Hyderabad, India