SUMMARY:

Over eight (8) years of Oracle Database Administrator (DBA) experience across Windows, Unix/Linux and Solaris platforms supporting web - based and client applications. Seeking a technical position in oracle database administration to further enhance my career and skill set. Self-motivated, versatile team player with excellent interpersonal and technical skills.

SKILL:

Operating Systems: Windows, Linux Red Hat, zLinux, and Solaris.

Languages: .Net, Python, PHP, PL/SQL, J2EE, and SAS.

Databases: Oracle, Informix, Sybase, and MongoDB.

Applications: MS Products, Crystal Report, and Siebel.

Servers: Microsoft IIS, VMWare, WebLogic, and WebSphere.

Tools: SQL Developer, Toad, Oracle Forms, Telnet, FTP, and Putty.

Backup Tools: NovaBACKUP, NETBACKUP, and Veritas.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Oracle Database Admin

Responsibilities:

• Provide day to day operational Enterprise Production Databases (12c/11gR2) and applications supports under all environments for ongoing business activities in data warehouse environment.
• Installed/Configured new database environments within Windows/Linux using 12c of Oracle Real Application Clusterware (RAC).
• Manipulating user profiles, groups, roles, privileges, authentications scripting for easy database administration.
• Perform Oracle database software installations, configurations, upgrading databases and patching, set up backups, disaster recovery (Active Data Guard) and high availabilities (RAC) of the systems.
• Monitor enterprise database systems performance, including running applications, user session activities, long running jobs/queries and managed workloads to ensure the healthy systems and resources are available.
• Perform database tuning activities, codes reviewing, SQL scripts testing, logs analysis; long running query analysis, bug fixing and recommend release into the production.
• Migrated/Upgraded from 11gR2 to 12c multitenant database.
• Work Experience as a member of AWS Build Team.
• Perform data loads using Data Pump and export/import utility. Analyze database performance utilizing Oracle ADDM, OEM and Ignite.
• Running commands through PuTTY serial connection.
• Diagnosed and troubleshot database problems such as bugs, performance problems, runaway processes, connectivity problems, poor SQL statements.
• Configure large number of batch jobs, views, materialized views, synonyms and schedule those jobs, stored procedures and packages and run them when needed in terms of end user and developer requests.
• Full database encryption for mission critical databases.
• Support internal EDWS applications (Daily/Monthly/Quarterly End running for critical jobs) ensuing proper usage and data replicate on the target systems, in case of jobs failure or aborts.
• Installed Oracle Unified Auditing for overcoming security vulnerabilities.
• Monitor database systems performance using various tools (Nagios) and maintain database backup and recovery processes, data security/integrity, disk space requirements and database server performance.
• Support developers/business users/ stakeholder required data movements processes from single/multiple partitioned tables and locations under Data Warehouse distribution policies and agreements using ETL and PL/SQL.
• Strong proficiency in relational database management system within Agile methodology.
• Perform daily/weekly database backups and archiving medical data for future recovery.
• Providing on/call (24/7) assistance in troubleshooting applications and database infrastructure problems for restoring business systems that have failed.

Confidential, Richmond, VA

Oracle Database Administrator

Responsibilities:

• Administered over 70 database servers across multiple database environments via use of command line and Oracle Enterprise Manager (OEM) including 12c.
• Installed and managed Oracle Real Application Cluster (RAC) database with more than 15 applications.
• Upgraded databases from 11gR2 to 12c on Red Hat Enterprise Linux (RHEL).
• Installed and configured Oracle Data Guard databases with the sizes from 3TB to 10TB on a four node RAC.
• Successfully installed Oracle Golden Gate replication between sites for High availability.
• Performed database tuning, analyze objects, and recommend changes to improve performance.
• Identified objects no longer accessed and removing those objects which results in saving space in the databases.
• Maintained DATA GUARD to provide high availability by implementing physical standby database and snapshot-standby for reporting purpose.
• Provided support for Oracle RAC, including applying patches, and performance tuning.
• Performed trace analysis, service creation for the apps to fail over, cluster and system management.
• Refreshed database using export/import from production to other lower database environments.
• Implemented partitioning on large tables, perform composite partitioning, local indexes, and global indexes.
• Implement RMAN backup utilizing Crontab job.
• Worked with UNIX shell scripts, materialized views, and Capacity planning.
• Performance tuning using AWR, EXPLAIN PLAN, ADDM and Statspack.
• Provided database support for development and deployment of database scripts in Development, Test, Pre-Production, and Production environments.
• Run commands through PuTTY serial connection.
• Monitored internal and customer systems from a PC with terminal windows generated by PuTTY.
• Created and supported schemas including various database objects.
• Provided database administration support for application development teams for Maintenance and Emergency software releases.
• Twenty-four (24) hours on-call production support.
• Nagios alert monitoring system for database servers’ activities.

Confidential, Sacramento, CA

Oracle Database Professional

Responsibilities:

• Implemented Oracle Real Application Cluster (RAC) including Grid Infrastructure and ASM disk groups on Red Hat Linux.
• Assisted with the specifications and requirements for determining hardware, network, and storage requirements to support databases.
• Kept the databases up to date with respect to the latest database security patches.
• Was responsible for database maintenance, backups, recovery, patching, upgrades, performance tuning and user access control.
• Successfully implemented physical standby database using Oracle Data Guard and Active Data Guard feature for High availability configuration in RAC environment (RAC to RAC Data Guard).
• Upgraded database 10g to 11.2.0.4 Oracle database binary version.
• Configured notifications on Cluster activities, tablespace utilizations, Listener alerts via Oracle Enterprise Manager (OEM).
• Managed the remote Linux servers using PuTTY.
• Installed Oracle Golden Gate for disaster recovery process on test database servers.
• Configured and maintained Windows and zLinux servers with Oracle database.
• Assisted application DBA engineering teams with performance and tuning (e.g: database parameters, indexes, and PL/SQL).
• Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, and RAW Devices.
• Strong experience in mentoring with team members including documentation for database installation and configuration.
• Created and configured Real Application Cluster (RAC) on Windows servers.
• Was monitoring databases using Grid control with proactive measures.
• Data pump export / import from Production to the Reporting Server on request basis.
• Supported Oracle Data Guard replication and physical standby for Disaster recovery.
• Created and monitored Job Scheduling for databases through Crontab as well as windows job scheduler.
• Trained resident DBA in administration, performance tuning, networking, backup and recovery of Oracle databases.
• 24/7 on call rotation production database.

Confidential, Reston, VA

Oracle DB Admin

Responsibilities:

• Installed and configured standalone 10g and 11g Database servers for Development, Test, Dev, Pre-prod, and Production environments.
• Installed and configured four nodes Oracle Real Application Cluster (RAC) database environments on 11gR2 with ASM file system on Linux environments.
• Performed maintenance tasks including scheduling backup jobs, monitoring job failures, and troubleshooting.
• Upgraded and applied CPU patches and bug fixes as required and troubleshoot issues in various modules.
• Was responsible for collecting and analyzing performance statistics for resource consumption and performance Anomalies, managing Tablespaces, Datafiles, Rollback segments, and Temporary tablespace.
• Built reporting against database objects and Complex Custom SQL.
• Used EXPORT/IMPORT to perform schema level, table level, and full database imports as per application requirements.
• Successfully migrated databases from legacy hardware system to new Linux servers, running Oracle 10g over Oracle 11gR2.
• Developed scripts to proactively monitor the databases and alert the DBA team on events such as running out of storage space.
• Setup, configured and maintained of standby databases using Data Guard to ensure disaster recovery, and data protection.
• Scheduled and maintained RMAN (Recovery Manager).
• Monitored databases and performance tuning using OEM (Oracle Enterprise Manager), AWR, and ADDM.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs and change requests for future reference.
• Created UNIX shell scripts to automate batch jobs through Crontab.
• Manage the remote Linux servers using PuTTY.
• Involved disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Participated in business requirement gathering and applying the business logic at the database level.
• Analyzed and managed of Oracle problems/defects using Service Request (SR) with Oracle Support.
• Applied Oracle Quarterly patches for database enhancements.