Krisztina Hickey

**** ******* ******, ******, ** 80138 ad1uw9@r.postjobfree.com 720-***-****

SQL Database Administrator Database Architect

Over twenty years of applied, progressive work experience to all aspects of database availability, architecture, migration, development, deployment, capacity planning and tuning.

Strong background in On-Premise and Cloud technologies with enterprise Devops and Secops solutions as well as experience with migrations to cloud solutions.

Knowledge and experience in SQL, NOSql, and Document based Transactional and Access Pattern based environments, Replication, Availability Groups, Sharding and Clustering.

Multi-database platform experience for Document Database, Business Intelligence, and Warehouse capabilities.

Database architecture and modeling experience with associated Documentation and Standards.

Knowledge and Experience in Relational and Non-Relational Database Design and Relational Theory along with Access Patterns based Tuning.

Knowledge and Experience in Schema Migrations for Conversions from Relational to NoSQL databases.

Experience in database Health Monitoring, Alerting, Job Automation and Notification.

Experience in data objects including Extensions, Stored Procedures, Partitioning, Indexing (GIS included), Archiving, Derived tables, Dynamic Views, and SQL Optimization.

Knowledge and Experience with High-Availability and Recoverability technologies, including Multi-node Clusters, Elastic Beanstalk, and Corporate Disaster Recovery efforts On-Premise or Cloud.

Experience to Analyze and produce Capacity Planning models for environments.

Documenting database systems Implementation recommendations.

Organized, Productive, Excellent project management, communication and coordination skills.

Recognized as a top contributor with a creative mind, an ability to encourage cooperation, mentor with an enthusiastic thirst for knowledge and a desire to exceed the expected standard of performance to complete projects.

Technical Proficiencies

Installing, Maintaining and Upgrading High Availability Solutions including Sharding, Clusteing, Windows Clustering, DH2i DxEnterise Solutions, and Always ON Availability Groups. Powershell, OLTP Replicated Environments, Performance Tuning Queries, Server Processes, Cloud Storage and Computing, Control M, Informatica

SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 SSIS, SSAS, ERWIN Datamodeler, Report Server, Postgresql 15,14, 13, 11, Oracle 12c, Db2 LUW 11.5, Azure, AWS, Google Cloud, Informatica PowerCenter, DymanoDB, MongoDB

Professional Experience

VARIOUS CONSULTING\MIGRATION PROJECTS 2021-CURRENT

CLIENTS INCLUDED GAF, KPA., TRANSAMERICA, STARZ, UNISON, DIGNITY HEALTH

WORKED WITH DEVELOPMENT TEAMS ON-PREMISE AND CLOUD SOLUTIONS TO MIGRATE SERVICES TO AZURE SQL AND POSTGRESQL (INCLUDING CITUS EXTENSION) and AWS RDS AND AURORA TO MEET CORPORATE REQUIREMENTS.

WORKED WITH INFRASTRUCTURE TEAMS TO MIGRATE MONGODB SOLUTIONS FROM ON-PREMISE TO CLOUD MANAGED SOLUTIONS

AUTOMATION OF ADMINISTRATION, SOURCE CONTROL, CI/CD PIPELINE BUILDS, AND DEPLOYMENTS USING GITHUB AND REDGATE TOOLS

PROVIDED DEVELOPMENT, QA, UAT SUPPORT AND MAINTAINED THE ENVIRONMENT SECURITY, GOVERNANCE, AND HEALTH.

PERFORMING BUSINESS INTELLIGENCE, TABULAR SUPPORT, MANAGING DEPLOYMENTS AND PERFORMANCE TUNING THROUGH SDLC LAYERS

TRANSAMERICA CORPORATION

LEAD SENIOR SQL SERVER DATABASE ADMINISTRATOR (SQL DBA) 2018 - 2021

WORKING WITH PRODUCTION ON-PREMISE AND CLOUD SOLUTION TO DELIVER SUPPORT TO 1000+ SERVERS (ACROSS MULTIPLE CONTINENTS FOR A GLOBAL CORPORATION)

LEVEL 4 MAJOR INCIDENT SUPPORT WITH ON CALL.

PERFORMING BUSINESS INTELLIGENCE, TABULAR, CUBE SETUP AND SUPPORT, MANAGING DEPLOYMENTS AND TUNING THROUGH SDLC LAYERS

EXPERIENCE WITH HA, AG, REPLICATION AND ELASTIC BEANSTALK

AUTOMATION OF ADMINISTRATION AND INVENTORY MANAGEMENT TASKS

LARGE SCALE PROJECT ARCHITECTURE EXPERIENCE FOR MIGRATION TO CLOUD

AUTOMATION UTILIZING CONTROL-M, INFORMATICA AND AGENT CONTROLLED SSIS PACKAGES

CENTURA HEALTH

SENIOR SQL SERVER DATABASE ARCHITECT (SQL DBA) 2016-2018

WORKED WITH PRODUCTION OLTP DATABASES RUNNING LOCALLY/REMOTELY 1000+ SERVER (ACROSS MULTIPLE HOSPITALS AND REGIONS)

PERFORMED INSTALLS, UPGRADES, VERSION AND SERVER LEVEL MIGRATION (SQL 2005, 2008 TO 2014 AND 2016) AND LEVEL 4 MAJOR INCIDENT SUPPORT WITH ON CALL.

IBM GLOBAL SERVICES (CONTRACTOR)

LEAD SQL SERVER DATABASE ADMINISTRATOR (SQL DBA) 2008-2016

WORKED WITH PRODUCTION AND NONPRODUCTION DATABASES (OLTP AND BI) RUNNING LOCALLY/GLOBALLY 2600+ INSTANCES.

PERFORMED INSTALLS, UPGRADES, INPLACE AND MULTI-TIER MIGRATIONS (UP TO SQL 2014) AND LEVEL 4 MAJOR INCIDENT SUPPORT ON A 24X7 BASES WITH DAYSHIFT\ROTATION\ON CALL.

NOT EMPLOYED BUT PART TIME - MY SON WAS DIAGNOSED WITH CANCER 2007-2008

IBM GLOBAL SERVICES (FTE) 2004-2007

LEAD SQL SERVER DATABASE ADMINISTRATOR (SQL DBA)

WORKED WITH LARGE PRODUCTION DATABASES (VLDB’S) DATABASES RUNNING LOCALLY/REMOTELY 525 SERVERS, 1000+ INSTANCES.

PERFORMED INSTALLS, UPGRADES, TROUBLESHOOTING, MIGRATION AND SUPPORT.

COMPREHENSIVE SOFTWARE SYSTEMS, DENVER, CO 2001-2003

LEAD DATABASE ADMINISTRATOR / ARCHITECT

LED A TEAM THAT INSTALLED AND SUPPORTED TRANSACTION PROCESSING (OLTP) SYSTEMS FOR MORTGAGE BROKER FIRMS TRADING ON THE STOCK EXCHANGE.

TUNED AND OPTIMIZED QUERY PERFORMANCE OF VERY LARGE DATABASES (UP TO 4.7 TB PER APPLICATION).

VARIOUS CONSULTING POSITIONS 1996-2001

DATABASE ADMINISTRATOR/ARCHITECT/REPORT WRITER

CLIENTS INCLUDED IBM, TEKSYSTEMS, LAW.COM

I WORKED WITH ANALYSTS, ARCHITECTS, DEVELOPERS, AND CUSTOMERS TO UNDERSTAND DATABASE REQUIREMENTS AND TRANSLATE INTO DATABASE DESIGNS/SOFTWARE.

EDUCATION

REGIS UNIVERSITY, DENVER, CO

MASTER OF SCIENCE IN INFORMATION SYSTEMS/DATABASE TECHNOLOGIES (CURRENTLY ATTENDING)

BACHELOR OF SCIENCE, INFORMATION SYSTEMS 2000

Contact this candidate