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