EXPERIENCE SUMMARY

• 11 years experience performing installations, configuring and testing Microsoft SQL Server 2000, 2005 and 2008 in a cluster.
• I worked in 24/7 Support environment performing configuration management for weekly SQL Script rollouts and running a world-wide SQL server replication with multiple hubs for over 75 SQL instances and more than 100 replication subscribers.
• Over 8 years using Oracle with Advanced CRM Applications like FrontRange ITSM, CRM and HEAT products.
• 7 years experience clustering SQL server and Exchange server with in-depth knowledge on patching, advanced networking configuration and disk configuration.
• 5 years experience with Powershell scripting and VB scripting working with SQL server and Windows Administration with Windows 2003 and Windows 7.
• 4 years experience in quality assurance/research and development using SQL and Oracle backend.
• Advanced SQL Tuning in Microsoft SQL Server 2008 and Oracle.
• 7 years experience with MSSQL 2000 in various capacities such as configuring, supporting and installing.
• Tested integration of FRS products using MSSQL Server with QuickBooks, Citrix, Exchange Server, and clustering Exchange server.
• QA engineer with a 'test to break' attitude, with an ability to take the point of view of the customer, a strong desire for quality, and astute attention to detail.
• Used both tact and diplomacy in maintaining a cooperative relationship with developers, and have successfully communicated with both technical developers and non-technical customers, management people.
• Deep understanding of the software development process and levels of database abstraction which has given an appreciation for the developers' point of view, and reduced the learning curve in automated test tool programming.
• Used judgment skills to assess high-risk areas of an application on which to focus testing efforts when time is limited.
• Worked with functional, interoperability, installer, alpha/beta, conformance, smoke, and load/stress testing.
• Expert web integration skills with Windows 2003 Server with IIS and SQL Server with over 4 years experience in web services.
• Set up and manage Microsoft Virtual PC 2004 and Microsoft Virtual Server 2005 to host SQL databases in VM environment.
• Set up and test multiple operating systems including all Windows, Unix and Linux.
• Excellent database skills with MSSQL Server 2000/2005/2008 and Oracle 10g and 11g.
• High level of expertise with all aspects of virtualization, simulation and emulation with both Windows and Palm OS systems.
• Excellent technical writer who has managed Microsoft Project and other Gantt chart project software and technical drawings including UML, state diagrams, topology diagrams and use cases with Visio.

TECHNICAL SKILLS

Windows Server 7, 2003 Server, Microsoft Virtual PC 2004, Microsoft Virtual Server 2005, Unix and Linux, MSSQL Server 2000/2005/2008, Oracle 10g, QuickBooks, Citrix, Exchange Server, Oracle Database configuration, Active Directory, Microsoft Project, Cisco IOS, NAT, TCP/IP, ARP/RARP, network cabling, PBX wiring, network design, IGRP, RIP, ACL, Switch configuration, VLAN and IGRP, HEAT, GoldMine, IPCC and ITSM, Oracle, Mercury and Segue, Crystal Reports, C , Visual Basic 6, C , and VB.NET, MS Office, Exchange Server 5.5, Internet Information Server, COBOL, JavaSript and VBScript.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Database Administrator and Manager

• Took charge of several database projects working with a team of 10 developers and managing 3 DBA's. Successfully used project management skills to help migrate databases and provide support and direction on upgrading DTS packages to SSIS.
• Installed Configured, Administrated 2005-2008 SQL Instances.
• I implemented Advanced Encryption using TDE and column encryption working with the legal team to produce a highly secure and private database. Researched laws and implemented high level design to produce a system that has security on multiple levels.
• Installed Configured, Administrated 2005-2008 and 2008 R2 SQL Instances and worked with junior DBAs to create a structured migration plan for SQL Server 2000 legacy DTS packages to SQL Server 2008 Integration Services.
• Supervised the work of 3 DBAs.
• Built and configured SSRS server on 2008 R2.
• Design and configuration of data warehouse using 2008 R2.
• Performance tuned memory and SQL statements.
• Advanced Backup and Recovery tools using Differential backups with Powershell.
• Administered SQL Server logins and Active Directory user groups using Powershell.
• Installed and configured Quest LiteSpeed.
• Completed a certificate while working full time in Oracle 11g Administration on RMAN backup and restore and performance tuning.

Confidential

SQL Server Database Administrator

• Installed Configured, Administrated 2000-2008 SQL Instances.
• Worked with Oracle 11g for performance tuning and RMAN backup and restore.
• Performance tuned memory and SQL statements.
• In charge of Release Management for weekly replication and scripts to over 100 production databases.
• SQL DBA for a large transactional replication system over 3 geographies: NAM, EMEA and ASIAPAC.
• Administered SQL Server logins and Active Directory user groups.
• Installed and configured Quest LiteSpeed developing stored procedures and developing stored procedures to integrate LiteSpeed into a reliable system. I successfully migrated the entire backup system from Embarcadero to Litespeed.
• Coded Powershell, Access and Excel VBA Scripting spreadsheets to ease administrative tasks.
• Worked with Microsoft Baseline Security Advisor API to implement a system to verify updates to SQL Server.
• Corrected cluster issues in a production environment. I helped to document the cluster system and implement disaster recovery plans to recover the system.

Confidential

SQL Support/Level 2 Messaging Engineer

• Used SQL Server on several Exchange specific product integration projects.
• Managing and configuring SQL Server 2000 and 2005.
• Working in Enterprise systems with 5 separate customer accounts.
• Worked with many backup technologies, spam filters, Linux bastions to filter email and white/black listing.
• Worked with Enterprise BES Server database taking charge of monitoring and configuring for end user satisfaction.
• Direct contact with end users helping them configure SQL Client and create public folders, distribution lists and other SQL tasks.
• Managed SQL changes on multiple systems
• Performed SQL Performance tuning to solve locking and blocking problems.
• Performed imports/exports of SQL data making changes to production databases and troubleshooting problems. Worked with Oracle and helped to monitor and configure replication.
• High level research for problems directly affecting end users both recommending and implementing fixes for many problems working with many HP SAN and network managing tools to monitor the network.

Confidential

SQL CRM Quality Assurance Software Engineer

• Worked with Oracle 8, 9 and 10 to perform installation on Enterprise CRM software. I performed basic indexing, backup and recovery and database setting to maximize efficiency of the software with the relational database.
• Primary QA tester for MSSQL database for GoldMine and GoldMine integration software tools.
• I worked with many IPCC products that integrated with GoldMine on MSSQL backend and n-tier database and tested those products on a regular basis.
• Used SQL Server on several SQL specific product integration projects.
• Exclusive control over testing and configuring SQL Server 2000 and 2003.
• Setup a cluster for configuring SQL Server 2000 and 2005, configured advanced options, and used the System Manager to setup Public Folders, viewed the SQL API to track event objects to troubleshoot issues, and setup multiple servers in multiple Active Directory child domains.
• Worked with many new products including HEAT, GoldMine, IPCC and ITSM running on MSSQL and Oracle.
• Examined API changes and document programmatic changes to our software.
• Perform advanced SQL and to a lesser degree Oracle configuration, testing and troubleshooting.
• Learning automated testing and configuration management with Mercury and Segue automated tools.
• Have a solid grasp of n-tier configuration setup and design.
• Wrote many test plans and took the lead in helping others develop plans that are fast, efficient and make the most use of QA time.

SQL Business Applications Analyst Confidential

• Setup a cluster for configuring SQL Server 2000 and 2005, configured advanced options, and used the Management Console to setup replication, viewed the replication API to track event objects to troubleshoot issues, and setup multiple servers in multiple Active Directory child domains.
• Performed installations of Oracle for use with CRM product named HEAT on Oracle 8 and 9.
• Exclusive control over testing and configuring SQL Server 2000 and 2005.
• Used SQL Server on several SQL specific product integration projects.
• Lead technician for Partners and Customers for the HEAT and GoldMine Application Programming Interface API for MSSQL Server.
• Received an Outstanding Performer of the Year in this position.
• Helped customers daily with ETL/import problems, Crystal Reports, SQL Server installation, configuration, and administration with SQL Server backend database.
• Fielded questions and helped resolve customer problems with programming issues in C , Visual Basic 6, C , and VB.NET.
• Worked on integrating Windows 2000 Reporting services on MSSQL Server 2005 for FrontRange customers utilizing Business Intelligence software.
• Studied and helped resolve issues with XML, DOM, and data-related customizations with SQL Server.
• Tested and reported software anomalies and helped customers to work around these issues.
• Worked on customer escalations as a day-to-day occurrence, helping to resolve show stopping issues.
• Built add-on programs to search databases and reverse engineer FrontRange products to work in place of existing solutions that were unavailable or not feasible for customers to implement.
• Worked with all types of data including time adjustments in software over different time zones in design, programming, reporting and supporting such functionality.

SQL Help Desk Technician/Junior Confidential

• Received an Outstanding Performer award for the year in this position.
• Delivered technical solutions over the phone to customers and partners, testing software and finding solutions for Goldmine 4.00.xxx through 5.50.xxx, and Heat 6.4.xxx for client-server configurations in dBase, MS-SQL Server 7.0 and 2000, API Support in Visual Basic.NET for GoldMine Plus Accounting, e-mail troubleshooting with Exchange server, GoldMine Everywhere Web, Internet Information Service, Word macros installation and configuration, Palm Pilot features, extensive use of Crystal Reports, ODBC database connections, and network configuration and support.
• Created ad hoc SQL queries, designed database tables, configured stored procedures, and configured the Borland database engine.
• Tested software configurations in Windows 9x through XP including Windows 2000 Professional and Server.

• Successfully resolved installation issues for database server software and client-server applications on a daily basis.

Confidential

Help Desk Engineer,

• Help desk engineer for Enterprise phone support for users on the Dow Chemical Global Network, for Compaq Corporation, administering an NT-Windows 2000/ IBM AIX/ VAX network.
• Worked with network connectivity, VPN tunneling, RAS configuration on IBM laptops, and MS Office.

Confidential

Student Project SQL Team Member

Student Project Field Experience

• Helped develop a project lifecycle for a major network upgrade and migration including the installation of SQL Server 2000 and Internet Information Server IIS .
• Produced technical documentation including a feasibility analysis, detailed design requirements, and a various implementation reports.
• Created Visio and Microsoft Office 2000 reports and analysis of network specifications.
• Installed and configured an NT Server 4.0 for use with the Dynamic Host Configuration Protocol DHCP .

Confidential

Network Coordinator

• Administrated the SQL database, taking charge of technical support for 1 main and 2 remote offices for the Motor Vehicle Department.
• Monitored an NT 4.0 network planning network upgrades, coordinating work with contractors, network cabling, email support, Excel Macros, and scripting and updating COBOL and web page code JavaSript and VBScript .

Confidential

Head Clerk

• Ten years' experience in a technical, accounting and managerial aspect at King Soopers grocery store.
• Network administration for store operations including LAN maintenance of IBM system for 6 years
• High volume customer service with a diverse clientele.
• Installed software and prepared various accounting reports using Microsoft Office.
• Supported scanners, scales, POS terminals, IBM printers, IBM 486 dual servers, and dot-matrix printers.