PROFESSIONAL SUMMARY:

• 15+ years experience in IT
• 10+ years of extensive experience in database administration with Unix, Linux, Windows.
• Extensive experience in data modeling (ERWIN/ERStudio), data analysis, physical/logical database design and documentation
• 5+ years experience in report development, report automation
• Extensive experience in supporting product development thru Dev, QA, Build and Release cycles
• Extensive experience in automation of database installation and maintenance tasks
• Extensive experience in developing n - tier Client/Server applications using Visual Basic, SQL Server, MTS, Oracle, HTML, MS Site Server and PL/SQL
• Extensive experience in developing Web applications using ASP, .NET, VB Script, JavaScript, WebObjects, Java, MS SQL, Oracle
• Extensive experience in configuring web servers (Apache, IIS, Netscape Enterprise Server), SSL Security and web server administration.
• Extensive experience in using FTP, SFTP, Telnet, and SSH

TECHNICAL SKILLS:

Technology and Tools: Oracle 8i/9i/10G/11G/12C DBA, Oracle RAC DBA, MS SQL Server 7/2000 DBA, Ipedo Native XML DBA, Sybase, MS Access, MySql, Postgres, Ingres, PL/SQL, Explain Plan,XQueries, XSLT, XML, Perl, JSP, ASP, JavaScript, VB Script, Visual Basic, HTML, Some Java, JDBC, ActiveX, UML, Rational Rose, COBOL, Perl, MS Front Page, MS Visual Studio, Macro Media DreamWeaver, Visual Inter Dev, WebObjects, Visual Source Safe, JBuilder3.0, Crystal Reports, Business Objects, Brio Query, Business Objects, ERWin, Rational Rose, ERStudio, Visio 2000, SAS, SQL Analyzer, OCI Tools, TOAD, SQL Loader, Import-Export Utilities, RMAN, OMWB, DTS, Query Analyzer, OEM, Statspack, Query Analyzer, SSDLC, MS Excel, Macros, Apache, Java Web Server, Netscape Enterprise Server, IIS, Sun SPARC Solaris, awk, sed, Mac OS/X, Linux, Windows 95/98, Windows NT/2000, SNMP, TCP/IP, Socket Programming, EMC/SAN storage

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Technical Consultant ( Oracle DBA)

Responsibilities:

• Lead a team of DBA’s to maintain 72 oracle RAC and Veritas Cluster instances
• Effectively manage highly complex data environments and data structures
• Develop and maintain database support documentation
• Use best practices, work plans, checklists and defined processes
• Take ownership of complex database incidents and problems, providing resolutions in a timely manner
• Engage SMEs or vendors to provide assistance to resolve more complex incidents as required
• Monitor database environments, proactively identify and prevent incidents
• Implement database change requests
• Proactively support application teams, release cycles, schema changes and advice on application data issues
• Support development, test, and production Oracle database environments
• Follow and contribute to database best practices
• Perform database optimization and performance tuning
• Install and configure Oracle 11G/12C RAC database servers on RedHat Linux/Solaris
• Perform database replication using GoldenGate, DataGuard
• Perform Veritas (VCS) to RAC migrations
• Perform database migrations between data centers
• Upgrade and patch database servers
• Implement database backup and recovery procedures
• Troubleshoot database and SQL query performance issues
• Maintain and support high available oracle RAC and Veritas cluster environments
• Implement data encryption using TDE and COST
• Provide Oracle database 24x7 on call support to include participation in Severity 1 production outages for critical airline systems.

Confidential

Sr. Database Administrator(contractor)

Responsibilities:

• Effectively managed development, QA and production database environments for PPM R&D software group
• Provided expert direction and guidance to application developers on application data issues and best practices
• Communicated with developers, data analysts, and business liaison on daily basis
• Assisted troubleshooting query performance issues on Business Objects reporting application
• Develop and maintain database support documentation
• Implemented database change requests
• Installed and configured Oracle 110G/11G RAC database servers on RedHat Linux, AIX, Windows platforms.
• Installed Oracle patches and database schemas, and upgraded the databases to new versions
• Automated database server installation, database creation and maintenance functions (Oracle Provisioning)
• Provided database support for product development thru Dev, QA, build and release cycles for PPM application
• Configured data modeling (in-house) and documentation tools for new software releases
• Performed database optimization and performance tuning for servers, applications, and SQL queries
• Performed database monitoring via OEM and Sitescope monitoring tool

Confidential, San Jose, CA

Sr. Database Administrator

Responsibilities:

• Maintained Production/Development/QA Oracle 9i/10G, Oracle RAC on RedHat Linux Advanced Servers
• Maintained/Installed MS SQL Server production database servers
• Migrated a large production MS SQL Server database to Oracle 10G
• Installed latest database schemas, patches and upgraded existing Oracle 10G servers
• Supported product development thru DEV/QA, Build and Release cycles
• Proactively supported application teams, release cycles, schema changes and advice on application data issues
• Wrote and converted T-SQL scripts to PL/SQL and partitioning scripts to upgrade schemas
• Identified performance bottlenecks and tuned SQL and server memory structures
• Performed database backup and recovery procedures
• Implemented database monitoring tools
• Designed/developed custom SQL/PL-SQL scripts to implement UI functionalities.
• Performed 24X7 on-call duties on production database servers and application servers.
• Defined business requirements, wrote technical specifications, designed and developed finance and manufacturing reporting solutions (Crystal Reports XI)
• Wrote Shell scripts to automate EXCEL financial reports generated via Oracle production databases

Confidential, Cupertino, CA

Sr. Database Administrator (Contract)

Responsibilities:

• Installed, maintained Oracle 9i RAC and Native XML (Ipedo) database servers on RedHat Linux
• Deployed a reporting server synchronized with production database server
• Designed and developed finance reporting solutions
• Implemented solutions that improved the performance of Oracle RAC.
• Installed staging and QA Oracle and native XML database servers (Ipedo) on development and production RedHat Linux AS3 and SuSE Linux platforms
• Capacity planning on EMC/SAN storage environment
• Migrated and maintained staging and production Native XML database (Ipedo) servers.
• Wrote Perl/Shell scripts to automate database replication for reporting server
• Wrote Perl scripts to automate management reports
• Integrated 3rd party reporting tools with Native XML database for business and ad-hoc reporting

Confidential, Sunnyvale, CA

Sr. Database Architect/Administrator (Contract)

Responsibilities:

• Designed and developed a web-based reporting system (using Crystal Reports, Cognos, .NET) for Product Engineering Group.
• Designed and developed corporate engineering database using ERStudio and MS SQL Server.
• Designed logical and physical data models and optimized and tuned SQL and database.
• Resolved database replication issues and generated scripts to create databases.
• Designed and implemented Fault Analysis reporting systems using Accurev Configuration Management Software.
• Trained various product systems engineering groups in using the database, the reporting system, the Fault Analysis and bug tracking systems.

Confidential, CA

Database Administrator

Responsibilities:

• Participated in the planning and implementation of the hardware/software configuration and related database server environment.
• Installed, configured and maintained Oracle, MS SQL Server, MySql database servers.
• Developed and implemented backup and recovery strategies and procedures (RMAN).
• Developed data models (using ERWIN/ERStudio) and created the physical implementation of databases.
• Managed high-availability databases on multiple development (Linux) and productions servers (Solaris).
• Automated monitoring of key database server components and events.
• Enforced database security policies in compliance with HIPAA security and regulations.
• Implemented solutions that improved the performance of server functions.
• Provided expert information and advice to application developers to assist them in making the most effective and efficient use of database management system capabilities.
• Performed migration of various databases (Sybase, SQL Server, and Access) into Oracle 8i/9i on Solaris/Linux platforms.
• Tuned SQL using Explain Plan and TkProf and developed table fragmentation strategies.
• Developed Stored Procedures, Functions, Triggers, SQL and Perl/Shell scripts to automate day-to-day administrative tasks.
• Wrote PL/SQL scripts to log all database errors to a table demonstrate database triggers, list foreign keys in tables, show database versions with options installed, and load data from a cursor in PL/SQL.
• Wrote PERL scripts to change the Sybase DATE formats and setup Cron jobs to load text data files into Oracle database server.
• Participated in 24X7 on-call rotation as necessary.
• Communicated with users, developers, data analysts, and business liaison on daily basis.
• Configured/installed and maintained Web Servers (Apache, Netscape Enterprise Server, IIS) on Windows, Mac OS/X platforms.
• Configured Video Servers (Windows Media Server, Real Server) on Windows 2000 platform for the Media Server project for local and distance teaching, research, and clinical outcome analysis.

Confidential, Cupertino, CA

Senior IT Consultant

Responsibilities:

• Developed use cases (Rational Rose, UML) for eSiebel application for Microsoft in Seattle.
• Designed and the developed an internal application using ASP, jhtml, SQL Server and ATG Dynamo for theconsulting firm.

Confidential, Los Altos, CA

Software Developer/DBA

Responsibilities:

• Designed and developed an Confidential ImageArchive software using Webobjects, Java, Oracle
• Installed, configured, maintained Oracle 8i/MySql Server database servers and created instances.
• Migrated a hierarchical text database into MySql
• Monitored logical logs, daily backups, and shared memory allocations.
• Exported and imported databases frequently.
• Wrote Shell and Perl scripts to automate database administration functions.
• Managed and implemented schema level upgrades.
• Developed Stored Procedures and Triggers.

Confidential

Implementation Consultant

Responsibilities:

• Implemented Practice Management Software including Time & Billing, Administration, Planning, Bulk Billing and Consultant Management for leading financial, software and consultancy firms in Sydney.
• Developed project specifications, work plans, change management documentation, implementation plans and reports using tools such as Visual Basic, MS SQL Server, MS Access and MTS.
• Developed data extraction processes, stored procedures, triggers
• Involved with the integration of INVISIC software to SAP interface for Microsoft Consulting Services (Sydney) and lead a team of developers on development efforts.
• Defined business requirements, supported product and systems upgrade issues and assigned them to team members.

Confidential

Software Developer

Responsibilities:

• Designed and developed n-tier Client/Server applications using Visual Basic, MS SQL Server, MTS, Oracle, HTML, VB Script, Java Script, ASP, MS Site Server and PL/SQL.

Information Systems Instructor

Responsibilities:

• Taught various different software applications including MS Access at undergraduate level.
• Installed, upgraded, and maintained software and hardware in the computer labs.

Confidential

Database Support

Responsibilities:

• Designed and developed a MS Access database and the interface using Access Basic to a Student Information Management System.
• Produced reports in a timely manner using the Student Information Management System.