| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate [pic]SwathiEmail:EMAIL AVAILABLE Mobile: PHONE NUMBER AVAILABLE Senior Database AdministratorCertified Database Admin with 8 years of experience in Design,installation, configuration, and management ofOracle, IBM Netezza and SQL server RDBMS for multi Billionorganizations.Core Competencies Include: Oracle 19c/12C/11g/10g/9i, RealApplication Cluster (RAC) , Data Guard, RMAN,OEM 12c/13c and Golden Gate. IBM Netezza, SQL server(2008/2012/2016/2022), DPA Ignite, Spotlight, Commvault,Net Backup, EMC's Avamar, Rubrik and DD Boost.Education & CertificationOracle Certified Professional 19cAWS Certified Solutions Architect AssociateMaster's in business administrationProfessional Summary: * Extensive knowledge on database administration of Oracle 9i, 10g, 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems. * Experience on database administration of MS SQL Server 2005, 2008, 2008R2,2016,2022 instances. * 24*7 production database support with Support to developers & end- users. * Excellent experience in installation, setup and configuration of Oracle 9i, 10g and 11g on Windows, RHEL platforms. * Expertise in building RAC environments on RHEL/OEL platforms using ASM block level storage and Extensive hands-on experience on building 19c RAC databases. * Expert in converting single instance databases to RAC using RCONFIG, MANUAL CONVERSION and RMAN. * Expertise in Installation, maintenance and tuning of RAC Applications. * Installed oracle GOLDENGATE version 11.2.0.1.6 one-way replication on Oracle database 11.2.0.3. * Extensive knowledge on creating physical standby databases with Active data guard. * Expertise in upgrading the Oracle databases from Oracle 10g to Oracle 11g and to Oracle 12c. * Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN. * Implemented RMAN backup (Full, incremental, and cumulative) and recovery, Incomplete recovery and disaster recovery using Data Guard. * Experience in backup and recovery of Sql Server database using SSMS. * Strong knowledge on 12c OEM and 13c OEM Grid. (Configuring New targets, configuring Backups, Archive log jobs, scheduling/creating jobs and performance tuning). * Performance tuning of the database - SQL Tuning, Used Tuning utilities like Autotrace, STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, SQL Advisor, Foglight Performance Analyzer. * Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms * Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP. * Database replication using snapshots, materialized views and advanced replication methods. * Experience in applying security patches to databases. * Effective troubleshooting of database and Performance problems. * Good experience in Data Migration using export/import. * Management of Objects, Schemas, Partitioning the tables and Indexes. * Worked on Developing PL/SQL packages, stored procedures, functions, Cursors, triggers. * Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views. * Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN). * Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures. * Good Interpersonal communication skills and Documentation Skills.Anthem(Elevance Health) - Baltimore, MD September 2021 -Till DateOracle DBASenior Database Administrator led enterprise-wide effort in Design,installation, configuration, patching and cloning of Oracle databases.Installation and administration of Multi-node RAC Clusters. * Exadata X7 Rack, 1/8 Rack, X8 Rack VM Virtualization * Configure Exadata VM isolation using VLAN tagging. * Exadata DomU resource management * Exadata Quarterly Platinum Patching management. * Exadata H/W components Disk and DIMM replacement. * Configure and Maintain Physical Standby Data guard DB for DR at remote site. * Installed 10g/11g/11gr2/12c/19c RDBMS DB's. * Installation, upgrade, maintenance, and patching of RAC/NON- RAC12c/11g/10g/9i/8i RDBMS. * Installed OEM 13C and DPA Ignite for monitoring DBs and APPs across Enterprise wide. * Automated database backups using RMAN and Data Pump using shell script which helped in standardizing back up activity across DB tier. * Tuned SQL statements and Oracle DB's reducing batch run time for Applications, achieving performance improvement by 40%. Recommended OS parameters changes as per Oracle best practices. * Created and managed Oracle RDS instances in AWS cloud. * Worked on AWS data migration service for migrating data from on-prem to RDS. * Monitoring and Logging: Automated AWS CloudWatch alarms and logs setup with Python scripts. * Developed Python scripts to automate the scheduling and management of RDS backups, ensuring data integrity and disaster recovery readiness. * Install and Configure OEM 13c including Middleware and WebLogic components. * Responsible for continuous database monitoring and reorganization for ensuring performance. * Install and configure Oracle GoldenGate. * Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK. * Writing Shell Scripts for managing day-to-day activities and automation of backup. * Applying Quarterly and on-off patches to OMS and WebLogic components * Upgraded and Migrated databases from IBM AIX platform to Linux Platform. * Analyzed the user requirements and designed partitioned tables for improving performance of Data marts. * Point of Contact for the Database migration Project from one DC to another DC with minimal downtime. * Sql Server Database Mirroring setup/Break for DR Patching and Maintenance. * Sql Server Agent Jobs setup and troubleshooting as needed. * Documented installation, troubleshooting, backup setup, patching, migration, upgrade, so that same procedure can be carried out across Enterprise wide. * Troubleshoot and recovered multiple Databases, which were corrupted due to accidentally modification of Data, dropping table caused by human errors. * DB monitoring using Spotlight and Ignite.CGI - Fairfax, VA July 2018 - Aug 2021Oracle DBAAs Consultant worked as Senior Database Administrator led enterprise-wideeffort in Design, installation, configuration, patching and cloning ofOracle, Netezza and SQL servers RDBMS. * Installation and administration of 2 Node RAC hosting various applications like Oracle RMS, ORPOS, ATG, OMS and Fusion Middleware Technology. * Installed 10g/11g/11gr2 RDBMS DB's. * Installation, upgrade, maintenance, and patching of RAC/NON- RAC12c/11g/10g/9i/8i RDBMS. * Knowledge of Netezza Twinfin3/Striper administration tasks. * Setup ACFS and HANFS on 11g/12c RAC. * Installed OEM 12C for monitoring DBs and APPs across Enterprise wide. * Automated database backups using RMAN and Data Pump using shell script which helped in standardizing back up activity across DB tier. * Tuned SQL statements and Oracle DB's reducing batch run time for Applications, achieving performance improvement by 40%. Recommended OS parameters changes as per Oracle best practices. * Tuned DB for RMS, JDA, ORPOS, ODI and EBS applications improving application response by 60% which was noticeable to end users. * Upgraded and Migrated databases from IBM AIX platform to Linux Platform. * Implemented Oracle database security using Oracle Database Vault, Transparent Data Encryption and VPD to secure SOX and PCI compliance data. * Documented installation, troubleshooting, backup setup, patching, migration, upgrade, so that same procedure can be carried out across Enterprise wide. * Implemented Python automation for configuring AWS Cloud multi-AZ deployments and failover strategies for AWS RDS instances, enhancing availability and reliability. * Developed Python scripts to automate data migration tasks between AWS RDS instances or from on-premises databases to RDS, ensuring seamless data transfer with minimal manual intervention. * Mentor Junior level DBAs to bring them up to speed with DB concepts and Environment. * Troubleshoot and recovered multiple Databases, which were corrupted due to accidentally modification of Data, dropping table caused by human errors.CNO Financial -- Indianapolis, INMar 2016 - Jun 2018Oracle DBA * 24x7 Oracle Production Database Administration. Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on IBM z/OS with OEM Grid control to maintain the database effectively. * Proactively monitoring the database. Implementation and configuration of OEM Grid, Oracle Management Server for maintenance and monitoring data. * Hot / Cold backups of the database through RMAN, Hot backups & BCV's Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports. * Performed Cloning/Refresh to setup Test and Development database Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database. * Review alert logs and dump files to check for any problems related to the database. * Database cloning/exp/imp to setup identical databases in the production and development environments. * Worked on operating system command line utilities like SAR, TOP, MPSTAT, VMSTAT Monitored performance and availability of the VIS application a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN. * Create and maintain users, roles and privileges & Auditing Triggers. * Upgrade/Migrated the production and development databases from 10g to 11g, 11g to 12c. Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans. * Setup and configured 2 node Oracle 10g RAC with ASM. * Responsible for setting and managing user accounts, Granting required privileges to users. * Involved in Database sizing, Capacity Planning. * Perform Space Management & Troubleshooting the database issues. Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine tuned further. * Actively involved in monitoring the lock processes, releasing locks in case of resource blockage, and gathering statistics.-----------------------PROFESSIONAL EXPERIENCE |
