Provide production support and technical expertise for advanced SQL options and functions including query troubleshooting and tuning, index analysis, data compression, encryption, etc.

Use Agile/DevOps development & collaboration methods to improve integration, automation, testing, delivery and reliability of software releases and infrastructure changes with goal of no negative impacts with continual improvements

Maintain integrity of SQL Scripts, Cold Fusion scripts, and VB code and development using source control, best practices, and company procedures to ensures availability and reliability of applications

Assisted web developers and .NET developers in developing, testing and implementing integrated applications by writing complex SQL components and by providing technical support and expertise of all SQL Server components and processes

Developed and implemented ‘home-grown’ applications and solutions to resolve a variety of different needs using SQL Stored Procedures, VB.Net, Active-X, XML\XSL, Reporting Services, and .NET Applications for SQL 2000 and Yukon

Responsible for and performed all security updates and service packs for servers and applications in addition developed and improved security controls for SQL Servers including Business Continuity and Security Audits

Maintained the integrity and security of development SQL code from Alpha code through release-to-production

Performed all aspects of SQL Server code management by following standard Software Development Cycle best practices

Responsible for the development, implementation, ETL, reporting, and maintenance of SQL Server 2000/2005 BI, Data Warehouse and Reporting Solution using SSAS, SSIS, and OLAP reporting tools such as ProClarity, Crystal Reports and SSRS. This solution was used for overall business analysis, upper management decision making, and executive financial reporting

Responsible for managing the technical performance and assigning workload of two junior level SQL Server DBAs

Modeled, Architected, Designed, and Implemented SQL Servers and databases of various sizes and specifications to meet performance and design requirements

Developed and implemented applications and solutions to resolve a variety of different needs using SQL Server Stored Procedures, VB.Net, Active-X, XML\XSL, Reporting Services, and .NET Applications for SQL 2000/2005 Data Transformations and MySQL from native data various systems and formats including Lotus Notes, Oracle, Linux, and AS400

Responsible for and performed all security updates and service packs for servers and applications in addition developed and improved security controls for SQL Servers including Business Continuity and Security Audits

Responsible for compliance with Sarbanes-Oxley audit requirements for all SQL Server related systems and data

Responsible for data integrity and reliability for Great Plains Accounting System and Human Resource Management System

Performed as Senior Database Administrator with full responsibility over all SQL Server 7.0/2000 and Oracle 8i databases. Responsible for all operational/production and development database issues including: Creation, Performance, Tuning, Maintenance, Troubleshooting, Backup/Recovery, Sizing, Replication, Scalability, Modeling, Migration, and Security

Wrote and implemented SQL Server and Oracle stored procedures, triggers, functions, plans, DTS scripts etc. using T/SQL, PL/SQL, VB/Java script. Develops database applications for new and existing tasks to meet user needs. Provides technical assistance to and collaborates with staff and program managers to ensure system usability and compatibility for all ongoing database development. Coordinates, directs, and oversees development of outsourced databases and database applications

Responsible for extraction, loading, scrubbing/transformation, verification, and querying of data from various sources and formats

Served as Project Manager/Director for all DHR IT initiatives. Designs, develops, and directs complex new projects or completes extensive modifications or enhancements to existing projects and services by providing direction and leadership to staff, partners, and contractors

Functioned as Agency Information Officer and the Agency Information Security Officer. Serves as agency liaison to the Commonwealth of Virginia Secretary of Technology. Serves on the Virginia Council of Technology Services Enterprise Architecture Workgroup and the Organizational Workgroup to develop statewide IT policies and guidelines

Directed, planned, designed, manages, and maintains all aspects of the DHR IT/Network System and Database Systems. Ensures agency business technology and systems are adequate for 24/7 agency business operations and compatible with upcoming B2B transactions and emerging technologies. Responsible for the development, performance, security, procurement, and maintenance of all IT system hardware and software