SUMMARY

• 10 years Oracle Database Administration experience in Financial, health care and consulting industry adhering to the Industry best standard in Compliance and Change Management practices.
• Extensive technical skills in automation scripting of business processes and other routine tasks as related to provisioning and decommission database, database maintenance tasks and monitoring.
• Proficient in Installation, Troubleshoot, Administration and technical Support for Oracle (12c, 11g and 10g) Databases, Oracle RAC, Active Data Guard, ASM and Grid Control 12c.
• Expert in disaster recovery; providing industry best practices solution to meet businesses RTO as stipulated in the SLA.
• In depth understanding of security and backup procedures to ensure database integrity and disaster recovery plans.
• Good understanding of Software Development Life Cycle (SDLC) and Agile Methodologies; manages databases from planning and testing stages through implementation and support.
• Excellent communication, presentation, analytical, problem solving skills and work well with all levels of business.
• Extensive experience in development, testing and writing technical designs.
• Experienced in Performance Tuning such as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, and redo mechanisms.
• Highly skilled in Oracle DBA Administration, creating Backup & Recovery Strategy Implementation, Performance Monitoring/Tuning and Database Security for Databases having more than 500+ users.
• Support mission critical - application databases in High Availability Environment.
• Maintenance and development of database objects like Queues, Tables, indexes, Stored Procedure, constraints, triggers, Table & Index Partitioning, DB links, users, roles, profile and SQL NET and Listener.
• Experience is data encryption using Oracle TDE tools to protect our client’s PII and to adhere to the industry standard.
• Knowledge in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN).
• Experienced in planning and implementation of Backup and Recovery strategy, used physical backup and logical backup using EXPORT/IMPORT.
• In-depth knowledge of setting up RMAN backups using control file and Recovery Catalog, and maintaining catalog schema. Proficient in creating auxiliary and duplicate databases using RMAN.
• Extensive experience in developing shell scripts to automate monitoring of tablespaces, alert logs and invalid objects in the Database.
• Expert in Oracle Golden Gate implementation at the database, schema and table levels.

TECHNICAL SKILLS

• Windows
• Oracle 11g/10g/9i
• UNIX
• Linux
• Sun Solaris
• IBM AIX
• PL/SQL
• Microsoft Project
• Data Guard
• Golden Gate
• Perceiver
• Oracle Enterprise Manager
• Oracle RAC
• ASM
• SQL Server
• Data Pump
• RMAN
• SDLC
• HP Quality Center
• HP Site Scope
• Service-now
• Manage-now and Infoman. Sql Server
• PLSQL
• R programming Language

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

• Installed, configured, and managed Oracle Binaries 11g on UNIX, Linux platforms.
• Created and modified database structures as required by developers due to business or application requirements, creating test databases for testing and training.
• Refreshes databases and/or schemas with new data when needed.
• Works with Configuration Management to ensure the DB builds are successfully and accurately promoted to the QA and UAT environment for testing and then to the production environment.
• Troubleshoots Oracle database issues and optimization issues using awr reports and explain Plans.
• Design and implementing database security strategies for user and application access levels
• Provide both onsite and on call Tier 3 and Tier 4 support for over 30 instances of both Oracle RAC and Single instance databases on Red-Hat Linux platform
• Design and configure databases across different environment to include Development, QA, Staging and production environments in both physical and virtual servers.
• Design, configure, deploy and maintain active physical Dataguard 11g (Active/Passive).
• Author and maintain Oracle SOP’s/ documentation including databases.
• Design database structures, auditing, security, managing patches, and other tasks as needed to ensure regulatory compliance and a proactive security posture.
• Migrated database schema’s from uat to test, dev to qa using data pump export and import utility.
• Created, configured and designed new database instances on dev, qa, uat and preprod.
• Diagnoses, troubleshoots and resolves any database related problems. Work with Oracle Support if necessary to bring problems to a successful resolution.
• Implement ASM cluster on Oracle RAC11g (Active/Active & Active/Passive) on Multi Node Cluster up to 5 nodes.
• Performs capacity management on our systems using.
• Supports highly critical production RAC databases.
• Installed, configured and implemented oracle Golden Gate to replicate schemas and some tables from OLTP to OLAP (Data warehouse) databases.

Confidential

Oracle DBA

Responsibilities:

• Successfully completed two migration projects: lift and shift and new server build migration
• Automated backups on all servers and Oracle Enterprise Manager (OEM).
• Monitored back up on all environments (Dev, Test, QA and Prod) and perform manual backups whenever backup fails.
• Automated the monitoring of tablespaces and mount point’s threshold and proactively cleans up by scripting.
• Used Perceiver to collect data and monitor disk, memory and CPU usage for capacity Management Planning.
• Developed shell scripts to automate the review of invalid objects in the Databases and proactively fix them.
• Developed shell scripts to Automat the tasks of dropping and creating partitions on tables.
• Creating and managing LOBs. Creating Regular views, sequences, partitions, and refreshing Materialized Views as needed by the development team.
• Uses HP Quality Center to prepare test cases and proceed with testing.
• Worked on 24 x 7 production environment and provides on - call and day to day support.
• Managed RAC and ASM production databases and performance tuning.
• Supported 11G/10g RAC Multi Node configurations.
• Managed Data warehouse databases and supports an OLTP application Databases.
• Performed database troubleshooting and tuning using AWR Report.
• Applied Oracle Critical Patch Update (CPU) patches on databases.
• Implemented Table and Database refresh using data pump export and import utilities.
• Develop and document disaster recovery procedures in accordance with the financial institutions policies.

Confidential

Oracle Developer

Responsibilities:

• Requirements analysis: Met with business experts, analyzes and documents the requirements from a database perspective.
• Database design: Performed analysis of requirements and designs/modify database schemas to meet those requirements.
• Database development: Converted the logical database specifications into physical design. Creates and maintain data definition language scripts for all database changes. Works on the development of code to maintain data integrity and automation of database procedures.
• Data migration: Defined the data migration strategy and assists in development of data migration procedures.
• Collaborated with development techniques as well as knowledge of Project management discipline within Information Technology field.
• Production Support: Worked on fixing production defects and data fixes.
• Developed and maintained stored Procedures, Functions, Packages and PLSQL Blocks to build PCMH applications for end users.
• Coordinated with Data Architect’s in the design of Data models.

Confidential, King of Prussia, PA

Oracle Database Administrator

Responsibilities:

• Proactively Resized tablespaces, gathered DB sizes and performed health checks of databases.
• Configured Data guard on databases and kept the standby database in sync with primary database.
• Proactively cleaned up mount points of servers to enhance performance.
• Tuned Database Instances and monitored server performance.
• Performed database troubleshooting and tuning using ADDM, AWR Report.
• Upgraded databases from 10.2.0.4 to 11.2.0.1
• Prepared scripts to pin frequency used objects in the SGA to improve performance.
• Use RMAN to perform database recoveries when necessary.
• Handles database server tuning, application tuning, maintaining documentation, and capacity planning and database security.
• Identify, recommend and implement all new database technologies and upgraded oracle database from 10g to 11g.
• Created new databases and users and set up monitoring scripts.
• Implements automated backups and recovery procedures of databases on LINUX and Sun Solaris environments.
• Prepared Instance release documentation.
• Identified, troubleshoot, resolve, document and communicate issues that affect the systems, servers and database related products.
• Configured Physical standby database using RMAN Duplicate.

Confidential, Annapolis junction, MD

Oracle Database Administrator

Responsibilities:

• Responsible for installation and verification of the database software on the database server. Duties includes planning, preparation and scheduling of software installation, install Oracle 10g and 11g on Unix, Linux and Windows, apply patches; upgrade Oracle server and application tools, maintaining the software at the latest stable release level and testing and verification of installed components.
• Performs database tuning, creates database reorganization procedures, scripted alerts and monitored scripts.
• Applied Oracle Critical Patch Update (CPU) patches on databases.
• Installed and configured RMAN to backup production databases.
• Performed database troubleshooting and tuning using ADDM, AWR Report.
• Performed database design tasks such as enforcing referential integrity standards; create database tables and table dependencies such as indexes, stored procedures, functions, packages, triggers, views, materialized views etc.
• Upgraded several databases from Oracle 10.2.0.1 to 10.2.0.4.
• Setup technical procedures and administrative policies for production, test and development databases physical design, administration, maintenance, tuning, backup and recovery.
• Allocated system storage and plan future storage requirements for the database systems.
• Resized database redo logs files by creating new redo logs files and later dropping the existing redo logs.
• Implemented database refresh using full export for table level and full database defragment resulting in improved performance and effective space management.
• Performs database tuning, creates database reorganization procedures, scripted alerts and monitored scripts.