SUMMARY:

Over 6 years of experience as an Oracle Database Administrator having hands on experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DBCA) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBUA, ADDM, Oracle Migration Workbench, Remedy, Service NOW(SNOW)

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP - UX), LINUX, Windows 10, Windows 8, Windows 7, Windows XP and Novell (limited), Oracle 11g/SQL, E-Docs, Office 365, 2010, 2007 and 2003 (roll-out/installation and support). Limited Lotus Notes, Maximo, HP ServiceDesk, Track-It, Remedy, Footprints, LANDesk, DemandDesk, Symantec Norton Anti-Virus, Ad-aware, SpyBot, MalWarebytes, 45 wpm, ability to learn quickly, iManage, Caseware, Internet Explorer, Firefox, and Google Chrome. Support of Blackberry, iPhone and Android phones as well as Windows Tablets. Created/assisted with Help Desk support/training documentation.

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential

Responsibilities:

• Performing schema and full database refresh using Export/Import datapump utilities and RMAN Duplicate command.
• Perform SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Work closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Create oracle databases on preconfigured servers with established standards to maintain uniformity in the environments.
• Creating and testing of database links to access data across databases and across platforms.
• Recompiling packages, materialized views, views as needed when they fail to pull data from remote databases.
• Monitoring databases and tuning for better performance by tracing blocking sessions, inactive sessions, resource intensive sessions with high CPU utilization and offer advice with regards to killing aging and blocking sessions.
• Configuring databases for optimum backup and recovery using RMAN recovery catalog and a nightly scheduled job.
• Weekly scheduled statistics gathering on main application schemas objects to improve performance.
• Preparation of documentation for procedures to implement various database administrative tasks.

Oracle Database Administrator

Confidential

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Implemented the resizing the online redo logs in production and in standby database.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.

Oracle Database Administrator

Confidential

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Data pump, conventional Export/Import (Oracle 10g, 11g and 12c) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "run Installer" and perl based utility "opatch".
• Review the Customized codes being put into the Oracle system and optimize the performance of the same.
• Coding Standards and configuration management through various development instances and also integrating the Custom developed components.
• Rebuilding of Indexes and managing the table partitions for better performance, maintenance of Oracle Database. Establish Backup policy using RMAN and VNB (Veritas Net Backup). Also managed Backup, Restore using Data Pump, Traditional Export and Import Utilities.
• Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
• Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.
• Worked with Partition Tables. Partitioned Tables and sub-partitions as per the requirement of the Applications to improve performance and data management.
• Expert in Space monitoring, Functions, Procedures, Triggers & Packages, and Object Management.
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Oracle Database Administrator

Confidential

Responsibilities:

• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
• Installed and configured block change tracking to work with RMAN Merged incremental backups
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitored the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Extensively worked on Backup/Recovery using RMAN and Scripts based for Oracle 9.x, 10.x, 11.x with SAN and NAS File systems with and without Oracle ASM.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduled the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Provided 24X7 supports for all the production and development databases

Jr. Oracle Database Administrator

Confidential, Washington, DC

Responsibilities:

• Installation of Oracle Database and Oracle products.
• Implemented Backup/Recovery Strategies.
• Wrote scripts for backup and recovery.
• Tuned systems for better performance.
• Created user accounts and maintained database security.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Wrote UNIX shell scripts for backup and recovery.
• Supervised the installation and configuration of Oracle databases on Linux and Windows NT
• Wrote SQL scripts to monitor database performance.

IT Support Analyst

Confidential, Bethesda, MD

Responsibilities:

• Provide Tier One Help Desk Support to incoming requests on daily questions and problems and handle calls by logging them into Footprints tracking ticket system and document and update status of calls/resolutions in Footprints.
• Troubleshoot hardware and basic issues with software applications such as Caseware, Office 2007, Office 2003.
• Set up & test Video equipment for scheduled Video conferences (Polycomm/IVCI)
• Support Remote Access issues such as VPN and Dial-up as well as work independently and follow-up with solving staff hardware/software and Remote Access issues.
• Configure Computer Systems for new images (Symantec Ghost), updates and rotation assignments to staff
• Responsible for inventory and asset control records in database (ie: Laptops, Desktops, PDA's, Printers, Security Cables, Memory Keys, Mouse etc). Also monitor, troubleshoot/support Printers.
• Process/add new employees accounts as well as remove/deactivate terminated employees within Active Directory

IT Support Specialist

Confidential, Bowie, MD

Responsibilities:

• Provides phone support for XP Professional, Office 2003, WordPerfect 12, Office 2003, Internet Explorer, Firefox and Groupwise.
• Resets Network passwords using Active Directory and econtrol.
• Supports Blackberry and printer issues and also configure and maintain laptops including inventory.
• Uses Remedy ticketing system to log in all calls or emails that come in from employees.

IT Support Specialist

Confidential, Washington, DC

Responsibilities:

• Answers, evaluates, and prioritizes service requests received via phone or email concerning Attorney’s, Paralegals, Secretaries, etc. computer performance.
• Performs diagnostics with customer to collect information about problem to determine source of error.
• Resolves remote access issues, printing issues, and network connectivity issues as well as troubleshoots PC hardware, software problems and Blackberries, and identifies, categorizes, and resolves PC hardware and software application problems.
• Escalates the most complex problems to third-tier Senior Support Specialists or other Hardware/System Specialists as necessary.
• Assign/create user id/passwords using RSA Secure ID Key.
• Logs and tracks calls using Remedy and maintains history records and related problem documentation. Maintains accuracy of help desk database and records resolution information.