SUMMARY

• Over 10 Years of experience in the IT specializing in Oracle Database Management Systems.
• Expertise in Database Cloning, Backup & Recovery, Disaster Recovery techniques for Oracle 12c & 11g databases. Hands - on experience with Oracle 12c, 11g, 10g Oracle software installation and maintenance.
• Provide 24X7 Provided DBA support for total of 600+OLTP, Data warehouse, and RAC databases in Production, Verification & Validation (VV), QA/Test, and Development environments, alongside working with engineering & development teams on UNIX, Linux, Solaris & Windows platforms.
• Expertise in Database Installations, Configuration, Monitoring, Maintenance, Patching, ASM, and CRS/Clusterware Database Migration, Database Upgrades, and supporting 6+ Terabyte Databases and DB Applications.
• Excellent Knowledge in RMAN, Conventional Backups & Recovery.
• Knowledge of Oracle Real Application Clusters (RAC) concepts: Scalability, Load Balancing, Accessibility and Manageability.
• Diagnose and troubleshoot database problems such as errors and bugs, performance problems, runaway processes, connectivity problems, poor SQL statements, etc.
• Hands-on experience with Installation, Configuration and maintenance of RAC Databases.
• OEM Cloud Control 13c & 12c experience - performance management, automatic tuning, promoting, monitoring targets (hosts, databases, listeners, agents, etc.), creating named credentials, automated patch deployment.
• Expertise in Oracle Schema Object Management.

TECHNICAL SKILLS

Databases: Oracle 10g, 11g RAC, 12c RAC

Tools & Utilities: RMAN, Data Pump, OEM, CRS, ASM

Operating Systems: Linux, UNIX, Solaris 10, 11, Windows 2000/2003

Others: Toad, SQL Developer, PL/SQL Developer, VMware, VERITAS Net Backup, Serena DA, BMC Remedy, Serena Dimensions CM Web Client, Solutions Business Manager

PROFESSIONAL EXPERIENCE

Confidential

Systems/Database Administrator

• Provide application administration and support database administration for assigned program tools.
• Maintain user account access control, permissions, and roles.
• Advise on the administration and design of current and future systems engineering related tools.
• Manage and resolve trouble tickets. Coordinate with technical support team and help desk to resolve issues.
• Notify users of planned and unplanned tools issues, outages, upgrades, and resolution status.
• Document and assess user requirements for modifications to tools and provide recommendations.
• Coordinate tools requirements and upgrades and assess impacts.
• Coordinate functional upgrades and assist with implementations.
• Validate status of user accounts.
• Provide other program support as identified.

Confidential, Suitland, MD

Oracle Database Administrator

• Designed and implemented daily reporting of Production Database backups to DBA team and upper management
• Assisted MySQL DBA team with daily database status reports and periodical Census Indicator Releases which had high visibility with Census Management.
• Maintain the Oracle 12c RAC environment on both Solaris and Linux 12 Multi-tenant platforms and troubleshoot performance problems.
• Setting up and managing backups for databases using cronjobs as well as working with Enterprise Backup Team to set up Net Backups.
• Going through the day-to-day user requests and troubleshooting the database related problems.
• Providing 24/7 and periodical scheduled On Call DBA support.
• Perform DB patching, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Handle and perform clients Service Request for Incident Management, Problem Management and Change Management.

Confidential, Manassas, VA

Sr. Database Analyst

• Hands-on experience working across four (4) lifecycles supporting the Healthcare Quality Information System (HCQIS) project for Centers for Medicare & Medicaid Services (CMS).
• Provided DBA support for total of 300+OLTP, Data warehouse, and RAC databases in Production, Verification & Validation (VV), QA/Test, and Development environments.
• Supported multiple complex projects like Hospital Quality reporting, Enterprise services, Physician Quality Reporting systems, as well as RAC & Standalone databases supporting health care application systems.
• Cloning of databases using ASM copy as well as Timefinder Snapshot technology.
• Converted single-instance databases to RAC cluster databases.
• Performed day-to-day operational activities like schema/database refreshes from PROD environment to lower environments using Data Pump Export/Import utilities, fixing database links, database creation, responding to client requests submitted via remedy tickets, database space management, database upgrades, migration, configuration and maintenance of RAC systems, etc.
• Coordinated with Middleware engineers to create and troubleshoot data sources, password changes, application users, etc.
• Provided monthly support for maintenance weekends with tasks such as GI and RDBMS upgrades, patching and hardening of servers and databases.
• Performed 24/7 Infrastructure and deployment On-call DBA duties during business/off-hours including weekends periodically.
• Utilized Oracle Enterprise Manager to monitor database as well as custom OS shell scripts to monitor database-related components.
• Performance tuning, troubleshooting & monitoring using ADDM and Automatic Workload Repository Advisor for very large OLTP databases.

Confidential, Warrenton, VA

Sr. Database Analyst

• Upgraded Oracle Databases from 10g to 11g.
• Implemented and supported Oracle RDBMS environment requirements to meet security and audit requirements using standardized database security baselines, regular patching of Oracle homes, hardening of databases, native auditing, etc.
• Created Oracle 12c Container databases for pluggable databases on Windows Servers.
• Performed day-to-day operational activities like schema/database refreshes from PROD environment to lower environments using Data Pump Export/Import utilities, fixing database links, database creation, responding to client requests submitted via remedy tickets, database space management, database upgrades, migration, configuration and maintenance of RAC systems, etc.
• Monitored database servers for issues with disk space, CPU usage, memory problems, or other issues that may impact the end-users.
• Participated in the planning, implementation and testing of various applications for projects as assigned.
• Reviewed deployment plans and performs database upgrades/deployments.
• Performed 24/7 Infrastructure and deployment On-call DBA duties during business/off-hours including weekends periodically.
• Performed on-going resource evaluation to assess if environment resources are suitable for the environment needs (capacity planning).
• Leveraged Oracle technologies along with OS technologies to provide a high level of database redundancy and availability (database multiplexing).
• Performed routine database health checks in order to forecast possible issues (proactive database monitoring).
• Developed and execute strategies to address datafile, database sizing/storage, security, and performance and optimization issues.
• Scaled ASM environments by adding candidate disks to disk groups and rebalancing disk data.
• Provided assistance in administering, monitoring, configuring, tuning, troubleshooting and correcting database related problems.
• Configured crontab for export backup jobs, collecting system reports, ASM disk groups critical statuses, checks for schemas that are locked or on verge of locking, database connectivity, archive logs cleanup, and hot backups.
• Tuned long running SQL to be less resource-intensive through AWR and Explain Plan through analysis then rewrite the code with the help of developers to do buffer gets (soft parse) instead of physical reads (hard parse).

Ishglo-one Corporation, Frederick, MD

Oracle Database Administrator

• Performed backup and recovery of Database Management Systems, configured database parameters, and defined data repository requirements, data dictionaries and warehousing requirements.
• Developed best practices and repeatable procedures for deploying databases, as well as day-to-day operational activities including space management, backup and recovery, database replication setup and management.
• Applied Oracle Critical Patch Update (CPU) patches on our databases every quarter.
• Performed various DBA maintenance tasks such as rebuilding indexes, validating constraints and reorganizing tables.
• Performed database design tasks such as enforcing referential integrity standards, creating database tables and table dependencies such as indexes, views and materialized views.
• Cloned Oracle databases from production to development environments.