OBJECTIVE

• An energetic Oracle Database Administrator seeking a position in a forward moving company with opportunities for dedicated customer satisfaction, attention to details, problem solving, organization and the ability to maximize system resources.

SUMMARY

• Worked in development, testing and production environments.
• Practical experience in customer service and Oracle Database Administration
• Quick learner with the ability to adapt to new environments and cultures
• Experience in installing, configuring and administering Oracle 9i, 10g, and 11g on both Windows and UNIX/LINUX platforms.
• me am self - motivated and exceed ongoing and overlapping deadlines in fast-paced environments.
• Provide a 24/7 availability and coverage for technical assistance.

TECHNICAL SKILLS

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP

RDBMS: Oracle 10g/11g

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Agents, Real Application Clusters (RAC), ASM, Sql Developer, TOAD, Exp/Imp, DataPump (expdp/impdp),SRVCTL,SQL*Plus, Recovery catalog, Autosys, Crontab, HP Manager, My Services, OTG etc

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM etc

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential - Troy, MI

Oracle Database Administrator

Responsibilities:

• Performed Hot Backups, Cold Backups as well as incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Oversaw DR testing operations (as a backup strategy) on numerous Data Guards, physical/logical standby configurations. Resolved archivelog gaps and other related problems. Effected switch overs manually and using DMGDGR
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Use Autosys, windows task scheduler and Crontab to schedule weekly backup and file clean jobs
• Database Refreshing / Replication from production to testing using Expdkp/Impdp.
• Designed, developed, and maintained basic UNIX shell scripts to collect and monitor database errors and messages
• Extensively performed performance tuning of the database instances - SQL Tuning, Used Tuning utilities like EXPLAIN PLAN, AWR, ADDM, Sql Tuning tools and Tuning of SGA, distribution of disk me/O, Sizing of tables and indexes.
• Automated hourly, daily, weekly system health reporting using Crontab, PL/SQL and shell scripts.
• Used Grid Control extensively. Configuring and troubleshooting of agent related issues, set up Rules for alert notification and schedule RMAN backups with Failure notification
• Troubleshooting of windows Oracle database backup related issues
• Installation of the Oracle software using both GUI and silent feature and also manual database creation
• Worked as part designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.
• Supported & maintained the Production/Test/Development databases on various servers
• Extensive troubleshooting of Databases backup related issues
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 11g Grid Control.
• Managing and creating User accounts, profiles, roles etc
• Perform quarterly home and database PSU patches
• Provided support to application DBA’s and SA’s.
• Provided team support and handling of team escalation and E-On-calls
• Performed team mentoring and administrative duties, daily, weekly and monthly reporting
• Periodically analyzed AWR, and ADDM reports for proactive performance considerations

Confidential, Falls Church, VA

System Administrator/Database Administrator

Responsibilities:

• Currently supporting Oracle and MS SQL Server databases, including database design, performance tuning, database backup and restore, and database replication, and develops plans and procedures.
• Assists with planning to migrate from existing application version (DOORS) to SERENA including configurations.
• Performance/Risk Management Services to achieve positive outcomes from IT investments.
• These services include: Performance Management Plans, Risk Assessment/Management, Performance Metrics and Frameworks and Earned Value Management.
• Provides IT Deployment & Sustainment, services to assess and manage Requirement Analysis, Process Reengineering, System/Network Performance Assessment, Deployment/Installation Coordination, Help Desk/Network Operations Center Management, Hardware/Software Maintenance and Development of Service Level Agreement and related documents.

Confidential, Potomac, MD

Oracle Database Administrator

Responsibilities:

• Proactive performance monitoring, reporting, and tuning of Oracle databases to ensure the highest standards of availability, resilience, integrity, security and performance required by business systems.
• Responsible for scheduled maintenance tasks including exports, replication, mirroring, cloning, backups, and database recovery; developing, maintaining, modifying, and creating tablespaces and datafiles.
• Develop database schema, make modifications and improvements to the schema, columns, constraints, sequences, and indexing using Oracle development tools.
• Responsible for configuration management of an Oracle Software Development environment.
• Responsible for installing, configuring, managing and maintaining Oracle servers in 9i, 10g, and 11g.
• Performs SQL tuning monitor activities included verifying dat databases performing optimally has enough space in the tablespaces, reviewing alert logs, etc.
• Write Unix/Linux CRON script to automate OS and database related process schedules.
• Support production environments and performance tuning of databases using SQL to accomplish these Administrative tasks.
• Install and configure software updates, and security patches.
• Creates, modifies and deletes (manages) user accounts, privileges and access control Ensure latest software versions and patches are tested and deployed accordingly.
• Designing (worked with System Analysts using ERWIN to produce optimal ERDs to meet business requirements), creating, maintaining, and performance tuning of database tables and datafiles.
• Responsible for data loads, testing, data extraction and job scheduling.
• Partitioning of very large database (VLDB) and Encryptions.
• Install and configure Oracle 10gR2 and 11g Enterprise Manager (OEM & GRID control) on UNIX/LINUX (Red Hat and Oracle Enterprise Linux 5 (RHEL5) and Windows platforms following OFA guides.
• Resizing, relocating and duplexing redo logs to either reduce log switching or eliminate contention.
• Knowledge and understanding of the RAC environment.