Principal Systems Engineer Resume Blue Ash, Ohio - Hire IT People

SUMMARY:

Well rounded technology expert with a strong background in Applications, Data, Infrastructure, Operations, and Security. Looking for a great team centered around learning and collaboration and focused on building a world - class data platform.

PROFESSIONAL EXPERIENCE:

Confidential, Blue Ash, Ohio

Principal Systems Engineer

Responsibilities:

Upon joining Confidential, I successfully revived stalled subsidiary integration projects.
Reviewing applications and infrastructure systems and working with subject matter experts and business stakeholders to plan and implement the consolidation of application monitoring, support, and hardware resources according to Confidential standards.

Confidential, Blue Ash, Ohio

Systems Architect

Responsibilities:

Led database administration team as the data platform owner responsible for ensuring fault-tolerance, performance, and recoverability of a $150MM 24/7 highly-transactional multi-terabyte database environment (10 TB, 16 Servers, 16 AG, 200 Cores)
Led a successful hands-on proof-of-concept data warehouse project (data lake) using HDInsight (Hadoop) on Microsoft Azure with the idea that it would allow the company to consolidate and analyze large amounts of data using a wide variety of tools.

Confidential, Blue Ash, Ohio

Database Administrator

Responsibilities:

Directed DBA workload and projects for data engineering and established “Data Services” department
Responsible for data modelling and ETL/ELT development for data warehouse
Set direction for Sr. and Jr. DBAs to ensure system performance, backups, and 24/7 support
Worked closely with application architects to develop data models for new application features
Organized/spearheaded data integration for “rapid Paycard” (acquisition)

Confidential, Blue Ash, Ohio

Application Engineer

Responsibilities:

Led a successful large-scale data conversion involving hundreds of tables for a 10TB production database--six people under my direction across a series of milestones for a total system redesign with hard cutover
Developed complex T-SQL for reports, analytics, data blending, cleansing, and applications; mentored analysts and report writers on SQL
Developed many SSIS projects/packages converting data, transferring files (SFTP), and loading tables with billions of rows utilizing ETL and ELT methods
Developed applications/scripts using C#, PowerShell, and T-SQL to prepare and verify proper file formats and process batches of data through APIs--using the language appropriate to each situation
Coached analysts, developers, and report writers on T-SQL features and query optimization (joins, set operations (union), correlated sub queries, analytic functions, grouping, aggregation, temp table and table variables, indexing, sargability)
Vetted data models to ensure application requirements were met and database access was optimized for high volume (design indexes and suggest changes to application code)
Used “downtime” to perform in-depth application security analysis, identifying and resolving numerous attack vectors and compliance violations. Conducted developer OWASP training.

Confidential, Hillsboro, Ohio

Systems Analyst

Responsibilities:

Successfully implemented an application integration and upgrade for a Microsoft Access-based application to SQL Server and automated the exchange of information between the ERP system
Managed a complex security appliance (Firewall, IDS/IPS) to isolate/secure the ERP environment
Performed penetration testing on ERP web application and network (network and application security)

We provide IT Staff Augmentation Services!

Principal Systems Engineer Resume

Blue Ash, OhiO

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship