Sql Server Engineer

Gene B. Torres

EXPERIENCE SUMMARY

. ** years experience performing daily work installing, configuring and

testing Microsoft SQL Server. I have 3 formal years as a DBA with

Microsoft SQL and 1 year using Oracle RDBMS as a DBA.

. 4 years experience in quality assurance/research and development using

SQL backend.

. 6 years experience with GoldMine, CRM Softwareon MSSQL 2000 and 2005.

. 4 years experience with HEAT and 2 years ITSM CRM FrontRange products

using Oracle and MSSQL.

. 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.

. 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.

EDUCATION

Regis University, Colorado Springs

Currently Enrolled and Seeking Masters in Computer Science Database

Technologies with Oracle 10g. I completed a Certificate in Oracle Database

Administration with Oracle.

Colorado Technical University, Colorado Springs

Master's Degree, Computer Science Software Engineering

University of Southern Colorado

Bachelors of Science in Computer Information Systems, Minor in

Business Administration

CERTIFICATIONS

Certificate in Oracle Database Administration with Oracle

Certified in both GoldMine and HEAT.

Certified with the Help Desk Institute.

TECHNICAL SKILLS

Windows 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

Premiere Global Services, Colorado Springs, CO 6/2007-

Present

SQL Server Database Administrator

. Installed Configured, Administrated 2000-2008 SQL Instances.

. 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.

Analysts International, Colorado Springs, CO 12/2006 - 5/2007

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 dat 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.

FRONTRANGE SOLUTIONS, Pleasanton, CA 10/2000 - 12/2006

SQL CRM Quality Assurance Software Engineer (08/2004-12/2006)

. 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 for GoldMine CRM, Colorado Springs, CO

(03/2002 - 08/2004)

. Used SQL Server on several SQL specific product integration projects.

. Exclusive control over testing and configuring SQL Server 2000 and

2005.

. 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.

. 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 SQL DBA (10/2000 - 03/2002)

. 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.

TAC STAFFING, Colorado Springs, CO 6/2000 - 8/2000

Help Desk Engineer, Contract

. 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.

LAKE PUEBLO STATE PARK, Pueblo, CO 1/2000 - 4/2000

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).

EL PASO COUNTY CLERK & RECORDER'S OFFICE, Colorado Springs, CO 5/1999

- 11/1999

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).

KING SOOPERS, Pueblo, CO 12/1987 - 5/1998

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.

TECHNICAL TRAINING

Regis University, Colorado Springs- completed a Certificate in Oracle

Database Administration with Oracle. I am working towards a Master of

Science in Database Technologies. I have completed masters level

coursework in database architecture, concepts, database administration and

performance tuning.

Colorado Technical University, Colorado Springs - Masters in Computer

Science, Software Engineering. I have also earned a Certificate in Systems

Engineering. Graduate work is focusing on database innovations like

Business Intelligence software, international collaboration, information

systems security, and programming for secure rich-data solutions in XML

with the .NET platform. Classes covering CMM, software architecture,

computer security, design, testing, requirements gathering, project

management, computer architecture, advanced networking, systems

engineering, and process engineering.

University of Southern Colorado - Bachelor of Science in Computer

Information Systems. Emphasis was in network administration and C++/Visual

Basic programming, focusing on the administration of Windows NT, Netware,

and UNIX systems.

7/2001, 4/2001, 10/1999

Pikes Peak Community College, Cisco Network Academy, semesters 3 of 4

completed,

Learned router configuration, static and dynamic routing commands, CLI

operability, IP routing for packet, circuit, and switch based networks.

Hands on training configuring multiple routers, troubleshooting

connectivity. Learned configuration of ACL, switch configuration,

configuring Novell internetworks, in-depth network troubleshooting

techniques, and helped design an internetwork topology using multiple

protocols in a WAN environment.

Contact this candidate