Database Team Leader Resume
CERTIFICATIONS
- ORACLE 11G/10G CERTIFIED PROFESSIONAL (OCP)
- Oracle RAC Certified Expert
- Oracle Linux Certified Expert
- VMware Certified Professional (VCP4)
- SUN MYSQL Certification
- NOVELL CERTIFIED NETWORK ENGINEER
- Microsoft Certified SQL Server 2008 (MCP)
- Microsoft Certified SQL Server 2008 (MCTS)
2011 to Present
Confidential, (CT)
Database Team Lead
- Day-to-Day Oracle production support including patching, upgrades and installs within an ASM 11G/10G Oracle Clustered environment.
- SQL Performance tuning/system performance reviews.
- Data Guard Support logical/physical.
- Supporting Data Warehousing applications and critical management reporting systems.
- Supporting financial apps, developers, and Business Intelligence teams.
2006 to 2011
Confidential,Lead Database Engineer/
Database Performance Lab Manager
- Third-level support, diagnosed/resolved major 10G/11G RAC performance issues, identified bugs, and configuration design issues. Provided solutions including: bug fixes, database workarounds, custom fixes, application tier fixes and extensive tuning of each component tier.
- Lead Oracle Database Architect, responsible for setting direction and road maps globally for the Oracle RDBMS Stack.
- Created an automated Oracle 10G/11G installation process that is currently used for all of Liberty Mutual standard software installs for the Global enterprise.
- Worked closely with Oracle development/consulting teams to insure future platform scalability of large scale distributed applications using (J2EE/.Net) on high-end platforms (IBM P-Series, Sun Fire, Sun M-Series and Linux Servers).
- Key day-to-day database responsibilities: Oracle RAC Database instance management, resolving performance issues, RMAN backup/recovery, DB tuning, replication, cloning, upgrades, new user creation, and working with users/developers to troubleshoot system and application issues.
Projects Used Enterprise Hardware/Software includes:
- Application Servers(Weblogic, Apache/Tomcat, Oracle 10iAS)
- Storage( EMC, Hitachi, ASM, Veritas Clustering/High Availability)
- Database Technologies (Oracle, UDB, MYsql, SQL Server)
2004 to 2006
Confidential,Sr. Oracle DBA
Traditional database support: backup/recovery, security, tuning, and database management.
- Responsible for over 100 database instances on Linux, SUN, IBM Platforms.
- Oracle CRM/ERP, Technology Stack, 10G RAC, Welchs Custom Applications, Oracle Workflow configuration and system administration.
- Configured, installed and upgraded database instances (Oracle 9i/10G/11i).
- Infrastructure design, performance monitoring and tuning and recovery of all databases.
PROFESSIONAL EXPERIENCE
Confidential,Sr. Database CONSULTANT
1998-2004
- Installed, configured, upgraded, and apply patches to all databases and 11i applications.
- Establish and maintain security and integrity controls on the Welch Oracle databases
- Supported: Oracle 10G Database/Data Warehousing, Noetix Reporting, Demantra, Kantana ITG, Quest and Webmethods
- Backup/DBTools: RMAN, OEM, TOAD, Unix shell scripts
- Successfully implemented $7 Million CRM/ERP Oracle application effort using 11i (11.57, 11.56, 11.55, 11.03)
- As an Oracle Application Consultant successfully implemented Oracle application 11i CRM for large variety of companies (9iAS with Oracle ERP, HR, AR, AP, GL, Order management and shipping for Xerox (Major Fortune 500) focused on problem resolution, bugs fixes, configurations\\setup and Application patching. (Sample of clients listed below)
- Confidential,Responsibilities include application development, system management and client. Installed applications, configured modules, and supported and upgraded Oracle 11.57 Apps environments for both the ERP/CRM environments.
- Modules 11.5x: Financials :Accounts Payable, Accounts Receivable, Cash Management, General Ledger, Fixed Assets, Bills of Material, Capacity, Field Sales, Inventory, Pricing, Project Manufacturing, Purchasing, Scheduling, WIP, MRP and 9i RDBMS.
- Confidential,supported both the application development team and functional analyst. Installed patches, configured modules, and supported and upgraded Oracle 11.57 Apps environments for both CRM and ERP environments.
- Modules 11.5x: Financial Intelligence, Install Base Intelligence, Service Intelligence, iStore, iMarketing, Contracts, Field Service, Maintenance, and 9i RDBMS.
- Confidential,core technologies implementation team, Installed patches, configured modules, and supported Oracle 11.55 Apps environments for both CRM and ERP environments.
- Modules 11.55: Financials, HRMS, Supply Chain, iPayment, iStore, iMarketing, Web Customer, Contracts, Field Service, Maintenance, Field Sales, Financials, HRMS, Call Center, Supplies, and 8i RDBMS.
- Setup and monitored critical concurrent processes.
- Worked closely with Oracle development to resolve customer and application issues.
- Resolve both enterprise server and infrastructure related problems.
- Other projects involved on Oracle ipayment for AMA, CRM for Timex, Internet Technologies for CMGI, ERP for Workscape and ERP/SAP for Kodak
- Confidential,Team lead, for a major database consolidation effort that saved the client over $2,000,000 annually.
- Worked for a key Streaming Technology firm to create their RDBMS architecture for a Clickstream Datawarehouse and built a large number of internal databases.
PROFESSIONAL EXPERIENCE
- Confidential,1998 to 1995
- Network Manager
- Built a New Network Operation Center using several SNMP Managers.
- Day-to-Day responsible for a staff of technical professionals
- Technical recruitment, performance reviews, and to provide management direction.
- Creating budgets, managing purchases and negotiating contracts.
- Developed Intranet sites for using IIS and Hyperion Software an enterprise, financial reporting package that provides web-based viewing of reports.
- Built, installed, and configured a large array of file servers: Netware 4.x/3x.,LOTUS NOTES, Web Servers, WindowsNT4.x, SOLARIS 2.x.
- Configured/Installed/ support databases Oracle 7.x /8.x Enterprise Server and Clients.
- Confidential,1995 to 1991
- Network Supervisor
- Build new Network Infrastructure Composed of Cisco Routers, T1 lines, high-speed Gigabit backbone, and Fast Ethernet Hub.
- Developed a Banking Asset tracking system for a large financial institution the system handled billion dollar portfolio for Asset Based Lenders. The system connected directly with IBM Mainframe.
Technology
Software, Tools & Languages :Discoverer, Jdeveloper, Perl, C/C++, IDE Eclipse, VB.NET, Topas, NMON, NIM Servers, Linux Satellite, IBM System Planning Tool, IOMeter, sar, prstat, vmstat, iostat TSM/ Commvault Backup, Netbackup and Bladelogic
Databases :Oracle DBMS 9i/10G/11G, IBM DB2/UDB, Informix, Sybase, MySQL, Netezza and Teradata
Operating Systems :UNIX (Linux Redhat 4x/5x, Sun Solaris 9x/10x and IBM AIX 5x/6.1) , Windows 2008, 2003 and Vista
Monitoring Tools/Applications :BMC PATROL/Performance Assurance, Mercury LoadRunner and Quest Database Tools, Oracle OEM, Introscope, HP OpenView,
EDUCATION/ PUBLICATIONS
B.S. Computer Science
Technical Editor/Courseware Reviewer for PL/SQL documents
Oracle 11i J2EE Best Practices/ Database Tuning Guide
Whitepaper 10iAS Support and Implementation Guide
Ecommerce Implementation Guide (ORACLE Consulting)
SAP/Oracle Performance Baselining Whitepaper (ORACLE Consulting)