TECHNICAL SKILLS:

• Procs, Functions, Dynamic SQL, Triggers, CTEs/Windowing, etc.
• OLTP Tuning, Monitoring, Optimization, Capacity Planning, Partitioning
• BI - Analytics, Power BI, Tableau, Visualization
• OLAP, Star Schema, Facts-Dimensions, Measures, PowerPivot, PowerQuery
• Database Modeling, Deployment, Capacity Planning, Implementation, Reverse Engineering
• Architecture & Design, Standards, Requirements, Strategic Decisions, Operations, Automation, Baselining
• Database Monitoring, Security, Best Practices, Assessments, Features
• PowerShell, R, Python, XML, XSLT, XQuery, XPath, DAX, MDX, LINQ, Expressions
• Backup/Recovery, High-Availability, Change/Configuration Management
• Oracle, NoSQL, PostgreSQL, Hadoop, MySQL, Excel, Access, Dynamics, Sybase
• .NET, VB/Java Script, JSON, JQuery, HTML5, CSS
• SDLC, SaaS, Web Services, Cold Fusion
• Windows & SQL Azure, Linux (Red Hat), Active Directory, Kerberos (SPN), Domain Administration
• TFS, VSTS, SalesForce, Rally, Documentation, Quality Assurance, Jenkins, Docker
• DevOps, Tier-2 Support, Triage, 24x7 On-Call, Customer Service, Testing
• Director, Team Lead, Project Management, Business Liaison
• Financial Applications
• Healthcare Applications
• Warehouse/Logistics Applications
• Mentoring, Tutoring, Subject Matter Expert, Trustworthy, Dependabl

PROFESSIONAL EXPERIENCE:

Database BI Developer (SSRS & SSIS)

Confidential

Responsibilities:

• Develops prototype data views and reports of financial data and work with business users and SMEs to refine requirements
• Create, maintain, and support complex reports, dashboards with multipart formulas, stored procedures, custom tables and customized functions utilizing SSRS, SharePoint, Excel Power Tools and other BI tools to visualize the data
• Creates, modifies, and enhances SQL 2012 SSIS packages used to import call center data into staging and production systems
• Act as key point of contact for data requests to produce data analytics key to driving business intelligence insight
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
• Test and evaluate business rules, master data services and ETL and reconcile any differences from expected results

Sr Application Developer Support

Confidential

Responsibilities:

• Implement DevOps Best Practices for Software Deployment, Continuous Integration/Automation, Application Stability/Reliability, and Business Continuity ensuring Maximum Production Systems Uptime
• Provided advanced database query troubleshooting and performance tuning for SQL 2012 applications
• Monitor, report, troubleshoot, and resolve application performance issues for multiple Applications and Services
• Provided application support and new documentation, ERDs & process workflow diagrams around data transfer, file transfer, logins, compliance (permissions, security settings), application deployments, application layer ETL and system development
• Developed PowerShell scripts to automate and simplify status reporting of SQL Agent and Task Schedule Jobs w/ color coding

SQL Server Dev/DBA & .Net (Web)

Confidential

Responsibilities:

• Tutor adults and college students in TSQL and SQL Administration
• Provide services including Website/Report enhancements, updates, and modifications for individuals and non-profits
• On-line/Telecommute technical support, troubleshooting, query performance tuning, backup-recovery, training, reverse engineering
• 9-month sabbatical to Richmond, VA (EOL preparation assistance & handicap accessibility for very elderly parents)
• Returned to Atlanta, GA beginning of October, 2016

Senior SQL Server Developer/DevOps

Confidential

Responsibilities:

• Provide advanced/complex database development including stored procedures, triggers, functions, dynamic T-SQL, views, and ad-hoc queries for SQL 2016 & 2008R2 … including new features Windowing Functions, CTEs, etc
• Provide production support and technical expertise requiring advanced SQL understanding & experience for query troubleshooting, performance 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
• Occasional BA/PM role gathering/clarifying requirements, objectives, and goals from key stake holders, SMEs, upper management
• Mentor, train, and provide assistance to new team members as required
• Provide report development, processing, dashboards and analytical presentation using SSRS, Crystal Reports, VB, Power BI, others

Senior SQL Server DBA/Developer

Confidential

Responsibilities:

• Provide expert level database administration, modeling, and development for SQL 2012 & 2008R2 environments
• Provide support and technical expertise for advanced SQL options including failover cluster, replication, database mirroring, AlwaysOn Availability Groups, log shipping, table & index partitioning, data compression, snapshots, encryption, filestream, etc.
• Plan, develop and implement architecture, processes, baselines, best practices, and procedures to ensures availability and reliability of SQL instances and applications
• Plan, develop and implement automation of monitoring and alerts via T-SQL & PowerShell scripts and SQL Agent
• Provide security audit, security findings report, and security strengthening of SQL environments
• Provide 24/7 on-call readiness as necessary
• Perform capacity planning, re-design, server consolidation, virtualization, high availability, disaster recovery, service packs, and version upgrades
• Provide SQL performance audit and recommendations based on detailed analysis. Perform effective query/stored procedure performance tuning
• Provide SQL Server licensing audit and recommendations
• Mentor, train, and provide customized hands-on tutoring and presentations of advanced SQL DBA/Development theories, principals, technologies, and skills
• Write and troubleshoot complex stored procedures, triggers, functions, dynamic T-SQL, views, and ad-hoc queries to meet specific business requirements
• Integrate and migrate data from other RDBMS (including Oracle, DB2, MySQL, Sybase, Access, etc.) using SSIS, OpenQuery, OpenDataSource, Linked Servers and other methods
• Provide report development and presentation using SSRS, Cognos, Crystal Reports, Proclarity and other tools
• Gather and clarify requirements, objectives, and goals from staff, management, and owners. Create design documents/diagrams, data models, functional requirements, prototypes, and test cases

Lead SQL Server DBA/Developer

Confidential

Responsibilities:

• Responsible for senior level database administration and high availability of production SQL 2012 & 2008R2 Servers
• Responsible for SQL security, capacity planning, server consolidation, and disaster recovery
• Responsible for backup and recovery model, service pack and patches, performance baseline, and overall SQL Server health
• Planned and Implemented upgrades/migrations of SQL versions from 2005 to 2008R2 and from 2008 to 2012
• Developed, maintained, and deployed complex SSIS packages for SQL 2008 R2 and 2012 (project deployment model)
• Wrote complex SSIS packages for large multi-step ETL processes utilizing multiple connection types, error handling, alerts, etc.
• Monitored and maintained SQL Server 2008 failover cluster (on Windows 2008 Clustering Service)
• Implemented best practices for database administration in virtual environment (VMware) and non-virtual environments
• Developed detailed complex SSRS solutions to support internal processes
• Developed tabular model SSAS data warehouse for processing and analysis of internal data
• Wrote SQL Server ETL processes for migration of data from multiple data sources
• Trained junior staff in SQL best practices
• Wrote complex T-SQL stored procedures, triggers, functions, and complex queries
• Maintain and monitor SQL Server systems using email alerts and key performance indicators

Senior SQL Server DBA/Developer

Confidential

Responsibilities:

• Responsible for development and administration of PROD, TEST, & DEV SQL 2005 & 2008R2 Servers in hosted virtual environment
• Participates in all phases of the software development and maintenance life cycle including code reviews and requirements gathering
• Wrote SQL Server ETL application for migration of warehouse inventory and setup data from Oracle to SQL Server
• Developed SSIS for complex ETL processes as necessary and feasible
• Lead Developer on several production software builds
• As Senior SQL DBA maintained best practices for SQL environment including baseline monitoring and business continuity
• Responsible for managing production software releases through all phases including testing and promotion
• Rotating 24x7 On-Call support of core application and database
• Developed senior level complex T-SQL stored procedures, triggers, functions, and complex queries for extraction, evaluation, scrubbing, transformation, reporting, and analysis of food industry warehouse data from Oracle to SQL Server
• Maintain and monitor SQL Server systems using email alerts and key performance indicators
• Developed SSRS application for tracking SQL performance and data statistics, KPIs and progress towards company goals

Sr. 2 SQL Server DBA/Developer

Confidential

Responsibilities:

• Senior DBA/Developer responsible for all corporate SQL Servers (local and remote)
• Developed complex SSIS packages and ETL processes to perform remote data collection from many different, sources, platforms and data types. Evaluate data for consistency, accuracy, and completeness to eliminate duplicate or missing data and ensure reliability
• Responsible for SSIS deployment across DEV and PROD environments
• Most of SSIS development work was done using configuration files paradigm for scalability and portability
• Functioned as technical lead in planning, modeling, design and implementation of corporate SQL environment, including hardware requirements, configurations and security
• Wrote complex SQL Server 2000 and SQL 2005 stored procedures, triggers, functions, and complex queries for extraction, evaluation, scrubbing, transformation, reporting, and analysis of financial data from various internal and external sources and formats
• Assisted in development, implementation, productivity, and documentation of SQL Server components for end-user BI dashboards and status reports, and production reports
• Planned and implemented best practices for optimal performance, tuning, optimization, troubleshooting, and availability of local and remote SQL Server systems
• Worked with LAN/WAN and Domain administrators to evaluate and resolve remote connectivity and performance issues and maintain security updates and service packs of servers
• Provided detailed documentation of physical environment, ERD and data models, logical processes, and methodologies for all SQL Servers as peer-user documentation and ensure business continuity in disaster recovery scenarios
• Proactively maintained and monitored internal and remote SQL Server systems. Set up email alerts and key performance indicators
• 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

IT/SQL Consultant - CEO

Confidential

Responsibilities:

• Own and operate all aspects of upstart IT consulting firm
• Primary responsibility to perform competent work to the complete satisfaction of existing clients
• Other roles include new client sales. Provide technical specifications of job, and negotiating job contracts that benefit clients
• Performed installation, configuration, and maintenance of all hardware, software, network, and communication components for computer systems ranging from personal desktops to Client/Server LAN/WAN based networks using Windows Server OS, Exchange Server, Microsoft BackOffice, SQL Server, SharePoint, and SMS
• Troubleshot, torn apart, and repaired hundreds of PCs and Servers for issues ranging from motherboard replacement, new memory or other cards, incompatible drivers, etc.
• Designed and/or developed, user-friendly customized, relational database applications for small businesses, churches, dentist offices, and other organizations (clients) using SQL Server 2000, MS Access, and/or Visual Basic. The specific application components vary depending on client needs but most all include customized data entry forms, data analysis queries, and summary reports
• Developed web sites and web pages for clients. Help identify and setup available hosting packages for clients
• Installation and optimization of productivity, networking, and communication software and services

SQL Server Developer-DBA

Confidential

Responsibilities:

• Wrote complex SQL Server 2000 and SQL Server 2005 stored procedures, triggers, functions, and complex queries
• 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
• Modified existing SQL code to improve speed and overall performance of the Confidential application
• Administered performance, tuning, troubleshooting, and availability of internal SQL Server systems on Windows 2000 & 2003
• 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
• Maintained and monitored internal SQL Servers. Set up email alerts and key performance indicators

Senior SQL Server DBA

Confidential

Responsibilities:

• Functioned as Senior SQL Server DBA responsible for maintaining several high availability production SQL Server 7.0/2000/2005 Applications in highly secure distributed LAN and WAN environments
• Managed Enterprise operational database infrastructure for all internal database systems based on SQL Server and Analysis Services
• Worked extensively with DTS and SSIS to extract, transform, and load data from various heterogeneous sources including HTML, XML, Oracle, Lotus Domino, SQL, AS400, Flat Files, Access, Excel, etc.
• 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
• Wrote complex stored procedures, complex queries fact tables, data marts, cubes, dimensions, etc against SQL Server and Analysis Services to provide data to meet user BI and Reporting needs
• Developed and maintained financial data portal accessible via Intranet using SharePoint 2003 technologies and IIS
• 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
• Administered all aspects of performance, tuning, troubleshooting, and availability of both clustered and un-clustered SQL Server 2000/2005 environments running on Windows 2000, Windows 2003, and Windows NT
• 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

Senior SQL Server DBA

Confidential

Responsibilities:

• Functions as Senior DBA with primary responsibility for company’s 24x7 production database systems supporting .COM Internet applications
• Primary focus on SQL Server Availability and Reliability; SQL Instance and Database Security; Backup, Recovery & Contingency Planning and Implementation; Server & Database Performance Tuning and Optimizations; Index Creation and Tuning; Query Design & Optimization; Performance Monitoring; and SQL Development
• Writes Stored Procedures, Triggers, User Defined Functions, SQL Scripts, VB/Active X Scripts; Creates and Implements Data Transformation (DTS) Packages and Jobs as part of continued application development and enhancements
• Responsible for Windows 2000 Advanced Server /Windows NT 4.0 Server administration of servers running SQL Server instances
• Maintains and troubleshoots all SQL Server and Windows 2000/NT issues impacting database servers
• Generates ad hoc database reports to support management and staff using Crystal Reports and Microsoft Access

Senior SQL Server DBA

Confidential

Responsibilities:

• Performs all DBA functions for all Confidential ’s SQL Server 2000 and SQL Server 7.0 databases, including Installations, Upgrades, Service Packs, and Migration to new releases of SQL Server; Availability and Reliability Testing; SQL Server and Database Security; Disk Management and Capacity Planning; Backup, Recovery & Contingency Planning and Implementation; Server & Database Performance Tuning and Optimizations; Index Creation and Tuning; Query Design & Optimization, Implementation, Optimization, and Analysis
• Responsible for developing, testing, and executing plans to extract data and recordsets from various sources, hardware platforms, data formats, and database applications
• Responsible for extraction, loading, scrubbing/transformation, verification, and querying of dissimilar data elements from various sources and formats. Creates homogeneous/heterogeneous linked servers to facilitate seamless data sharing between remote SQL Server and/or Oracle databases
• Writes Stored Procedures, Triggers, User Defined Functions, SQL Scripts, VB/Active X Scripts; Creates and Implements Data Transformation Packages and Jobs; Data Warehousing Implementation, Database Modeling and Implementation for Application Development. Work as a Part of Software/Application development group and data team
• Assists Oracle DBA in administering and maintaining Oracle 8.0.6.0 and Oracle 8.1.7 databases. Serves as primary backup for Oracle DBA
• Develops and Maintains Technical Specifications and Documentation for all SQL Server Installations
• Develops and Maintains Confidential ’s Emergency/Contingency Plans, Policies, and Procedures for all SQL Servers
• Develops requirements documentation for SQL Servers to be deployed with applications
• Performs load/stress testing of servers/databases/tables/indexes for application development team
• Develops/Troubleshoots/Modifies End User Database Applications (Visual Basic, Access 2000/97, Proprietary)

CIO, IT Director, Senior DBA, Systems Engineer

Confidential

Responsibilities:

• Performs 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
• Writes and implements SQL Server and Oracle stored procedures, triggers, functions, plans, DTS scripts etc. using tSQL, 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 planning, development, testing, migration, and implementation of the Integrated Preservation Software database application from DOS based dBase III to SQL Server 7.0
• Responsible for extraction, loading, scrubbing/transformation, verification, and querying of data from various sources and formats
• Serves 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
• Functions 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
• Directs, plans, designs, 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 Confidential transactions and emerging technologies. Responsible for the development, performance, security, procurement, and maintenance of all IT system hardware and software
• Provides expert technical support services to DHR local and remote users including hardware/software installation, maintenance, network administration, database administration, software development, and problem assistance. Conducts assessment of satisfaction with support provided. Assess user training needs and makes administrative arrangements for training and/or conducts training classes for agency users
• Supervise employees to ensure quality results from assigned tasks