Oracle DBA

Sandeep Reddy E-MAIL: **********@*****.***

Objective:

To achieve a challenging position in the area of database development and administration, and to contribute all my efforts to the organization with efficiency and proficiency.

Professional Summary

Have 10+ years of experience in Oracle Database Administration on Linux, Windows and UNIX environment.

Supporting 24X7 enterprise production/non production oracle databases on UNIX (Linux, AIX and Solaris) OEL platforms and Windows platforms.

Involved in the planning, analysis, design, implementation, maintenance, and control of the databases.

Oracle Golden Gate configuration and administration. Configured bi-directional and unidirectional replication between databases.

Good knowledge in troubleshooting Oracle Golden gate issues.

Oracle Software Installation 12C/11g/10g, Upgradation, migration, Client Installation, Database creation & its objects, Tablespace management, File system standards. Scheduling Cron jobs.

Database Upgrades and migration from oracle 9i and 10g to 11g and 11g to 12c.

Experience in Oracle Transparent Data Encryption (TDE) for enhanced security.

Experience in Oracle data encryption and security (SSL, TLS, TDE, Advanced security and Network Security).

Experience in Oracle cloud control management.

Schema management activities like Create/Drop database users, Create Roles, Grant Roles/Privileges, Create/Modify Profiles and Password reset.

Maintenance and troubleshoot for production/non production DB instances configured on RAC.

Experience in Oracle ASM 10g/11g ASM disk group management.

Installation of OEM13c and upgrading the EM agents and configure new agents in EM and add on packages like Oracle golden gate.

Applying GI PSU (oracle 11gr2 RAC) & standalone PSU on quarterly basis.

Experience in maintaining/troubleshooting DB instances configured on high availability solutions such as Oracle RAC services and workload balancing using Server Pools.

Experience in configuring/troubleshooting Oracle Dataguard & Standby database. Monitor/Identify the log gaps and resolve any issues.

Coordination with Oracle support to resolve issues through raising SR.

Experience in working on AWR/ADDM reports, SQL Tuning Advisor, TK Proof and Explain Plan.

Data refresh from production to non-production environments through RMAN hot backup, Cold Backup, Export/Import & Data pump utilities. Experience in RMAN backup and recovery tool.

Monitoring Databases using OEM Grid control and adding Cluster and Database services in OEM Grid for new servers.

Enabling auditing on the objects and monitoring on the indexes drop them if they are not in use.

Experience on EXADATA.

Knowledge on Couchbase (NoSQL) database,

Prime responsibilities for DBA activities - Logical/ physical design of databases, defining of roles, profiles etc., backups, connectivity to database.

Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.

Experience in Re-indexing, Replication, Mirroring, Updating Statistics and performing other maintenance tasks.

Experience – Very strong in ITIL processes on Change Management, Problem Management, Incident Management and ITIL Process related activities.

Good team player, attitude with the ability to work independently.

Excellent verbal, written, and interpersonal communication skills.

Educational Qualification

Bachelor of Engineering in Electronics and Communications from JNTU, Hyderabad.

Technical Proficiency

RDBMS : Oracle (9i, 10g, 11g and 12c), RAC, ASM, Dataguard and Oracle Golden Gate

Platforms : IBM AIX 5.1/6.1, Linux AS4, ZFS, OEL, Solaris 10, Windows 2012/2002/XP/98

Tools : SQL*Plus, Toad, Oracle Net Configuration Assistant, OEM Grid 12c and 13c.

Languages : PL/SQL and Shell scripting

Ticketing Tools : Remedy, Ascent, HPSM and Service Now

Projects Handled

Client – Western Union, Denver, CO

Duration – Aug 2016 to Till Date

Role – Oracle Database Administrator

Level Support – L2 and L3

Environment – IBM- AIX, Red Hat Enterprise Linux 6.5, Sun OS, Windows 2012R2

Oracle Database Versions – Oracle 10g, 11g, 12c RAC, OEM 13c and Oracle Golden Gate

Tools – TOAD, Sql Developer, AWR, ADDM, ASH, TDE, Oracle Partitioning and Oracle Net services.

Description: The Western Union Company is a financial services and communications company based in the United States. Its North American headquarters is in Meridian, Colorado, though the postal designation of nearby Englewood is used in its mailing address. Up until it discontinued the service in 2006, Western Union was the best-known U.S. Company in the business of exchanging telegrams.

Responsibilities:

Handling more than 260 databases including Production, Pre-production and Development boxes.

Primarily responsible for production support. To keep all databases up and running in production.

In-depth Knowledge of installation, configuration, and maintenance of Oracle database – 9i, 10g, 11g and 12c.

Did the datacenter migration of Oracle databases from one DC to another DC with zero downtime using Oracle golden gate.

Hands on experience on fixing Oracle golden gate issues.

Moved the Dev and QA databases to Oracle PCA (Private Cloud Appliance).

Performed to storage migration of databases from VNX storage to Unity and Xtream IO.

Performed annual DR (Disaster Recovery) of critical production databases.

Perform switchover and switchback of databases as per client requirement.

Up-gradation of RAC databases from 10gR2 to 11gR2.

Configuration of 11g CRS RAC Environment using ASM and creating ACFS in RAC environment.

Oracle 12c installation and applying latest security and bug fix patches to the grid and RDBMS homes

Multitenant: Manage tablespace in a Container database (CDB) and pluggable databases (PDB) in oracle database 12c release 1.

Multitenant: Manage users and privileges for container databases (CDB) and pluggable databases (PDB) in Oracle release 12c.

Multitenant: Backup and recovery of container database (CDB) and a pluggable database (PDB) in oracle database 12c.

Oracle Golden Gate configuration and administration. Configured bi-directional and unidirectional replication between databases.

Troubleshooting golden gate issues and conflict handling issues in golden gate.

Experience on GDPR and implemented it in Oracle databases in WesternUnion environment.

Implemented Oracle data encryption and security (SSL, TLS, TDE, Advanced security and Network Security) in Western Union environment.

Configure Oracle wallet for TDE encryption and set to auto login.

Prepared the capacity planning and added required storage to the database servers.

Experience in Oracle licensing (Processor based or Named user based licenses). Optimizing the oracle licencing like de-install the licensed components which are not in use from database registry.

Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.

Converting huge tables into partition tables.

Automation of jobs using shell scripts and task scheduling.

Monitor database management systems as well as evaluating database performance to maximize efficiency

Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.

Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.

Taking table level backups using expdp/impdp.

Responsible for capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lock activity.

Tuned the system in terms of SQL optimization, Memory tuning and application tuning.

Tuning Query performance by creating Indexes and using SQL Advisory to tune queries and give recommendations to the Applications Team.

Monitoring, sizing and tuning undo segments by creating multiple undo tablespaces.

Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.

Replication of tables to cross platform and Creating Materialized Views.

Client – Charter Communications Inc, Denver, CO

Duration – July 2014 to August 2016.

Role – Infra Technical Specialist

Level Support – L2 and L3

Environment – IBM- AIX, Red Hat Enterprise Linux 6.4, Windows 2012R2, Sun OS, MSSQL (2012, 2008R2, 2008, 2005) and Exadata

Oracle Database Versions – Oracle 10g, 11g, 12c, RAC, Dataguard and ASM

Description: Charter Communications, Inc. is an American telecommunications company that offers its services to consumers and businesses under the branding of Spectrum. Providing services to over 25 million customers in 41 states, it is the second-largest cable operator in the United States by subscribers, just behind Comcast, and third largest pay TV operator behind Comcast and AT&T U-verse/DirecTV. It is the fifth largest telephone provider based upon residential subscriber line count.

Responsibilities:

• Server migration from Linux to AIX using cross platform transportable tablespace.

• Storage Migration from Dell to IBM.

• Configuring services and resource manager to manage the CPU workload of OLTP and Reporting consumer groups.

• Configuring Snapshot Standby for smoke testing.

• Creating ASM disks using oracleasm and adding disks to Diskgroup using Asmca.

• Migration database files from File System to ASM (Automatic Storage Management).

• Backup remediation.

• Configuring the Listener.ora and Tnsnames.ora and Host Naming.

• Database refresh from production to non-production environment, database objects export/import between the instances different database versions, database backup/restore using Symantec Netbackup tool for oracle.

• Managing database security and creating and assigning appropriate roles and privileges as required by the application user.

• Experience in Oracle flash back (Flash back of database, tables…).

• Installed and Configured SQL Server 2012/2008/2005 Enterprise Edition with all necessary storage systems.

• Extensively worked on Installation of MS SQL Server 2012/2008/2005, upgrade of SQL Server instances and applying service packs.

• Deployment of application sql scripts during code release.

• Experience in performance tuning of the SQL queries which are long running.

• Experience in Oracle exadata.

• Manage and estimate the physical storage of a database files.

• Providing support to external teams during OS Upgrades/Patches.

• Oracle database software installation, Client installation, Database upgrades from 9i/10g to 11g. Database tools installations/upgrades like OEM agents.

• Applying quarterly patches GI PSU (11g RAC), Standalone PSU and Bug patches/One of patches.

• Coordination with Oracle support to resolve issues through raising SR and following the solutions available in Meta link notes.

• SQL query tuning. Generating the database health check reports using AWR, ADDM, Sql Tuning Advisor.

• Performing routine checks of space utilization and Extended Table spaces by resizing/adding data files when needed.

• Involved in Installing, Monitoring and Troubleshooting Backup and Dbcc jobs on MSSQL servers.

• Creating users, managing privileges, allocating data and log space in the MSSQL databases. Execution of user requested queries and giving the outputs.

• Created and deployed pre-authorized, Normal and Emergency change orders.

• Have been center point in preparing and auditing SQL database, its users, rights etc.

• Coordinating with clients and giving the best solution as per their Requirements

• Handling/Leading a DBA team. Mentoring new Joiners.

• Providing extensive support during weekend as On Call.

• Continuous interaction with different application teams and SQL developers to troubleshoot APP jobs.

Company – HCL Comnet, India

Client – Covance Inc.

Duration – January 2014 to July 2014

Role – Senior Specialist

Level Support – L2 and L3

Environment – Oracle 11g/10g, Oracle EM Grid Control 11g and 12c, ASM, Streams, IT Central, AWR and ADDM Analysis, SQL*Plus, Toad, SQL*Loader, RMAN, Red Hat Linux, HP-UX, Sun Solaris.

Oracle Database Versions – Oracle 10g, 11g, 12c RAC, and ASM

Description: Covance is one of the world’s largest and most comprehensive drug development services companies with more than 12,000 employees in 60 countries. Through its lead optimization, nonclinical, clinical and commercialization services, Covance has helped pharmaceutical and biotech companies develop one-third of all prescription medicines in the market today.

Responsibilities:

Handled more than 380 databases including Production, Pre-production and Development boxes.

Primarily responsible for production support. To keep all databases up and running in production.

Experience on installation of 4 node and 3 node RAC and creating services in the RAC environment.

Configuration of 11g CRS RAC Environment using ASM.

Meeting the SLA Metrics week to week for Oracle Track.

Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.

Extensive experience in working on Distributed Oracle Database server's 11g/10g, and developing stored packages, procedures, functions, triggers and views

Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.

Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.

Taking table level backups using expdp/impdp.

Responsible for capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lock activity.

Tuned the system in terms of SQL optimization, Memory tuning and application tuning.

Extensive experience in database design, data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.

Tuning Query performance by creating Indexes and using SQL Advisory to tune queries and give recommendations to the Applications Team.

Company – HCL Comnet, India

Client – Micron Technology.

Duration – August 2012 to January 2014

Role – Senior Specialist

Level Support – L1 and L2

Environment – Oracle 11g/10g, Oracle EM Grid Control 11g and 12c, ASM, Streams, IT Central, AWR and ADDM Analysis, SQL*Plus, Toad, SQL*Loader, RMAN, Red Hat Linux, HP-UX, Sun Solaris.

Oracle Database Versions – Oracle 9i, 10g, 11g, OEM 10g, 11g and ASM

Description: Micron Inc. is a world leader in manufacturing for DRAM. They have sites around the world and Manufacturing FAB centers, which are critical to the production of DRAM.

Responsibilities:

Planning and implementing Backup and Recovery procedures (Hot Backups, and RMAN), scheduling daily backups and performed periodic recovery tests.

Taking table level backups using expdp/impdp. Responsible for capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lock activity.

Tuned the system in terms of SQL optimization, Memory tuning and application tuning.

Extensive experience in database design, data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.

Tuning Query performance by creating Indexes and using SQL Advisory to tune queries and give recommendations to the Applications Team.

Primarily responsible for production support. To keep all databases up and running in production.

Up-gradation of RAC databases from CRS 10.2 11.2 for the Micron’s SDW and CDW databases.

Configuration of 11g CRS RAC Environment using ASM.

Meeting the SLA Metrics week to week for Oracle Track.

Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.

Worked on Oracle SAP databases and applied the patches using mopatch utility.

Worked on Oracle E-business database and ODA.

Perform switchover and switchback of databases as per client requirement using DG broker or manual.

Extensive experience in working on Distributed Oracle Database server's 11g/10g, and developing stored packages, procedures, functions, triggers and views

Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.

Monitoring, sizing and tuning undo segments by creating multiple undo tablespaces.

Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.

Replication of tables to cross platform and Creating Materialized Views.

Designing and developing packages in the database layer, stored procedures, functions and triggers.

Replicated Datacenter and Local database for automatic update of Objects.

Communicating with UNIX Production Support group for UNIX production issues like database installations, file space issues, patch applications, database startup/shutdown automation, and other database services and file system backups.

Company – HCL Comnet, India

Client – Shopko.

Duration – January 2011 to August 2012

Role – Senior Specialist

Level Support – L1 and L2

Environment – Oracle 9i/10g/11g, AWR and ADDM Analysis, SQL*Plus, Toad, SQL*Loader, RMAN, Red Hat Linux, HP-UX, Sun Solaris.

Oracle Database Versions – Oracle 9i, 10g, 11g.

Description:

The Shopko is a retail organization having 250 Shopko stores, providing quality name-brand merchandise, great values, pharmacy and optical services in small to mid-sized cities and 6 Shopko Express Rx stores, a convenient neighborhood drugstore concept. Shopko stores are multi-department retail stores committed to offering quality merchandise, services and value to meet customers' needs for home, family basics, casual apparel and seasonal products, with a special emphasis on retail health. Shopko stores are a neighborhood drug store format that provides professional pharmacy services, health & wellness products/information, home business solutions, photo processing, a convenient assortment of food, beverages and traditional drug store merchandise.

Responsibilities:

Handled more than 350 databases including Production, Pre-production and Development boxes.

Installation of Oracle 9i and10g on UNIX and Windows platform and creation of Database.

Installation of Database security patches and performing the point release upgrade.

Installing Oracle Client of version 10.2.0.4

Frequent refresh of the Databases using RMAN.

Creating Duplicate database using RMAN

Involved in the server migration activities.

Performing periodical Backup, Restoration and recovery using RMAN (full & incremental).

Database Restoring from Production to Test and Development Database using RMAN and performing Point in time Recovery (Cancel based, Change based, Time based).

Monitoring databases space requirements and adding spaces as per the database.

Managing tablespaces, data files, redo logs, tables and its segments.

Managing Users, Privileges and Roles.

Performance tuning resource monitoring (Disk Space Utilization CPU etc).

Day-to-day business database support and management of the production DB.

Support activities that include areas like Problem Management, Incident Management and Change Management.

Company – IBM India Pvt Ltd.

Client – Astra Zeneca Pharmaceuticals.

Duration – July 2008 to January 2011

Role – Operations Senior Lead Specialist

Level Support – L1 and L2

Environment – HP UNIX, IBM AIX, Solaris, Windows 2003, Oracle 8i,9i,10g and 11g, Oracle EM Grid Control 10g, ASM, Streams, AWR and ADDM Analysis, SQL*Plus, Toad, SQL*Loader, RMAN, OS cluster and windows failsafe cluster.

Oracle Database Versions – Oracle 9i, 10g, 11g, OEM 10g and ASM. DG Broker

Description:

AstraZeneca is a global, innovation-driven, integrated biopharmaceutical company. Its mission is to make a meaningful difference to patient health through great medicines that bring benefit for patients and add value for our stakeholders and society. We discover, develop, manufacture and market prescription medicines for six important areas of healthcare, which include some of the world’s most serious illnesses: cancer, cardiovascular, gastrointestinal, infection, neuroscience, and respiratory and inflammation. Read more about our medicines. It also works with others to combine complementary skills and strengthen the platform for success in meeting a common goal: improved healthcare. Find out more about partnering with us. We are active in over 100 countries with a growing presence in emerging markets including China, Brazil, India and Russia. AstraZeneca employ over 62,000 people (47% in Europe, 31% in the Americas and 22% in Asia, Africa and Australasia).

Responsibilities:

Handled more than 1600 databases including Production, Pre-production and Development boxes.

Installation of Oracle 9i and10g on UNIX and Windows platform and creation of Database.

Installation of Database security patches and performing the point release upgrade.

Installing Oracle Client of version 10.2.0.4, OEM.

Standby Database Rebuild using RMAN.

Frequent refreshing the Database of size 1.2 TB using RMAN.

Involved in the server migration activities.

Administrating oracle10g, 9i and Oracle 10g RAC, standby database.

Performing periodical Backup, Restoration and recovery using RMAN (full & incremental).

Database Restoring from Production to Test and Development Database using RMAN and performing Point in time Recovery (Cancel based, Change based, Time based).

Monitoring databases space requirements and adding spaces as per the database.

Managing tablespaces, data files, redo logs, tables and its segments.

Managing Users, Privileges and Roles.

Database switchover and switchback and failover in case if it require.

Performance tuning resource monitoring (Disk Space Utilization CPU etc.).

Handled Databases in RAC and OS Cluster environments.

Support activities that include areas like Problem Management, Incident Management and Change Management.

Handling Alert tickets and the severity tickets with incident tracking tools Remedy and Manage Now.

Close interaction with the business users and IT groups across the region and globally to ensure issues are resolved in a timely manner as per the Database Management standards.

Co-ordination with the team to meet the SLA between vendor and client.

Contact this candidate