| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateAfiyaEmail: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLECandidate's Name
US CitizenSUMMARY10 years of experience in managing Oracle Databases as DBAManaged databases on Linux, AIX and WindowsExtensive experience in administering 11g, 12c, 18c and 19c.Good understanding of performance tuning and Oracle Data dictionaries.Build Standby database and practice disaster recovery scenarios.Build 2-node and 4-node RAC cluster.Experience in managing databases using OEM / 13c cloud control.Experience in data transfer utilities like SQL*loader, Data pump and import/export.Upgradation of database to 18c and 19c.Participated in database migration from one data center to another.Experience in handling recovery issues using Oracle Flashback Technology.Configured ASM disks and ASM instances.Performance Tuning experience using explain plans and other various toolsUsed ASH, AWR, ADDM, SQL Profiles to tune databases.Proficient in handling databases on Oracle 11g, 12c, 18c RAC and Data Guard.Experience on Backup and recovery using RMAN.Extensive experience in database cloning and refreshing.Worked on Migration projects.Implemented Oracle Automatic Storage Management (ASM), Cluster InterconnectsService Load balancing and designing failover systems on UNIX platforms.Utilized new features with Oracle 12c, especially multi-tenancy, ASM and data guard.Installation and configuration, maintenance for Oracle Golden Gate.Proficient in Adding, removal of nodes in RAC environment and handling databases on Oracle 10g, RAC, Physical Standby Databases (Data Guard).Implemented Replications using Golden Gate (Unidirectional, Bi-directional) and performed proof of concept on the replication using Oracle Golden Gate.Expertise in installation, configuration and administration of Oracle 9i/10g/11g in very large-scale database environment (VLDB), high availability OLTP, Data warehouse (OLAP), DSS systems, and SAN environment.Expertise in Database upgrade and migration of Oracle server (10g, 11g).Performed TSPITR, duplicating database using RMAN.Involved in DR Planning.Experience in partitioning and sub-partitioning.Test and implement different physical and logical backup and recovery methods like point in time (PITR), media recovery, full / partial backup, Export/Import and Data Pump. Data loading using SQL*Loader.Applying Patch set, Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using Opatch and run Installer under UNIX and Windows.Hands on experience in oracle 11g Flashback to provide fast and easy recovery at database, table, and row and transaction level.Good exposure of advanced Security using Database trigger, Auditing.Strong Knowledge of creating Tables, Indexes, Views, Materialized views, Synonyms, Blinks, Packages, Procedures, Functions, Cursors, Triggers.Experience in managing users, privileges, profiles and schemas using Oracle Enterprise Manager (OEM) and Grid control.Developed Shell scripts for day-to-day database administration tasks that include various Corn jobs for alert logs and performance, Backups, Restores and Recoverability.Excellent experience in performance tuning of oracle databases and tuning applications using OEM GC, Cost optimizer, SQL analyzer, Performance Manager, Statspack, AWR, ADDM, ASH, RDA, Explain plan (10046), TKPROF, SQL TRACE and Oradebug.Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.Administering critical databases on Oracle Exadata X7Experience in Real application cluster, (RAC), Oracle Exadata and Golden GateExperienced upgrade 11.2.0.1 to 11.2.0.2 on ExadataExperience with configuring/administering Exadata environments.Provided 24 x 7 support and flexible to work beyond regular hours.Managing Database Structure, Storage Allocation, Table/Index segments, Undo segments, Constraints, Database Access.Create and maintain databases to Oracle Optimal Flexible Architecture (OFA) standards.Oracle Support Services are utilized for troubleshooting and database issues by creating Service Requests.Involved in all phases of Project life cycle.Self-motivated and able to work in challenging environment.A team player with excellent communication and interpersonal skill.Experience in managing database with SQL Developer / TOADHands on experience in Shell Scripting.Experience in Tablespace managementApplied Quarterly PSU patches.Worked with storage admins on ASM needs.Comfortable with both command-line and GUI interface.Proficient in writing UNIX Shell scripts to automate business process and daily backup.Experience in Application tuning using session trace file and TKPROF utility.Managed databases on Exadata X7Managed disks and ASM Disk groupsConfiguration, troubleshooting Golden Gate issues.Setup Uni-directional Golden Gate setup.Setup and managed replication using Oracle Golden Gate.Worked on Data Migration project.Worked with Oracle on open issues.SKILLS / TOOLSSoftware:Oracle Database 19c, 18c, 12c, RACOperating Systems:Linux, Solaris, AIX, Windows.Others:Oracle OEM Cloud Control 13c, 12c, 11g, Data Guard, RMAN, Remedy, Exadata X7Language:SQL, PL/SQL, Shell scriptingPROFESSIONAL SUMMARYGDH (Gov Fed Client)Oracle DBAOct 2021 OngoingResponsible for administration oracle 19c,18c and12c databases on Exadata X7.Build 4 node RAC Cluster on Linux.Setup the Disaster Recovery site and build Data Guard Environment.Documented procedures on what is being done during DR exerciseCloned databases using RMAN Active Duplicate to AWS.Migrated and managed databases on AWS.Moved ASM disk groups to another enclosure.Managed and maintained ASM disks.Setup monitoring of databases on Amazon cloud.Performed point in time and transportable tablespace recoveriesProactive database monitoring using 13c Cloud Control.Install Oracle supplied tools to assist in database and SQL Tuning like SQLTPerforming tuning of using Explain plan, Stats pack, AWR, ASH ADDM etcWorked on slow running queries to optimize databases performance.Worked on Performance Tuning tasks to reduce the query response time.Remove unnecessary histograms in highly volatile schemas.Performed tasks on setup users accounts, passwords, roles, profiles and quotaMonitored data files, logical data storage and data growth activitiesSupported 24/7 on-call pager support for mission critical financial databases.Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.Managed Golden Gate Extract and Replicate processes in GG replication.Created database maintenance plans, including updating statistics, re-indexing, structure modifications, Capacity plans, and index analysisApplied extensive knowledge on Data Dictionary.Analysis and management of Oracle problems/defects using SRs and/or Metal ink with Oracle Corporation and installation of patchesCreated Triggers for multi-master replicationWorked with client on regular basis.Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.Served in an administrative role regarding database privileges, security, and migration.Developed policies and procedures for system operations to better serve clients.Cloned oracle databases using RMAN duplicate.Refreshed databases using Data PumpPatched Grid and RDBMS homes.Express Script, St Louis, MOAPRIL 2017 TO OCT 2021ORACLE DBAResponsibilities:Part of 5 DBAs who supported over 80 Oracle databases 12c and 18c databases.Worked on database migration project.Converted standalone to 2-node RAC clusters.Build Standby databases.Configuration, troubleshooting Golden Gate issuesSetup Uni-directional Golden Gate setupSetup and managed replication using Oracle Golden Gate.Worked on Data Migration projectsManaged databases from file system to ASMMonitored databases using 13c Cloud control, remedy, and shell scripts.Cloning database using RMAN backups and RMAN Duplicate.Performed performance and tuning using AWR, ASH, ADDM, SPA, advisors.Tune SQL with SQL Baselines and SQL profilesPatched databasesUpgraded databases from 11g to 12c to 18c.Refreshed lower environments with Data Pump and export / import.Copied databases using RMAN duplicate database and physical standby.Assisted other DBAs on best practices on managing RACParticipated in design, document and deployment of database team meeting.Troubleshoot storage and RAC issuesImplemented Disaster Recover Site with Data Guard on AWS using EC2 instances.Implemented shell scripts to automate jobsTuned slow running queries with execution plan and SQL Plan management.Worked on table partitioning.Familiar with data dictionaries and dynamic views.Refresh database using data pump.Familiar with RDS instance management on AWS.Participate in on-call rotation.Worked in onshore-offshore model.Clone database using RMAN duplicate.Familiar with OVMs in Exadata.Configure backups in ZFS (moved from Commvault)Setup alerts in OEM.Configure grants, roles and privileges to restrict permissions.Migrated database using RMAN duplicate.Proactive performance monitoring, and capacity planning for future growth.Performed Range Partitioning as a cause to improve the performance of the database.Performed Cross platform migration using transportable tablespaces and RMAN.ENVIRONMENT: ORACLE 12C, 18C, RAC, EXADATA, AWSTransunion, Chicago, ILAPR 2013 MAR 2017ORACLE DBAResponsibilities:Designed, configured and installed Oracle Real Application Clusters on a 3 node Cluster.Installed, patched, configured database software.Monitored, maintained, tuned databases.Configured and monitored database backups.Assisted developers in troubleshooting SQL performance issues.Duplicated production DBs to lower environments using snapshots.Used Oracle OEM cloud control, toad, SQL Plus to manage databases.Monitored space usage, performance tuning.Created oracle servers, configured RMAN and OEM database control.Managed daily tasks using unix scripts via cron.Proactive real-time monitoring with OEM grid control and cron based UNIX shell scripts.Migrated data to lower environments using data pump export / import.Data warehouse database size in hundreds of gigs with partitioning.Monitored space usage, performance.Created tables, sequences, indexes, other database objects.Carried rotating pager 24/7 as part of coverage team.Worked with data modelers on converting logical model to physical model.Performed backup and recovery activities on the RAC databases.Experience in taking backup of OCR.Experience in adding and removal of nodes in a RAC environment.Daily database administration tasks including backup and recovery Import/Export.Designed the database schema and created any necessary database objects.Added nodes to the RAC cluster for the increased load balancing and removed it.Applied patches or upgrades to the database as needed.Created number of LINUX shell scripts for various tasks.Worked on Oracle Metaling in case of problems.Tuned memory structures such as the database buffer cache, shared pool library cache.Setup physical standby database to protect mission critical databases.Configured ASM for RAC setup and non RAC databases.Managed databases with 8 TBUsed TOAD for various database Administration tasks.Used SQL*Loader to move data from flat files into an Oracle database.Applied various database patchesSolved database connection issues using Oracle Net Services.Applied various patches which includes quarterly critical patch.Environment: RAC, Data Guard, Solaris, AIXEver Green Group Colorado Springs, COJune 2011 Apr 2013Oracle DBARole & Responsibilities:Build 2, 3 and 5 node RAC Cluster.Build many physical standby databases.Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux ServersData modeling / Logical database design and implementation (including index design)Migration of system and applications from Oracle 10g to 11g using DatabaseConfiguring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasksCreate and maintain multiple database and deployments..Create multiple 11g databases on RHEL5 in development.Schedule backup in 11g using db console.Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10gUsing TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.Constant monitoring of database space and space managementSetting up Oracle Standby Data Guard.Setting up of Oracle and Application user accounts and passwords, monitoring application securityResponsible to improve the performance by Using the Hints, Indexes, Explain PlanPerformance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL TraceSetup and documented Oracle GoldenGate replication on 10g and 11g for support team.Worked with RAC implementation team. Added nodes.Tablespace management including, adding/resize data files, allocated quotas to user and managed disk spaceHelp developers writing database triggers, packages, procedures, functions, utilities for application development.Export and Import of User, Tables and Database using exp/imp and Data Pump.Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.Installed, migrated, configured and tested Oracle 11g databases in various environments.Extremely dedicated, selfmotivated, Pro-Active and willing to assume responsibility.Provided technical troubleshooting and give consultation to development teams.Performed Database Refreshes and Database Copies for Development, Test and Production databases.Implemented basic replication through Materialized Views.Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g, Sun Solaris Unix, Linux Windows XP, Oracle Forms 10g, Oracle Streams Oracle Reports 10g, Oracle DeveloperEducation:Bachelors from Osmania University |
