SUMMARY:

• Certified Oracle Database Administrator with over 4 years’ experience in implementation, tuning, development, and support of mission - critical database on both UNIX and Windows Platform.
• Strong experience with RMAN backup/recovery procedures, UNIX shell scripting, and performance tuning.
• Expertise in working with cloud database Amazon AWS RDS.
• Expert at utilizing my Management Information Systems proficiency to manage the different phases of a project life cycle from business requirements and technical definitions to testing, documentation, production support, training and completion.

TECHNICAL SKILLS:

• Proficient in all DBA responsibilities such as installation, Configuration, Upgrades, Patches, Performance Tuning, Backup, Recovery, Cloning, Space management, Database Security, Auditing, Troubleshooting, Database Design, Unix Shell Scripting, Scripting in RMAN and Documentation.
• Provided 24x7 production supports for Oracle 10g/11g/12c databases on Windows / UNIX platforms.
• Planned and implemented maximum availability and disaster recovery infrastructure using Oracle Active Data Guard with Data Guard Broker, Automatic Storage Management (ASM) and Real Application Cluster (RAC)
• Created Oracle, MySQL databases using Amazon Web Services Relational Database Service.
• SQL*Plus, Enterprise Manager (OEM), Grid Control, Data Pump, SQL Loader, Oracle Recovery Manager (RMAN), Recovery Catalog, Automated Workload Repository (AWR), ADRCI, Oracle Scheduler, Data Pump, Real Application Clusters (RAC), Standby Database (Physical, Snapshot, Logical), Unix Shell Scripting, Automatic Storage Management (ASM), MySQL, Mongo db, TOAD, putty, MobaxTerm, SecureCRT, Enterprise Reporting using Microsoft Office (Word, Excel, PowerPoint, Outlook and Project.), Amazon Web Services Relation Database Service(AWS RDS), Erwin.
• HTML, XML, Intermediate JAVA, SQL, PL/SQL

SOFT SKILLS:

• Excellent Financial, leadership qualities, team management and development skills
• Good communication (verbal and written) and interpersonal skills
• Reliable, Result Oriented, Trusted & Proactive, very hardworking, resourceful and dedicated with a high sense of duty.

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential, Atlanta, GA

Responsibilities:

• Monitors and tunes database performance during testing and production operations; coordinates and implements database sizing/resizing, restructures and index rebuilds; assists with capacity planning for future database growth; documents benchmarks and procedures needed to optimize performance; ensure that all performance guidelines are followed.
• Worked on Oracle running on amazon cloud - EC2 and as RDS, looked into various aspects of running databases in the cloud. Review and analyze change requests to determine the scope of work and estimate the level of effort for database changes.
• Develops and modifies database definitions including entities, attributes, relationships, and referential integrity triggers. Maintains detailed database design documentation.
• Project Team Member - successfully analyzed, recommended and implemented an Oracle Active Data Guard (Standby Database) to facilitate data protection, site redundancy and disaster recovery.
• Project Team Member - upgrade/migrate Oracle 11gR2 database to Oracle 12c on Oracle Enterprise Linux
• Develops, maintains and supports procedures standards and interfaces for centralized database management. Implements Database Change Requests including data repairs and running complex queries to retrieve data from multiple tables within Oracle and SQL Server databases.
• Assists application development and maintenance staff with database questions and issues.
• Plans and implements strategies and procedures for physical disaster/recovery and contingency planning. Establishes mechanisms for replicating production databases in development environments.
• Provides problem resolution support, specific to database issues; identifies and resolves database problems, coordinating with application users to determine root cause and ensure accurate problem definition.
• Carrying out Oracle Database maintenance; base lining, performance tuning, alert configuration, using snap shots taking by Automated Workload Repository (AWR)/ Automatic Database Diagnostic Monitor (ADDM) to generate performance reports, monitoring and database performance

Database Administrator

Confidential, Atlanta, GA

Responsibilities:

• Maintain the Oracle 11g RAC environment and troubleshoot performance problems on Oracle Solaris platform
• Building test strategies, backup & recovery models for Oracle. Refreshing test databases.
• Managing backup & Recovery for Oracle on Linux using RMAN
• Going through the day-to-day user requests and troubleshooting the database related problems.
• UNIX shell scripting for monitoring oracle Database status, security & backups.
• Monitored Tablespace size, resizing Tablespace, relocating data files for better disk I/O.
• Created backup plan design and implementation using cold/hot backups and RMAN backup technology.
• Experienced in using database features such as RMAN, Data pump, SQL Loader, Flash Back, AWR, ADDM, ASM, TTS, SQL Tuning/Access Advisor, TOAD, ASMCA, ASMCMD, DBCA, DBUA
• Running complex queries to retrieve data and ad-hoc reports from multiple tables within Oracle database