| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateLAXMIPHONE NUMBER AVAILABLEEMAIL AVAILABLELINKEDIN LINK AVAILABLEPROFESSIONAL SUMMARY:Having 10+ years of experience as an Oracle Database Administrator, Having hands-on experience in database administration, production support, installation, configuration, upgrades, patches, cloning, performance tuning, backup and recovery, space management, database security, Database Migration from On-premises to AWS, and documentation.Proficient in Oracle database architecture, Having experience with Oracle 11g, 12c, and 19c RAC and Non-RAC Databases on Linux, AIX, and Windows platforms.Having hands-on experience in the complete lifecycle of Production Databases, including installations, upgrades, patching, cloning, backup/recovery, decommissioning, and High Availability (RAC and Data Guard).Proficient in restoring and recovering databases using RMAN/Data Pump.Experienced in deployments and Application Testing using Flashback technologies by creating Guaranteed restore points.Supported application teams for database Monthly Releases and troubleshooted Oracle databases in case of issues.Experience with database design, performance tuning, and managing large-scale production databases.Configured TDE encryption to encrypt tablespaces and sensitive columns, and network-level encryption using TCPS.Involved in Database Performance tuning services via AWR, ADDM, TKPROF, Explain Plan, SQL Tuning Advisor .Configured and maintained Oracle Enterprise Manager 12c/13C for monitoring databases.Developed and enforced database-related policies, standards, naming conventions, operating procedures, and best practices.Developed complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.Configured Unidirectional and Bidirectional replication using Oracle Golden Gate and implemented conflict detection and resolution.Proficient in AWS database services, including EC2, RDS, VPC, S3, IAM, CloudWatch, EBS, Elastic Load Balancer, DynamoDB, AWS CLI, CloudFront, CloudFormation, Amazon Aurora, and DynamoDB Cross-Account Access.Proficient in Automatic Storage Management (ASM), including installing, configuring, and managing ASM services on standalone and RAC environments.Experience in designing and configuring high-availability systems using Data Guard with Physical Standby and Active Data Guard for both Standalone and RAC databases. Proficient in configuring Data Guard broker (DGMGRL).Experienced in Oracle RAC Architecture.Configured load balancing at the server side, and client side, TAF (Transparent Application Failover) for the RAC database.Troubleshooted cluster databases using command-line utilities CRSCTL and SRVCTL.Knowledge of Installation, deployment, and managing MongoDB.knowledge of MongoDB backup/recovery procedures and MongoDB Replication.Basic knowledge of Oracle-based ETL processes, including data extraction, transformation, and loading, and data flow across systems.Experience in PostgreSQL Database Administration on V12, V13 and V14.Good knowledge of PostgreSQL Database Architecture.Installing, and configuring PostgreSQL using GUI and silent modes.Experience in handling Database Logical and Physical Backups.Experience on restoration techniques on PostgreSQL /PPAS like pg_restore and point-in-time recovery (PITR).Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.Proactive managing standby replication methodologies like streaming replication, Cascade replication, Logical replication, log shipping replication and Pgpool, EFM, and Pgbouncer for load balancing.Experience in Oracle to PostgreSQL migration using ora2pg, DMS tool.Technical Skills:Operating systemsHP-UX, Sun Solaris, AIX, Red Hat Linux (RHEL) and Windows.DatabasesOracle 19C/18C/12C/11g, RAC, SQL Server 2014 & 2019,PostgreSQL,DB2 and AWS.Oracle Database ToolsExadata, Golden Gate, RMAN, Data Pump, API, Toad, OEM, SQL Developer, DBCA, RMAN, SRVCTL, CRSCTL, DB Artisan, ASM, OEM Grid Control, Jagent and Load balancer.LanguagesSQL, Basic shell scripting and Ansible.Work Experience:OSG Connect, Dallas, TX Nov2023 to till dateRole: Senior Oracle Database EngineerResponsibilities:Performed Installation, configuration, design, troubleshooting and production Support of oracle Multitenant 12C and 19C databases on Linux Solaris.Experience in Maintaining the 12C & 19C Exadata Multi-Tenant Container and Pluggable databases on Exadata Machine.Managing Oracle Databases on AWS on EC2 and RDS services and migrating standalone databases to AWS Cloud environment.Experience in migrating databases from On-prem to AWS cloud infrastructure using Links, Datapump and RMAN tools to create EC2 and RDS instances.Experience in setting up Oracle GoldenGate one-way, two-way/bi-directional, active-to-active, and active-to-passive data replication with conflict detection and resolutions.Installation on Oracle Golden Gate, configuring extract, replicate and initial load and ensures the data replication are running without lag and keep databases sync until the time of cutover.Involved in database troubleshooting and maintenance activities and solve some GoldenGate issues such like abended, lagging, long transaction, troubleshooting and latency issues.Worked on Oracle Golden Gate, configuring extract, replicate and initial load and ensures the data replication are running without lag and monitoring through Jagent setup.Test initial Data Load option of Golden Gate during environment build and Investigate Replication failures using Log Dump utility.Experience in in Upgrading Oracle GoldenGate from 12C to 19C on RAC databases.Experience in Upgrading Oracle from 12C to 19c using autoupgrade tool.Applied the Oracle quarterly released patches (PSUs) to the CRS & RDBMS homes which fixes the bugs in the Cluster and database environment in a rolling fashion.Experience in setting up DDBOOST backups on for new build databases and upgrade databases.Experience in Switchover and failover operations during DR testing of critical production databases and the Archive Gap Resolution rebuilding standbys.Performing day-to-day database administration tasks like tablespace usage, checking alert log, trace files, Data guard standby validation, LOG Shipping, CRS processes, Listeners and Sessions, monitoring disk usage, Table/index analyze jobs, database backup logs etc.Worked on major deployment changes in production databases with application team.Analyzed performance with respect to OS, network, database, procedural and suggested possible improvement.Experience in configuring new build DBs for Production monitoring 13C OEM grid control.Supported rigorous application development, testing and tuning efforts for business-criticalapplications by closely coordinating with application teams and Offshore DBAs.Environment: Oracle 19C/12C RAC, Exadata, OEM13C, RMAN, GoldenGate, Data guard, Ansible, Jagent setup, Exp/Imp Data Pump, SQL server, TOAD, Shell Scripting, Linux, AIX, Solaris, ASMMicron Technologies, Boise, US Jul 2020 to Jul 2022Sr.System EngineerResponsibilities:Performed Installation, configuration, design, troubleshooting and production Support of oracle Multitenant 12C and 19C databases on Linux.Configured Physical, Active and Snapshot standbys to maximize database availability and quality assurance testing for application team.Experience in Maintaining the 12C & 19C Pluggable databases on Exadata Machine.Experience in Switchover and failover operations during DR testing of critical production databases and the Archive Gap Resolution rebuilding standbys.Rebuilding standby database using production backup and making sure DR and PROD are in sync.Experience in Golden Gate setup for unidirectional replication and test initial Data Load option of Golden Gate during environment build and troubleshooting maintenance issues.Executed and provided ADDM, AWR and SQL Management reports to end user and recommended solutions for improved performance.Delivering SQL and Database performance tuning services via Explain Plan, TKPROF, AWR reports, ADDM, SQL Tuning Advisor, Oracle Enterprise Manager (OEM) and analyzing SQL trace dumps.Supporting Critical Change Requests related to Production databases and generating AWR and ADDM reports as well as identifying the top resource consuming SQLs.Monitored and tuned database systems to optimum levels of performance, performed system upgrades in support of business processing requirements.Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.Responsible for migration of all objects into different test instances like Development, Integration test, production whenever required.Experienced in Oracle support raising SR process for technical request through Metalink.Co-ordinated and participated on bridge calls on various occasions and part of on call DBA support.TATA Consultancy Services Dow Chemicals, MI, US Jul 2019 to Jun 2020IT AnalystResponsibilities:Performed Installation, configuration, design, troubleshooting and production Support of oracle 11gand 12c databases on Linux, Solaris and AIX.Experience of handing issues on Dataguard (Standby Database).Involved in Configuring and maintaining 4 Nodes 12C/11g RAC for production databases Automatic Storage Management (ASM) and Data guard for high availability databasesExperienced with SRVCTL, CRSCTL, OCR and Voting Disk of 11g RAC.Migrating standalone databases and support Databases on AWS RDS cloud environment.Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups with Export /Import.Involved in monitoring daily crontab jobs for RMAN Backups, Data guard standby validation, LOGShipping, CRS processes, Listeners and Sessions.Experience in configuring Commvault backups for all types of databases.Performed High availability HA test for newly built clusters and databases.Proficient in managing Oracle Instance, database storage structure, schema objects.Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.Creating and managing Users, Roles, Groups and handling database security policies.Supported various application teams by providing subject matter expertise and improving efficiency in debugging application related issues.Analyzed performance with respect to OS, network, database, procedural and suggested possible improvements.Used shell scripts for monitoring jobs, for startup and shutdown, health check of databases, analyzing stats at different levels, rebuilding indexes as well.Identify risks involved with replicating highly volatile tables with large data volume.Perform routine DBA activities like maintaining Space, Schema management and troubleshooting the Databases issues and solving the Incidents.24/7 support for Production databases and responsible for round-the-clock database operations and ensured customer satisfaction as the prior importance.Infosys Limited ConAgra Foods, Omaha, US Sep 2015 to June 2019Technology AnalystResponsibilities:Performed Installation, configuration, design, troubleshooting and production Support of oracle 10g and 11g databases on Linux and AIX.Maintaining SAP and NON-SAP Oracle Database environments.Performed migration for large SAP 2TB Oracle databases from Solaris to Linux.Experience configuring and maintained setup of oracle 11g Physical Standby database using RMAN active duplicate method for production.Managing standby databases with 0% ensured data loss guarantee and managing the gaps in archive logs to bring the standby in sync with primary database.Maintaining 4 Node 11gR2 RAC with ASM production databases.Supported rigorous application development, testing and tuning efforts for business-critical applications by closely coordinating with application teams and Offshore DBAs.Performed the Migration of large 2TB critical databases from Solaris to Linux.Worked on SAP BRTOOLS Like BRCONNECT, BRRESTORE, BRSPACE and BRARCHIVE.Creating new Oracle databases using DBCA or database scripts. Installing creating new ASM disk groups for both 10g and 11g RAC databases.Recommendations on database parameter changes, reorganization strategy and scheduled purge jobs on huge tables resulted in enhanced database performance.Managing space requirement with capacity planning management team & adding space to ASM/non ASM disks.Effective coordination and management of planned and unplanned changes and incidents relating to the PROD and Non-PROD databases.Scheduling RMAN jobs in Crontab and troubleshoot failed RMAN backups. Registering databases in catalog database and crosscheck backup.24*7 production database support to developers & end-users and resolving the tickets depending upon the issues.Delivering SQL and Database performance tuning services via V$/GV$views, Explain Plan, TKPROF, AWR reports, ADDM, SQL Tuning Advisor, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 10g/11g databases.Enterpts IT Services Commercial Metals CompanySoftware Engineer Aug 2012 to Sep 2015Responsibilities:Performed Installation, configuration, design, troubleshooting and production Support of oracle 10g and 11g databases on Linux and AIX.Experience of handing issues on Dataguard (Standby Database).Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 11g RAC.Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups with Export /Import.Database refreshes using Logical Export/Import & Expdp/Impdp utilities.Involved in monitoring daily crontab jobs for RMAN Backups, Data guard standby validation, LOGShipping, CRS processes, Listeners and Sessions.Proficient in managing Oracle Instance, database storage structure, schema objects.Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.Creating and managing Users, Roles, Groups and handling database security policies.Supported various application teams by providing subject matter expertise and improving efficiency in debugging application related issues.Identify risks involved with replicating highly volatile tables with large data volume.Perform routine DBA activities like maintaining Space, Schema management and troubleshooting the Databases issues and solving the Incidents.Experience in Planning Database, Sizing table space, create database, scripts, monitor databases, interact with developers, working on tickets and 24x7 critical production support.Identify risks involved with replicating highly volatile tables with large data volume.Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.Experience in Performance tuning techniques like EXPLAIN PLAN & SQL TUNING ADVISOR.A team player with concern for quality at all levels and ability to perform under stress.EducationBachelors in Information technology with JNTU in 2012 |
