Senior IT consultant with over 15 years experience, including over 10 years as a Senior Oracle Architect and Technical Project Lead. Relies on 10 years of extended experience and judgment to plan and accomplish goals. Works under little supervision and has a tremendous degree of creativity and latitude.

EXPERIENCE

Confidential

Senior Oracle DBA/Designer

• Expertise in MS SQL Server 2008, including SQL Server operations and SQL query optimization for large databases in a 24x7 environment.
• Deep expertise in configuration and tuning, backup and recovery, transaction log management, cluster configuration, maintenance, performance tuning, and indexes in a MS SQL Server environment.
• Experience designing, implementing, and maintaining high-availability MS SQL databases.
• 4-6 years' experience implementing and maintaining enterprise level database solutions using Microsoft SQL Server in a high transaction or large database environment.
• Maintain 99.99 availability for all Hosting products and infrastructure.
• Deep knowledge with Oracle 11g databases, RMAN, and Data Guard experience.
• Interface with other central organizations to improve and implement process, procedures and automation.
• Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN, trace analysis, service creation, cluster and system management.
• Implementation and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases, including RAC Real Application Clusters databases on HP-UX and Linux.
• Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues.
• Regular database capacity planning related to database growth and system utilization, trend analysis and predicting future database resource requirements.
• Provide 24 x 5 escalation support using a Follow the Sun type model and/or Shift basis.
• Participate in rotational on-call schedule.
• Provide fourth level escalation support for the Support Center.
• Provide Hosting Professional Services for customers with requirements that go beyond the normal scope of work.
• Working closely with other team leads and their technical teams to ensure delivery of database services within the performance targets set.
• Defining and implementing consistent standards across systems.
• Defining database configuration standards related to performance and sizing for both transactional and data warehouse databases.
• Mentoring and knowledge transfer to other DBAs

Confidential

Senior Oracle Architect/DBA

• DB Manager responsible for the database administration of all db servers in the North America region,
• Duties included all aspects of Oracle database administration including performance tuning, Oracle installation and Oracle upgrade, database maintenance, database recovery and RAC clusters.
• Responsible for database administration for a nation-wide distributed system of more than 70 Oracle databases.
• Supported Oracle developers, performed database tuning, created database reorganization procedures, database alert scripts, monitoring scripts and backup procedures. Also developed a method for configuring EMC disk arrays for data warehouses and created a system for detecting I/O bottlenecks.

Confidential

Senior Oracle Team Lead/DBA

• Responsible for coordinating and directing teams involved in Oracle 10g projects with an emphasis on Oracle Performance, High Availability, Backup and Recovery and Capacity Planning.
• Senior Oracle DBA responsible for all aspects of Production and Development Backup and Disaster Recovery and Security.

Confidential

• Independent consultant for multiple consecutive assignments as a Senior Oracle Database Administrator. Hands-on experience installing, configuring, and administering server software, including Oracle 10g, Oracle 9i, Oracle 8i, and Oracle 8 databases on Linux and Windows 2000 , Apache Tomcat including developing and deploying web services on Axis . Advanced Performance tuning with several database monitoring tools such as Embarcadero DB Artisan, Quest Central, and Oracle Enterprise Manager against 10g. Application SQL Performance Tuning with use of WAIT events, STATSPACK, Quest SQLLAB, and Enterprise Manager Performance Pack. Oracle Apps upgrade 11.5.8. 11.5.10 Production and performance DBA. Created Capacity Planning for the Solaris/Oracle configuration. Built a system to record growth trends at segment, file and file system level using STATSPACK as well as shell scripts and PLSQL procedures for 10g.
• Responsible for all aspects of Production and Development database loading, migration and cleansing. ETL solutions include Oracle Warehouse Builder OWB and ETI IDS toolset and includes of the WEB, OLAP and WAREHOUSE environments in a Production, Test, and Development environment. Installed, migrated and managed Oracle 9i and 9i application server. Responsible for 24/7 database management and PRODUCTION availability. Part of the high level Coding team developing custom caching tools. 10,000 user base environments. Implemented Sarbanes-Oxley SOX technical database compliance and solutions corporate wide. Managed and implemented technical details, policies and procedures to ensure security for all databases and data warehouses. Designed periodic and systematic evaluations of internal control systems and developed software to control and prevent unauthorized changes to transactions in the system.

Confidential

• Senior Oracle DBA responsible for all aspects of Production and Development Backup and Disaster Recovery, Security, Apps Server development and Instance management. In Responsibilities included managing all aspects of the warehouse environment in a Production, Test, and Development environment. Experience with database management tasks for Oracle 9/8i and 9/8i application server. Managed over 20 developers and 4 DBAs.
• Installed and configured multi tiered environment . Designed and Implemented Oracle Database
• Backup and Recovery plan using Oracle Recovery Manager RMAN with the integration of Veritas Netbackup. Created Database Packages, Functions and Stored Procedures for the use of the company's custom applications. Managed over 50 separate instances on over 30 UNIX HP and Solaris machines. Application front ends include PVCS, Silknet CRM, ClearQuest and Rational.
• Includes an in-depth knowledge and understanding of all phases of the data warehouse/mart
• development cycle from the business requirements and system analysis phases through the extract, transformation, load and reporting processes. Working knowledge of major ETL tool s , implementation procedures, i.e. coding, cleaning, etc. and major enterprise reporting tool s . COGNOS lead responsible for the design, and development of COGNOS/ORACLE data warehouse based cubes and Oracle based web-reporting systems. 2 Years of COGNOS, Powerplay, Visualizer, Decision Stream, Impromptu and all web related products. Programming responsibilities included Oracle DBA scripting tasks, Oracle/SQL and PL/SQL. Senior COGNOS lead responsible for the design, and development of COGNOS/ORACLE based cubes and Oracle based web reporting systems.