OBJECTIVE:

• A Database Architect Lead / Senior Database Administrator with operations support, project management, applications development background seeks employment in IT / database administration / project management capacity to improve customer satisfaction, quality and productivity.

SUMMARY:

• Fifteen years of IT experience. Ten plus years of experience with Oracle technology in both application development and 24x7 business mission critical operations support, with multiple fortunate 500 clients.

TECHNICAL SKILLS:

TECH SKILLS DBMS: ORACLE v7.x (SQLFORMS v3.0, v4.5, SQLPLUS, PL/SQL, Pro*C), 8i, 9i, 10g, 11gRAC, ASM, Grid Control, Oracle Streams, Oracle Enterprise Manager, SQL ServerMS OFFICE SUITE, ACCESS, EXCEL, WORD, PROJECTOracle Applications 10.x, PeopleSoft

CRM System: Remedy, Vantive, Salesforce

Operating Systems: UNIX (Solaris, AIX, HP UX, Linux), MSWINDOWS 95/98/2K/2K3/NT,DOS.

High Availability Systems: Veritas VCS Cluster, Legato Qualix HA Cluster, IBM HACMP, Disaster

Recovery w/Oracle DataGuard using physical standby.

Platforms: SUN, IBM RS 6000, Intel.

Languages: C, SQL, Embedded SQL, Shell Programming, Pascal, FORTRAN, 4GL, Perl.

PROFESSIONAL EXPERIENCE:

Senior Oracle Database Administrator

Confidential, San Mateo, California

Responsibilities:

• Ensure that production databases for hosted operations remain optimally tuned, perform required database maintenance including:
• Work with production hosted databases and ensure that we are meeting contracted service levels and that the customer is satisfied.
• Ensure database objects (views, stored procedures, triggers, constraints, defaults, etc.) or SQL statements meet performance and security objectives.
• Install and maintain Oracle databases on UNIX/ Sun Solaris; maximizing availability, reliability, and performance, and minimizing issues.
• Provide operational support to hosting customers as part of the Confidential hosting operations team.
• System monitoring, troubleshooting and support of SUN, Linux, Windows Server.
• On call rotation.
• Work with the hosting team and professional services to perform customer database implementations in our hosted environment, work with engineering, hosting team, professional services and 3rd party consultant implementation teams to ensure that the oracle implementation is successful, on - time and the customer is satisfied.
• Work with Hosting Team Project Manager and Professional Services Project manager to define and follow implementation project plans for customer database implementations.
• Work with hosting operations team to help ensure required infrastructure is in place for new customer database implementations.
• Coordinate and perform performance tests for hosted customer implementations.
• Recommend and implement improvements to the database objects and structure in order to improve performance of Confidential ’s hosted applications and applications deployed at customer sites.
• Ensure database migration scripts and programs meet data integrity, performance and security objectives.
• Work with partners and vendors responsible for DBA related services and ensure we are receiving services for which we have contracted.
• Provide database design recommendations and solid database operational best practices to help form and harden the hosting offering.
• Determine additional services that are required for our hosting offering, make recommendations for obtaining those services and work with Confidential ’s executives to ensure these services are purchased and delivered.
• Work with Customer Service, Engineering and PSO to help solve customer software deployment issues in the following areas:
• Current production instances
• Customer GO - Lives
• Development phases
• Performance phases
• Review existing product schemas and provide recommendations to engineering team on restructuring and performance tuning.

Database Architect Leader

Confidential, Oakland, California

Responsibilities:

• Successfully migrated Oracle 9.2.0.4 to 9.2.0.8 for all production, staging and DR instances.
• Maintained Oracle 10g RAC on linux for all production, staging and DR instances.
• Cloned new RAC instances for production and development databases. Setup backups/monitoring in lieu with 24x7 ticketing and oncall paging system.
• Set up DataGuard RAC using physical standby on DR site. Setup custom monitoring scripts to catch log gaps.
• Proactively worked with PeopleSoft team on RAC dbs and application performance issue, identifying bottlenecks, enhancing monitoring scripts to pin-point long running queries, using stored procedures/sql trace/tkprof/explain plan to identify troubled query plan and to improve cost, running stress/load test and to provide recommendation using statspack.
• Provided development cycle export/import between production and staging instances.
• Worked closely with SAN and UNIX team on capacity planning and space allocation for data growth.
• Worked closely with client on security auditing findings and security measure implementation.
• Annual Oracle RAC DataGuard readiness test for Disaster Recovery. It has been using with Failover/Switchover method. Provided documented procedures to client.
• Managed and implemented of db maintenance tasks for Oracle database patching, upgrade, backup using both RMAN/cold/hot backups/export, recovery, RAC related issues, Disaster Recovery with physical standby database, installation, monitoring, capacity planning and performance tuning for various customers, mostly on VCS clusters or AIX RAC.
• Managed a Data Warehouse implementation/customer schemas in coordination with client reporting.
• Served as a Project Manager to oversee the activities of delivery of new design/implementation and maintenance of custom database service offerings. Served as a resource for internal teams and other external sources. Monitored and ensured timely execution of customer requests and allocate and schedule team resources for various internal and external IT projects.
• Served as an Oracle DBA architect and provide feedback to pre-sales team for customer database architecture designs and layouts over business critical applications, including using High Availability design and Disaster Recovery solution on Solaris, IBM AIX and NT platforms.
• Attended various external customer-facing conference calls to resolve management and technical issues.

Oracle DBA Team Supervisor

Confidential, Palo Alto, California

Responsibilities:

• Provided technical guidance and feedback for team members, including backup/restore/point-in-time recovery, rman errors, and performance tuning issues.
• Contributed to backup improvement plan for better cooperate-wide Oracle databases backup operations.
• Mentored junior team members.
• Interfaced with Engineering and contributed to QA and design of database packages.
• Conducted Oracle databases Listener security patches application and audit.

Applications Engineer / DBA / Release Manager

Confidential, Redwood Shores, California

Responsibilities:

• Installed databases for Oracle Applications prod 10.6, 10.7 (Prod 15, 16) on Solaris for patch testing and product development. Performed database backup and recovery, including export/hot backup and weekly cold backup. Worked closely with development team for support of database schema, views, PL/SQL code objects.
• Installed and tested Oracle Application on the server side, including current manager diagnostics and setup, patch driver testing/setup, database driver testing/setup, application code area testing/setup on Sun Solaris and Sequent platforms. Familiar with Oracle Applications architecture including multi-org, apps account, autopatch and autoinstall. On the client side setup Oracle applications Production 14, 15,and 16 client software, Oracle Workflow, Oracle
• Office, Sqlplus, Developer 2K, Designer 2K on Windows platform. Setup Report Review Agent for viewing concurrent requests.
• Designed and implemented software modules for Oracle Financials Account Receivables in full software life cycle development, using Pro*C, PL/SQL and Oracle Financials on Sun Solaris and
• Sequent platforms.
• Research Assistant, Database Systems R & D Center and Dept. of Anesthesiology University of Florida, Gainesville, Florida.
• Maintained and developed a large - scale graphical database schema editor, browser, translator XGTOOLS, using X / Motif / C, for a prototyping Object-Oriented Database Management
• System.
• Designed and implemented a X/Motif based GUI for a Query Processor (M. S. Thesis). This project was developed as a part of the National Industrial Information Infrastructure Protocols
• Designed and supervised a graduate student in implementing a NIIIP protocol specification and workflow modeling tool for the NIIIP project using X / Motif / C.
• Designed and implemented a personnel leave request database system using PARADOX 4.5 on a
• Novell local area network for administrative use.
• Designed and implemented a medical information database using MS ACCESS for an Anesthesia
• Information Management System.
• Promoted assistance between DBA and ORACLE technical support to solve the SQL FORMS MENU, REPORT installation problems and tutored students in the use of ORACLE 7 for application purposes.