I am a Microsoft MCSA in SQL Server helping organizations with their data needs. I have 10 years of experience as a DBA and can assist with architecture, migration, design, or performance issues in the database. I also own a license of the Embarcadero’s Data Architect tool.
Regional Mentor, PASS, Mid-Atlantic Region
April 2014 – Present
June 2011 – Present Richmond, Virginia Area
Assist organizations with their SQL Server needs in the areas of analysis, architecture, configuration, design, development, integration, implementation, reporting, migration, and support. Provide health assessments of a database with coaching and guidance on how to make improvements.
Managed the upgrade process of 50 instances and several hundred databases to SQL 2012 for a legal firm with SSRS and SSIS components.
Database Modeling for startups or custom developed apps in an organization. Scripting of database objects approved in the model. Review of database design to ensure optimal performance. Surprising the number of foreign keys I don’t find in tables with lots of data that are commonly joined
Implemented High Availability Cluster for insurance aggregator to assist with DR and provide reporting relief of the transactional system. Architected with the data warehouse team the environment to run the ETL process and loading of data into the warehouse.
Assisted law firm in eliminating deadlocks in the system and reviewed index and statistics strategy. Provided guidance in creating backup and disaster recovery strategy for database.
Created ETL process for law firm to extract IIS log data and publish to SharePoint list for reporting and reconciliation purposes. Trained new staff on environment and best practices.
Technical Lead, McGuireWoods LLP
Partnership; 1001-5000 employees; Law Practice industry
August 2009 – Present (3 years 1 month) Richmond, VA
Led the technical components of the Elite (legal financial software) application upgrade with implementation of multi currency functionality and the import of foreign office data. Responsible for migrating and/or upgrading applications dependent on financial data in conjunction with financial system upgrade. Created appropriate test environments, worked with users and vendors to create test cases in Quality Center, created migration scripts, coordinated roll out schedule and acted as liaison for the technical team of 10 people to the project leadership team and management. Implemented and coordinated implementation of changes over conversion weekend. Systems affected included workflow applications, internal web applications, BI and reporting applications, and data manipulation (SSIS) packages. Applications were delivered on time with no major defects.
Asked to lead the enhancement effort of the NBI (New Business Intake) system, an advanced workflow application for client conflict checks and creation of new matters in billing system after project was behind schedule and project sponsor was frustrated with prior team. Responsible for processing internal documentation, gathering requirements, communicating with vendor, coordinating testing, and communicating project dates to business. Delivered all requested functionality on time and within budget, which earned high marks from business sponsor. Relationship with our vendor was improved with better requirements gathering and defect reporting. Function as the subject matter expert for technical aspects of the application.
Daily responsibilities include monitoring of daily processes, coordinating the implementation of new software development and enhancement efforts, such as a document management system and data warehouse.
Database Administrator, Health Risk Partners (Now Verisick Health)
Public Company; 51-200 employees; Hospital & Health Care industry
June 2009 – August 2009 (3 months) Richmond, Virginia Area
Provided SQL Server support in rewriting stored procedures and SSIS packages for efficiency. Assisted with creating disaster recovery environment in Atlanta. Lead several small training sessions for other data analysts to learn SQL syntax.
Database Administrator, Capital One
Public Company; 10,001+ employees; COF; Financial Services industry
December 2008 – August 2009 (9 months) Richmond, Virginia Area
Assigned to Rapid Cycle Development team as a database administrator responsible for gathering data requirements from end users, creating detailed ERD diagrams and submitting them to standards committee for review and approval in very fast cycles of usually less than two weeks. Responsible for creating databases, administering security, capacity planning, and documenting all work. Migrated data from spreadsheets or Access databases to secure applications with a web front end, SQL Server backend environment. Successfully worked with offshore application team in application development. Frequently tested front end applications before turning them over to user acceptance testing.
Database Administrator, LandAmerica
March 2008 – November 2008 (9 months) Richmond, Virginia Area
Worked on application support team with both application support and database support assignments. Supported Oracle DBA with claims system that included Oracle grid server, Oracle Application Server, and 10g database; provided input on ERP system. Upgraded SQL databases that included user repository and merge/snapshot replication from 2000 to 2005. Implemented database mirroring technology for high availability applications. Supported SharePoint 2007 environment and configured web applications for use tracking. Configured applications at IIS, web config files, and database level; Requested SSL certificates. Supported a variety SSIS ETL jobs for finance and real estate transactions; Reviewed code with development team and write new functionality into packages.
Lead SQL Server DBA, Virginia Information Technologies Agency
Government Agency; 1001-5000 employees; Government Administration industry
July 2005 – March 2008 (2 years 9 months) Richmond, Virginia Area
Directed the SQL server environment and cross trained with the Oracle DBA to ensure adequate coverage to the organization. Provided SQL database support in active/passive clustered environment; set up high availability and data recovery, frequently tests recovery strategy. Supported SSIS packages that import and manipulate data during nightly batches; ensure data security during data import; manipulate packages created by developers. Served as technical lead for several opportunities including upgrading to Oracle 10g with GRID technology, Oracle ERP system, and implementing SharePoint 2003 farm with over 1,000 users. Led the SharePoint training and promoted teamsites, which later became the tool for VITA and NG communication.
System Administrator, IndigeTech (Now CXI)
Privately Held; 11-50 employees; Information Technology and Services industry
2002 – 2005 (3 years) Richmond, Virginia Area
Administered Active Directory Windows network; Monitored security with Cisco firewall, Helped ensure virus free workstations with Symantec Antivirus, Established VPN for external access to local resources, IIS. Provided DBA and data warehouse support for internal applications by ensuring availability and recovery; created basic DTS packages for internal apps; created basic stored procedures for time entry application. Installed and administered SharePoint 2003 in single server environment. Performed system integration at client site of Viador Portal technology. Developed and implemented IT policies and procedures; Reviewed with management to determine best way to implement security while not prohibiting users; created workstation standards; created test and production environments. Created test environments for new products for potential client engagements including Viador portal, Jrun, Lotus Notes, IBM Websphere, Oracle Portal