NICOLE BARNARD

adsqjs@r.postjobfree.com **** Aspen Court, Nashville, North Carolina 27856 254-***-****

IT Operations Leader Trainer Instructor

Software/RDBMS Development/Administration Enterprise Implementations Systems Engineering Data Analytics

Professional Summary:

●Accomplished Information Technology leader bringing more than 30 years of hands-on experience in database management, web design, development, data integration and 10 years of experience in team management.

●Skilled in achieving operational efficiency and increasing productivity in the information technology arena.

●Business process improvement, database systems analysis and systems development expert.

●Employs root cause analysis to identify issues and develop process improvements that lead to cost savings and high production availability.

●Exceptional planning and implementation capabilities.

Executive and Technical Highlights

●Strong technical leadership

●Experience with performance and scalability optimization servers and underlying processes and code

●Knowledge of agile/scrum processes

●Advanced problem-solving skills

●Database design and development

●Advanced Microsoft SQL server Admin

●Microsoft SharePoint Admin (On-Prem & Online) - Infrastructure database farms & Interface Development

●Exceptional logic and design skills

●Familiar with API development

●Experienced application/database life cycle concepts and implementation

●Detailed organization skills

●Cross-Functional Supervision

●Team Building & Mentoring

●Client Relations & Presentations

●Vendor Management

●Developing & automated KPI reporting for SR. VPs

Summary of key accomplishments:

●Enterprise Implementations: Brought in as a subject matter expert to multiple organizations with non-existent processes, procedures, or best practices surrounding database management/ETL/development code arenas. During a 5 year stay at one of the largest health care providers in Texas, I helped establish the foundation needed to run a multi-regional organization with 1/3 of the staff. The teams went from pillarized with internal strife to working as a unit and supporting each level of expertise through team mentorship. During this time, I consulted database teams, programmers, analysis and developed best practices surrounding database systems/ETL processes/scripting based on the discovery. Led teams across broad technical fields to standardized existing systems and ensured new systems met industry best practices in all database server, software development, infrastructure, security, and disaster recovery arenas. Collaborated closely with the Change Advisory Board (CAB) on best practices and protocols surrounding changes to database and coding systems. Implemented robust monitoring systems and other tools to assist developers and ETL coders to better tune queries and processes to improve client request turn-arounds. This implementation also provided leadership with important KPIs surrounding production times, storage needs, disaster recovery effectiveness, team workload analysis and alerting acknowledgements.

●Database/Interface/Tools Developments: Taking a company from reactive to proactive responses through the development of a server/document/code inventory system process using SharePoint, C#, VBS, VBA, t-SQL and a backend SQL server. This was used as a central information repository for all DBAs and Software Analysts in tracking servers/documents/code/scripts. Designed and developed a subject matter expert system that assisted with key team members with expert knowledge in an area such as programming/scripting, always-on, disaster recovery. Developed on SharePoint using C#, VBS, VBA, t-SQL to interface with a backend SQL server

●Team Leadership: Led 13-member multi-regional, multi-country, multi-platform database team in supporting over 1000 database servers for a major Texas based health care provider. Teams were divided into two groups, proactive and reactive and supported to lead subject matter experts. This restructuring took the team from having 75% production time to 95% production time in three months after reorganization of talent, skills and personal goals alignment. Lowed the ticket count from 500 per day to 65 per day.

●Systems Integrations/Migrations: Led team in massive EHR (electronic health records) system conversation covering over 150+ hospitals and clinics. Our role was converting all existing databases systems and tools from one system to the other, ensuring data mapping and extracts met all requirements for the stakeholders. This involved moving and/or duplicating all databases, custom ETL packages, reports, and code base. Coordinated with programmers to meet application life cycle needs as well as keeping with best practices with database deployment and code documentation of an enterprise wide transition from one EHR application (electronic health records) system.

●Completely automated and optimized a major Texas based military hospital’s SQL environment by developing daily maintenance plans and backup systems, configuring monitoring tools, developing disaster recovery plans, and reconfiguring environments for more efficient use of database servers, storage, and services.

Skills:

●Programming Languages: HTML, PHP, MYSQL, CSS, XHTML, XML, SQL and light experience in VB, VBA and VB script, .NET, C#

●Programing tools: Visual Studio 2005-2016, SQL Business Intelligence Services

●Collaboration tools: SharePoint Online, 2007 and 2017 database administration, site administration, and some customized web parts and data collection forms.

●Web Development tools: Visual Studio, Dreamweaver; Photoshop,

●Databases: SQL 7 to SQL 2017: Administration of complete database life cycle. with SSRS & SSIS.

Other RDBMS include: Rbase, FoxPro, FileMaker Pro, Dbase, Paradox, Access 97 to 2016, MySQL

●SSIS.SSRS: Troubleshooting and deploying with Visual Studio 2005-2016.

●Operating Systems: –Windows 2016 and below, Active Directory

●Virtualization: VMware

●Office Apps: All Microsoft Office Products from Version 97 to 2016 and Online;

●Graphics: Photoshop, Illustrator, Page Maker, MS PowerPoint, Corell Draw;

Email Packages: Outlook all versions

Professional Experience:

Manager Database Systems Administrator

Local Government Federal Credit Union March 2018 to July 2022

●Conducted SR. DBA activities, such as High Availability, Performance Tuning, Disaster Recovery and more

Sr. SQL DBA

Vaco – First Citizens Bank Jan 2018 to Feb 2018

●Short term contract for specific task of documentation for migration of standalone system to virtual AG system.

●Conducted SR. DBA activities, such as High Availability, Virtualization, Disaster Recovery and more

Sr. Lead SQL DBA

S3 - Premier Inc June 2017 to Dec 2017

●Conducted SR. DBA activities, such as High Availability, Performance Tuning, Disaster Recovery and more

●System develop, recommendations, and manage backup recovery plans and performance tools for MS-SQL database systems. All tools were developed using C#, VBS, VBA, t-SQL to interface with a backend SQL server.

●Led 10-member team’s daily functions, project management and orchestrated inventory and monitoring management and implementation

●High level troubleshooting of AG clusters, some replication, SQL Server systems ranging from 2000 to 2016.

Team Lead/Manager Sr. Database Administrator

Baylor Scott & White Healthcare February 2012 to June 2017

●Conducted daily manager duties and SR. DBA activities, such as High Availability, Performance Tuning, Disaster Recovery and more

●Developed multiple tools to interface with database systems and SharePoint using C#, VBS, VBA, t-SQL to interface with a backend SQL server.

●Managed teams in deployment and support of internal infrastructure systems ensuring that periodic tasks are completed by each team member.

●Coordinated with external technology vendors, internal staff members and third-party consultants.

SQL Server Database Administrator

AIST August 2011 to February 2012

●Conducted DBA activities, such as High Availability, Performance Tuning, Disaster Recovery and more

●Created and maintained data-models, design and enforce database coding standards

●Wrote, debug and tune stored procedures, triggers, and user-defined functions

Database Administrator II

STG, Inc. June 2009 to August 2011

●Conducted DBA activities, such as backups, maintain and generate user accounts and more

●Troubleshooting client/server problems/procedures, Create monthly IT Metrics Reports

●Enhanced web client screens

●MS Access: Designed Analytical Reports using QBE, Forms and Graphs for Metric Analysis

●Administer SharePoint database servers, and client tools

Department Chair - Master Instructor

Texas State Technical College September 1995 to June 2009

●Managed e-Commerce Technology's faculty, staff, budget, graduates and other duties as assigned.

●Master Instructor – Prepared and conducted lectures for courses in PHP, MySQL, Programming logic, Apache Server, Access, SQL 2-2007, Visual Studio 6 .NET, Internet Information Server, Adobe Web Design Suit and other various web/windows programing courses. Developed corresponding distance learning courses using Blackboard, Soft Chalk, Moodle, Angel, and other CMS tools.

●Scheduler - Schedule all Labs, Instructors, Students, and Courses for each term

●Department Advisor- Advise all students on current degree plans and future preparations

Additional Training/Skills:

●Manager Lean Training, Baylor Scott and White – 2012 & 2017

●Delivered various seminars and training sessions covering Distance Education development, Microsoft, Adobe products, Web Design, Web Programming, Business Management, and other technology related topics

●AAS Christian Education, Faith Bible Institute

●Privacy Act and HIPAA Operations CEUs, 2012

●DOD Information Assurance Awareness, 2011

●Army Specific Trainings for Security and Technology 2009-2012

●Penn Foster Career School – Advanced Paralegal Applications 2006

●Basic Instructor Training Course, Texas State Technical College 1999

●Excelling as a First-Time Manager or Supervisor, SkillPath Seminars 2002

●The Conference for Women, SkillPath Seminars 2002

Conflict Management for Women, SkillPath Seminars 2002

Education:

●Masters in Data Analysis, Western Governors University

●BS Database Administration, Western Governors University

●AAS Microcomputer Applications, Temple Junior College

Certifications:

●Microsoft SQL Server 2008 – Designing Database Solutions and Data Access

●Microsoft SQL Server 2008 – Database Development

●Microsoft Certified Technology Specialist

●Microsoft Certified Professional

●CIW Database Design Specialist

●CIW Associate – Web Foundations

●CIW Professional - Web Designer

●Project+ Verification

●Security+ Certification

●A+ Certification

Microsoft Office User Specialist Master

Contact this candidate