SQL Server DBA
Resume:
Martin Marczewski
Melbourne, FL *****
********@******.**
US Citizen
Clearance: DoD SECRET
https://www.linkedin.com/in/dbahomer/
Mission Statement: Achieve Sustainable Competitive Advantage by leveraging full Information
Technology alignment with Business and Data Security requirements.
Career Objective: Database Architect, Principal or Sr. Database Administrator,
Competencies: Impeccable track record of Turning Around Problem Areas especially in performance and designing VLDB architecture.
Expert in Quantitative/Analytical problem-solving approach.
Knowledgeable in Applied Math, Statistical Methods, Modeling, IT Integration, Engineering and Administration.
Analytical, Innovative and Resourceful. Strategic Thinker and Team Builder.
Has broad overview of patterns, standards, and trends in the IT industry.
Twenty years of progressive experience in providing strategic vision, sound IT management and leak-tight information security.
Interests: Operations management and optimization of complex IT systems.
Education: MBA (2006); B.S. (Geophysics, 1994). California State University Long Beach
IT Operations Expert:
• Full IT Operations Life-Cycle
* IT Reorganization/Business Realignment.
* Business Process Innovation (BPI).
* Operations Management/Control (ITIL, 6sigma, SDLC, Agile, SCRUM).
* In-depth understanding of RDBMS as they relate to e-commerce, B2C, B2B, EDI.
• In-Depth understanding and rarefied expert in operational control:
* Windows infrastructure, virtualization on ESXi and AWS.
* MS SQL Server, clustering, AG replication .
* IDERA, REDGate DBA Tool-belt expert, TFS, GIT, IGNITE.
* Managing hi-performance, hi-volume, HA RDBMS.
* Intimately familiar with 3PAR, PURE, ALLETRA storage.
* OLTP/OLAP/VLDB, e-commerce, RDBMS systems expert.
* iManage Autonomy DMS system: in depth experience
EXPERIENCE:
EdgeCo Holdings (MidAtlantic)
Pittsburg PA 15222
April 18, 2023 – current
Sr. Database Admin (remote)
* Re-architected data archival retention process rewriting existing code and implemented a custom,
based on CASCADE ON DELETE solution.
* Deployed significant code optimizations using Quest and my own solutions, some with 60x
improvement.
* Created great report between DBA and DEV teams based on successes above
* Implemented many of previously developed maintenance solutions, gaining 30 % performance gains
across all platforms.
* Upgrading and migrating all remaining 2003, 2008, 2012 to 2019/2022 converting legacy mirroring
to AG with a dynamic FSW, both on prem and in AWS.
Northrop Grumman Aeronautics Systems (NGC AS)
1500 West NASA Blvd Melbourne, FL 32901
March 30, 2020 – April 18, 2023
Sr. Principal Database Architect (DoD Secret, active) (remote)
* Conducted periodic SQL performance reviews addressing issues with SQL (10 to 98%
improvements) on a few dozens of the most used SQL objects providing critical TABLEAU reporting for AS sector customers.
* Created several breakthrough solutions (9/80 Aging Function, SecureDatabaseModel (SDM) concept
which is utilizing:
Transport Encryption, TDE, AE, RLS, delivering a layered security allowing for object re-use.
* Developed many sophisticated SSIS packages of an ever-increasing complexity to deliver ETL
secure, stable and salable solutions (3S) to NGC AS customers using T-SQL, C#, Power Shell, Python/Anaconda
* To date: delivered 25% DB performance improvement and reduced storage needs by 72%
* Created ETL pipelines which deliver 25% of all data AS group ingests, 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 any Tableau modifications when data source structure changes.
Southern Glazer's Wine and Spirits
2400 SouthWest 145th Ave., Miramar, FL 33027-4228
Jan 7, 2019 – Jan 31, 2020
Sr. MSSQL Database Administrator
* SQL PTO (Performance Tuning Optimization) expert
* Security and Performance Audits
* Managed several thousands of SQL Sever databases on 150 of AlwaysOn instances, 111 TB of flash
* RE-Architected maintenance via parallel stats updates, BLAZINGLY fast and effective,
* PowerShell automation for AlwaysON monitoring: HEALTH, Data-Loss RPO/RTO,
SQL Agent JOBs, SQL logins, SSIS packages, SSRS report differences
* Created Centralized CMS server for Multi-Server Administration and SQL jobs control
* Cleaned-up neglected areas where maintenance is dearly needed (SSISDB, msdb)
* Migration of out-of-support SQL 2008 instances to 2016/2017/2019
* Capable of creating dozens of SQL instances and migrate thousands of databases a day
(record: 54 instances, 40k databases ) via Power Shell automation
* Expert in migrating SSIS packages using VS and SSDT; re-architected security of ETL/SSIS/SQL Agent Jobs landscape; created policy document (PROXIFY) for the Entire Glazer's Enterprise
* Capable of addressing and fixing any and all production issues precisely, fast and effectively.
* Deployed distributed Quest FOGLIHT FMS, AgentManager and PerformanceInvestigator instalation;
* My mission: preach and implement The Best Practices..and ALWAYS be ON top of that
VIKING River Cruises
5700 Canoga Ave Ste 200 Woodland Hills, California, 91367-6569
Nov 26, 2018 – Dec 31,2018 (resigned to care for family member in FL)
Sr. MSSQL Database Administrator
SQL Server security audit and performance evaluation. Made few fixes.
KAREO.com
3353 Michelson Dr., Irvine, CA 92612
Dec 18 2017 – Oct 19 2018
Sr. MSSQL Database Administrator
* Effective fixing bugs from day 2 (Job Activity Monitor GUI Refresh)
* Re Architected statistics maintenance process,
1M stats in 40k databases on 51 SQL Instances, on 54 TB)
eliminated Sch-S/Sch-M locks pegging CPU.
* Fixed miss-configured db options affecting the entire instance performance.
* Eliminated CPU/tempdb utilization issues caused by excessive X request_mode waits in TEMPDB and 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 ~300k ms to mere 16 ms.
* Migrated 40k databases (54TB) to ESXi VMWare on prem cloud; created unattended installation scripts, configuration 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 (compliance requirements)
* Replaced an obsolete and fundamentally flawed database maintenance scripts (stats, indexes, backups) with a more intelligent process; re-architected data access methods for analytics
* 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)
222 N Sepulveda Blvd, El Segundo, CA 90245
Feb 1 2016- Nov 24 2017
Sr. MSSQL Database Administrator
* Indispensable in tracking down and fixing data quality issues and resulting from it anomalies
* A “go to” expert for solving design and architectural “special projects”
-in first 3 months resolved performance degradation issues due to M$ bug in Change Tracking
-identified need to create a custom solution to address performance (high CPU from Sch-S/M locking) issues due to auto-created hypothetical statistics on very wide and API customizable tables
-managed performance for 3k databases with hundreds of very wide tables
( up to 1024 columns) ; each Db up to 2.5k transactions/sec
* Proven track record of resolving the most difficult performance, design, architectural and deployment
logistical issues including data security, encryption and data transmission encryption
* Expert in using Nagios and Idera for proactive monitoring and performance problem-solving
* Used TFS/ Power Shell to automate database deployments
Dun and Bradstreet Credibility Corp.
22761 Pacific Coast Hwy, Malibu, CA 90265
2015-2016
Sr. MSSQL Database Administrator
* Spearheaded continuous performance/security audits for incremental improvements of key production MSSQL systems:
-MSDB/SSIS optimization and maintenance for very complex data loads end post-processing
-SQL jobs schedule optimization (tens of thousands of scheduled jobs, almost a NP hard problem…)
-missing/overlapping indexes analysis across thousands of databases
-used ERwin and ERStudio extensively to model, analyze and create the best performing OLAP/CUBE
structures and deploy appropriate (Kimball or Inmon) architecture
-ITIL/SOX compliance
* Migrated hundreds of databases to AWS, with performed sizing and capacity analysis
* Provided on call 24/7 support for ALL AWS based infrastructure
* Productive from day 1 due to extensive library of developed scripts and solution patterns
* Outstanding talent for troubleshooting and finding creative solutions
* Expert in using Nagios and Idera for proactive monitoring and performance problem-solving
TRUECAR.com
120 Broadway St., Santa Monica, CA 90404
2012-2015
Sr. Lead MSSQL Database Administrator, Production Engineering Operations
* Automated, performed and oversaw code deployments to production MSSQL systems
* Provided on call 24/7 support resulting in a steady decrease in the number of outages over time
* In 4 years of tenure wrote 15k lines of code addressing key neuralgic performance/maintenance areas
* Fluent in the use of IDERA SQL Diagnostic Manager?, RedGate DBA Toolbelt (including Backup), GIT HUB
* Accomplishments:
- steadily increased areas of responsibilities to provide full coverage of the environment
- performance reviews: consistently rated in the top 5% of company’s top performers
- contributed to a Continuous Integration Deployment process
* Expert in using Nagios and Idera for proactive monitoring and performance problem-solving
* Created automated deployment/rollback process using Power Shell, RedGate's MULTI-Script, GITHub and Jenkins
SHEPPARD MULLIN RICHTER & HAMPTON LLC.
333 S. Hope St., Los Angeles, CA 90071
2011-2012
Sr. MSSQL Database/ iManage DMS Administrator
* Core duties: administration of about 100 MSSQL instances ranging from SQL2000sp4 to SQL2008r2sp1 and Autonomy iManage 8.5 cluster document management system (DMS) supporting twelve satellite offices globally, including 24/7/365 on-call support for these systems
* Accomplishments: became a true “change agent” a catalyst for vital improvements
- Quickly mastered iManage/Autonomy DMS WorkSite platform administration
- Successfully migrated Autonomy WorkSite 8.2 to 8.5 multi node cluster
- Successfully implemented localization in 8.5 cluster environment, including IDOL indexing
- Successfully upgraded WorkSite Standalone Communication Server 8.5.1 to 8.5.2 load-balanced cluster
- Successfully implemented WorkSite iMobility 8.3.3
- Quickly identified critical MSSQL database performance bottlenecks and eliminated root causes
EDGECAST
2850 Ocean Park Blvd., Suite 110, Santa Monica, CA, 90405
2011-2011
Sr. Microsoft MSSQL Server DBA
* In just several weeks was able to stabilize MSSQL clusters stretched to their maximum capacity (SQL 2008 R2) still, in some cases, gaining up to 200% increase overall processing performance
* Instrumental in reducing NET30 billing processing cycle from 14 to less than 3 days, resulting in increased cashflow
* Completed an exhaustive capacity analysis for a 2-3-year storage growth; engaged vendors in a competitive bidding and was able to achieve below market prices for hardware worth about a million $$ with $ 100k in savings
* completed a comprehensive analysis of existing DB security and created a roll-out roadmap for a fully CIS/SOX compliant security implementation, achieving 20% of all milestones before leaving company
21st Century FOX Entertainment Interactive Media Grp., myspace.com
407 N. Maple Dr. Beverly Hills, CA, 90210
2007-2011
Sr. MSSQL Server DBA, Lead DBA
* Managed and lead team of seasoned engineers supporting infrastructure of over 500 MS SQL Servers and Aster’s nCluster 200 node implementation (Linux/mySQL)
* Key metrics: 500,000+ transactions/sec
400 M+ users worldwide total; 100M unique visitors/month
4.6 million simultaneous users
.5PB in
1500 OLTP databases (64-bit SQL 2005, Windows 2003/2008 EE, SQL clustering)
94GB/s peak total DB throughput
nCluster (ASTER DATA) daily ingest of 1TB/day of data (site metrics)
* Specialized and was responsible for RDBMS platform's infrastructure:
performance, proactive management, maintenance
data security, encryption, secure transmission and integrity
* Key achievements: instrumental in stabilization very volatile RDBMS platform
consistently successful in eliminating root causes of incidents
created essential management tools and operations oriented reports
fine-tuned and automated management/administrative processes
helped to create great collaborative teamwork atmosphere
applied Shannon–Hartley theorem for a predictive systems failure analysis
and to achieve maximum systems consolidation density (number of databases
per system, number of cluster nodes in n+1 cluster instances)
managed engineers responsible for automated SQL instance deployments (via Power Shell)
EDMUNDS, Inc.,
1620 26th Ave., Santa Monica, CA 90404
2006-2007
Configuration Management Sr. Engineer, Technical Services Management
* led company-wide eCMDB re-engineering effort aimed at full alignment of IT and business processes
* Key metrics:
achieving unimpeded 100x/year transactional volume growth
9.5 million unique visits/month managed application generating revenue of $3 million/yr.
17% compound annual revenue growth
* Key achievements:
successfully implemented ITIL and six-sigma methodologies drastically reducing incident rates
EDMUNDS, Inc.,
1620 26th Ave., Santa Monica, CA 90404
2005-2006
Lead B2B EDI Support Engineer
* Applied neural networks self-learning algorithm to increase volume of data acquisition in less time
* Responsible for total process improvement of B2B applications.
* Created functional models of existing systems which helped to identify and eliminate bottlenecks
* Reduced unplanned downtime by 80% insuring success of very aggressive expansion plans.
* Drastically reduced incident and transactional failure rates of new applications by recognizing and eliminating deficiencies early on before they could incur unplanned downtime production costs.
* Responsible for ensuring compliance with contractual SLAs with data vendors.
* Identified critical areas for monitoring. Improved and re-positioned existing process controls
* Lead team collaboration to create a comprehensive monitoring matrix for all enterprise-wide B2B
applications.
* Developed strategy to integrate monitoring data into the flow of live transactions (via marker data seeding).
EXPERIAN CONSUMER DIRECT,
17500 Von Karman Ave., Suite 900, Irvine, CA 92631
2003-2005
Sr. Microsoft SQL Server DBA, Lead DBA
* Responsible for financial data security, encryption, its secure transmission and integrity
* Managed and led DB production operations group
* stabilized very volatile DB platform, implemented best RDBMS practices, SOX compliance and DR
* Led two data-center DB consolidation efforts: consolidated 3 sites into one DC location with a remote DR site
* instrumental in reducing incident rates by 88%
* while increasing transactional throughput 5x
(which resulted in revenue quadrupling in 2 years, to a peak ingress of $150,000/hr.)
* 3million unique visitors/month
* 10,000 simultaneous users
* managed SAN storage environment (EMC/Clariion)
CREATIVE ARTISTS AGENCY,
2000 Avenue of the Stars, Los Angeles, CA 90067
2000-2003
Sr. SQL Server DBA and Intranet and Applications Manager
* upgraded 100+ server environment (NT4 to W2000, SQL6.5 to 2000, MTS to COM+)
saving $750,000 in IT budget over 3 years by consolidating SQL infrastructure
* introduced SAN based clustering to achieve HA and storage consolidation essential for DR
* initiated and implemented MSF based SDLC process
* led application re-engineering efforts and was solely responsible for security of highly sensitive data
TOSHIBA, TAIS-CSE,
9740 Irvine Blvd., Irvine, CA 92618
1998-2000
Manager of Microsoft SQL Server DBA s and Web Operations (TAIS-CSE Div.)
* implemented DR/business continuity plan for the entire division
* responsible for all aspects of operations of toshipbapc.com domain (ftp, web, middle-tier, database
production and per-production environments)
Contact this candidate