Post Job Free

Resume

Sign in

SQL DBA/Data Architect

Location:
New Albany, OH
Posted:
July 10, 2016

Contact this candidate

Resume:

Christopher Peer

**** ********* **** ***** 502-***-****

Columbus, Oh 43230 acvmua@r.postjobfree.com

OBJECTIVE Obtain Senior Level Developer, System Analyst or Database Architect position that would take advantage of my years of proven success in both business and academic environments.

EXPERIENCE

Oct 2013 Nexus Communications Inc. Columbus, OH

To Present Chief Technology Officer (CTO)

Report directly to the chief executive officer. Responsible for establishing company’s technical vision and leading all aspects of technology development, according to strategic direction and growth objectives.

Establishing technical standards and ensuring adherence. Supervise software testing, and information systems security and maintenance. Lead organization in anticipating and reacting to major technology changes. Developed technology contingency plans to keep projects on track.

Direct all employees in IT to attain the company’s strategic goals established in the company’s strategic plan.

Work in a consultative fashion with other department heads, such as marketing, production and operations as an advisor of technologies that may improve their efficiency and effectiveness.

Reverse engineer legacy systems, migrate data, update code base, and provide design documents to recreate business logic in new systems.

Provide training for junior programmers or assist in code development when resources not available.

Manage maintenance plans (backups, logs, and indexes) for over 200 SQL 2008/2012 instances.

Administer SQL server security, granting access rights based on role based security model.

Develop and maintain replicated databases used for reporting and data marts.

Develop and maintain SSIS and SSRS packages used for various ETL projects, business reporting, data marts, and migration.

Responsible for migrating data between legacy MySQL, Mongo, Excel and Access database into normalized SQL database.

Develop SQL stored procedures and triggers to support contracted developers and perform performance tuning for all existing TSQL code.

Architects database designs to meet new and existing business requirements. Create relational or multi-dimensional database models with SSAS or SQL stored procedures.

Reverse engineering .NET, PHP, ASP, and CRON jobs to restore databases and identify data quality issues.

Design and develop .NET web applications using various APIs and web services for internal and external customers.

Administered VMWARE to create Windows server, install SQL instance(s) and managing resource allocations.

Dec 2006 Kentucky Farm Bureau Louisville, KY

To Oct 2013 Database Administrator/Senior Systems Programmer

Troubleshoot and optimize database performance for various software applications (Ceridian, Heat, SQL Server, Plainview, & On Base)

Provide custom applications or interfaces to link customer and database using various developer tools (T-SQL, VB.net, ASP net, SQL Reporting Services, and Crystal Reports).

Design and develop ETL solutions to bridge gap between systems or provide data warehousing solutions (DTS, SSIS, and IBM Datastage).

Establish standards for new database systems and develop processes/applications to convert existing systems.

Design, development and implement disaster recovery procedures that ensure high availability requirements are maintained.

Monitor database performance factors against pre-established metrics and take appropriate action to correct hardware or software deficiency.

Develop maintenance plans to prevent data loss and optimize database performance.

Aug 1999 AIK COMP Louisville, KY

To Dec 2006 IT Manager, Senior Systems Analyst

Developed departmental policies and procedures for software design, development, and maintenance.

Translated business needs into numerous Windows and Web applications using Power Designer tools and Use Case Modeling. Changing roles (IT Manager, Systems Analyst, Database Administrator, and Software Developer) during the development process to meet company objectives.

Database Designer and Administrator for entire SQL database system housing millions of records within several hundred tables.

Developed and conducted user training/presentations to staff, corporate officers and board of directors.

Utilized and mentored development team using VB, VB.NET and T-SQL environments.

Ensured success of daily computer related operations including email communications, network reliability, data integrity, and disaster recovery plans.

Mentored other developers during coding (Visual Basic 6, VB.Net & SQL Server) and implementation of user, business, and data services.

Aug 1998 Technology Consulting Inc. Louisville, KY

To Aug 1999 Senior Systems Analyst & Project Leader

Translated business needs into numerous Windows and Web applications using Power Designer tools and Use Case Modeling.

Database Designer and Administrator for several small and mid-size companies.

Supervised and mentored development teams using VB, Visual C++ and T-SQL environments.

May 94 533rd Training Support Squadron Vandenberg AFB, CA

To Aug 98 IT Manager, Senior Systems Analyst, Project Leader

Directed the acquisition operation, support, and maintenance for over $1 million worth of small computer systems, peripherals, software, and multimedia classroom presentation systems.

Involved in all phases of software development process - requirement analysis, software design, implementation and coding using CASE tools (Rational Rose) and object oriented methodologies.

Provided network system administration for local- and wide-area computer networks.

Converted software designs into various computer and authoring language programs and researched applicability of new programming tools and techniques.

Supervised and managed the troubleshooting and repair of computer software and hardware malfunctions.

Advised senior staff on contractual decisions relating to small computer acquisitions.

Provided supervision and technical expertise to subordinates in personal and professional development.

Designed, managed, and instructed courses on small computer applications.

Dec 90 Education Technology Department USAF Academy, CO

To May 94 IT Manager, Senior Systems Analyst, Project Leader

Used state-of-the-art microcomputer technologies, software, and local area network methodologies to design or supervise other in designing software and hardware solutions for educational applications.

Translated courseware designs into various computers and authoring language programs.

Interfaced with military personnel, civilians, and contractors for new courseware or equipment development.

Managed 8500K interactive multimedia Network Classroom Laboratory for faculty experimental course development and computer-based instruction.

Designed and presented training for faculty in educational technology applications.

Researched, developed, and acquired new technological applications.

Provided technical expertise to subordinates, superiors, and faculty.

Managed $300k in departmental computer resources and supplies.

HARDWARE &

SOFTWARE Languages/Software: TSQL, Visual Basic, Visual Basic for Applications (VBA), VB.NET, ASP.NET, PHP

Visual C++, C, Java, Toolbook, and ICON Author, Crystal Reports (8.5, 9, 10 & 11)

DBMS & ETL: SQL Server (7 - 2012), MS Access (VBA), Brio Query, Brio Reports, SQL Server Integration (SSIS), SQL Reporting Services (SSRS) and IBM Data Stage,

Operating Systems: MS-DOS, Windows 95 to Windows 7, Windows Server 2003 – 2008, Linux

Hardware: IBM PCs, LAN Components, VAX, and Harris

Analysis/Design Tools: MS Visual Studio 2005-2012, Eclipse, Sybase Power Designer Suite, Object-Oriented Analysis and Design, Rational Objectory Process, UML, Embarcadero ER Studio

Software & Project HP Quality Center, Base Camp, JIRA. MS Project

Management:

EDUCATION University of Phoenix – Phoenix, AZ MS, Computer Information Systems

Regis University – Colorado Springs, CO BS, Computer Information Systems

Community College of the Air Force AA, Computer Science Technology & Info Management

Rational University & Learning Tree International

Object Oriented Analysis and Design

Object Oriented Programming using C++

Advanced Programming using C++

United States Air Force Technical Training Center, Keesler AFB, MS

USAF Basic Instructor Course

Computer Operations/Programming Specialist



Contact this candidate