Database Administrator Recovery Manager

Srinivas Medaramitla

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

Mobile: 703-***-**** Ext: 308

https://www.linkedin.com/in/srinivas-m-0a5924232/

Woodstock, MD

Summary:

13+ years of IT experience as an Oracle Database Administrator in designing, installing, upgrading, and maintaining 10g,11g,12c and 19c databases in large-scale UNIX/Linux environments.

Expertise in Oracle 19c,12c, 11g, 10g, 9i on various UNIX platforms and windows in the areas of database creation, refreshing database, user management, RMAN, Export and Import utility.

Experience as 24*7 Production, Development and test databases support as DBA.

Working on Multi-node cluster environment Oracle 12C on Exadata machines.

Administrated various production databases under multiple node Oracle 11g & 12c RAC environment.

Hands on experience on creation of databases, instances, table spaces, data files, rollback segments.

Experience on Maintaining Non-RAC & RAC Databases, migrating from Non-RAC to RAC & Non ASM to ASM.

Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.

Experience on Data-guard and Create and maintaining RAC & Non-RAC Physical & Standby database.

Creation of users, roles, profiles, dblink, privileges and assigning roles to users and maintaining system security.

Experience in Upgrade the databases from 11.2.0.4 to 12.1.0.2, 11g to 18c, 12.1.0.2 to 12.2.0.1 and 19C

Experience in Grid and database upgrade from 12.1.0.1 to 12.1.0.2 and 19C.

Hands on experience on cloud-based database environments with Oracle Cloud Infrastructure (OCI).

Experience on cloning using RMAN Backup & Physical Backups.

Hands on experience in Grid control, Streams, GoldenGate Replication.

Experience in Applying patching activities in multi node RAC environments.

Administration of ASM Instances and ASM Disk Groups.

Hands on experience in MySQL and SQL Server administration on Linux and Windows environments.

Monitoring databases in Oracle Enterprise Manager (OEM) for DB monitoring/performance/diagnostics.

Maintained database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).

Extensive Knowledge on Oracle Database Architecture

Experience in Logical backups and Database migration tools with Data Pump, Export/Import and Transportable tablespaces.

Experience in performance tuning EXPLAIN PLAN and collecting statistics using STATSPACK, AWR and ADDM.

Creation of Database links and Materialized views.

Creating indexes and rebuilding indexes for better performance.

Experience in configuring Database Parameters, Reorganization, and knowledge in Flashback Technology& Flash recovery Area.

Monitoring and managing day-to-day operations, maintaining Table spaces and CRD files.

Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.

Troubleshooting day-to-day issues in RAC environment.

Worked closely with application development teams and system admins to test, troubleshoot, and optimize new and existing database-driven applications.

Involved in enterprise security, auditing, and compliance related tasks.

Hands on experience in managing full rac exadata machines.

Technical Skill Set:

Databases

Oracle 9i, 10g, 11g,12c,19C, OCI, MySQL 5x, SQL Server 2005 and 2008,

Operating Systems

Red Hat Linux, Oracle Linux, HP-UX and Windows

Utilities

RMAN, Oracle 11g Grid Control, Data Guard, EXP, IMP, Datapump, SQL Developer

Tools

TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ADDM, Auto Trace, OEM, RMAN, SQL*PLUS.

Languages

SQL, PL/SQL, UNIX Shell Scripting

Experience:

Data Recognition Corporation, MN 11/2019 to till date

Sr.Oracle DBA

Responsibilities:

Installed and maintained Oracle 10g RAC/11g,12c and 19c databases on testing, development for production on Linux.

Migrated and upgraded Oracle Databases 10.2.0.4 to 11.2.0.2 on ASM Cluster environment.

Implemented and supported 2 node Oracle 11g RAC and Managing ASM Instances.

Monthly restoration tests for client audit.

Applying patches Unix/Linux platform to make application environment upto date.

Refreshing and cloning databases from Production to Test and Development environments using data pump utilities EXPDP/IMPDP.

Performed in configuring and backing up database Cold Backup, Hot Backup and Logical backups using conventional Backups and RMAN, performed various recovery scenarios in development and critical Production databases.

Prepared Backup Schedules which include offline, online, and logical backups.

Creation of Password Files for network authentication of the Administrator.

Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity for.

Performed migration and up-gradation of Oracle databases by using import/export, Oracle Data Pump, and Transportable tablespaces.

Generated Performance Reports and Daily Health Check of the Database using AWR, ADDM utilities to gather performance statistics.

Responsible for creating users, groups, roles, profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Monitored overall system performance and Database growth rate, Added Data files to Tablespace.

Monitored and audited database access for unauthorized access.

Administered all database installation, creation, modification, and tuning issues of Oracle.

Planning and implementing backup and recovery procedures, scheduling daily backups and performed periodic recovery tests.

Involved RAC and Physical Standby databases for High availability and disaster recovery.

Actively monitoring of Oracle Database &Applications, which include Space management, Standard Services availability check, quickly identify and resolve database and application-level errors.

Performed capacity planning required creating and maintaining the database environments.

Gathered Database instance statistics & generated reports using STATSPACK.

Troubleshooted and resolved user connectivity and account locked issues.

Responsible for performing routine checks of a certain number of assigned databases to ensure maximum efficiency and availability.

Monitored alert logs, trace files, partition tables and indexes for better performance of the database.

Managing application user profiles and managing concurrent managers, concurrent processing, load balancing etc.

Served as a member of 24-hour on call support staff.

Environment: Oracle 9i/11g/12C, RMAN, RAC, Oracle OEM, Import/Export, GoldenGate, Exadata, NG Autofix, Service now and LINUX.

Responsys-Oracle, VA 12/2017 – 11/2019

Sr. Cloud Administrator

Responsibilities:

Provided 24X7 supports for all the production and development databases.

Involved in Oracle Server Installations/Upgrades/Patches, space management and capacity Planning.

Administering tasks on Oracle single instance and RAC instances.

Support in the development and maintenance of the cloud infrastructure capacity forecast.

Set up and maintain cloud infrastructure user access roles.

Managing database running on RAC and setting up Standby Database / Oracle DataGuard to protect against failures or disaster recovery.

Maintaining the Disaster Recovery Oracle Database Server at remote location through synchronization of archived logs on Production Server and DR server by auto/manual.

Backup/Restoration/Recovery and Export/Import of Oracle Database.

Reports generation for tablespace growth and database growth on weekly bases.

Monitoring dataguard activities plan for switchover and switchback as and when required.

Generated Performance Reports and Daily Health Check of the Database using AWR.

Proactively monitored Space Usage on daily basis.

Managing Database User management, Table space management, performance related issues.

Configuring new databases and users: set up backups, export, and other monitoring Scripts

Performing regular DBA Activities like Backups, Managing Database Storage for various activities

Managing hot / cold backups (Hot, Cold & RMAN backups)

Performing logical backups using export/import and Data pump Utilities.

Restore & recover database UAT environments as per requirement.

Cloning of production database to the test environment using Recovery Manager.

Purging activities on weekly, Monthly and Quarterly basis.

Preparing Quarterly Capacity reports for all the production databases.

Monitoring and managing the use of disk space, memory, and connections, initializing database devices, Disk mirroring for recovery, creating, enlarging and removing user database and transaction log, creating and using segments.

Environment:Oracle 10g/11g,RMAN, RAC, OEM Cloud Control, Data Guard, OEM, AIX,Linux, Insight monitoring.

Bank Of America, NC 02/2016 – 12/2017

Oracle Database Administrator

Responsibilities:

Installed and maintained Oracle 11g RAC/12c databases on testing, development for production on Linux.

Managed 3 node Oracle 11g and 12c RAC, Managing ASM Instances.

Installed 12C Real Application Cluster and involved in migration of standalone databases to RAC Cluster.

Performed Cross platform migration and used Oracle Golden Gate to transfer database from Hp-Unix to RHEL configured integrated extract, integrated replicate and coordinated replicate on Oracle multitenant databases 12.1.02

Worked on Monthly restoration tests for client audit.

Involved in upgradation of databases from 11.2.0.4 to 12.1.0.2, 11g to 18c, 12.1.0.2 to 12.2.0.1

Involved in Grid and database upgrade from 12.1.0.1 to 12.1.0.2.

Involved in designing of Disaster Recovery using Data Guard and High Availability using 11g RAC.

Experience in Applying patching activities in 3 node RAC environment for quarterly patches for GI and DB PSU patches.

Cloning of the database from Production to the Test and Development environments using Expdp/Impdp.

Performed Cold Backup, Hot Backup using conventional Backups and RMAN, performed various recovery scenarios in development and critical Production databases.

Prepared Backup Schedules which include offline, online and logical backups.

Creation of Password Files for network authentication of the Administrator.

Responsible for database connectivity for clients using TNS names.

Used Export/Import Utilities to move the data between different databases and to external storage area.

Involved in performance tuning, tuned various large critical OLAP databases using STATSPACK, AWR, SQL-Trace and Explain Plan Methods.

Generated Performance Reports and Daily Health Check of the Database using AWR, ADDM utilities to gather performance statistics.

Creation of Users and allocated appropriate Table Space quotas with necessary Privileges and Roles.

Adding nodes to already existing clustered servers as a part of data load\high availability.

Monitored overall system performance and Database growth rate, Added Data files to Tablespace.

Migrated databases from non-Exadata environments to Exadata environments using Dataguard switchover.

Served as a member of 24-hour on call support staff.

Environment: Oracle 11gR2/12C, RHEL 6.X, OEM 12C, RAC, Data guard, GoldenGate, ADDM,VMWARE, EXADATA, Data pump, STATSPACK, SQL-Trace, Explain Plan and RMAN cloning

Economical insurance (EI) 02/2010 – 02/2016

Database Administrator

Responsibilities:

Providing all activities related to the administration of a massively scaled Oracle database fleet.

Projecting and providing long-range requirements for database administration and design in conjunction with other service owners in the Oracle Cloud ecosystem.

Conducting quality control and auditing of databases to ensure accurate and appropriate use of data.

Designs, implements and maintains complex databases, access methods, access time, device allocation, validation checks, organization, protection and security.

Ensures high availability of all the databases, monitoring GoldenGate and DG scripts.

Monitoring and Maintaining backup scripts, logs and RMAN backups.

Respond to Prod-Ops team requests for trace files, monitoring or killing long running DB sessions.

Maintaining administrating ETL Jobs, Insight Application on MySQL CMS server along with Reporting DBs in MS SQL Server.

Perform DB cloning by creating standby DB's, restoring and recovering.

Installation of SQL Server and Backup Server.

Maintaining more than 100+ DB’s including Prod, Pre-Prod, Dev and Staging.

Perform daily activities like Final extract, Zone termination, Zone refresh and Exadata Upgrade, Binary Upgrade, Grid Upgrade using PRISM tool.

Data transfers using BCP, granting roles and permissions to SQL Server users, fixing super user permission, granting & removing permissions of all users.

Checking MRP process to applies the redo data into standby database.

ASM configuration adding/resizing and managing the disk group.

Requested actions fulfillment done through Jira ticketing tool.

Analyzing the SQL Query using Explain plan.

Oracle Golden Gate troubleshooting and fixed.

Provided MySQL multi-master replication administration and configuration.

Migrated Oracle 9idatabases to MySQL using the MySQL Migration Toolkit.

Performed MySQL server installations, configuration and upgrade on Windows and Linux environments.

Monitoring the database for Memory and I/O utilization.

Monitoring the growth of Database, Tablespace and Disk level.

Creation of roles granting privileges to users and roles.

Configuring archive log and managing daily basis.

Handling the resources of RAC using CRSCTL and SRVCTL.

Administration of Oracle Enterprise Manager using EMCTL.

Using Tableau to analyze the data from different sorts on env

Environment: Oracle 9i, 10g, Datapump, Dataguard, OEM, RAC, RMAN, Export/Import and Linux.

Education:

Bachelors in Electronics and communication engineering, JNT University – 2008

Certifications:

Oracle Certified Associate by Oracle corp on oracle 12C Database.

ITIL V3 trained in IBM

Contact this candidate