Description
Highly experienced SQL Server database administrator with experience leading teams.
Work Experience
| COMPANY | POSITION HELD | DATES WORKED |
|---|---|---|
| (Confidential) | (Confidential) | 4/2005 - Present |
| University Medical Center | (Confidential) | 9/2002 - 4/2005 |
| UPMC Health Plan | (Confidential) | 12/2000 - 8/2002 |
| Self-Employed | (Confidential) | 12/1999 - 12/2000 |
| Catholic Healthcare West | (Confidential) | 7/1999 - 12/1999 |
Education
| SCHOOL | MAJOR | YEAR | DEGREE |
|---|---|---|---|
| University of Phoenix | Computer Information Systems | 1997 | Master Degree |
| University of Arizona | Accounting and Finance | 1990 | Bachelor Degree |
Accomplishments
Highlights:
EDUCATION THE UNIVERSITY OF PHOENIX, Tucson, AZ Master of Science degree in Computer Information Systems, May 1997. Passed the Certified Public Accountant Examination, November 1991. THE UNIVERSITY OF ARIZONA, Tucson, AZ Bachelor of Science degree in Business Administration with majors in accounting and finance, May 1990. Activities: Member, National Association of Accountants CERTIFICATIONS Microsoft Certified Information Technology Professional (MCITP), Database Administrator 2008 Microsoft Certified Technology Specialist (MCTS), SQL Server 2008 Implementation and Maintenance Certified Public Accountant, Arizona 8013-E EXPERIENCE 2005-Present CONSULTANT, Tucson, AZ. Worked on a variety of projects and provided support including: ? Provided support for over 100 SQL Servers containing approximately 900 databases, half of which required 24x7 support. ? Automated many database administration activities, including performance counter alerts and jobs for a large SQL Server environment. ? Performed clustered server implementations and periodic failover for testing and reboots. ? Advised development groups on database architecture and T-SQL code optimization. ? Installed and maintained SQL Server 2005 databases. ? Used SQL Server Analysis Services, MS Visual FoxPro and MS Office automation to generate scorecard reports on an enterprise level. ? Developed a database application to look at statistical bed day utilization for hospitals and predict bed need. ? Developed technical specifications for a managed care application. 2002-2005 LEAD DATABASE ADMINISTRATOR, University Medical Center, Tucson, AZ. Responsible for managing the team accountable for the technical operations of all major clinical applications for a major research/teaching hospital. Areas managed are database administration, technical support, server performance/management, LAN/WAN network troubleshooting, report development, project management, interfaces into and out of managed systems and vendor relations. Also responsible for hardware specifications, planning and management of application upgrades, allocation of system and personnel resources and providing input into organizational information technology strategy. 2000-2002 DATABASE/SYSTEMS ADMINISTRATOR, University of Pittsburgh Medical Center Health Plan, Pittsburgh, PA. Responsible for the implementation and administration of the Health Plan�s Onyx Customer Relationship Management system used by the Sales, Marketing and Operations areas of the Health Plan. Responsibilities included SQL Server database administration, database design, ASP and JavaScript development, technical documentation, project management including management of external vendors and consultants, testing and implementation of system enhancements/modifications, management of system maintenance, management of system backup/disaster recovery planning and reporting to senior management on project and system status. 1999-2000 SYSTEMS CONSULTANT/PROJECT MANAGER, Tucson, AZ. Assisted small businesses in the selection, implementation, administration and maintenance of SQL Server-based accounting software packages. 1999 PROJECT MANAGER, Catholic Healthcare West. Project based position responsible for managing the implementation of several key systems including patient financial services, clinical, and enterprise resource planning systems (SAP). Project management responsibilities include managing a team of eight sub-project managers and coordinating the design/development, migration and training activities in a multi-hospital environment. 1997 � 1999 FINANCE/INFORMATION SYSTEMS DIRECTOR, CIGNA HealthCare of Arizona � Tucson, Tucson, AZ 1994 � 1997 MANAGER, DATA MANAGEMENT, Partners Health Plan/HealthPartners Health Plans, Tucson, AZ. 1992 � 1994 SENIOR INTERNAL/EDP AUDITOR, Magma Copper Company, San Manuel, AZ. 1990 � 1992 AUDIT MANAGER, General Accounting Office � Department of Administration, State of Arizona, Phoenix, AZ. SKILLS Database Administration � 10 years database administration experience with SQL Server 6.5, 7.0 and 2000. � Completed coursework on SQL Server 2005 MS Course 2936: Installing and Securing SQL Server 2005 MS Course 2937: Administering and Monitoring SQL Server 2005 � Experience writing reports with Seagate Crystal Reports (3+ years) and Cognos Impromptu. � Experience with SQL Server Data Transformation Services (DTS). � Experience with MDX queries. � Extensive experience developing stored procedures using SQL Server�s T-SQL language. � Physical database design and implementation. � Data conversion/migration. � Tuning and performance monitoring of production SQL Server systems. � Backup administration and disaster recovery. � Experience with SQL Lightspeed and IBM Tivoli SQL Server backup software. � Development of a Microsoft Access application to track prescription drug utilization and prescribing patterns within an HMO. Project Management � Managed implementation of SAP ERP system in hospital environment. � Managed implementation of a Patient Financial Services system in a hospital environment. � Managed the implementation of the Windows version of Onyx Customer Center CRM package and subsequent upgrade to the web version. � Managed the development/implementation of UPMC Health Plan�s Broker Portal system allowing registered brokers to enter prospect census information and receive customized group health insurance rate quotes over the Internet. � Managed several version upgrades of SQL Server databases. � Managed multiple system enhancement/upgrade projects. � Managed implementation of Cognos/Onyx DataMart, Impromptu and PowerPlay. Applications � Onyx Customer Center 5.0/5.01 CRM system � Onyx Employee Portal 3.0 � Seagate Crystal Reports � Cognos Impromptu � Microsoft Office (Excel, Access, Word, PowerPoint) � Microsoft Access Database and VBA Development � Microsoft Project � Microsoft Visual FoxPro � Microsoft Windows 2000/2003 Server � Microsoft Visual SourceSafe � Microsoft Internet Information Server (IIS)
Job Skills
Keywords
Responsibilities
Presently lead a database administration team responsible for over 100 SQL Servers running SQL Server 2000, 2005, 2008, and 2008 R2 containing approximately 875 databases.
