SUMMARY

A qualified and clearable Oracle Database 11g/10g/ DBA with more than 8 years managing and working with leading edge projects that require experience on diverse OLTP and Data Warehouse environments.player  and Logical database design, installation, configuration and implementation, support and maintenance of Oracle databases in a LINUX, UNIX and WINDOWS environments. Experience includes upgrade to Oracle 11gR2, setup ASM to manage storage for better performance, RAC 10g/11g installation and patching, troubleshooting RAC, using ASMCFS file system for Clustering, implementing Data Guard for real time disaster Recovery . also has experience customizing utilities for performance, Capacity Planning and reliability.  highly exposed to Big Data/VLDB environments and has excellent skills in upgrade and migrations, applying quarterly patches etc. versatile in establishing client relationships for understanding their business processes, user tasks & goals; analyzing and defining requirements to ensure efficient and cost - saving technological solutions to meet and exceed the client’s needs. Experienced in automating database creation through Oracle response files and through Linux shell scripts; he is versed in oracle management tools like Oracle Enterprise Manager performance tuning techniques comprises of usage of indexes,compression,  minimizations through hardware  and other load balancing techniques.  well exposed to Oracle Engineered Systems and has experience leveraging such systems to meet challenging and evolving client data needs.

SKILLS

• Oracle 11g RAC installation
• Oracle 11g/10g database administration
• Systems Integration
• Oracle Performance Tuning
• Sql query tuning
• Technical Documentation
• Capacity Planning
• Logical and physical database design
• Technical Leadership
• Oracle Database architecture
• Oracle RAC
• Oracle ASM technology
• Oracle RMAN
• Oracle Data Guard
• Oracle Grid Infrastructure
• Oracle Datapump
• Intermediate Linux Shell scripting
• UNIX Platforms - Solaris, AIX, HPUX
• Linux Platforms - Red Hat, Fedora, Ent. Linux
• Windows Server - WS2003,WS 2008
• Oracle Enterprise Business Suite
• Oracle Grid Control Management

PROFESSIONAL EXPERIENCE

Confidential

Kansas City, MO 

SR Oracle Database Administrator

• Install ed and configure d Oracle 11g /10g RAC using for storage, conduct ed daily incremental and weekly full backups using, and also perform ed database
• Upgrade d Oracle database versions 9i and 10g to version 11g using different migration tools such as, transportable tablespaces, and .The upgrade steps include reviewing the existing database configuration, statistics collection, troubleshooting and resolving  related script performance after any go live event
• Perform ed disaster recovery drills and recommend ed changes to current systems while adhering to change management policies
• Perform ed database performance tuning activities using tools like reports, Active Session History Reports and SQL tuning advisors
• Automate d database administration routines, e.g. backup and recovery, response files, data pump export/import activities, schema refresh from different sources, creation and disk usage monitoring
• Designed and implemented Oracle user audit collection and led the DBA team in architecting data flows to the presentation tiers for senior management
• Analyze database failures, identify and document corrective measures needed to maintain 
• Perform database hardening post development and testing duplications.
• Identify performance bottleneck, storage issues and other Operating Systems related optimizations
• Provide customer support to hosted Clients while coordinating clients’ support with Oracle support
• Develop and document tools, scripts, and processes for internal and client DBA use
• Highly skilled at researching new RDBMS version and functionality
• Provided technical direction, development, training and mentoring to team members and clients as needed
• Performed restores on non-production databases as needed
• Performed data scrambling on highly sensitive data.
• Assisted on several new flip projects, which included setting up and configuring new footprints as well as monitoring scripts in crontab and DBMS jobs to allow proactive database monitoring and tuning.

Confidential

Kansas city,DE

Oracle Database Administrator

• Installed database software, created databases, performed database upgrades and applied one-off and quarterly patches when necessary. Also Managed online redo log files, archive log files, control files and other oracle related files
• Took part in efforts in tuning existing software and its relation to database performance
• Took on the task of researching and testing out new database technologies before introducing new database technologies to entire organization
• Responsible for the planning, designing and implementation of the backup and recovery program for database backups, restoration and recovery for continuous operation
• Extensively dealt with schema design and data modeling using tools like Oracle Data Modeler
• Managed database security by creating new users, roles, profiles and privileges in development, test and production environments. Planned all database storage structures and approved all production changes
• Proactively performed database performance tuning by monitoring different hit ratios of the  components such as shared pool, database buffers and redo logs. Utilized database advisors to maintain optimal database efficiency and performance.
• Utilized Automatic Workload Repository to generate snapshots of key performance data, such as time-model statistics, which shows how long each database activity is taking and high-load-SQL statistics which aids in identifying resource-intensive SQL statements
• Managed all database performance monitoring and tuning through Oracle Enterprise Manager
• Planned and Implemented a Data Guard setup for disaster recovery
• Familiarity and understanding of data storage solutions 

Confidential

Oracle Database Administrator

• Trained interns in installing Oracle database server on the UNIX and LINUX platforms
• Assisted in generating training material for interns
• Assisted in the designing backup and recovery program
• Trained interns in installing and configuring Oracle 
• Assisted in configuring  file servers and other Linux appliances for this client
• Provided technical direction, development, training and mentoring to team members and clients as needed
• Assisted in writing technical manuals for on-site Linux and Oracle Administrators
• Developed hardware requirements specification and assisted in other sizing activities.