Sql Server Developer
Resume:
James B. Dinkins, MCDBA.
Little Rock, AR 72216
501-***-**** (home)
501-***-**** (cell)
Professional Summary
Seasoned professional with 18 years of experience straddling the divide between
developing SQL Server back-end databases and programming front-end applications;
over 10 years of experience as a SQL Server DBA maintaining SQL Server 2000, 2005
and 2008 databases and trouble-shooting data access issues involving authentication,
delegation, and network connectivity. Highly motivated and self -directed learner with
excellent communication skills and a background in technical writing and experience
teaching logic and critical thinking to college students.
Technical Summary
Experience writing VBA for Word, Excel, and Outlook, programming applications using
Access VBA and DAO against SQL Server 2000 linked tables, VB 6 with ADO against
SQL Server 2005 stored procedures, and most recently, VB.Net and ASP.Net (Visual
Studio 2010) against SQL Server 2008. Currently preparing for SQL Server 2012
Developer (MCSA) certification. Experience backing up, restoring, tuning, and
maintaining SQL Server 2000, 2005, and 2008 databases in conventional and virtualized
environments. Experience installing and configuring the databases for SharePoint Server
2010 and SQL Server Reporting Servers in both the SharePoint integrated and stand-
alone configurations.
Professional Experience
Acxiom Corporation
February 2013 to August 2013
Senior Database Developer
• Developed a database to support a Web Application for internal use by Acxiom to
enable its Unit Managers to indicate the percentage of time their respective unit
members spent on activities that might qualify for a Research and Development
Tax Credit. The project specifications dictated that the application be as
configurable as possible to permit its annual reuse without rewriting: it should be
a virtual blank slate. This in turn dictated that many features one would normally
consider to be part of the fixed application design (control object choices and
page layouts) should instead be treated as configurable templates and stored in the
backend to be invoked by stored procedure calls and rendered by the browser at
run time. Consequently, the bulk of the application logic was implemented in the
database as two distinct stored procedure layers; a lower “data access” layer
handling basic CRUD operations and making simple functions calls to monitor
application and session state; and a higher “business logic” layer containing
business rules and flow control code, and making calls to the lower level
procedures in order to assemble the final output for the browser. All SQL code
was confined to the lower layer. The UI took user input, made calls to the higher,
business-logic layer’s stored procedures, and rendered the database output.
Arkansas Economic Development Commission
August 2002 to January 2013
Database Administrator and Senior Programmer/Analyst
Interviewed Agency employees in the different Divisions to determine departmental
application development needs; developed separate Access front-ends using VBA
and SQL Server and a variety of data access methods from DAO and linked tables
to ADO and SQL Server Stored Procedures; developed MS SharePoint Web
Applications of both the “pure” and “hybrid” types using SharePoint Access
Services and SharePoint List data as well as linked SQL server tables; trouble-
shot application related networking issues; maintained, monitored, and modified
application performance and security.
Imported data into SQL Server from a variety of ODBC-accessible data sources using
DTS and SSIS; developed custom string parsing routines to strip data out of a
variety of text file formats.
Developed back-end databases to support front-end applications; created indexes and
tuned queries for performance optimization; configured and maintained SQL
Server instances in both conventional and virtualized environments; used Veeam
Backup in conjunction with an ExaGrid appliance to implement backup and
disaster recovery; implemented Agency reporting objectives using SSRS.
Worked with the GIS specialist to install and configure ESRI’s ARCGIS application
server against SQL Server 2005; developed a routine to parse agency address data
against the schema of the Arkansas Centerline Project in order to improve
Geocoding results.
ProTexn, Inc., Dallas, TX
May 2000 to May 2001
Application Developer
Worked with the ownership of an Insurance agency (a former CPA) to develop an
Access application to support day to day business operations and produce
standard accounting information and financial reports.
Custom MicroSystems, Little Rock, AR
August 1999 to May 2000
Desktop Application Developer
Hired as an apprentice programmer while learning SQL and VBA.
Developed applications in Access with VBA and inline SQL usually against JET, but
occasionally against SQL Server.
Independent Contractor, Little Rock, AR
December 1997 to August 2000
Desktop Application Developer
Developed simple desktop applications in Access with the User Interface and VBA
wizards for a series of companies spun off from Gameday Apparel, Inc.
Gameday Apparel, Inc. Little Rock, AR
August 1996 to November 1997
Inventory Manager
Responsible for managing inventory for a clothing manufacturer and distributor.
Developed MS Excel spreadsheets to assist in inventory management and record
keeping.
University of Arkansas at Little Rock
August 1991 to May 1993
Instructor, Dept. of Philosophy and Religious Studies
Taught sections of The Introduction to Philosophy as well as sections of Critical
Thinking to undergraduates and co-taught several courses for the Donaghey
Scholars Program.
Certification/Training
MCDBA (SQL Server 2000) July 2002
Education
BA, English, Ohio Northern University, Ada, OH, 1986.
30+ Undergraduate Hours in Algebra, Trigonometry, Analytic Geometry, Calculus and
Differential Equations.
30+ Graduate Hours in Technical and Expository Writing, University of Arkansas at
Little Rock, 1988-1989.
Contact this candidate