SUMMARY

• Highly experienced, energetic and solution - focused professional with diverse background in Database administration and management positions.
• Exceptionally organized with track record of success in fast paced settings, enthusiasm for improving processes, and reputation for saving time, reducing costs and increasing quality.Proficient certified oracle database administrator having 6+ years’ experience and possessing excellent skills in performance tuning, software installations, upgrades, configuration, backup and recovery, space management, production support, cloning, database security, scripting and data modeling within 10g, 11g and 12c and 18c versions of Oracle databases running on Linux RedHat, Windows and AIX operating systems platforms.
• Enhanced experience in configuring technologies like Data-Guard, Golden-Gate, Real Application Cluster (RAC) and Migrating Databases to Cloud notably AWS Cloud
• Skillful with database tools such as SQL Developer, Database Configuration Assistant (DBCA), Oracle Enterprise Manager (OEM), Data-Pump, SQL*Plus, SQL-LOADER, RMAN, Exp/Imp, DBUA, AWR, DBCA, ADDM, TOAD and many others.
• Knowledge on AWS, SQL-server and experience in Postgresql
• In depth comprehension of System Development Life Cycle (SDLC)

TECHNICAL SKILLS

Operating System: Linux, Windows, HP, Sun Solaris, AIX

RDBMS: Oracle (10g, 11g, 12c, 18c), AWS and Postgresql 9.6 and 10, SQL-Server

Language: PL/SQL.

Tools: TKPROF, EXPLAIN PLAN, AWR, ADDM, Toad, Putty, WinSCP

ETL Tools: DTS (Data transformation services), SQL Server Integration Service (SSIS), Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS)

Database Utilities: SQL*Plus, Oracle Enterprise Manager, RMAN, ASM, Transportable Tablespaces, Export, Import SQL*Loader, DataPump, Lugdump, Keycols, Foglight monitoring tool.

PROFESSIONAL EXPERIENCE

Confidential - Irving, TX

Oracle Database Administrator

Responsibilities:

• Collaborated with staff and/or customers in the planning and the implementation processes of projects and architectural designs and achieving a 5% profit to company.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Proactive-DBA responsible in supporting major projects from Development to Production via Technical Testing environments.
• Involved in daily configuration, administration of Databases of size range 30GB to 4TB running on Linux platforms.
• Installed oracle Golden Gate and Configuration for real time database replication purpose. Troubleshooting Golden Gate extract and replication issues.
• Installed and configured oracle database 11gR2, RAC and ASM/non-ASM on Linux servers
• Identified long-running database queries, refining queries for better performance while working with end- users to implement changes.
• Maintaining Database Security using auditing.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Implemented automated DBA routine tasks such as database backup and database statistics monitoring using Grid control /Crontab.
• Strong experience in space and user management, capacity planning, standby setup, backup and recovery using Import/Export, DataPump, RMAN tools.
• Delivering Oracle Database performance-tuning services for customers using EXPLAIN PLAN, TKPROF, AWR, ADDM, SQL TRACE, TOAD.
• Basic knowledge on computer science programing languages and fixes
• Written SQL scripts to create database objects like tables, views and sequences.
• Performed database reorganizations and schema refresh using Export/Import tool
• Performed full & incremental backup (cumulative and differential) using RMAN as well as implementing recovery strategies (rman catalog) to monitor them
• Implement Oracle Golden Gate (OGG) to replicate data from front-end OLTP databases to back-end Data Warehouse systems.
• Proactively maintained databases by working with Development Team to improve and optimize applications usage of database resources.
• Resolving physical and logical block corruptions while recovering using RMAN
• Applied database interim patches for bug fixes on database products using Opatch utility and building cloned instances for the Development and Test teams.
• Maintained and monitored various production servers running on Oracle database version 11g R1, 11g R2, 10g.
• Utilize BASH shell scripts on command line to interact with Linux 7.6 OS and schedule backup jobs at non peak periods
• Used the software tool OLAP for data analysis coming from different data sources
• Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and partitions.
• Created and maintained DATA GUARD for disaster recovery by implementing physical stand-by and snapshot-standby database.
• Performed database maintenance procedures to ensure optimal performance and uptime of database by running PL/SQL packages to improve performance.
• Implemented shell scripts like the BASH for the automation of daily backup duties.
• Applying regular Security Patches, Critical patch Updates (CPU) and Patch set updates (PSU) on Oracle databases.
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts
• Managing Users, Roles, privileges, profiles, schemas, SQL monitoring tools, SQL Advisor, SQL tuning and other database metrics required to enhance performance.
• Experienced in monitoring database using Oracle Enterprise Manager (OEM).
• Planned and implemented Oracle 10g, 11g, 12c Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).
• Performed Switchover using Data Guard Broker and manually as need required.

Confidential - ATLANTA, GA

Oracle Database Administrator

Responsibilities:

• Performed database replication from production to test/development environment using RMAN, Data Pump utilities
• Used Python program language to easily debug and handle errors
• Creating database objects like tables, views, indexes, constraints.
• Experience in on-premise migration from oracle to postgresql using MTK and SCT.
• Implemented automated monitoring of databases, backup and recovery activities by running cron-jobs and customized Unix Shell Scripts,
• Planned, evaluated and implemented backup strategy using Oracle Utilities such asexpdp/impdp or Rman
• Configure Data Guard for disaster recovery, golden gate for real time data replication and RAC for high availability and scalability solutions
• Responsible in database network management and involved in a Client-Server environment using TNS names, listener, Net Configuration Assistant and other configuration files.
• Used Oracle Flashback technique with guaranteed restore point to create and restore databases
• Applied security patches (Critical Patch Updates, Patch Set Updates) using “opatch” utility.
• Experienced in implementing Transportable Tablespace (TTS) feature using Data-pump (Oracle 11g, 10g) hence enabling users to move data across oracle and other broker platforms
• Expertise in implementing data refreshes (database, schema & table level) using RMAN utility and Data-pump, conventional Export/Import of Oracle 11g, 10g.
• Installed Oracle and Grid software on ASM standalone servers.
• Configured DATA GUARD and Goldengate projects which aimed at respecting the SDLC and SLA prior implementation
• Performed ASM activities by creating disk group with different Redundancy Levels and, added a disk to a disk group, making disks online/offline and mount/dismount disk groups
• Involved in data modeling both physical and logical
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities in Dataguard projects
• Implemented data confidentiality, integrity, availability and audibility policies using access control policies.
• Supported RAC production databases alongside several development and Test databases and upgraded from 10g to 11g and 11g to 12c.
• Migrated and upgraded databases of different versions to different environments and platform
• Migration of Postgresql database to AWS EC2 and RDS cloud instances using MTK and SCT
• Database backup and restore using pg dump on postgresql database.
• Use of MVCC to implement read consistency
• Installed and configured open source postgres on windows and linux
• Created databases, tables for data population in postgres
• PostgreSQL Installation, Configuration, Migration, Upgrades for server versions ranged from PostgreSQL 9.6 to 10
• Database migration to an EC2 AWS cloud
• Experience in writing UNIX/SHELL scripts for providing the reports
• Implemented the consolidation and transformations of data from multiple sources into useful format using the Oracle Warehouse builder ETL tool
• Used the ETL-tool to perform data integration from various sources with goal to decrease stress on production systems