Sql Server Engineer
Resume:
Bryant Griffith
Folsom, CA *****
abl3il@r.postjobfree.com
OBJECTIVE:
DATABASE/ DATA MANAGEMENT SUPPORT
QUALIFICATIONS
. Microsoft Certified Professional (MCP)
. Microsoft Certified Systems Engineer (MCSE)
. Microsoft Certified Database Administrator (MCDBA)
COMPUTER COMPENTENCY
. SQL Server 2005
. T-TSQL
. MS Excel (VBA)
. MS Access (VBA)
. Window 95/98/XP/Vista
. Windows 2000 Server
. PHP/HTML
. Statistics
. ODBC Connections
. UNIX familiarity
. MS Word
. UNIX familiarity
SUMMARY OF QUALIFICATIONS
Technical skills to implement a database solution with Microsoft SQL server
client/server database management system. Ability to create database
applications, write stored procedures and triggers and retrieve using
Transact-SQL. Able to write a SQL statement. Restrict and sort data,
display data from multiple tables, aggregate data using group functions,
write sub-queries, produce readable output with SQL, create and manage
tables, manipulate table data, maintain relational integrity using database
constraints, create and maintain other database objects and control user
access.
5+ years experience with Relational Databases. Knowledge of principles and
methodology of designing and normalizing relational databases.
Administration and management of Relational Database Management Systems
(RDBMS).
Installation of SQL Server 2005 and SQL Server 2008, having three plus
years experience
Utilization of Data Transformation Services (DTS). Familiar with SQL Server
enterprise reporting solution (Reporting Services) and SQL Server 2005
Business Intelligence. Experienced in establishing database normalization
and creating schemas. Trained in Analysis Services including Dimensional
Model, Data Warehousing (OLAP) and Data Mining
Implementation, administration, and troubleshooting information systems
that incorporate Microsoft Skills and knowledge to install, configure, use,
and support Transmission Control Protocol/Internet Protocol (TCP/IP) on
Microsoft Windows NT operating systems.
Installation and configuration, resource management connectivity,
monitoring and optimization in enterprise-computing environment. Knowledge
and skills to perform post installation and day-to-day administration tasks
in a single domain and multiple domain network.
Qualified to install, administrate, and integrate Unix/Linux operating
systems to support a mixed operating system environment.
WORK EXPERIENCE
05/2010 - 07/2010 Tenderloin Housing Clinic San Francisco, CA
SQL Programmer on MS SQL 2000 & SQL 2008
. Database technical support
. Prepare stored procedure to solve accounting issues
. Part of Migration to SQL 2008 team
10/2009 - 04/2010 ClinOps San Francisco, CA
SQL Programmer on MS SQL 2005
. Data validation for pharmaceutical client
. Clean data to present to FDA
. Worked with data dictionary to resolve edit checks
. Automate MS Excel tracking sheet for project managers
08/2008 - 09/2009 Stantec Rancho Cordova, CA
Database Administrator
. Automation of reporting process
. Develop Views, Triggers and Stored Procedures to
facilitate data import process
. Create and implemented database design solutions in
collaboration with programming team
. Write processes to analyze databases with greater
than 7000 records
. Generated update automation for database
. Used data dictionary to help resolve program
development process
. maintenance of database entities
. edit internal website using PHP to add flat files to
SQL Database
. Wrote macros for MS Excel to automate spreadsheet
process
. Edit MS Access database using query updates and VBA
09/2004 - 07/2007 Brown and Caldwell Rancho Cordova, CA
DBA Analyst
. Data validation (laboratory data)
. Retrieved, updated, append results from SQL server
via T-SQL
. Worked with statistician using MS Excel (formulas,
macros, VBA)
. Statistical Charts
01/2003 - 09/2004 Tramco Folsom, CA
Technical Support/DBA Assistant
. Migration from one database to another
. Ran queries on SQL 2000 server for special request
reports for clients
. Ran update statements
. Generated scheduled backup for client database
. Worked closely with senior DBA
. Properly format submitted data from client
. Worked within a Windows/Linux environment
01/2002 - 01/2003 Earthlink Roseville, CA
Technical Support
. Troubleshoot all Internet connections, email problems
via mail server settings, dial-up configurations, DSL
configuration and Cable connection, replacing corrupt
files, uninstalling and reinstalling communications
and hacking the registry
. Troubleshoot browsing issues with use of ping,
tracert, route print, ipconfig and other utilities
. Provide support for most Apple Computers
12/1997 - 04/2001 Federal Government McClellan AFB, CA
Computer POC / Environmental Program Specialist - GS-12-7
. Provided computer user support (Excel, Access, LAN)
. Designed database to track analytical request and
cost
. Normalized existing database - team effort
. Developed basic SQL queries for repetitive request
. Enhanced database using Visual Basic
. Developed weekly reports based on database input
. Coordinated weekly activity with superiors
. Tracked hazardous waste contracts via Access database
. Tracked analytical request for hazardous waste
analysis via Access database
. Incorporated workstation into existing LAN (shares,
IP address, subnet mask)
. Worked closely with Database Administrator on various
projects
09/1991 - 12/1997 Federal Government McClellan AFB, CA
Chemist / Laboratory Manager - GS-12-1
. Computerized the laboratory
. Statistically tracked quality control
. Designed dBase database for sample log
. Established new certification for laboratory - EPA
Method 502.2
. Ran all analytical equipment; all software driven
. Responsible for troubleshooting and maintenance of
all equipment
09/1986 - 09/1991 Federal Government McClellan AFB, CA
Chemist / Hazardous Waste - GS-7 - GS-11
. Tracked QC via macro driven spreadsheets
. Used analytical equipment to quantitate hazardous
content of various samples
EDUCATION
University of Maryland, College Park, MD Bachelor of
Science in Chemistry
MTI College of Business & Technology, Sacramento, CA Microsoft
Systems Engineer Diploma
American River College, Sacramento, CA Computer
Science & Mathematics
Contact this candidate