Engineer Data

SAVITHA

Phone: 919-***-****

Email: ******.**********@*****.***

Summary

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

Work Experience

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

Responsibilities:

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

SYSTEM ENGINEER

Infosys Ltd (Client: Pfizer) –May 2012 to July 2014

Responsibilities:

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

Educational Qualifications

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

Contact this candidate