Siva Kumar Makkapati

Oracle Database Administrator

Email: aczij9@r.postjobfree.com

Phone: 669-***-****

PROFILE OVERVIEW:

Around 8+ years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 12c/11g/10g on Red Hat Linux, Oracle Enterprise Linux and Windows

Experience Synopsis:

●Professional IT experience as an Oracle database administrator,Good Experience in Managing RAC Databases for ORACLE 10g,11g,12c and maintaining ASM Instances, Experience in Managing Standby databases using Dataguard

●Extensive experience in Database development and 24x7 production system support handling large databases using Oracle 10g, 11g, 12c on various platforms which include Oracle LINUX, WINDOWS.

●Good Experience in planning and designing new RAC clusters, Databases for ORACLE 10g,11g,12c and maintaining ASM Instances.

●Creation of tablespaces, user maintenance, database security imposition by creation and granting of roles and privileges, backups.

●Sound Knowledge in 11g, 12c Database architecture, Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

●Good Experience in Working in Exadata Environment X3-2 and managing databases in Exadata x3-2 and familiar with features in Exadata

●Creation of Duplicate Database Using RMAN, Strong in Oracle Backup and Recovery

●experience in Analysis, Design, Development, Testing, Customization, Bug fixes, Enhancement, Support and Implementation of various web, stand-alone, client-server enterprise applications using Python, Django in various domains.

●Extensive experience in system analysis, design, development and implementation of web based and client/server application using HTML, AngularJS, Bootstrap, underscore.JS, Node.JS, CSS, JavaScript, AJAX, JSP, JDBC, XML, XSLT, Python, Django.

●Good Experience in Linux Bash scripting and following PEP Guidelines in Python.

●Experienced with databases using ORMs/DOMs for integrating with MySQL, Postgres, Neo4J, MongoDB, and Cassandra SQLite.

●Architecture, size (Capacity planning), Data modeling, implementation and support Cassandra Clusters including install, configure and upgrade DSE v3/4 (Cassandra v 1/2.x) and OpsCenter v 4.x/5.x on Bare metal and Cloud including AWS (Amazon Web Services).

●Strong in Production Maintenance, Managing Oracle security and network tools

●Experience with migration, upgradation and applying patches from 10g,11g and 12c

●Expertise in monitoring databases using Enterprise Manager O.E.M 10g, 11g and 12c

●Coordinated and Upgraded Test/Development/Pre-production/Production databases to latest Oracle Version.

●Database space management, Object Management, Operating System monitoring and space management.

●Exadata Administration, which includes migration of DBs, Resource Management, Monitoring and Troubleshooting, Storage Management, Infiniband Switch, Performance Tuning, CellCLI and DCLI commands, Resource Management, Upgrade and Patching.

●Loading bulk data from flat files using sql*loader and external tables.

●User creation and applying appropriate privilege, Backup and Recovery: Physical Backup (Hot, Cold and RMAN Backup), Cloning of 10g, 11g,12c Databases.

●Performing logical backups by Export/Import utilities and Data pump utilities.

●Involved in many critical issues and crisis calls as part of everyday work.

●Best practices on production support policies of ITIL

●Excellent interpersonal and communication skills; strong analytical skills and a demonstrable bias toward action

TECHNICAL SKILLS

Databases : Oracle 10g, 11g, 12c, Oracle 11g Real Application Cluster

(RAC),ASM

Operating Systems : Linux, UNIX, Oracle Enterprise Linux, Red Hat Linux 4.x,

5.x,6.x and Windows 2000,XP,2007.

Tools and : RMAN, Export, Import, Data Pump, OEM, SQL, WinSCP

Utilities Control-M, Patrol Monitoring, Putty, TOAD, SQL*Plus

SQL * Net, SQL * Loader, SQL, Cloning, Migrations

UNIX Shell Scripting

EDUCATION

Bachelors in Information Technology JNTU, INDIA 2008

PROFESSIONAL EXPERIENCE

Client: Caliber Home Loans Inc. Irving, TX

Aug 2015 -- Till Date

Role:Sr. Oracle Database Administrator

Responsibilities:

Installation, configuration and maintenance of Oracle 11g and 12c databases on Sun Solaris and RHEL.

Expertise in Installing and configuring ASM and RAC for high availability databases

Worked on Multiple RAC clusterand adding instance to the existing 3 Node RAC database, creating and managing services on RAC databases

Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.

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

Monitoring the Oracle Instances, Users, Tables, Table spaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.

Involvement in space management, rectification of lock problems, managed quotas.

Created & administrated all database objects, including tables, Indexes, views, sequences, packages, DB Linksand procedures.

Performance Tuning of Oracle database using OEM GC, Cost optimizer, SQL analyzer, Performance Manager, Stats pack, AWR, ADDM, ASH, RDA, Explain plan (10046), TKPROF and SQL TRACE.

Responsible in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, AWR, ADDM, ASH

Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.

Wrote Python scripts to parse XML documents and load the data in database.

Development of Python APIs to dump the array structures in the Processor at the failure point for debugging.

Used Python based GUI components for the front end functionality such as selection criteria. Administration of dedicated collocated RHEL 4 machine and configured complex Apache configuration files.

Representation of the system in hierarchy form by defining the components, subcomponents using Python and developed set of library functions over the system based on the user needs

Created Python and Bash tools to increase efficiency of call center application system and operations; data conversion scripts, AMQP/RabbitMQ, REST, JSON, and CRUD scripts for API Integration.

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Designed and developed various custom packages triggers and forms

Loaded the data into database tables using SQL*loader from text and excel files.

Developed data model, SQL Coding, SQL Query tuning process and Schemas.

Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination

Created SQL*plus reports as per client's various needs, and developed business objects.

Experience in upgrading database from 11.2.0.4 to 12.1.0.2

Involved in migrating databases from Sun Solaris to RHEL.

Cloned schemas, objects and data on new server using Data pump.

Creation, Configuration and setting up of RMANcatalog databases and registering target databases with the catalog.

Planned and Implemented cross platform upgrades from 11g to 12c using Golden Gate

Extensively used Golden Gate during migration and troubleshooting issues

configured, automated and implemented physical RMAN full and incremental backups (differential, cumulative) for all databases to recover from failures.

Responsible for capacity planning, recovery planning and installing patches

Responsible in installing and setting-up Golden Gate from source to target to provide active data replication

Configured multiple scripts for starting Golden Gate processes during server reboots and automated scripts for auto restart ogg process on servers

Worked on x3-2, Implemented Dataguard between Exadata machines, setting up databases parallelism and configured scripts for monitoring standby databases

Responsible in switching over/switching back to Physical standby database

Installed 12c agents on hosts and discovered targets, worked with programmers and debugging PL/SQL, SQL, Dynamic SQL and UNIX shell scripting

Experience in writing Shell scripts and a good understanding of the Cron Jobs.

Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.

Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.

Involved in 24x7 production database maintenance and on-call support.

Environment:Oracle 12c/11g/10g, Sun Solaris, UNIX, RHEL 4.x/5.x, ASM 11.2.0.4, OEM 11g,12c, RMAN,Data Guard, Golden Gate v11, 12c, Exadata x3-2, Explain Plan, SQL Developer, PL/SQL Developer, Erwin, Data Pump, Business Objects, Toad 11.X, PUTTY, SFTP, SCP

Client: American Family Insurance Madison, WI

Mar 2013 – July 2015

Role:Sr. Oracle Database Administrator

Responsibilities:

●Provided 24x7on call support for all the production databases on rotation basis.

●Configured and Upgraded to Oracle 12c from 11g.

●Installed ORACLE Enterprise Manager11g, 12c and configured it server targets for a centralized monitoring system.

●Installed Oracle R12 EBS with 11gR2 RAC and Successfully implemented physical standby database using Oracle Data Guard feature for High availability.

●VLDB migration and replication using GoldenGate TDM technology.

●Administration and Troubleshooting GoldenGate.

●Build new and enhance existing GoldenGate implementations in development, testing and production environments.

●Administer and manage Oracle Grid Control high availability RAC & ASM.

●Creation of table spaces, user maintenance, database security imposition by creation and granting of roles and privileges, backups.

●Provided support for Advanced Replication using Golden Gate Technology.

●Configured and implemented Oracle 11g ACTIVE DATAGAURD for Database Disaster Recovery by using DATA GUARD

●Database recovery, moving data files to different locations.

●To Check Alert Log errors and to make necessary actions to rectify them.

●Managing the roles and privileges, Export/Import of Tables, Users and Databases.

●Creation of Database and location of initial data files, redo log files, control files and multiplexing them editing database initialization parameter files.

●Performing RMAN backup and Database cloning, control file rebuilding.

●Changing Database from No archive to Archive, taking logical and physical backups periodically and Monitoring the database growth.

●Up gradation of databases by applying patches in rolling fashion using opatch auto

●Migration: Duplicated database using RMAN and upgraded it to oracle 10g/11g and applied latest patch set.

●Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

●Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.

●Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.

Developed Procedures for efficient Error Handling process by capturing errors into user managed tables

●Worked on various PL/SQL features like Cursors, REF Cursors, Collections, Analytical Functions and Bulk Binding along with the various Exceptions in the PL/SQL Stored Procedures.

●Involved in Performance tuning and Query optimization.

●Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tablesin pl/sql blocks and even have experience with exception handling..

●Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.

●Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.

●Designed, configured and maintained backup and recovery policies including RMAN backups and Optimized the query result cache for best performance.

●Troubleshooting Database related issues, Proficient with Standby Database, Data Guard and Replication.

●Worked on TSPITR using RMAN, handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations on as needed basis.

●WroteSQL scripting to monitor the extent growth, Shell scripting to monitor table space and extent growth, Space Management, which includes table space creation, adding new data files.

●Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.

●Solid discipline in providing end-users timely updates on their problems and installing server software.

●Migrating and upgrading the Oracle 10g database to Oracle 11g.

●Monitor, Maintain/administer existing databases security with Oracle database environment.

●Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects.

●Performing automatic product deployments and repeated database maintenance and monitoring tasks.

●Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schema, table spaces and other database objects.

●Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.

●Importing of dumps using impdp/expdp utilities.

●Loading bulk data from flat files using sql*loader and external tables.

●Monitoring weekly maintenance DB activities like DBCC and fixing bugs, Creating indexes, Update Statistics etc.

●Managing and monitoring use of disk space, performing data refresh from Production to Dev and UAT and DR Servers.

●Implementation of different security policies by granting or revoking permissions to users, groups and server level roles.

●Managing server configuration parameters as per requirement.

●Wrote SQL queries related to DBA use and documented them for future use

●Hands on experience on problem management and change management.

●Involved in tuning the server parameters.

Environment: Oracle 10g/11g/12c databases, EBS R12, Oracle’s OEM 11g,12c, Dataguard, Golden gate, RMAN, Data pump, Export/Import, Migration, Upgradation, Physical Backups, Linux, Oracle Enterprise Linux, TOAD 10.X

Client: State of Montana Health care & Benefits Division Helena, MT

Role:Sr. Oracle Database Administrator

May2011 to Feb 2013

Responsibilities:

●Installed, upgraded and patched Oracle installations.

●Implementation of Data Guard for disaster recovery on both 10g & 11g.

●Installation, Configuration of Oracle Data Guard for Physical and Logical mode.

●Perform administration of Oracle Data guard, converted physical standby to snapshot standby databases

●Implementation of Data Guard for disaster recovery on both 10g & 11g.

●Set up, configured and maintained oracle data guard (primary and standby databases) to ensure recovery, high availability and data protection.

●Extract from Oracle 10G redo logs, setup extract process to read the redo logs and replicate the data to the target system using several mapping statements using GoldenGate parameters.

●Test the software before moving to production, UAT, QA, and Build test the application, Load data to the source and target databases based on GoldenGate requirement.

●Extensively used Database Administrative tools like Oracle Enterprise manager (OEM) Grid control, DBA Studio, SQL*PLUS, TOAD, DBA Artisan.

●Installation and maintenance of Oracle 9i/10g on Linux OS.

●Used Datapump utilities, SQL, PL/SQL, RAC, RMAN backup & recovery, ASM and Linux shell scripting.

●Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.

●Worked on user management mainly on grants, privileges, roles and profiles.

●Designing and developing SQL procedures, query performance tuning.

●Performed hot and cold backup and recovery using RMAN and UNIX Scripts

●Worked on Problem areas to enhance performance.

●Monitored database and system performance.

●Worked on application and database security (data access, passwords, network)

●Handled daily production problems/change requests with Oracle.

●Performed daily database administration tasks: User management, Space monitoring, Performance

●Monitoring and tuning, Alert Log monitoring and backup monitoring.

●Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).

●Management of the databases; pre-empted and prevented issues, disasters from happening.

●Monitoring tablespace issues, creating tablespaces and adding data files.

●Involved in session management and monitored the critical wait events, blocking sessions in the database.

●Loading data from external files into the Oracle database.

●Tuning test and production database by altering the parameters.

● Export and Import of database objects to copy from one database to another database and Investigating suspicious database activity using Auditing.

●Involved in query optimization and using rule based optimizers and cost based optimizers.

●Detecting and correcting instance performance problems. Locating and tuning SQL statements.

●Handling Incidents and Change Requests of users by troubleshooting Level 1 and Level 2 tasks as per SLA defined.

●Run clone scripts on DEV and QA servers to copy large production database dumps very fast, finding repeated issues on the servers and fix them with permanent fixes

●Monitoring user batch processes and give updates on process status to users on time and Performing purging activities on user tables upon user requests

●Experience in analyzing logs for troubleshooting issues from server side

●Taking prod database dumps and load it into DEV and QA database servers

●Trouble shoot on Control-m job failures and fix them on time

●Find out long running queries on tables and fix them by create clustered index on them to improve performance.

●Prepared Daily database reports on excel sheet and send across global team

●Give knowledge sharing sessions to team members and keep the documents in project folder for future reference.

●Mentoring junior team members: document recurring administrative tasks for execution by junior members and perform cross-training.

Environment: Oracle 10g, 11g, Linux, Solaris, ASM, RAC, Data Guard, GoldenGate, Upgradation, RMAN, OEM.

Client: STATE BANK OF INDIA, Mumbai,INDIA

Feb 2010 – Mar2011

Role:Oracle Database Administrator

Responsibilities:

●Installation and maintenance of Oracle 10g/11g on Linux OS

●Installed, upgraded and patched Oracle installations.

●Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.

●Worked on user management mainly on grants, privileges, roles and profiles.

●Designing and developing SQL procedures, query performance tuning.

●Performed hot and cold backup and recovery using RMAN and UNIX Scripts

●Monitored database and SQL performance using Stats pack, EXPLAIN PLAN and tuned problem areas to enhance performance.

●Monitored database and system performance and Configured the Event Manager to notify support personnel.

●Handled daily production problems/change requests with Oracle.

●Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.

●Dataflow architecture, Install and configure GoldenGate software, gather requirements and modify as needed based on the application data flow.

●Worked on GoldenGate on 10g and 11g and maintained Golden Gate environment

●Performed Physical backup (hot and cold) as well as Logical backup

●Proactively managed the databases; set up alarms for managing any exceptions in day to day, Management of the databases; pre-empted and prevented issues, disasters from happening.

●Monitoring tablespace issues, creating tablespaces and adding data files.

●Involved in session management and monitored the critical wait events, blocking sessions in the database.

●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.

●Tuning test and production database by altering the parameters.

●Export and Import of database objects to copy from one database to another database.

●Investigating suspicious database activity using Auditing.

●Involved in query optimization and using rule based optimizers and cost based optimizers.

●Detecting and correcting instance performance problems. Locating and tuning SQL statements.

Environment: Oracle 10g, 11g, Linux, Unix, RDBMS, VERITAS Net backup, Golden Gate v10, PL/SQL, Shell Scripting, HTML, Stored Procedures, Triggers.

Client: Bharat Sanchar Nigam Limited New Delhi, INDIA

June 2008 - Jan 2010

Role: Oracle Database Administrator

●Install & implement Oracle databases for different projects.

●Worked on supporting RAC databases.

●Creating tablespaces and schemas.

●Performing logical backup(expdp/Impdp/exp/imp) as per the requests.

●Daily backup and maintenance job monitoring

●Maintaining weekly RMAN backups.

●Query tuning to help application development team.

●Trouble shooting Connectivity issues.

●Loading data using SQL loader and Database Character conversion.

●Experience in refreshing & cloning data between databases

●Interaction with UNIX group and Data Protector group for storage and tape related issues.

●Worked on Restoration and recovery as needed.

●Tuning and monitoring of databases and servers to insure optimum performance.

●Interaction with Operations group for any job related issues

Environment:Oracle 9i, 10g, Sql Loader Utility,SQL, PL/SQL.

Contact this candidate