Jack Nicholas Email & Phone Number

Chicago, Illinois, Us

Authored a collection of microservices to support cloud migration from SQL Server data warehouse to AWS data lake. Including common ETL and data engineering workflows: SQLServer-to-Parquet (via PySpark script in EMR), Redshift-to-Redshift, CSV to Redshift.Pipelines/workflows built leveraging AWS serverless architecture including Elastic Map Reduce (EMR), Elastic Container Service (ECS), API Gateway, Lambda, DynamoDB, Redshift, S3. The asynchronous queues are serviced by python-based workflow where Docker images run in ECS tasks within FARGATE containers on an ECS cluster. Used Django framework to present dashboard that tracks the progress of requests within a single pane of glass. Additional configuration functionality offered includes load balancing, throttling, & priority setting.

Jersey City, Nj, Us

Built a set of tools to support data lake pilot project. Leveraged AWS Data Migration Service (DMS) to copy SQL Server tables as parquet files to Amazon S3. Used AWS Glue to integrate the files and AWS Athena to query them. Created simple stored procedure API that adds table level asynchronous requests to workflow queue. Set scheduled Python scripts to run in Task Scheduler on AWS EC2 Windows instance and managed steps of workflow. Automated quarterly database security review process. Crafted application, using ASP.NET MVC web C# as front end with SQL Server as back end. Designed to produce comprehensive artifacts to satisfy rigorous audit requirements.Automated SSAS cube from staging area to production. Solution employed SQL Agent jobs that managed workflow, using T-SQL to dynamically script XMLA backup and restore code. Authored SharePoint site with how-to documentation related to vast database environment.Straddled both DBA and SAN responsibilities with heavy focus on data migration between data centers. Worked with data owners, internal auditors, and external auditors to demonstrate company compliance.

Zurich, Ch

Provided development and production support for the Equity Trading SQL Server Platform. Handled legal and regulatory reporting inquires.Planned and implemented database disaster recovery procedures.Introduced table compression into the SQL Server 2008 environment. This freed up enough space to keep all historical databases online.

Jersey City, Nj, Us

Managed Argus’ SAN that connects 3 petabytes of SAN storage to over 30 SQL Server databases. Wrote a custom interface for Xiotech's Intelligent Storage Element (ISE) SAN using Visual Basic as the front end, simplifying the administration of over one hundred independent SAN devices Managed and executed conversion of multi-server environment from SQL Server 2000 to SQL Server 2005. Managed and executed conversion of multi-server environment from SQL Server 2005 to SQL Server 2008. The impetus for this conversion was to leverage SQL Server 2008’s data compression feature.Designed extensive backup TSQL code to efficiently manage the backups of the over 3,000 databases in the SQL environment. Utilized Microsoft Reporting Services to expose monitoring reports.Mentored DBA team in best practices for managing big data and the vast SQL Server installations. Ensured disaster recovery readiness for the over 3,000 production databases.

Rye Brook, Ny, Us

Managed data conversion from legacy Microsoft Access databases into centralized SQL Server database. Implemented SQL Server Replication to facilitate separation of transactional and reporting databases.Planned and implemented database disaster recovery procedures.Managed complex data model using Visual Paradigm.