Sql Server Security Clearance

KILEY MILAKOVIC

Job Category: Senior Consultant, Director of Technology, High-Level Systems Developer Project Lead/DBA

Secret Security Clearance

Summary:

I have over 26 years of both technical and leadership experience. I have a solid and diversified background in several languages and platforms. I believe strongly in the System Life Cycle, and the Capability Maturity Model. I am extremely comfortable in dealing with all levels of both customers and management. The country’s largest technical consulting company has professionally trained me. I pride myself on being current with all new technology and leading a team of strong highly motivated developers.

Technical Disciplines:

SQL SERVER Azure, AWS, 2019, 2017,2016,2014,2012,2008 R2, 2008,2005,2000,7.0, 6.5,, SQL SERVER Reporting Services, PowerShell, Visual Studio .net 2003 – 2022 Team Foundation Server 2005 – 2022, Azure Data Studio, SharePoint 7.0 - 2016, CA Erwin, Visio 2.0 - 2013, Access 2.0 – 2013 OFFICE 95 – 2013, Oracle 11g – 7.0, Visual Basic 6.0, Visual Studio .Net 2003 – 2013, XML, RDS, ado, ado.net, VBScript, COM/DCOM, ASP 2.0-3.0, ASP.NET, HTML, XML, JavaScript, MTS 4.0, ADO, Crystal Reports, Visual SourceSafe 6.0-7.0, COBOL 75-85, REXX, CLIST, Assembler, JCL, CICS, VSAM, IDMS, Culprit, DYL280, Business Objects 11.0, Business objects composer, Business Objects Data integrator 11.5, Remedy, Sybase 10.0, IBM Netezza.

Hardware/OS Experience:

Windows10, 8.1,8,7, 2012r2, 2012, 2008r2, 2008,2003r2, 2003, Windows NT 4.0,2000, XP, vista, windows 7, NT Server 4.0,2000, Windows 8.1.8.7, Vista, 95, 98, ME, XP, IIS 4.0 – 11.0, Peer Web Server, X-Windows.

Dell 2950, 3960, SC 1425 etc., IBM System-36, All PC types, IBM, Apple, Mac, IBM 3191, Unix, IBM Netinifinty, Unisys ES7000, ES2000, EMC.

Professional Experience:

ABC Fitness/Planet Fitness -Remote May 2022 to Current

Sr. SQL Server DBA/ETL Engineer

Document and define current technologies within the company between Oracle, IBM I-series, IBM Netezza, and Microsoft SQL Server Azure. Create ERD diagram, Data Definition Documentation Document and Data Model. Architect New Solution Going from Microsoft SQL Azure to Snowflake, getting rid of existing technologies.

Progressive Insurance -Remote May 2022 to Current

Sr. ETL Engineer

Assist in updating Claims, Injury, Property Information using SQL server 2019 SSIS, Azure Dev Studio. Modify existing packages per user enhancement requests. Create New packages to handle new requirements.

Teleosoft, LLC -Remote May 2021 to May 2022

Sr. SQL DBA/ Engineer

Lead SQL server DBA for migrations from existing county court systems to new enterprise systems. In charge of performance tuning, machine and hardware recommendations, engineering using SSIS and Visual Studio 2019 Dacpacs with GIT. Responsible for creating and configuring best practices as well as source control and build/release strategy as it relates to the four corp database systems.

Mizuho Securities (via ProRec Resource Solutions, LLC) Remote May 2020 to May 2021

Sr. SQL/ETL Architect

Called back to do some fixes and work with current team on enhancing the performance and work on and maintained SSIS packages. Develop and maintain T-SQL and Stored Procedures. Worked in PowerShell to automate functionality for data.

Chewy.com (via ProRec Resource Solutions, LLC) – Remote Sept 2019 to March 2020

(ended Due to COVID)

Review and Assess the entire SQL environment, Code and Create auto provision and auto update process using PowerShell and SQL server tools. Supported SQL server 2012-2019 On-Prem and remote cloud AWS. On call to provide Tier 3 SQL Server support and assisting developers with new design and code fixes.

Solvaria (via ProRec Resource Solutions, LLC) - Remote

Sr. SQL/ Architect/DBA

July 2018 – Aug 2019

Review and Assess Client SQL servers for Microsoft and Industry best practices. Provide Performance tuning recommendations, Code and database design, training and documentation to various clients. Assist in database standards as well as code level reviews. Plan, Code and Test various client Migrations from On-prem to cloud both Azure and AWS. Automation using Power shell 2.0 to current.

TransCore (via ProRec Resource Solutions, LLC)

Sr. SQL/ Architect/DBA – Lead DBA

October 2017 – July 2018

Focused on troubleshooting, process assessments, document and performance tuning for existing databases for performance issues. Taught and mentored developers on Microsoft Best practices in their application development, focused on data security, along with set-based coding techniques. Configured and setup both Hybrid On-Prem and Microsoft Azure database hosting. Run day to day production servers. Act as tier 3 support for any daily issues that arise. Examine/Assess and recommend new hardware for more efficient data processing. Also assisted in SAN configurations and changes as well as plan budget for IT software and hardware needs.

Mizuho Securities (via ProRec Resource Solutions, LLC) Half remote; half onsite

Sr. SQL/ETL Architect

July 2017 –October 2017

Led a team of SQL server ETL developers. Developed and maintained SSIS packages to move and migrate data from various external entities such as Bloomberg, Bank of New York, Citigroup, Deutsche Bank and JP Morgan. Develop and maintain T-SQL and Stored Procedures, along with logical and physical data model to support new enterprise entities. Developed in PowerShell to automate functionality for migrations and conversions for data.

Bridgewater Associates (Via Credo Technology Solutions, LLC)

Sr. SQL Server Engineer/Architect

January 2015 – May 2017

Assist the world’s largest Hedge fund in implementing a new Enterprise Database Design and Framework Automation Application using PowerShell, T-SQL, and C#. Continue to help consolidate and recommend best practices for Microsoft SQL server. Transition the Server Fleet of over 700 servers and 3000 databases from SQL server 2008 to SQL server 2014 and 2016 beta. Code and Engineer the Management of the fleet as well as utilize “AlwaysOn” across multiple geographic data centers. Report to Database section leads and all management any and all findings. Migrate and support On-Prem and Azure off site Always on solutions. Assist Microsoft MVP with Building an in-house application to assist in automated backups, monitoring, Auditing, Database server and Platform provisioning for the company.

B2B Consulting

Freelance Senior Consultant/DBA

September 2014 – December 2014

Work on behalf of B2B to assist both current clients as well as obtain new clients. Clients include many fortune 500 and 100 companies as well as various industries in Healthcare, Manufacturing, Commerce, and Logistics. Senior DBA to provide overall health assessment of Organization as well as recommend and provide any and all best practices and changes required to meet needs of clients as well as those of various Authoritative bodies. Full range of guidance from SQL server 7.0 to SQL server 2014. Also, assist and recommend change management, TFS and SharePoint upgrades and assist with SCCM issues. Finally, Tier 3 support in case of major client outages or problems that arise from day to day business.

Sigma 7~Deloitte Consulting

Pa Dept. of Human Services

Lead Consultant/DBA/ SQL SERVER 2008 R2 - 2012

June 2014 – December2014

Advise State Database Staff and upper management on all technical decisions going forward as well as interact with all vendors on behalf of the State. Overall will save state upwards of 5 million dollars over next three years. Teach and train State Staff and other consultants on Microsoft Best Practices, State of PA coding standards. Lead Consultant/DBA to assist, recommend, and lead both a Migration of all Enterprise Servers from Windows 2008r2 and 2004r2 SQL server 2008 and 2008r2 to Windows 2012r2 SQL server 2012. Convert and consolidate everything to utilize latest and greatest virtualization using V-BLOCK, EMC, and SQL server 2012 always on. Architect plan for movement, prepare documentation, assist state staff with vendors and Implement changes. Also prepare plan for data center move from Harrisburg Pa, to McLean, Virginia data center. Configure, test, and maintain dual always on network over separate subnets. Install, configure and deploy TFS 2010 and then 2013. Install, train, and configure SharePoint 2010 and 2013. Install, Configure SCOM 95 to Operations Manager 2013. Baseline all hardware and both determine all new database server hardware as well as layout infrastructure and procurement documentation for hardware and software as needed.

Developers IT, LLC

Pa Dept. of Corrections

Lead Consultant/DBA/ SQL SERVER 2005, 2012

March 2012 – May 2014

Advise State CIO and staff on all technical decisions going forward as well as interact with all vendors on behalf of the State. Teach and train State Staff and other consultants Microsoft Best Practices, State of PA coding standards. Lead Consultant/DBA brought in to modernize Department of Corrections and Department of Parole from SQL server 2005 to SQL Server 2012. Over 200 applications ranging from classic asp to .net 2013. Install, configure and Deploy TFS 2010 and then 2013. Teach and train State Staff and other consultants Microsoft Best Practices, State of PA SQL Server coding standards. Install, train, and configure SharePoint 2010 and 2013. Install, Configure SCOM 95 to Operations Manager 2013. Baseline all hardware and both determine all new database server hardware as well as layout infrastructure and procurement documentation for hardware and software as needed. Migrate IBM VSE COBOL Application to .net SQL Server 2012 saving taxpayers 2.5 million dollars per year. Review architecture, software for security issues, best practices, and replaced outdated mainframe, excel, and access systems. Create supporting documentation and justifications as requested by CIO’s. Help define IT budget, reduce costs and maximize hardware and architecture. Changes so far have saved State of PA 4 million dollars in hardware overhead.

Developers IT, LLC (Owner - Contractor)

Pa Dept. of Health

SR DBA/ SQL SERVER 2008 R2

August 2010 – March 2012

Senior SQL server DBA assigned to upgrade and convert SQL server 2005 databases to SQL server 2008 r2 for PA WIC system. Troubleshoot performance of queries, table design and views. Assist development team with coming up with new relational design. Leverage, and utilize new SQL server 2008 functionality to include Database change data capture, database auditing, data types, etc. Provide both the necessary documentation as well as code the conversion of legacy applications and strategies Provide technical guidance and training to state client. Assist in phasing out sql server replication to tablet/laptop pc’s in favor of using new sync technology as well as use of SQL server clustering and database mirroring.

Developers IT, LLC

Pa Dept. of Environmental Protection

PA Dept. of Conservation and Natural Resources

Senior Consultant/DBA/ SQL SERVER 2008 R2

March 2011 – October 2011

Senior consultant brought in to advise both DEP and DCNR CIO’s and staff on all technical decisions going forward as well as interact with all vendors on behalf of the State. Teach and train State Staff and other consultants Microsoft Best Practices, State of PA coding standards. Recommend and design new database(s) to handle the needs of both agencies and its customers. Review architecture, software for security issues, best practices, and replaced outdated mainframe, excel, and access systems.

Create supporting documentation and justifications as requested by CIO’s. Help define IT budget, reduce costs and maximize hardware and architecture.

Developers IT, LLC

Pa State Police

SR DBA/ SQL SERVER 2008

June 2009 – June 2011

Senior SQL Server DBA for Pennsylvania State Police. Currently in charge of architecting the Hot Files application to track Missing persons, Wanted persons, Protection from abuse, and Stolen Vehicles. Application is currently IBM mainframe based flat file system to be recoded into relational database design utilizing windows .net 2008 web service’s and SQL Server 2008. Primary functions Include database design, Database Conversion, Database and SQL Server 2008 report server architecture planning, configuration and setup. Database Clustering. Database programming SSIS programming to load and unload data from legacy COBOL system. Configuration and administration of Team Foundation Server 2008 and Windows SharePoint Server 2007. Assign database permissions, create and apply database encryption strategy. Take advantage and leverage all 2008 new functionality. XML data storage, conversion and coding. Data modeling using CA Erwin 7.3.3.1782. Apply and recommend to State employees all SQL server coding standards and best practices. Train state staff on T-SQL and Reporting Services. Provide all documentation to include, data model, data mapping, database migration and conversion strategy, database environment, data dictionary, installation and disaster recovery plans and data archiving strategy.

Developers IT, LLC

Pa Turnpike

SR. DBA/ SQL SERVER 2005

May 2008 – January 2010

Senior SQL Server DBA for Pennsylvania Turnpike Commission. In charge of 60 databases, and 3 developers. Current job entails migration from SQL server 7.0 to SQL server 2000, 2000 to 2005, and 2005 to 2008. Managing SQL Server Reporting Services, Conversion of all Oracle 11g to SQL server 2008 and writing PL/SQL statements and other day to day database efforts. Responsible for database design, SQL server clustering, Hardware Capacity planning, database Q/A, migration strategy, security, coding, standards, budget, and training state DBA’s to perform role.

Developers IT, LLC

ISG/Pa Lottery

SR. DBA/ SQL SERVER 2005

September 2008 – February 2009

Senior Consultant brought in to troubleshoot and identify various issues around SQL Server replication. The current application in use uses WPF foundation to replicate data between source database and 100 tablet pc’s in the field. While onsite I am to also set technical direction as to the network configuration and Technical Processes currently in use to better maximize performance and development.

Developers IT, LLC

Prelude Services

Consultant

June 2008 – September 2008

I am Senior Consultant in charge of identifying issues in I.T. department. Main purpose is to help streamline application support, hardware cost savings, staff issues, etc. Prelude supports well over 75 nursing homes and pharmacies. They have well over 45 domains and well over 150 servers. I have reported directly to CIO and CEO of company giving various recommendations and strategies to improve overall data processing department.

Current Environment Includes SQL Server 2000, 2005 and 2008. Overall assessment of SQL Clustering, Replication, SQL Server Reporting Services and SQL Server Integration Services is required.

Developers IT, LLC

OVR Office of Vocational Revocation

DBA/ SQL SERVER 2005 Developer

Jan 2008 – May 2008

Developer in charge of coding data fixes to assist OVR with the transition from mainframe to CWDS system. Primary job duties include fixing over 200 data defects as well as training state DBA in SQL server 2005. Data fixes range from ma few rows to more than 12 million.

Developers IT, LLC/EDS/Deloitte Consulting

CWDS - Workforce

DBA/ SQL SERVER 2005 Lead Conversion Developer/Architect

Feb 2006 – Jan 2008

Conversion DBA, responsible for stability of SQL SERVER 2005 conversion servers. Primary job duties include day to day monitoring and coding of various conversion routines to convert data from 3 different legacy systems into new sql server 2005 system. Three systems include data from IBM mainframe, lotus notes, SQL server 2000, Access 2000 and excel spreadsheets. I have daily interaction with state clients from both Departments of welfare as well Labor and Industry. Currently, four developers report to me. My job also entails training and assisting state clients as well as training and assisting team members with SQL server and the conversion process. I am responsible for coming up with conversion Data Conversion and Strategy technical approach, testing scenarios, change control management, and documentation as needed by client. Primary tools used are Sql server 2005, Business Objects Data Integrator, and Business Objects Composer.

Developers IT, LLC

Harrisburg School District

DBA//Architect SQL SERVER 2005 VB.NET 2005

Jun 2007 – Oct 2007

Senior Developer, Architect, Database Administrator for Provider based VB.net web reporting tool used by School District to track and maintain list of Providers Used for mental Health Services for the District. I developed database data model using Rational Rose, Database Design in SQL Server 2005, and web application in VB.net 2005.

Developers IT, LLC

Veridyne Consulting

DBA//Architect SQL SERVER 2005 VB.NET 2005

Sep2007 – Oct 2007

Senior Database Administrator and developer for a VB.net web Survey tool used by Center for schools to track and maintain list of Providers Used for both mental and physical Health Services. I developed database data model using Rational Rose, Database Design in SQL Server 2005. Assisted in web application development in VB.net 2005. Consultant had left after six months sticking client with no code, I had 6 weeks to get entire system up and running.

Developers IT, LLC

Ajilon Consulting/PMSLIC Insurance

March 2007 – October 2007

Senior DBA brought in as consultant to assist PMSLIC in Conversion of SQL Server 2000, Oracle 10g, DB2 conversion into SQL server 2005 using SSIS(SQL server Integration Services. Guided PMSLIC DBA team in conversion effort as well as provided detailed plan for migration. Assisted in troubleshooting and training PMSLIC in SSIS package coding and best practices. Delivered SQL Server coding standards to put in place to help with uniform coding across company in SQL SERVER.

Ajilon Consulting & Developers IT, LLC

Oracle/.net developer

July 2005 – Feb 2006

Worked At Department of Welfare assisting in development of code using oracle 10g and .net 2003. Primary job was to assist development team in coding oracle stored procedures and packages to be used with .net application. Second, focus was to incorporate the Itasca (boscoe) framework usage into .net application. Application project was canceled due to awarding of contract to Deloitte consulting.

Ajilon Consulting & Developers IT, LLC

LEAD SQL Server DBA/LEAD ANALYST

July 2001 – July 2005

Senior SQL Server DBA for Department of Welfare of Pennsylvania. Currently in charge of 90 databases, and over 25 developers. Current job entails migration from SQL server 7.0 to SQL server 2000, Managing SQL Server Reporting Services, Oracle 9i and writing PL/SQL statements and other day to day database efforts. Responsible for database design, database Q/A, migration strategy, security, coding, standards, budget, and training state DBA’s to perform role. I have developed the Microsoft SQL server Standards for all state of PA agencies to follow.

Developers IT, LLC LEAD SQL Server DBA/LEAD ANALYST

January 2004 – Current

Assistant Chair for sql server users group State of PA.

Developers IT, LLC LEAD SQL Server DBA/LEAD PROGRAMMER

June 2004

Assisted the Office of General council in rewriting portions of 3rd party application to better meet the needs of governor’s attorneys.

Developers IT, LLC LEAD SQL Server DBA/LEAD PROGRAMMER

January 2002 – Current

Primary applications developer and DBA for Conestoga wood specialties. I have produced four .net applications using ASP/VB.net, SQL reporting services, SQL server 2000 and Crystal Reports. Applications range from payroll, incident tracking, trucking and inventory systems.

Currentech Inc. Director of Technology/Consulting

Jan 2000 – June 2001

Overall technical lead for Currentech Inc. Personally in charge of 15 developers spread out across multiple accounts. Set technical direction of company, developed coding standards, development standards, and trained all staff on current technologies. My responsibilities also include the finding of new work, laying out technical plans for all accounts/Jobs landed, and hiring and firing of technical staff. I am current with all technologies included asp+ beta, visual studio.net beta, SQL Server 2000, Windows 2000.

Currentech Inc. Director of Technology/Consulting

July 2000 July 2001

Lead DBA for SQL 2000/XML project for Verizon Phone Company. I performed everyday database duties as well as designing of stored procedures, functions, and DTS packages that would enable importing clients spreadsheets, flat files, and access databases into existing database to in turn be processed by web based MTS/VB6.0-7.0 system. Handled backup and restore strategies, user permissions, database/object scripting, database normalization, and database design.

Currentech Inc. Director of Technology/Consulting

June 2000 – September 2000

Developed client server application in VB 6, with access backed for Edgewater psychiatric in Harrisburg Pennsylvania. Application will allow director to match therapist and support staff with children based on a number of matching criteria including Childs age/therapist age range restrictions, sex, mental illnesses/therapist qualifications, and location/therapist work location.

Currentech Inc. Director of Technology/Consulting

Jan 2000 – August 2000

Lead developer/DBA for four main visual basic systems for Magellan Health. Was responsible for coding in VB 4-6, Crystal reports 5-7, and SQL server 6.5 – 7.0 Systems included a variety of com based components mostly dll’s to handle interaction between many systems and database. I was also responsible for training and hiring of new Magellan Staff. Lastly, I performed many DBA roles assisting DBA’s in optimizing of query time, triggers, and stored procedure execution, as well as index choices for tables in use.

Currentech Inc. Director of Technology/Consulting

Jan 2000 – April 2000

Project Manager lead team for Large Intranet Component based solution for Printing Company to Track Work Orders. Software developed included advanced, ordering, job tracking and integration with accounting. Performed migration of data from text based DOS environment to NT/95 GUI. Using Visual Basic 6.0 and SQL Server 7.0 MTS, IIS, ASP, COM, DCOM, VB Script, on Microsoft NT/98 platforms.

EDS S.E.

June 1998 – Jan 2000

Assigned to Department of Defense, Department of Finance and Accounting Service (DFAS) as a high-level systems developer. Primary Responsibilities include Define, Analyze, Design, Code, Test, and Document a variety of both client- server and web-based solutions. Experience includes programming in Visual Basic 4-6.0, VBScript, HTML, Oracle PL/SQL 7.0, and ASP 2-3.0. All tools are designed in client/server environment, IBM-NT front end, UNIX Backend, Oracle 7.0 database. Create COM components built in Visual Basic and managed under MTS 4.0. Migrated many components from Visual Basic Client-Server to web platform using COM, ASP 2-3.0, and including JavaScripting for Client-Side event handling. Used Visual SourceSafe 6.0 for version control with large-scale team development.

EDS S.E.

Jan 1998 – June 1998

Assigned to California Welfare account. Responsibilities included Analyzing, Designing, Coding, Testing, and documenting Visual Basic 4.0 Client-Server and IBM COBOL-85/CICS, VSAM, DB2-IDMS database solutions. Primary goal of contract was to assist customer in everyday maintenance of legacy application.

EDS S.E.

Jan 1997 -Jan 1998

Assigned to CIO services 2000. Primary responsibilities included year 2000 consulting, and project lead for a number of fortune 500 companies including Mobil Oil, Phillips Semiconductor, General Motors, and the EDS security system. I was responsible for assessing and renovating all code for year 2000 using a variety of applications, systems, and software platforms DB2, IMS, and VSAM where databases used.

Aerotek/EDS

June 1996 - Jan 1997

Served as conversion S.E. for Navy SPAR C2 contract. Primary job included

Conversion of Navy code from BURROUGHS 68 to IBM 74 COBOL. Additional languages and tools included IDMS, Meta-COBOL, Culprit, and Dyl280.

Professional Certifications:

MCTS(SQL SERVER 2008) 2009

MCTS(SQL SERVER 2005) 2007

MCITP(SQL SERVER 2005) 2007

MCDBA 2000

MCSE 1999

Publications:

I have posted two articles and several responses to www.sqlservercentral.com

Speaking/Training:

Provided one on one training to General Counsel, State of PA

Education:

Pennsylvania State University

York Campus Associate

Computer Science - 1995

Contact this candidate