SUMMARY

• An accomplished IT professional wif demonstrated success in designing and implementing database solutions dat improves business functionality. Possess diversified technical background in addition to Database administration: application clustering and knowledge of Enterprise Backup & Recovery solutions.
• Extensive experience wif Oracle database administration 8i, 9i, and 10g,11g Rac,, standby, replication, installation, configuration, migration, sizing, and space management, backup and recovery, performance tuning and troubleshooting. Broad technical knowledge of infrastructure management (network, systems, web hosting), combined wif outstanding leadership ability, project management, and creative problem solving skills in both strategic and tactical areas. Proving ability to implement technologies dat decrease cost, increase performance and positively effect the bottom line.

PROFESSIONAL EXPERIENCE

ORACLE DATABASE ADMINISTRATOR

Confidential

Responsibilities:

• Install, maintaining, migrate, upgrade oracle 10g/11gri1/11gr2 software stacks, manually and script
• Maintaining and managing critical backup using Rman tools and OEM to manage the oracle database
• Create tables and partition segment in logical tablespace
• Maintain and support 10 tetrabytes nodes rac system using GRID control for administration and maintenance
• Assist users wif problem resolution and answer database questions. Worked wif external and internal customers in existing data warehouse structures
• Develop automation tools for streamline workflow and database scripting in windows and SQL developer
• Monitor and tune performance of oracle database wif Grid control and AWR and ADDM features for analysis procedures, datapump export and import procedure
• Performance dynamic views dictionary to resolve performance

EXPERIENCE PROFILE

ORACLE DATABASE ADMINISTRATOR

Confidential

Responsibilities:

• Designed and monitored several instances of multi versions Oracle Databases, Includingthe responsibility for the physical database design.
• Performed Installation, setup and configuration of new versions of the Oracle RDBMSand its tools and any other tools dat access the Oracle database
• Administers all database objects, including tables, clusters, indexes views, sequencespackages and procedures.
• Plans and implements backup and recovery of the oracle database
• Provides technical support to application development teams. Contact al necessary supportssuch as Metalink or Oracle Support for assistance as necessary.
• Puts standards in place to ensure dat all application design and code is produced wifproper integrity, security and performance. In addition, performed the reviews on the design andcode frequently to ensure the team standards are being adhered to.
• Performed database capacity planning,
• Responsible for data analysis, transforming and loading data from various network devicesinto the data mining database for analytical reports.
• Creates design document for application/database development,
• Created data - model for supporting table driven design in ERWIN.
• Created data modeling using data modeling tools ERWIN to define models and data flows

DATABASE ADMINISTRATOR

Confidential

RESPONSIBILITES:

• Installed Oracle 10g release 2 and upgraded it to latest 10g patch set on HP-UX 1123
• Involved in HP DCC data consolidation process by assisting in migrating more than 1600 applicationsworldwide into the new DATA CENTERS in Houston, Austin, and Atlanta
• Migrating data from existing non-clustered oracle 8i/9i/10g databases to new DCC 10g RAC databaseenvironments using various migration methods (export/import),
• Extensive utilization of HP CAPMAN and other resources for database creations and enhancements
• Extensive use of ORACLE ENTERPRISE MANAGER (GRID CONTROL) for database monitoring and administration
• Involved in setting up RMAN catalogs for database backup and recovery purposes
• Creating physical standby databases for mission-critical databases
• Work closely wif the Unix Platform Team and Network engineers to resolve known server issues
• Complete migration reviews wif each application team to ensure proper database sizing, migration process etc.
• Perform Database creation Oracle DBCA and manual installations conforming to client’s requirements
• Experience in Space Management, Storage allocation, Table/Index segments
• Expert in Export/Import (object level, schema, table space, and full database)
• Extensive utilization of HP CAPMAN and other resources for database creations and enhancements

Database Administration

Confidential

RESPONSIBILITES:

• Provided expert Oracle database knowledge and support for Oracle 8, 81 application developments.
• Reviewed and enforced standards, procedures and guidelines for Developers’ usage
• Provided consultation and resolutions for al application development as it pertains to database related problems
• Design and implemented backup and recovery plan
• Develop database capacity planning.
• Normalization of the database logical and physical schema
• Executed test procedures
• Create database disaster prevention by using standby database and applying archived redo logs
• Support for the field system and sales engineering team on all Oracle database related issues
• Performed database performance system and SQL tuning
• Assisted in creating logical and physical design of database schemas for new applications
• Reviewed and aided in the design of Oracle databases to meet the business requirements
• Assisted in developing process flows to help identify database-related interfaces to other systems such as Oracles gateway for Sybase.
• Provided consultation, training and mentoring to all application developers in database management practices as it pertains to Oracle Databases
• Managed multiple environments for multiple applications: development, integration testing, systemstesting, staging (QA) and production. This includes synchronization wif database change control tools.
• Created and maintained data definition language scripts for all database changes
• Assists in providing documentation detailing the design and architecture of the databases, as well as the administration, backup procedures and data recovery steps
• Assisted in promotion of database related changes from development to production
• Worked wif operation DBA’s in the recovery of corrupted databases, timely troubleshooting of all
• Database-related problems an emergency response to all development, testing and production downtime events
• Monitored application and database performance, and adjusted database parameters, application code or schema as needed
• Monitored space usage, and adjust database as need
• Monitored backup operations, and schedules manual backups as needed/
• Worked wif system administrators to configure the system for optimal performance.

TECHNICAL SKILLS

TECHNICAL SKILLS: Oracle DB 10g, 10g RAC, 9i, 8, and 8i

HARDWARE: IBM Personal Computers and Compatibles, HP services and computers

OPERATING SYSTEMS: Windows 95, Windows NT, XP Professional, Windows 2000, HP UX Itanium, PARISC

LANGUAGES: PL/SQL, SQL

SOFTWARE: Oracle Cluster ware, Oracle RDBMS 10G R2 (Version 10.2.0.1, 10.2.0.2. 10.2.0.3) Oracle Applications Release 10.7