Data Oracle

Siva Chaitanya

Sr Oracle Database Administrator

Email: acz7qq@r.postjobfree.com

Phone: 719-***-****

Professional Summary:

My 8+ years of experience has scaled in providing client support, analysis, designing, testing, development, installation, migration, maintenance, Replication, Database Security, RMAN, User management, ASM, and monitoring the database using OEM Grid Control, and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup recovery, cloning, and space management, shell scripting using ORACLE, and Configured Disaster recovery databases using Dataguard and replicated databases using Golden Gate, Mango DB, Shareplex, Streams, Automated RMAN Backups, Datapump and various process using Unix Shell scripting.

Experience Synopsis:

Extensive working experience with administration of large-scale, massively concurrent, highly available distributed OLTP systems to monitor and administrate running on 24*7 within a team

Experienced in maintaining databases on large Production, Testing and DEV environments and Experience in database cloning with RMAN, Capacity Planning,

Database Refresh and Patch management

Hands on experience of database performance tuning including RAC and SQL tuning experience with 10g R2 /11g/12c RAC scalability, High Availability, robustness and load balancing, RAC performance tuning, instance availability and background processes monitoring, waiting events and log and trace files investigation for troubleshooting.

Extensive working experience with 9i, 10g, 11g, 12c DATAGUARD/active DG to administrate both standby databases including installation, configuration, run-time monitoring and administration, performance tuning and troubleshooting, and maintained physical standby databases on Solaris, AIX, RHEL.

Implemented GoldenGate Replication 11g/12c on ACFS and configured for Automatic failover of GoldenGate process and Hands in upgrading GoldenGate from v11 to 12c.

Proficient in shell and PL/SQL scripting to develop database administration tools for database maintenance, security, performance tuning, backup/recovery, SQL tuning.

Hands of experience on Exadata administration experience including providing advice and guidance for Disaster Recovery strategies for Database machines. Providing and implementing performance and tuning recommendations. Providing upgrades and patching for Exadata storage servers and InfiniBand switches.

Have experience on Object Oriented paradigm such as OOAD using UML, Rational Rose and J2EE design patterns.

Hands on Experience in databases such as MYSQL, Microsoft SQL Server, ORACLE. MongoDB (No Sql).

Administration and troubleshooting 10g, 11g and 12c RAC clusterware using clusterware logs.

Performed various tasks in RAC Cluster: Pinning nodes, used ocrconfig to backup OCR, OLR and voting files, creating services using Srvctl, changing scan port number, Multiplex Voting files, Mirroring OCR on different ASM disk groups, Tuning Node Evictions by setting disk timeout, reboot time, miss count, Creating New VIP to manage high availability, Configuring TAF and used different parameters, Configuring ACFS and configuring for Automatic failover.

Expertise in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM.

Configured Dataguard Broker and managed standby databases using DG broker.

Worked in Environment and configuring ZERTO at Server level replication.

Performed GoldenGate utility like ggsci, logdump, defgen for troubleshooting issues and Performed Homogeneous and Heterogeneous data replication from SQL server database to Oracle database using GoldenGate 11g.

Migrated databases using GoldenGate from AIX, UNIX to RHEL environments and applied Patches to GoldenGate environment 12.1.0.2

Mass deployment of agents from OEM, patching OEM, performing administrative tasks using OEM, generating reports, scheduling jobs using Auto sys, RMAN, SQL tuning advisor to tune sql’s on databases.

Experience in Performance Tuning, tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like AWR, ASH, SQL-Trace, Tkprof, ADDM, SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.

Used Data masking to protect private and confidential data by replacing sensitive information with dummy data, knowledge on Physical and Logical structure of database.

Expertise in implementing database Backup and Recovery concepts using RMAN utility.

Implemented scheduling full, incremental, cumulative and hot, cold backups writing, editing UNIX Shell Scripts for RMAN

Experience in implementing Flash-Back Technology 10g/11g/12c and used different techniques using Flashback Query, Flashback SCN, creating restore points on database.

Extensively used Flashback for Supporting DML and DDL changes and handled daily production problems/change requests (DBCRS) with Oracle Patching.

Worked On administration tasks such as Data loading, Batch Jobs, Data unloading, backup and recovery, user and application table management, Upgrades, creating databases, file groups, files, transaction logs.

Experience in taking backups and restores in SQL Server and Experience in Configuring Replication, Mirroring, Log shipping.

Expertise in analyzing database objects, dblinks, creating indexes, creating materialized views, writing packages, Stored Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle.

Experience in an agile development environment and Worked with Query tools like Toad, SQL *Plus, Sql Developer.

Designed and Implemented scalable, secure cloud Architecture based on Amazon WEB Services and Managed EC2 Instances utilizing Auto scaling, Elastic Load Balancing, Auto Scaling and Cloud formation templates.

Set – up Database in AWS using RDS, Storage using S3 bucket and Configuring instance backups to S3 bucket and migrated applications to AWS Cloud.

Used Oracle Meta-Link Support to resolve issues related to database servers, security patches and Proficient in raising SR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.

Excellent Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams.

Have Ability to function independently and plan, evaluate and design solutions to problems as they occur and Ability to work well in a group environment and Good ability to mentor other DBAs in the group.

Technical skills.

Languages

UNIX Shell Scripting, SQL, PL/SQL, MySQL, Java

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQL Tuning Advisor

Operating Systems

Red Hat Linux 4.x,5.x,6.x, AIX 5.1,5.2,6.1, O.E.L 5.8, 6.4,6.7 and windows 2000/XP, HP-UX 10.x,11.x, Sun Solaris 9,10, Exadata X3-2, X2-2, x2-8

RDBMS

Oracle 12c/11g/10g/9i, Oracle 10g/11gR2 /12c Real Application Cluster (RAC), ASM, SQL SERVER 2005/2008/2012/2014, AWS, MYSQL 5.7

Oracle Tools and Utilities

Data Guard, GoldenGate, Logdump, Defgen, Reverse Utility, Veridata, Web logic server, ODI, OBIEE, WebSphere, RMAN, OEM, Tuning Advisors, TOAD, SQL*Loader, Export/Import, Data pump, Net Backup, ZERTO, AVAMAR, RMAN, RAC TOOLS ORACHECK, oratop, TFA collector, OSWATCHER

Work experience:

Client: Trade Navigator, Colorado springs (CO)

Duration: (Aug 2015 to till date)

Role: Sr. Oracle DBA

Genesis Financial Technologies has been providing quality financial data since 1983. Trade Navigator is designed to be a completely personalized stock trading platform. Trade Navigator's award winning trading software takes immense quantities of complex data and distills it down to what really matters. No matter which way the market is going, the Trade Navigator trading platform makes trading simple, by instantly locking on the trades, or market, with the highest profit potential and most probable profitability.

Responsibilities:

Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Extensive experience in Real application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database.

Performed health checks of RAC clusterware components ocr, voting files and backups using ocrconfig and Troubleshooting Issues using Clusterware logs in 12C and 11g RAC Environments.

Configured Active Dataguard 11g Troubleshooting Out of sync issues in Data Guard environment and Configured Dataguard Broker and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing.

Performed various tasks in GoldenGate: Troubleshooting errors using report and ggserror.log, configured DDL, DML replication, Configured Bi-Directional Replication, New setup from scratch for Migration, Configured Extract, Pump and Replicate and replicated tables to different Instances using GoldenGate.

Installations of Oracle 11g RAC, 10g RAC, 9i, on Sun Solaris/Red Hat Linux, Oracle Enterprise Linux/HP-UX/IBM-AIX/Windows platforms and creating databases.

Installed, configured and maintained Oracle 12cR2 Real Application Cluster (RAC) 3 node RAC, Migrating single Instance Databases to 3 Node RAC environments.

Installed the 3 node RAC for the 12c database and administered the 12c databases on these RAC server’s.

Used RAC Tool orachk to scan different stack of layers and finding potential risk and reconfiguring RAC cluster and Creating and managing services using RAC Tools Srvctl and clusterware resources using crsctl.

Install, configure and administration of Bea WebLogic Server 8.1/9.x in various environments.

Assisted Development and Business analyst teams by capacity planning and cloning of databases to the test environments so they could develop custom applications and perform a variety of tests for quality assurance and issue resolution.

Managed testing, assisted Developers, and created backups by Exporting and Importing tables when needed.

Duplicated issues and tested solutions to make sure problems were resolved properly.

Troubleshooting multicast issues using WebLogic Java Utility Multicast Test.

Established performance tuning best practices used by the DBA and Development teams.

Performance tuning, Golden Gate replication and used Log dump and report files for troubleshooting.

Evaluate all Performance tuning tools used by the team including Toad, SQL Developer, and OEM.

Performance tuning of databases using AWR, ASH reports, ADDM reports, provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage, Oracle 11g new partition techniques Interval partitioning, system partitioning, Creating Views & Materialized Views, Implementing SQL profiles and Migrating SQL profiles, Creating and rebuilding Index’s, re-organizing tables.

Supporting and Monitoring data loading, Creating /Analyzing /Scheduling reports, User management, performance tuning using Data warehouse Administrative Control (DAC).

Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning.

Experience in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.

EBS DBA on numerous Oracle E-business Suite (11i/R12) implementations.

In Dataguard I Configured Physical Standby databases using data guard in maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c according to Business.

Expertise in configuring Active Dataguard, Snapshot standby and troubleshooting issues and configuring Service Level Agreements for query’s accessing standby databases.

Troubleshooting Dataguard using Views, troubleshooting missing archive log scenario, patching Dataguard environment, applied logs with delay Configured Dataguard Broker and managed standby databases using DG broker.

Configured Active Dataguard, Dataguard Broker and snapshot standby databases, Troubleshooting Issues in Data Guard Environment, missing archive log, performance of Standby databases using stats pack, applied logs with delay, Tuning Media Recovery process, Performed DR testing.

In Oracle Enterprise Manager I installed OEM 13c on database 12.1.0.2 and Monitoring databases using Grid Control 10g/11g/12c and 13c for Configuration of errors notifications and adding to the grid control.

Data masking sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using DBMS_SCHEDULER.

Database Maintenance Tasks: Rebuilding Index’s, Rebuilding Fragmented tables, gathering statistics, purging old trace files.

Enabling Transparent Data Encryption, Automatic Login Enabled for Transparent Data Encryption, Setting and Resetting the Master Key, Adding and Removing Salt from an Encrypted Columns.

Worked with Developers and developed UI using HTML, JavaScript and JSP’s for interactive cross-browser functionality and complex user interface, Application issues.

Daily Health Check Up of the Database and SQL Queries and Performed large batch jobs, and tuning of SQL queries and database systems.

Monitored the production of Oracle alert logs for database errors and data issues Involved in all phases of application development and assessment to QA/QC, design and support.

Responsible for database administration and worked in all phases of Software Development Life Cycle (SDLC), and systems analysis procedures.

Extensively used USH, Ticketing Systems BMC Remedy and Service now and 24x7 production Support Database Maintenance and on-call Support.

Utilized AWS Cloud watch to monitor environment for operational and performance metrics during load testing and Implemented Amazon EC2 setting up the instances and Leveraged AWS Cloud services such as EC2, Auto Scaling and VPC.

Applied PSU quarterly on 11g/12c GRID & RDBMS homes using Opatch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN.

Installed GoldenGate and configured GoldenGate v11 and 12c on AIX 6.1 and RHEL 5.8,6.7 platform and Performed Cross platform migration and used Oracle Golden Gate to migrate databases from AIX to Linux as a part of u12 Cloud migration project.

Used GoldenGate 12c new features: Configured Integrated Extract, Integrated Replicat and coordinated replicat on Oracle multitenant database 12.1.0.2.

Performed Zero-Down Time migration from AIX to RHEL using Expdp and GoldenGate and process improvement for GoldenGate by proactive monitoring using Shell scripts

Configured Extract and Replicate pumps for golden gate replication 11g/12c and Troubleshooting issues in GoldenGate Environment using report files & logdump

Configured BI-DIRECTIONAL replication and replicated tables between instances and used CDR parameters to resolve conflict

Used Logdump Utility to Investigate data on the trail and Defgen utility to create definition files used for replication

Installed WebLogic server 12c and Installed Oracle GoldenGate Veridata and Agents and created jobs compare data between instances

Environment: Oracle 11g/10g/12c, HP-UX 7.x/11.x, IBM AIX-6.1, RHEL 5.x, 6.x, OEM 11G/12c/13c, RAC11gR2, 12c, ORACHK, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL, Database10g/11g/12C, RMAN, DATAPUMP, WebLogic server 8.1/9.0,10g/11g, Goldengate11g, 12c, orachk Defgen, Logdump, ASH reports, Oracle Patching Opatch, Data Pump, putty.

Client: Care First Inc., MARYLAND, MD

Duration: (Sep 2013 to July 2015)

Role: Sr. Oracle Database Administrator

CareFirst BlueCross BlueShield is a not-for-profit, non-stock health services company which, through its affiliates and subsidiaries, offers a comprehensive portfolio of products and administrative services to individuals and groups in Maryland, the District of Columbia and portions of Northern Virginia. It is the largest health care insurer in the Mid-Atlantic region, serving 3.2 million members. The mission of CareFirst BlueCross BlueShield is to provide health benefit services of value to customers across the region comprised of Maryland and the National Capital Area.

Responsibilities:

Upgraded GoldenGate from 11g to 12c while upgrading Oracle databases.

Expertise in Oracle GoldenGate installation, configuration, and trouble-shooting GoldenGate issues.

Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate

Upgradation of databases from 11.2.0.2 to 11gR2 and Applied patches to databases 10g/11g

Configured backup & recovery solutions using RMAN and NetBackup, Troubleshooting RMAN failed and resolved issues, performed Block Recovery, Data file Recovery.

Responsible for setup and implementation of two node RAC and three node RAC on Oracle 11g.

Migration of large number of databases from 10g to 11g and implemented ASM on RAC and stand-alone databases and Applying PSU Patch and Migration of non ASM database to ASM database.

Performance tuning of databases using AWR, ASH reports, ADDM reports, provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage, Oracle 11g new partition techniques Interval partitioning, system partitioning, Creating Views & Materialized Views, Implementing SQL profiles and Migrating SQL profiles, Creating and rebuilding Index’s, re-organizing tables

Configured repository database for setting up OEM 12c used 10g,11g for monitoring databases, created administration group, template design, Black out, Database Administration, AWR, ASH, ADDM, SQL Tuning Advisor, monitoring performance of databases etc. using OEM 11g, 12c.

Performed various tasks on ASM: Installed standalone servers on ASM, used asmcmd to manage disk groups in ASM environment and Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM, tuning ASM parameters for better performance.

Creating table partitions and dropping partitions when required, creating indexes and rebuilding indexes for maintenance, creating new dblinks for new environment.

Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls.

Configured Oracle Data guard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required.

Developing Hibernate Configuration files for MySql 5.1, Oracle 10g &11g and MongoDB.

Wrote services to store and retrieve user data from the MongoDB for the application on devices.

Used Mongoose API in order to access the MongoDB from NodeJS.

Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for issues and validating disk space.

Environment: Oracle 11g/10g, Oracle 12c(Testing), Oracle GoldenGate 10.4, Oracle GoldenGate 11.2 & 12c, Data Guard, Oracle Enterprise Manager Grid Control, Oracle Enterprise Manager (OEM), MongoDB, Sun Solaris,Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Client: Arkansas Oklahoma Gas

(Arkansas Department of Human Services) Fort Smith (AR)

Duration: (Aug2012 to July 2013)

Role: Sr. Oracle Database Administrator

Arkansas Oklahoma Gas Corporation (AOG) is a natural gas company serving approximately 60,000 customers in Western Arkansas and Eastern Oklahoma. AOG provides natural gas service to residential, commercial and industrial customers and also transports natural gas produced from local wells to the interstate pipeline system. AOG is continuously upgrading and expanding its pipeline system and developing new sources of natural gas supply in an effort to meet the growing and ever-changing needs of its most valuable asset

Responsibilities:

Performed Upgrades, Bug fixes, 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.

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.

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.

Installed OEM repository database, 12c agents on hosts and discovered targets and created new Groups, Templates, and Incident Rule sets in OEM 12c.

Performed tasks like Database Sizing, Table space Management and Rollback Tablespace Management, Transaction Management and Security Administration.

Managed Oracle space, performed Oracle table space management tasks, maintained tables, database objects and Rebuilding indexes for better performance of Oracle database.

Extensive Performance Tuning, Memory (SGA) Tuning, RAID, RAW Devices and Involved in Writing shell scripts to monitor table space and extent growth.

Tested many scenarios in RAC, Data Guard and RMAN environment.

Performed fresh installation of 11.2.0.3 RAC on Automatic Storage Management and created databases in RAC environment.

Installation and configuration of Golden Gate and Replication of data using Oracle Golden Gate.

Migrated applications from UNIX to Linux using golden gate with minimum down time and resolved issues in Golden Gate.

Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate

Configured backup & recovery solutions using RMAN and NetBackup, Troubleshooting RMAN failed and resolved issues, performed Block Recovery, Data file Recovery.

Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes.

Environment: Oracle 10g/11gR2, AIX 6.1, RHEL 5.x, OEL 6.3, OEM 11g/12C, EXADATA, RAC 10g/11g, ASM, Data guard 10g/11g, Data pumps, RMAN, TDE, AWR, ADDM, ASH, TTS, GoldenGate, RAC

Client: IDEA Cellular Network Hyderabad (India)

Duration: (Mar 2010 to May 2012)

Role: Oracle DBA

Idea Cellular is an Aditya Birla Group Company. Idea is a pan-India integrated GSM operator offering 2G, 3G and 4G services, and has its own NLD and ILD operations, and ISP license. Idea is one of the top three mobile operators in India, with annual revenue in excess of USD 5 billion and a revenue market share of 19 per cent. With nearly 200 million subscribers, Idea ranks sixth in the global rankings of operators in subscriber terms, for single country operations.

Responsibilities:

Setup physical standby’s (DATAGUARD) for several Databases running 11g well (Container level and Non-CDB).

Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via command line and GUI.

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.

Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.

Statistics and Reporting: Various Golden Gate commands like STATS/LAG, RANGE to check the performance of various processes.

Manage the databases using OEM.

Making sure that proper RMAN backups are in place as part of a daily job.

Configured parameter file, Listener and Net service names manually for production and physical standby databases in Data-guard environment.

Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate

Configured and implemented Oracle Streams (Advanced Replication) for high availability.

Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.

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

Performing pre health check on 11i E-business suite.

Reduced the timelines of patching using features like defaults file and merge patch.

Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory.

Environment: Oracle 11g, Red Hat Linux 5.8, OEM, RAC, Oracle Advanced Security, Pluggable databases, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, Opatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations

Client: SBI (state bank of India), Mudhinepalli (India)

Duration: (july2008 to Jan2010)

Role: Junior Oracle DBA

State Bank of India (SBI) is an Indian multinational, public sector banking and financial services company. It is a government-owned corporation with its headquarters in Mumbai, Maharashtra. SBI provide credible, professional and customer-focused world-class investment banking services.

Responsibilities:

Experience in moving the data from one server to another server using SFTP, FTP and SCP.

Involvement in space management, rectification of lock problems, user management.

Duplicate Database or Data Pump utility for oracle 10g and 11g servers.

Involved in construction of Disaster Recovery (DR) for all the production databases using Data Guard.

Grant and Revoked user privileges and roles as per requirement and killed blocking session.

Involved in fine tuning stored procedures by making use of PL/SQL Collections and its Bulk Fetch and Bulk Inserts features.

Maintained database security by managing users roles, privileges. Implemented new security rules via roles as per the company policies.

Installed Standalone servers on ASM and migrated databases to ASM.

Cloned oracle production databases for development and testing.

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

Daily health checkup of databases.

Resolution of day to day related issues, documentation of Oracle DBA routine tasks.

Environment: Oracle 9i, 10g, 11g, RHEL 5, Windows, Solaris 10, SQL SERVER, Red Hat Linux, Putty, PL/SQL,

Education:

BACHELOR’S IN ELECTRONICS & COMMUNICATION ENGINEERING (JNTUK), VIJAYAWADA, INDIA

Contact this candidate