Sql Developer Database Administrator

Location:

Quinton, VA

Salary:

100,000.00 annually or 50.00 hourly

Posted:

March 23, 2023

Contact this candidate

Resume:

Leroy Leonard

leroyleonard**@gmail.com***-***-***2

linkedin.com/in/innovativedatalogichttps://lttechnologies12.com/

Summary

Master data leader with professional experience in implementation, administration, developing, designing, ingestion, programming, big data, data science, analytics, automation, visualization, database administration, SOP, and project management. Extensive data warehouse implementations and applications with leadership skills, software design deployment, and ongoing production support using agile and waterfall Software Development Life Cycle (SDLC). Proficient problem-solving skills and proven track record of producing high quality results with experience in business management. Ability to handle a challenging environment that focuses on customer service, software/hardware management, report writing, data security, backup, recovery, and analysis. Extensive hands-on experience leading all phases of projects and striving for teamwork that allows for successful projects that include vital lessons learned for continuous improvement and refinement. I support projects with the government, hospitality, property management firms, medicine, healthcare, banking, investments, finance, agriculture, technology, education, research, law, infrastructure, real estate, and wildlife industries. I am open and available to work with all sectors. I am authorized to work for any US employer and do not require sponsorship now or in the future.

Experience

Data Design Data Visualizer Database Administrator

Freelance

Aug 2015 - Present (8 years)

Design and development of stored procedures, automation, and other database objects to support client's business needs.

Programming front end in .NET, CSS, JavaScript, HTML, React.js, Node.js, and HTML5

Programming backend in ASP.NET, Unix, Linux, Python, C#, C++, Java, PHP, Visual Basics, VBA, Macros

Develop and maintain databases working with Oracle PL/SQL, MongoDB, MySQL, Microsoft T-SQL Server, SQLite, Microsoft SQL Server, SQL Developer, Oracle RDBMS, IBM DB2, Teradata, Microsoft Access, and PostgreSQL.

Function on Azure AWS and other virtual server and SQL platforms Use of Snowflake, Amazon ECS, and PostgreSQL Solutions Manage ERP and CRM environments, Oracle Peoplesoft.

Design and maintenance of near real-time database reporting environments.

Reports on database analytics using SSIS, SSRS, SSAS, SSMS, and Crystal Reports. Dashboard and Analytic reporting using Power BI, Tableau, R, and other API and data scraping software.

Project Management Skills using Scrum, Agile Methodology, and Waterfall

Database Administrator /Developer

HEALTH PROFESSIONS, VIRGINIA DEPARTMENT OF

Aug 2018 – Feb. 28 (4 years)

Design and development of stored procedures, automation, and other database object to support the agency's business needs.

Function on Azure and other virtual server and SQL platforms Manage an ERP and CRM environment, Oracle Peoplesoft.

Design and maintenance of near real-time database reporting environments Geographic Information Systems (GIS)

Reports on database analytics using SSIS, SSRS, SSAS, SSMS, and Crystal Reports.

Dashboard and Analytic reporting using Power BI, R, SAS, Python Analytics Libraries, and other API and data scraping software.

Project Management: Scrum Master, Agile methodology

Enforcing the agency's stored data in the database environment and appropriately securing policies, procedures, and standards for internal and external users.

Perform and help ensure Database backup and recovery; user ID setup and maintenance; Database security; software installation and support; creation and maintenance of interfaces to other databases, systems, platforms, and agencies.

Provides IT disaster recovery plan and contingency planning; coordinates changes with required technical staff, management, and end-users; provides A/B testing software upgrades, parameter changes, and system changes to ensure minimal impact to users and problem determination and resolution.

Proficient in Microsoft Excel, Access, Word, PowerPoint, Outlook, Adobe Acrobat

Programming front end in .NET, CSS, JavaScript, HTML React.js, Node.js, and HTML5

Programming backend in ASP.NET, Unix, Linux, Python, C#, C++, Java, PHP, Visual Basics, VBA, Macros

Communicate all changes to environments to staff in a timely and coordinated manner.

Work with teams to project, prioritize, plan, manage, and implement projects in various stages.

Database Administrator

Virginia Department of Wildlife Resources - Conserve. Connect. Protect.

Mar 2015 - Aug 2018 (4 years)

Design and development of stored procedures and other database objects to support the agency's business needs.

Function on Azure, Snowflake, and other virtual servers and SQL platforms Identify and correct inconsistent data.

Manage ERP and CRM environments, Oracle Peoplesoft.

Design and maintenance of near real-time database reporting environments Geographic Information Systems (GIS)

Reports on database analytics using SSIS, SSRS, SSAS, SSMS, and Crystal Reports.

Dashboard and Analytic reporting using Power BI, R, SAS, Python Analytics Libraries, and other API and data scraping software.

Project Management: Scrum Master, Agile methodology

Enforcing the agency's stored data in the database environment and appropriately securing policies, procedures, and standards for internal and external users.

Perform and ensure database backup, recovery, user ID setup, and maintenance. Database security; software installation and support; creating and maintaining interfaces to other databases, systems, platforms, and agencies.

Provide IT disaster recovery plan and contingency planning; coordinates changes with required technical staff, management, and end-users; provide A/B testing of software upgrades, parameter changes, and system changes to ensure minimal impact to users and problem determination and resolution.

Proficient in Microsoft Excel, Access, Word, PowerPoint, Outlook, Adobe Acrobat

Programming front end in CSS, JavaScript, HTML React.js, Node.js, and HTML5

Programming backend in ASP.NET, Unix, Linux, Python, C#, C++, Java, PHP, Visual Basics, VBA, Macros

Communicate all changes to environments to staff in a timely and coordinated manner.

Work alongside other teams to project, prioritize, plan, manage, and implement projects in various stages.

Programmer/Analyst

Town of Culpeper, Virginia

Jun 2013 - Jun 2015 (3 Years)

Developed and implemented system scope and objectives through research and fact-finding to create and modify ERP, CRM, Microsoft Dynamics Great Plains, Dynamics 365, SharePoint, and other moderately complex information systems.

Designed/Coded/Tested/debugged/Documented, and maintained software following the organization’s software development lifecycle (SDLC) methodology.

Design and maintenance of near real-time database reporting environments Geographic Information Systems (GIS)

Reported on database analytics using SSIS, SSRS, SSAS, SSMS, and Crystal Reports.

Proficient in Microsoft Excel, Access, Word, PowerPoint, Outlook, Adobe Acrobat

Programming front end in .NET, CSS, JavaScript, HTML React.js, Node.js, and HTML5

Programming backend in ASP.NET, Unix, Linux, Python, C#, C++, Java, PHP, Visual Basics, VBA, Macros

Assisted user departments with technical assistance.

Delivered project reports and presentations for management and stakeholders. Participated in the selection process for Agency staff.

Computer Information Specialist

Prince William County

Jul 2012 - Jul 2013 (1 year)

Maintained customer inquiries via telephone and web-based ticketing for twelve library locations.

Deployment and implementation of maintenance and support for computers.

Perform product evaluation, setup, design, and operation of the Public Access Computers.

Provided application support, troubleshooting, and diagnoses, for staff and patrons on Public Assess Computers.

Programming front end in .NET, CSS, JavaScript, HTML React.js, Node.js, and HTML5

Programming backend in ASP.NET, Unix, Linux, Python, C#, C++, Java, PHP, Visual Basics, VBA, Macros

Database report writing using Crystal Reports.

Trained staff and patrons on application operation, security protection, and recovery.

Help Desk Analyst III

Capital One

Sep 2012 - Jul 2013 (1 Year)

Programming front end in .NET, CSS, JavaScript, HTML React.js, Node.js, and HTML5

Programming backend in ASP.NET, Unix, Linux, Python, C#, C++, Java, PHP, Visual Basics, VBA, Macros

Responded to customer inquiries via telephone and web-based ticketing.

Used the HPSM Ticketing system to Work and escalated problems as appropriate.

Assisted with account management with password and user name reset.

Used Active Directory and SCCM To research and assign Groups Permissions.

Used Remote Access to resolve issues.

Support the backup and security of confidential data.

Help Desk Analyst

Meridian Resource, division of WellPoint/Anthem

May 2010 - Sep 2012 (2 years)

Programming front end in .NET, CSS, JavaScript, HTML React.js, Node.js, and HTML5

Programming backend in ASP.NET, Unix, Linux, Python, C#, C++, Java, PHP, Visual Basics, VBA, Macros

Responded to customer inquiries via telephone and web-based ticketing and acted as a single point of contact for 2000+ users daily.

Navigated through websites with customers for support and provided education.

Used the WAW ticketing system to escalate problems as appropriate.

Assisted with account management with password and user name reset.

SharePoint Administrator-Build/Modify Knowledge Database. Used a Multi-State Mainframe for research and verification.

System Administrator

Lampe Management Company

Apr 2006 - Apr 2012 (7 years)

Managed twenty self-storage facility location managers.

Managed sales, occupancy, and past-due accounts and performed minor maintenance.

Performed desktop configurations, network access, connectivity issues, and printer connectivity.

Programming front end in .NET, CSS, JavaScript, HTML React.js, Node.js, and HTML5

Programming backend in ASP.NET, Unix, Linux, Python, C#, C++, Java, PHP, Visual Basics, VBA,

Macros

Troubleshoot, installed, configured, and repaired computer systems. Performed hardware and software performance regularly.

Accounts Payable /Vendor Specialist

United Dominion Realty & Trust

Jul 2003 - Mar 2006 (3 years)

Reconciled various expenditure reports to source documents.

Prepared routine entries and posted financial transactions.

Assisted in the completion and maintenance of general ledgers.

Help Desk/Fiscal Tech

VCU Health

Apr 2000 - Jul 2003 (3 years 4 months)

Reconciled various expenditure reports to source documents.

Prepared routine entries and post-financial transactions.

Assisted in the completion and maintenance of general ledgers.

Budget and Purchasing Management

Programming front end in .NET, CSS, JavaScript, HTML React.js, Node.js, and HTML5

Programming backend in ASP.NET, Unix, Linux, Python, C#, C++, Java, PHP, Visual Basics, VBA, Macros

Education

J Sargent Reynolds Community College

Associate's degree, Information System Technology

Lafayette High School

High School Diploma

Thomas Nelson Community College

Associate's degree, Accounting and Finance

Licenses & Certifications

10987: Performance Tuning and Optimizing SQL Databases - New Horizons

Computer Learning Centers

.Net Certification - Microsoft

Security Plus Certified - Microsoft

MS Sever Certified - Microsoft

Skills

MongoDB • Microsoft Dynamics 365 • C# • Cascading Style Sheets (CSS) • XML • HTML •

HTML5 • Tableau • SharePoint Designer • HPSM

Contact this candidate