SUMMARY:

Results - driven Oracle Certified Database Administrator with over 7 years of hands-on experience in the daily administration of production Oracle 10g, 11g, 12c databases as well as installation and configuration of both standalone and Oracle Real Application Cluster ( Confidential ) databases, backup and recovery using Oracle Recovery Manager (RMAN) and Recovery Catalog, database migration and refresh using Oracle Data Pump, Oracle database replication using Oracle Data Guard for Disaster recovery and GoldenGate for real time data replication and Oracle 12c Cloud Control configuration and monitor. Also, responsible for patching, upgrade, database troubleshooting and supporting development effort with regards to production deployment releases, database schema, role, user, and objects, database hardening and baseline per security policy to improve database security. Experience in creation of project presentations for progress meetings and other high-level discussions. Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. I have installed and configured SQL SERVER on Windows server 2008, 2012, 2014, 2016, create database and Patched SQL Server 2012 r2 SP1 with SP3.

TECHNICAL SKILLS:

Databases: Oracle 12c/ 11G/10G

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. CentOS, Suse Linux, Fedora, Windows 2008, 2008 R2, 2012, 2012 R2, 2016.

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR, ASH and ADDM

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential, Edison, NJ

Responsibilities:

• Installed and configured Oracle 10g, 11g and 12c on different OS platforms.
• Monitor and Administer databases using Oracle Enterprise Manager (OEM) cloud Control.
• Loading data from flat files to database using SQL*Loader. External Tables.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Used Data Pump, conventional import/export utilities for Database cloning, refreshes and migrations to non Confidential and Confidential environment.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Successful installation/maintenance of physical standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5
• Golden Gate installation, Configuration and Management in both windows/Linux environments.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 9i to 10g to Oracle 11g and to 12c Confidential database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Installation, configuration and extended support to Oracle 11g, 10g two Node Confidential (Real Application Cluster) with ASM file system.
• Created physical standby databases using RMAN with zero downtime, and performed failover and switchover using both Data Guard Broker and the manual method.
• Converting a single instance database to Oracle Confidential databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD and Sql Developer for database management.
• Performed SQL and PL/SQL tuning, oracle contention and monitored Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• Made optimal use of Oracle Support in resolving the SRs.
• 24/7 Production & Development database support and administration.

Oracle Production Support Database Administrator

Confidential, New York, NY

Responsibilities:

• 24/7 Production Database support of multi-terabyte Oracle 11g database.
• Installed and configured Oracle 10g, 11g and 12c on different OS platforms.
• Performed all aspects of database administration including Installation, Configuration, Patches, Monitoring, Import/Export, Cloning, etc.
• Upgrade/Migrated the production and development databases from Confidential /10g to Confidential /11g.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g Confidential /Oracle 10g Confidential ) and Standby Databases for High Availability and Disaster Recovery purpose.
• Plan, implement, and troubleshooting Oracle RMAN backup, restore, and recovery.
• Provide performance tuning, problem diagnosis, data reorganization and database upgrade support.
• Monitor and tune Oracle database for optimum performance. Assist in capacity planning of Oracle database servers.
• Successful installation/maintenance of physical standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5.
• Created physical standby databases using RMAN with zero downtime, and performed failover and switchover using both Data Guard Broker and the manual method.
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports, error checking and monitored statistics for performance tuning of the database.
• Performed Data replication and Data transformation.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Performed data loads using SQL*LOADER.
• Developed PL/SQL Packages, functions and triggers to implement various functionalities.
• Experience in Managing work repositories and creating reports.
• Installation and administration of GoldenGate.
• Wrote UNIX Shell Scripts for Backup and cloning.
• Tune SQL, PL/SQL statements found in the reporting utilities and queries.
• Involved in the maintenance and troubleshooting of Confidential Databases.
• Monitored and managed the space usage and table partitioning.
• Implemented and Configured Standby database (Data guard) for disaster Recovery

Junior Oracle Database Administrator

Confidential, Chandler, AZ

Responsibilities:

• Involved in Real Application Cluster ( Confidential ) administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Successful installation/maintenance of physical standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5
• Wrote several shell scripts for checking oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Performing Backup/Recovery of all the Oracle databases using Recovery Manager (RMAN), also setup Recovery Manager Catalog for the same and hot and cold backups.
• Creating tablespaces, sizing the system tablespace, allocating default table spaces for users.
• Creating users with restricted access, with default and temporary table spaces.
• Creating different kinds of partitions on tables and indexes.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing.
• Sizing the SGA, sizing the database buffers, shared SQL area, log buffer based on the requirements.
• Oracle Export, Import, SQL*Loader and data pump utilities.
• Installing & configuring Oracle 10g, 10g Confidential on Linux & RHEL.
• SQL issues and Tuning Considerations for Different Applications.
• Created physical standby databases using RMAN with zero downtime, and performed failover and switchover using both Data Guard Broker and the manual method.
• Established and wrote the Database Administrators Procedures document for the IT department. This document outlines all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)

UNIX/LINUX Systems Administrator

Confidential, Stamford, CT

Responsibilities:

• Perform Systems installation and configuration on Solaris and Linux or Redhat servers
• Perform LINUX Kernel upgrade and compiling.
• Introducing RHEL 6.x, Solaris 10, CentOS 6.5, and Windows 2008 servers to the network.
• Setup and maintain IIS on windows server 2008.
• System hardening and monitoring, implement password security and policy.
• System Patching and upgrades on stand-alone servers and technical release rescue on production servers.
• Perform configuration and troubleshooting on TCP/IP, DNS; NFS, CIFS, FTP, TELNET, SSH, and setup SAMBA servers in multi-platform.
• Docker Container installation, configuration and administration on Red Hat, CentOS and Windows for running multiple applications.
• Applied system settings to configure server environment for Application execution using puppet
• Knowledge in monitoring logs on UNIX and Windows servers, including performance tuning and swap management.
• Install and setup of NAGIOS monitoring tool.
• Install and configure LAMP, MYSQL and PHP.
• Knowledge of server virtualization software, virtualization infrastructure management, and physical to virtual transformation processes
• Installation and configuration of LAMP on CENTOS and REDHAT Operating Systems.
• Perform Upgrade on VMware ESX 3.5 servers to ESX 4.0 servers and to ESX 4.1
• Configuration and administration of SVM and Logical volume manager.
• In-depth use of Shell scripting to schedule and automate processes.
• Setup a domain and active directory on a Windows 2008 server.
• Configure Apache on Linux for virtual and web hosting.
• Worked on creating disk groups, volumes, deporting, importing disk groups using veritas volume manager 5.1.

Computer Hardware Technician

Confidential

Responsibilities:

• Redesign and implement a more efficient network system resulting in optimal performance of all workstations.
• Troubleshoot an extremely challenging software problem with a standalone PC.
• Install hardware and software on standalone personal computers and laptops.
• Ensure maintenance of end user workstations and peripheral devices.
• Assist in providing desktop application solutions.
• Quickly respond to technical assistance requests.
• Manage testing procedures for newly installed hardware and software applications.
• Ensure timely repair of equipment.
• Assist with network troubleshooting procedures.
• Provide backup to the network administrator.
• Install and update antivirus programs on a constant basis.
• Prepared reports on network and network tools supplies.
• Liaised with IT network providers regarding latest technical queries.
• Provided standby help on computer related issues to end users.
• Introduced an antivirus solution that spanned both LANs and WANs using one server for control.
• Wrote a self-help troubleshooting manual in order to assist users in managing simple PC problems on their own and saving time.