Professional Summary

Reliable, Responsible, Trusted, Proactive Reactive Oracle Database Administrator with expertise in crisis management, performance tuning, and high availability to increase reliability, maximize productivity and ensure system efficiencies. Adept at all stages of project lifecycle, from business requirements and technical definitions to testing, documentation, production support, training and completion.

Technical Skills

• Provided 24x7 production support for Oracle 11g/10g databases on various platforms.
• Proficient in all DBA responsibilities such as Installation, Configuration, Upgrades, Patches, Performance Tuning, Schedule Backup in both archived and non-archived mode, RMAN Recovery Catalog, Cloning, Space management, Database Security, Auditing, Troubleshooting, Database Design, Unix Shell Scripting and Documentation.
• Implement Oracle Enterprise Manager Grid Control OEM 11g/10g for centralized monitoring and administration.
• Extremely detail-oriented and able to follow standard methodologies for troubleshooting and development
• Comprehensive knowledge of database administration design, installation troubleshooting
• Planned and implemented high availability solutions using Oracle 11g/10g RAC Standby Database using Oracle Data Guard and Replication.
• Operating Systems: Installation and Configuration of Unix/Linux, Windows 2003-08 for Oracle database, ASM and Oracle discoverer installation.
• Tools: SQL Plus, Enterprise Manager, Grid Control, SQL Loader, Oracle Recovery Manager RMAN , SQL Advisor, Control Advisor, Automated Workload Repository AWR , Scheduler, Data Pump, Real Application Clusters RAC , Partitioning, Active Data Guard, Unix Shell Scripting, Automatic Storage Management ASM , Data Archiving, TOAD, MobaxTerm, SecureCRT, Enterprise Reporting with Oracle Reports, EMC Avamar, Networking.
• Advance PL/SQL, development of store procedure, functions and packages for Business intelligence and logic.
• Experience working with EMC to provide high-speed backup and recovery to multiple DBs to ensure high availability
• Business Analyst, Software Development Life Circle SDLC Agile methodology, Agile Scrum, V-model and Water fall, software testing skill
• Understanding how to transact data across different heterogeneous environment in real time using Golden Gate
• Strong mathematical skill in Algebra, Pre-calculus, Calculus and Statistics using Minitab
• Understanding of Total Quality Management, Quality analysis and its applications

Professional Experience

Confidential

Oracle Database Administrator

• Installing and configuring Oracle Enterprise Red Hat Linux operating system versions and Windows 2008 servers for Oracle Relational RDB and Multidimensional Databases MDB installation and creation, configuring real application cluster RAC , Configure Automatic Storage Management ASM , installing Oracle grid infrastructures Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company. Using different tool to manage ASM and RAC configurations..
• Work Creating, migrating and backing up database for various clients.
• Work on a project with a team of 5 and successfully analyzed, recommended and implemented an active Oracle Data Guard, Real application Cluster RAC to improve Oracle data protection, data availability and disaster recovery to enable easier monitoring and management system in both OLTP and data warehousing environment
• Part a team of 3 to execute a project to configure multiple databases for different Counties GA for basic backup and disaster recovery that resolved data loss problems for the entire county database.
• Part of a team of 3 who successfully upgrade multiple databases and carried out short term performance tuning, maintenance and training for continuous operation for Wrynecks Groups in Arizona remotely
• Carrying out Oracle Database maintenance base lining, performance tuning, alert configuration, using snap shots taking by Automated Workload Repository AWR / Automatic Database Diagnostic Monitor ADDM to generate performance reports, monitoring database performance, securing protecting information/database with unique secure configurations, data encryption and masking procedure as well as with sophisticated auditing skills.
• Presenting and analyzing database performance reports and improvement recommendations to client company's senior executives.
• Ensuring fast and secure access to business applications round the clock
• Space and object management using scripts
• Provided a 24/7 remote third party support using Oracle Grid Control to plan database security strategy, up grading databases as required and implementing daily back-up and recovery as needed.
• Maintain a RAC environment using CRSCTL Utility, Server control Utilities and others.
• Addition of nodes and disk in RAC and ASM environment
• Resolving communication, network, IP connectivity between the nodes in two nodes cluster.
• Lead a consulting project during which my team performed all user requirements and troubleshooting activities, diagnosed the installed database with improved Oracle 11g packages as well as resolved connectivity issues. Implemented, administrated, and maintained daily backup and archived data on disc/tape. Created user accounts system/user-level database objects managed user privileges. Carry out database partitioning indexes, table to increase database availability, performance, and recovery during database design
• Installing Oracle software, planning the database security strategy, enrolling system users and planning for their Oracle Network
• Ensuring proper configuration and security on all database servers.
• Executed varying maintenance, installation and automation projects with clients using varying project management methodologies
• Running complex queries to retrieve data from multiple tables, ensuring fast and secure access to business application for about 60 users in remote location round the clock.
• Development of store procedure, function and packages for different oracle applications

Confidential

Oracle Database Administrator

• Building test strategies, backup recovery models for Oracle. Refreshing test databases.
• Managing backup Recovery for Oracle on Red Hat Linux using RMAN
• Team work with the developer and other project team member to achieve the goal of each project within the time frame
• Going through the day-to-day user requests and troubleshooting the database related problems.
• Linux shell scripting for monitoring oracle Database status, security backups.
• Monitored tablespace size, resizing tablespace, relocating data files for better disk I/O.
• Created user, allocation of appropriate tablespace quotas with necessary privileges and roles for Oracle databases.
• Part of the team of four, create backup plan design and implementation using cold/hot backups, Flash copy, RMAN backup, ASM and RAC technology.
• Used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries
• Running queries to retrieve data from multiple tables, ensuring fast and secure access to business application for different users in remote location round the clock, use data to perform business intelligence analysis.
• Keep good relationship with the management to better help the performance of every group, team and the entire organization performance
• Upgrading Oracle Databases from 10g to 11g
• Provide support for desktop, server and mobile technology
• Experience configuring network, building server system, and installing OS's both Unix and Window