Description
SUMMARY: * 11+ years of experience as Oracle Database Administrator, providing 24x7 production, development and integration support on oracle 12c/11g/10g/9i/8i databases on different Platform. * 2+ years of experience in MS SQL Server 2012/2008/2005 database administration activities and troubleshooting in Windows platforms for approximately over 250+ instances. * 2+ years in Managing/Installing/Troubleshooting MySQL and Maria DB in production and development on Linux environments. * Around 2+ years of experience in AWS, Big data Hadoop analysis, design, development, implementation and testing of systems primarily in the distributed web application and client/server environment. * Manage and configure AWS EC2 instances services as per the business needs (EC2, Route53, S3, RDS, Cloud Watch, IAM, SNS, VPC). * Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning. * Proficient in Oracle Database Administration on Production, Development and Test Databases including Disaster Recovery, High Availability Solutions (RAC & Data Guard) and Backup & Recovery (RMAN). * Designs and Configures Logical and Physical Database Design and Construction with ERWIN and BDA tools * 3 yrs in SAP Basis environment (installation of sap, brtools, tcodes, data refresh, monitor etc. * Expert in DBA activities such as Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation * Monitor and create alerts in Enterprise Manager 13c /12 c * Agent Installation and Target Discovery in Enterprise Manager 12c * Troubleshooting OEM 12c/11g issues by viewing Log Files and Trace Files * Installation of EM 12c * Continuous review of Business-Critical Database to proactively identify space issues, performance tuning issue. * Installed oracle database server on HP-UX, AIX, WINDOWS, REDHAT LINUX and migration of oracle server from9i to 10g, 10g to 11g and 11g to 12c. * 5 yrs of experience on oracle golden gate 11,12c * Hands on experience in Data guard, Grid control, stream& replication, monitoring batch performance. * Handled entire DBA activity on server move for VERITAS cluster and Data warehouse servers. * Administration, migration, health check, resource management, patching/upgrade and SQL tuning. * STATSPACK, SQL TRACE, ORADEBUG, 11g/12c OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities. * Experience with SQL coding including DDL, DML and fine-tuning those SQL's for better performance. * Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring. * Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views. * Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic. * Installation of SQL Server Reporting Services and Folders creation and assign rights to Users. * Ensuring that all databases are backed up on a regular basis, fixing backup failures, and address implemented resolutions. * Performed MySQL Replication setup and administration on Master-Slave and Master-Master. * Perform database migrations from MSSQL and Oracle to Maria DB/MySQL. * Actively involved in Database transitioning from MySQL to Maria DB. * Worked on many Unplanned power outage and restored the DB * Manage and configure AWS EC2 instances services as per the business needs (EC2, Route53, S3, RDS, Cloud Watch, IAM, SNS, VPC).
Accomplishments
Highlights:
Keywords
