SUMMARY:

• A proactive Oracle Database Administrator experienced in Linux - , Unix- and Solaris environments with practical knowledge in Oracle 10g & 11g and theoretical knowledge in Oracle 12c.
• I am seeking a challenging- and rewarding position that will allow me to use my skill set as a contribution to the development of the company, gain more experience and expand my knowledge base.

TECHNICAL SKILLS:

Operating Systems: Linux Enterprise Server 9, 10, Windows 95/98/NT/2000

RDBMS: Oracle 10g, 11g, 12c

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

Tools: Explain plan, Statspack, AWR, ADDR, Toad, Putty, Winscp, Remote Desktop Connection, VNC, Team Viewer, Cisco VPN client

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

Computer: Installation, repair

Troubleshooting: TCP/IP, LAN, WAN, CISCO routers

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

• 24 x 7 Production & Development database support and administration.
• Maintenance Oracle 11gR2 RAC Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Worked on import/export, export data pump/import data pump and SQL-loader.
• Installed and Implemented Backup & Recovery procedures, Implemented Backup & Recovery procedures, implemented Hot, Cold, Logical backup plans.
• Applied PSU/CPU Patches on Oracle databases using “runInstaller” and perl based utility opatch.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, table/index analyze jobs, database backup logs etc.
• Write and modify UNIX shell scripts to manage Oracle environment
• Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA for performance testing.
• Used AWR, DMM and explain plan for periodic performance tuning.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, Statspack, SQL trace, explain plan.
• Database monitoring/maintenance, replication process and performance tuning done using OEM.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) and Network Attached Storage (NAS).
• Documentation of the Standard Processes for peers to follow.
• Implemented Flashback technology of the Oracle 11g along with Recyclebin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Provide optimized performance for the database by rebuilding indexes on tables.
• Automated processes like managing alerts and efficient backup by developing UNIX scripts
• Installed ASM environment and migrated databases from NON-ASM to ASM
• Highly experienced in Hot/Cold Backup and Recovery and cloning of databases using RMAN.
• Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON- CDB) Databases
• Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switch over and Export & Import.
• Applied the Clusterware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for Bug resolution) using Opatch.
• Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c as part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1).
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
• Responsible for backup and recovery of databases using RMAN Tool (Recovery Manager), and database Flashback using GRP (Guaranteed Restore Point) and Export and Import (Datapump and Normal) for restoring the specific objects at the database level.
• Build Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases
• Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
• Monitoring the database using Oracle Enterprise Manager (11g)
• Tested disaster recovery with database failover and switchover using DBFS filesystem and ACFS.
• Efficiently performed installation, setup and creation of two/four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Helpdesk Support Specialist

Responsibilities:

• Working as part of the local support team for the GSA GEO contract
• Created oracle databases on configured servers using both the DBCA & Database creation scripts.
• Managed, tuned and troubleshoot database issues both on UNIX and LINUX command line, SQL*Plus, OEM client, as well as other third party tools.
• Monitored database systems and provide technical support for database system issues and application performance enhancement/improvement using OEM.
• Performed data migration between databases using both Oracle 11g and 10g export/import utility and Oracle11g exp/imp data pump.
• Analyzed schemas of databases created to collect statistics using the DBMS STATS package.
• Used AWR/ADDM for 11g statistics management and database tuning following creation of new databases and periodically thereafter.
• Troubleshoot installation errors with team members, independently and with Oracle support (via My Oracle Support).
• Used RMAN, Data Pump, Performance Tuning, ASM, DATAGUARD, Fine Grain Auditing(FGA).
• Performed Backup/Recovery, monitoring, and reporting using Oracle RMAN
• Documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.
• Designing & implementation of Database Backup and Recovery strategies - RMAN.
• Automated DBA activities using Cost -Based Optimizer, and OEM.
• Implemented recovery strategies in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) using RMAN utility and monitored the scheduled jobs.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups. .
• Used SQL TRACE, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 supports for all the production and development databases
• Troubleshooting IP addresses on laptops
• Using SERVICE NOW to manage tickets and resolve issues within the SLA
• Installing and configuring Microsoft Office 2013 and 2016
• Helping client understand the different tools in Office 2013 and 2016
• Managing user account and computers accounts with Active Directory

Help Desk Technician

Responsibilities:

• Install and configure Oracle 11g in ASM and non ASM filesystems on Linux platforms
• Configured Oracle Recovery Manager (RMAN) and Oracle Recovery Catalog to backup the databases
• Perform weekly full and incremental backups using RMAN
• Support clients in Operations Management tasks like user management and database environment
• Monitor, administer, and diagnose database issues using OEM, SQL Developer and SQL Plus
• Perform Oracle databases Upgrades and Migration from Oracle 11203 to 11204
• Perform Oracle databases Upgrades and Migration from Oracle 11203 to 11204
• Perform database performance tuning activities using tools like ADDM reports and AWR Reports
• Provided disaster recovery solutions and provided recommendations to senior management for implementation
• Generated monthly health reports on databases using grid control chart to senior management
• Supported in database auditing efforts, the goal was to track system access using fine-grained auditing
• Managed Oracle 10g and 11g on UNIX and WINDOWS operating systems
• Applied Oracle critical patches to each database
• Resolve complex database issues
• Installing and configuring Windows 7 and Oracle client on new laptops
• Configuring Windows 10 on the Tablets
• Configuring, setting up and troubleshooting iPhones and android phones
• Representing IT insider live at GSA Region 11

Help Desk Specialist

Responsibilities:

• Configuring and troubleshooting Dell laptops and desktops
• Troubleshooting IP addresses on laptops
• Team Lead for refresh of 800 laptops for GSA region 11
• Answering all the questions a client might have concerning a laptop, a cell phone or a Voip phone
• Configuring and troubleshooting CISCO voip phones
• Installing windows image on all required hardware
• Managing Asset and any equipment that I come in contact with
• Activating and configuring all the smartphones and blackberry per GSA requirement

Technical Consultant

Responsibilities:

• Conduct the move of IT equipment
• Manage the connection of printers on the network
• Configured and troubleshot Dell laptops

Consumer Representative / Technology Specialist

Responsibilities:

• Provided functional and technical support, troubleshooting and diagnosing hardware and software problems, including desktop, laptop, WAN, LAN, and remote systems.
• Assisted in the installation and updating of software, as well as the setup and troubleshooting of all equipment (computer and electronics).
• Expertly installed, configured, monitored and troubleshot PC's and related hardware on all OS platforms.
• Performed diagnostic testing on PC equipment and ensured printers were up and running at all times.
• Resolved Windows and Internet Explorer issues on desktop and laptop.
• Identified and remove computer viruses, provided major repairs in accordance with outside vendors.
• Performed wiring and daily maintenance of internal computer systems.
• Resolved Windows related issues, Internet Explorer issues and other PC software related issues.
• Monitored and troubleshot LAN, and generated weekly reports