Occupation:Database Administrator |
Location:Beltsville, MD |
Education Level:Bachelor |
Will Relocate:YES |
Description
Professional Summary * Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases. * Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure. * Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams. * Resolved/Diagnose Node Eviction. * Handled Multiple issues with Data Block corruption on ASM Disks. * Add or Remove Node from RAC. * Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB. * Experience in Installation of Oracle Databases 9i, 10g, 11g and 12c versions. * Experience in the Upgrade of Oracle Databases in patch set Level and also in version Level (9i to 10g), (10g to 11g) and (11g to 12c). * Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations. * Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental) * Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import. * Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities. * Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB * Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g.. * Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance. * Performing Fault Injection Test Cases for verifying the High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover. * Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM. * Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms. * Configuration and Management of Data Guard on RHEL, OEL. * Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases. * Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control. * Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS). * Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM). * Proactively monitoring the database's health and taking preventive or corrective actions * Proficient in Database Design (Physical and Logical Database Design) and Normalization. * Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM). * Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation. * Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD. * Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility. * Automated many common tasks using crontab including Backups, exports and imports.
Accomplishments
Highlights:
Keywords
