Database Administrator Information Technology
Resume:
Martin Marczewski
Melbourne, FL *****, USA.
email: ********@******.**
US Citizen.
Clearance: DoD SECRET.
Education: MBA and B.S. (Geophysics). California State University Long Beach. Website https://www.linkedin.com/in/dbahomer/
Professional
Summary
Database Architect, Principal or Sr. Database Administrator, Achieving Sustainable Competitive Advantage by leveraging full Information Technology alignment with Business and Data Security requirements. Skills MS SQL Server
AG HADR replication
Virtualization ESXi
RedGate DBA Tool-belt/ IDERA
GIT
SQL Performance Optimization
3PAR/PURE/ALLETRA/Nimble
OLTP
Operational control
FCI (n+1) Clustering
Mirroring/Log Shipping
AWS
Quest FogLight/SQL Optimizer
TFS
Hi volume VLDBs
iManage Autonomy DMS
OLAP
Windows Infrastructure
Work
History
EdgeCo Holdings (MidAtlantic)
Pittsburgh PA 15222
April 18, 2023 – March 10, 2025
Sr. MSSQL Database Administrator (remote)
* Deployed significant code optimizations, gaining 30 % in performance (across the board).
* Re-architected data and archival processes by rewriting existing code and implemented an elegant CASCADE ON DELETE solution, reduced storage by 15% to date.
* Implemented ingenious Index/Stats maintenance solution.
* Upgraded/migrated 2008 R2, 2012 and 2019 to 2022 Ent/DataCtr (about 10).
* Converted legacy mirroring to AG with a dynamic FSW (on prem and AWS).
* Proven track record of on-prem db migrations to the cloud (AWS/S3, EC2). Northrop Grumman Aeronautics Systems (NGC AS)
Melbourne, FL 32901
March 30, 2020 – April 18, 2023
Sr. Principal Database Architect (DoD Secret, active) (remote)
* SQL performance optimization (up to 98% performance gains) of SQL for TABLEAU
* Created several breakthrough solutions (9/80 Aging Function, SecureDatabaseModel (SDM) concept utilizing: Transport Encryption, TDE, AE, RLS, delivering a layered security.
* Delivered Secure, Stable and Scalable solutions (4S)T-SQL, C#, Power Shell,Python/Anaconda
* DB performance increased by 25% across the board and storage was reduced by 72%
* Created ETL pipelines delivering 25% of all AS data, while having only 4% failure rate.
* Has functional expertise with Alteryx.
* Developed a fully Dynamic ETL Process (DEP) using Power Shell and fully dynamic data return procedure (streams structured data back from any table), eliminating the need to change table structure, SSIS package, or make any Tableau modifications when data source structure changes.
Southern Glazer's Wine and Spirits
Miramar, FL 33027-4228
Jan 7, 2019 – Jan 31, 2020
Sr. MSSQL Database Administrator (hybrid)
* SQL Performance Tuning Optimization expert; eliminated root causes for almost all outages.
* Managed several thousands of SQL Server databases on 150 of AlwaysOn instances, totaling 111 TB.
* Automated deployment of AlwaysON AGs (T-SQL, PowerShell).
* Re-architected DB maintenance via parallel Stats update, extremely fast and effective.
* PowerShell automation for AlwaysON monitoring: HEALTH, Data-Loss RPO/RTO.
SQL Agent Jobs, SQL logins, SSIS packages and SSRS reports differences.
* Created Centralized CMS server for Multi-Server Administration and SQL jobs control.
* Addressed neglected areas where maintenance was dearly needed (SSISDB, msdb).
* Migrated of out-of-support SQL 2008 instances to 2016/2017/2019 (about 10).
* Expert in SSIS packages migration using VS and SSDT.
* Re-architected security of ETL/SSIS/SQL (via PROXYfying).
* Deployed distributed Quest FOGLIHT FMS, AgentManager and PerformanceInvestigator. KAREO.com
Irvine, CA 92612
Dec 18 2017 – Oct 19 2018
Sr. MSSQL Database Administrator
* Effective fixing bugs from day 2 (fixed Job Activity Monitor GUI Refresh)
* Re Architected statistics maintenance process,
1M stats in 40,000 databases on 51 SQL Instances, on 54 TB)
eliminated Sch-S/Sch-M locks pegging CPU.
* Fixed mis-configured database options affecting the entire environment's performance.
* Eliminated CPU/tempdb issues caused by excessive X request_mode waits in TEMPDB
(timeouts due to RESOURCE_SEMAPHORE waits).
* Fixed 54k ETL jobs having a daily .5% failure rate, current failure rate is ZERO (3 registry hacks)
* Reduced unnecessary TRX log space footprint from 9.3 to 7.6TB giving instances needed space for growth when needed.
* Optimized dozens of procedures reducing run time duration from ~300,000 to a mere 16 ms.
* Migrated 40k databases (54TB) to ESXi VMWare on prem cloud; created unattended installation, configuration SQL scripts, fully dynamic SQL database attach script; everything that was needed to successfully complete the project.
* Migrated 40k databases using SNAP COPY with almost zero downtime ( at a rate of ~1000 databases in 15 minutes ); 4 Hrs for the full migration, fully operational
* Managed HIPPA, CPT, HL7, EHR scripts for provider/insurance/patient compliant data and audits.
* Developed scripts for end-to-end SQL server/database security audits (SOC compliance requirement)
* Replaced an obsolete and fundamentally flawed database maintenance scripts (stats, indexes, backups) with a more intelligent process.
* Created an elegant process to enable ChangeTracking for an incremental Hadoop ingestion
* Expert in using Nagios and Idera for proactive monitoring and performance problem-solving EllieMae.com (Velocify.com, formerly Leads360.com) El Segundo, CA 90245
Feb 1 2016- Nov 24 2017
Sr. MSSQL Database Administrator
* Indispensable in tracking down and fixing data quality and performance issues
* A “go to” expert for solving design and architectural issues
-fixed performance degradation due to M$ bug in Change Tracking
-created a custom maintenance solution (eliminated high CPU from Sch-S/M locks)
* Expert in using Nagios and Idera for proactive monitoring and performance problem-solving
* Used TFS/ Power Shell to automate database deployments Expert: * Full IT Operations Life-Cycle: SCRUM, KANBAN, SDLC
* IT Reorganization/Business Realignment.
* Business Process Innovation (BPI).
* Operations Management/Control (ITIL, 6sigma).
* In-depth mastery of RDBMS as they relate to e-commerce, B2C, B2B, EDI. Skills * MS SQL Server, clustering, AG HADR replication.
* Performance Tuning
* Windows infrastructure, virtualization on ESXi and AWS.
* IDERA, REDGate DBA Tool-belt expert, TFS, GIT, IGNITE.
* Managing hi-performance, hi-volume, VLDB HA RDBMS.
* Data Warehousing, Database Security, Cloud Computing and Data Migration.
* Intimately familiar with 3PAR, PURE, ALLETRA and Nimble storage.
* OLTP/OLAP/VLDB, e-commerce, RDBMS systems expert.
* iManage Autonomy DMS system: in depth experience.
Contact this candidate