Sr Oracle DBA

Sandeep Nelluri

Sr. Oracle Database Administrator

Email: **************.***@*****.*** Contact: 925-***-****

Professional Experience:

Database administrator (DBA) with extensive 8 years of focused experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, database security,cloning, migration, shell scripting and documentation, 12c Cloud Control, setting up and configuring Data-guard, RMAN, RAC, Replications using Golden gate in high-availability environments.

DBA skills include:

Oracle RAC & ASM Administration/Installation

Oracle Forms and Reports Development

Oracle 10g/11g/12c Database Administration

Performance Tuning & Capacity Monitoring

Standby/Failover Administration

Database-Backed Web Solutions

SQL Tuning in an Oracle Environment

Data Security, Backup & Recovery

Experienced and proficient in technologies like RDBMS 9i/10g/11g/12c, Performance Tuning, Dataguard, Partitioning, RAC, ASM, RMAN, SQL Query Tuning and DB Upgrades.

Installation, Upgradation, Migration, Patches and Maintenance of very large Oracle databases (12c, 11g RAC, 10g) on Linux, Solaris, AIX and HP-UX.

Experience in Planning and Implementation of Datacenter migration project.

Experience in 24x7 On-Call DBA support for production and other environments.

Implementation of Oracle Dataguard, and replicationPlanning, documenting and implementing Disaster Recovery(DR) strategy for Oracle databases

Experience in managing Terabytes of data and tables with millions of rows and Proficient in performance tuning and maintaining of large volume of data

Having good experience in configuring OEM 12C cloud control and monitoring databases using OEM 10g/11g/12c.

Experience using enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging.

Experience in configuring and managing Golden Gate on multi-node RAC environment.

Experience in performing History pull to synch-up data between Oracle to Non-Oracle databases using Golden Gate.

Experience in setting up DDL/Bi-directional replication between source and target databases using Golden Gate and Experience in configuring Integrated Extract and Co-ordinated Replicat after upgrading Golden gate software to 12.1

Excellent command in creating Backup & Recovery procedures and implementing BACKUP and RECOVERY strategies for off-line and on-line backups.

Hands on experience of database Backup and Recovery using RMAN, Export/Import and Datapump.

Strong experience in ASM, Oracle Data Guard, SQL* Net, SQL * Loader and SQL*PLUS, STATSPACK, SQL developer, AWR, ADDM and TOAD.

Proficient in writing UNIX Shell scripts to automate business process and backups.

Experience in application tuning using Statspack, AWR, ASH and ADDM.

Have exposure in a variety of environments like Windows XP, Solaris, Red-hat Enterprise Linux

Successfully implemented migration of Databases and Applications across data centers.

Performed instance migration across platforms and DB upgrade from 10.2 to 11gR2 and 11gR2 to 12c

Proactive Monitoring to identify areas that needs to be modified to improve performance in the application and database using Foglight, Toad, in-house developed scripts etc.

Generated AWR reports from Oracle 10g/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth and database growth.

Involved in SQL Query tuning and provided tuning recommendations to Scheduled jobs, time and CPU consuming queries.

Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.

Experience in performance tuningusing EXPLAINS PLAN, SQL TRACE, SQL Profiles, TKPROF, AWR and ADDM reports.

Performed database and application cloning from production to development environment and resolved various issue encountered during cloning.

Involved in Daily monitoring of mission critical Production and Development System which includes application as well as database monitoring.

Managed multiple production databases on 10g and 11g.

Writing shell script for automation of DB RMAN backup and cloning of Oracle Databases and Applications and Tuning the databases for optimal performance and monitoring CPU performance.

Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures.

24x7 DBA support for multiple production, test, and development environments

Ability to build professional relationships and capable of multi-tasking for various projects and prioritizing the work.

Mentoring the junior team members and making them well-equipped about the processes followed and technologies involved.

Hardworking, result oriented good interpersonal and communication skills.

Technical Skills:

Operating Systems

HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,6.1, Red Hat Linux RHEL 4.x,5.x, Windows

Data Bases

Oracle 12c/11g/10g/9i, Oracle 12c, 11g/10g Real Application Cluster (RAC), ASM, MySQL, SQL SERVER 2008/2012, Mongo DB

Languages

SQL, PL/SQL, C, C++, UNIX Shell Scripting

Tools/

Utilities

RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import,

RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET, OEMCTL, DB verify, ODBC, Export/Import, Data pump, Data-Guard, Erwin, OEL, Log-miner, MS Visio, VERITAS Net Backup, BMC remedy, Pac 2000, VMware, Crontab, oradebug

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQLT, SQL TUNING ADVISOR

Terminal Emulation

Putty, Telnet, FTP, TOAD

Work Experience:

Client: Santander Bank, Boston, MA Duration: Oct-14 to Present

Role:Sr. Oracle Database Administrator

Responsibilities:

Installed, configured and maintained Oracle 11GR2/12C Real Application Cluster (RAC) databases.

Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.

Performed health checks of Real Application Cluster instances using Crsctl and Srvctl utility and troubleshooting RAC using clusterware logs

Converted single Instance Databases to RAC databases Manually and expertise in troubleshooting RAC issues, very strong in using ocrconfig to backup OCR and Voting files

Performed SAN migration with minimal down time, creating disk groups with different redundancy levels, creating ACFS on ASM using asmca

Monitoring and managing of Oracle instances using Enterprise ManagerControl 11g /12c

Implemented Disaster recovery for production databases using Data guard and creating physical standby databases, and involved in converting physical to snapshot standby, and also Active Data-guard

Converted physical to Snapshot standby and back to physical standby as per business requirement

Setup physical standby’s (Dataguard) for several Databases and configured Data guard broker between the primary and standby databases,

perform Switchover, Failover and monitor the Data guard status via command line

Proficiency with Installation and maintenance of replication tool Goldengateby creating extract process, extract pump, and replicate.

Upgrading GoldenGate from v11 to 12c and Expertise on Oracle Golden Gate and be able to configure Golden Gate and troubleshoot the issues related to Golden Gate independently.

Used Logdump utility, Defgen utility in GoldenGate environment and Installed Goldengate in dev, test, prod environment

Setup dev, test, UAT and Prod environments on RHEL, HP Unix database machines.

Problem diagnosis and Performance tuning by implementing Partitioning, Parallelism and Compression.

Setting up Hugepages - Calculated the recommended values and setup hugepages on Linux severs.

Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization.

Installed 12c pluggable databases and upgraded from 11g to 12c and managed fusion middle ware products

Performed stopping and starting web logic server whenever requiredand Worked with Fusion middleware team in tuning oracle database parameters, tested and deployed in production

Provided backup/Restore; Recover of the databases using RMAN andFLASHBACK database procedures.

Upgrade the binaries by applying patch set and interim patches using OPatchand OPatch Auto.

Creation of new PL/SQL procedures and triggers based on the projectrequirement and UNIX shell scripting as and when required based on the requirement.

Implemented backup strategies using hot/cold, Expdp/Impdp used on the business requirement.

Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using Datapump.

Worked on SAP databases and used B.R Tools for taking Backup of databases

Successfully migrated databases from Unix running oracle11g over to Linuxboxes12c

Unix Shell scripting in ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.

Worked onPerformance Tuning guidelines SQL and JDBCperformance tuning, application tuning methodologies, determining instance and I/O efficiency, and using tools like TKPROF.

Providing technical support to Application Support team for performance anddatabase related issues.

Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 12c and Production to development refresh.

Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metal ink).

24x7 Production database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Environment: Red Hat Linux5.x, Aix 6.1, RHEL 6, Oracle, Enterprise Manager GRID, RMAN, SAN/NAS, ASM, RAC, Golden Gate, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, ToadV11.x& SQL, Navigator V6.1.

Client: Laboratory Corporation of America, Burlington, NC Duration: Sept- 13 to Oct-14

Role: Sr. Oracle DBA/Production Support

Responsibilities:

Worked with DBA team in migration project and supported oracle databases

Installation, configuration, maintenance and tuning of Oracle 11g on Red hat 5.8, RHEL 6.x.

Successfully migrated Oracle 10g to Oracle 11g and Used OEM 11g/12c to monitor oracle databases on daily basis

Installation and configuration of Oracle 11gRAC using Cluster ware and ASM.

Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.

24x7 remote support and on call Database support for Database developers & end-users.

Configured Goldengate extract and replicate during the database character set conversion.

Configured Goldengate Datapump extract to move the trail files from source database server to target database server and Installed Goldengate Director to have a web view of all the Goldengate implemented servers.

Implementing necessary monitoring scripts for Golden gate in Unix/Perl scripting.

Configured Physical Standby database for 2 node RAC database using Data Guard.

Migrating databases into Exadata machine using Dataguard with minimal downtime and calculating cell offload efficiency of sql running on Exadata Machine

Worked with Platinum Support to apply patches on Exadata Machine X3-2 and Used smart scan, flash logging and storage Index to improve performance of databases

Experienced in implementing Oracle Database advanced security practices.

Configuring windows and SQL cluster components and Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.

Database Sizing, Table space Management and Rollback Table Space Management, Transaction Management and Security Administration.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager

Refreshing Schemas from Production to lower environment using Datapump

Killed Blocking sessions on oracle databases and monitoring Alert logs.

Applying shipped archived logs to standby databases on using MRP process

Experience in cloning RAC databases using RMAN tool.

Gathering stats on databases using DBMS_STATS and Automated the nightly RMAN backups for the Production and Test Databases in Crontab

Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard on both physical/logical standby databases in high availability mode.

SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, AWR, ASH, ADDM and monitor the database performance on daily basis.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Assisted SQL developers to optimize the SQL queries and stored procedures.

Creating and Scheduling Oracle Backend Process Jobs in Crontab.

Cloning & duplicating databases using scripts as well as RMAN.

Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.

Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication, Audit vault, DB vault.

Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.

Applying security patches both Server side and Client side and Performed testing.

Used Secure SCP & FTP extensively for the File transfers from machines to remote server.

Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.

Raised SR's with oracle in case of problems.

Environment:AIX 5.x, 6.x, and Red Hat Linux 5.x, Oracle 10g and 11g, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, Exadata, Smart scan, Storage Index, RAC, Data Guard, Golden Gate, ASM, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Client:City National Bank, Los Angeles, CA

Role: Oracle Database Administrator Duration: May-11 to Sep-13

Responsibilities:

Extensively involved in analyzing the functional requirements for the Database Access Profiles.

Managed and monitored the Oracle Real Application Cluster (11GR2 2,3 node RAC) running on VERITAS storage.

Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.

Extensive experience in RMAN recovery in RAC and standalone database.

Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.

Performed Upgrades, Enhancements, and regular maintenance to system by researching, planning, as well as applying patches to databases and E-Business suite to keep them up-to-date.

Kept databases, applications, and operating systems up-to-date through assessing, planning, and implementing upgrades and patches.

Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data.

Installation, configuration and maintenance of Oracle 10g and 11g database on OEL.

Supported more than 130 production and development databases.

Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.

Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.

Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.

Implemented data transfer using Data Pumps and Export/Import utilities.

Taking the RMAN incremental and cumulative backups and Scheduling the databases backup using Crontab.

Implemented DRP (Disaster recovery plan) for critical databases using Streams.

Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.

Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.

Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.

Responsible for capacity planning, recovery planning and installing patches.

Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability

Developed stored procedures using PL/SQL. Used Hints, Indexes, Explain Plan, Sql Trace and Tkprof for effective retrieval and processing of queries used for retrieving current details and also history of changes made for a version.

Environment:Oracle 11g/10g, Sun Solaris 9, AIX, Redhat Linux, OEM, SQL, PL/SQL, SQL Plus, Unix, Erwin Data Modeler, OEM 10G/11G, RAC, Dataguard, ASM, EBS, Expdp, Impdp, RMAN, Toad, Putty

Client: ING Vysya Bank, Hyderabad

Role: Oracle Database Administrator Duration: Jan-10 to Apr-11

Responsibilities:

Oracle Configuration. Oracle Tuning. Oracle Patch Administration.

Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.

Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.

Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.

Planning, Installation and Configuration of Oracle Database on the Server.

Creation of Table space, Data files, Indexes,Rollback Segment and monitoring them.

Creation of Users and Granting them privileges and roles.

Performed Database Tuning. Performed DatabaseSecurity and Integrity.

Wrote extensive Sub Queries, PL/SQL procedures, functions, databasetriggers and packages.

Responsible for writing database programming to Store/Retrieve the information from the database using SQL.

Designing and creatingschemaobjects like Databasetables, indexes, views, synonyms, and all schema objects inOracle.

Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.

Monitoring the data loading jobs and tuning the SQL queries.

Environment:Oracle 10g/11g, SQL Server 2005, UNIX (Sun Solaris), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.

Client:Bajaj Allianz, India

Role: Oracle Database Administrator Duration:Sep-08 to Dec-09

Responsibilities:

Installation and creation of 9i and 10g databases for Testing, Development, Production including configuration, backup & performance tuning.

REFRESH/CLONING of Database and applications for development, testing

Installation and Maintenance of Stand by database.

Conducting sizing & capacity planning fororacle databases and Upgrade of databases from 10.2.0.2 and to 10.2.0.4 and designing the logical and physical database structure.

Taking Backups on scheduled time and monitoring scheduled Backups

Performing backups and recoveries using RMAN conventional hot backups.

Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.

Partitioning Strategies for very large tables and Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.

Data refresh from production to test and development, maintain Database Security.

Performed block recovery using RMAN. Performed backup validations using RMAN and Database monitoring, troubleshoot and resolve the issues.

Management of schemas, objects partitioning the tables & indexes and Automation of data load using shell scripting and SQL*Loader.

Responsible for setting and managing user accounts, Granting required privileges to users.

Defining and Implementation of backup and recovery strategies

Optimization and tuning SQL queries using TRACEFILE, TKPROF, EXPLAIN PLAN.

Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.

Tuning heavy data loads. Monitoring and Performance tuning.

Writing scripts for the system and database for effective functionality and report generation.

Applied High priority, security patches downloaded from Metalink.

Environment: Oracle 9i/10g, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.

Education:

Bachelors of Electronics and Communication Engineering

Jawaharlal Nehru Technological University

Contact this candidate