Oasis

Oasis specializes in custom cloud solutions for complex, mission-critical
workloads. Hyper-focused on performance and compliance, Oasis
builds and manages custom private clouds that integrate high-
performance hardware, network infrastructure, cybersecurity, disaster
recovery, and a variety of managed services to provide a comprehensive cloud solution. The international company is
headquartered in Los Angeles and London with distributed operations
in five countries.

Director of Database Administration

SQL Solutions Group

Professional Services:
• Built and enhanced Salesforce CRM to/from Epicor ERP process using SSIS 2017 and C#
• Utilized SentryOne Task Factory Salesforce REST API with C# to pull/push data
• Created reports using SSRS 2017 to proactively identify gaps in data and correct data
• Documented source-to-destination mapping
• Synced, pulled, pushed the project from/to GitHub using Visual Studio
• Analyzed SSISDB and applied log retention best practices
• Enabled PowerBI logs to identify data refresh problems
• Integrated with Active Directory to pull user info to match CRM accounts using SSIS
• Fixed setup problems with Epicor ERP and Dynamics AX
• Created updatable SSRS reports
• Designed a process to create a lockbox files from credit cards exports

Sr. Consultant – DBE/Developer

Managed Services:
• Created workflows using Process.Street to standardize on-boarding of new clients
• Performed Health Checks and provided recommendations
• Installed, configured, and upgraded SentryOne SQLSentry
• Utilized SentryOne SQLSentry and Plan Explorer to improve database performance
• Used Devolutions Remote Desktop Manager to manage various clients servers
• Managed public cloud architecture on Microsoft Azure and AWS
• Upgraded SQL Server 2008/2008 R2 to SQL Server 2016 instances
• Employed Microsoft Assessment and Planning Toolkit to discover SQL Server instances
• Applied PS.Core with dbatools.io and PowerShell ISE/VS Code to develop a new health check process
• Monitored issues with OpsGenie and opened tickets in Jira KANBAN board
• Provided guidance and direction to move on-premise infrastructure to AWS public cloud
• Adopted an open source Audit framework to record all the server/database changes (www - who, when, what) 
• Recommended to stop unnecessary/unused SQL Server related services to free up resources
• Identified and alerted on client gaps in business continuity plans
• Proactively analyzed performance bottlenecks and provided solutions
• Setup Always On AG and Transactional Replication to offload reporting needs to another server
• Tapped into Ola Hallengren’s scripts for routine maintenance tasks
• Setup/migrated to multi-subnet SQL Server Failover Cluster Instance (FCI) using Windows 2019 Server Failover Cluster (WSFC), SQL Server 2019 Standard Edition on AWS EC2, and SIOS DataKeeper Cluster Edition
• Evaluated and migrated instances from on-prem to AWS EC2 and then AWS RDS
• Created offsite database backups (AWS S3 bucket)

Sr. Consultant – SQL Server Architect/DBA

Beautycounter

Highlights:
Earned a Data Steve nickname by promoting a data-driven culture throughout the company
Articulated and presented a data road map to help the company drive business decisions based on facts/data
Revolutionized company access to the data by replacing aging historical OLTP-based reporting (1-month look back only) with near real-time OLAP reporting data (all times lookback)
Brought disparate data sources (SAP S4/HANA, MailChimp, SailThru, Square, ZenDesk, PureCloud, Narvar) into DataMarts and then into a DataWarehouse, a centralized place for all different company systems to provide a holistic picture of a company performance using descriptive and predictive analytics

Leadership:
Managed the Team
Motivated Team members to reach their full potential
Administered culture of a constant flow of communication and feedback
Leveraged Trello and Spoke to provide efficiency, transparency, and accountability

Infrastructure:
Managed to fine-tune AWS DMS via AWS CLI to reduce latency between source and target to 60 seconds
Lead an effort to improve OLTP (SQL Server) performance with deep level index analysis, removal of unnecessary indexes, creation of clustered indexes on heap tables, and defragmentation of 200+ existing clustered and non-clustered indexes to boost performance by 5 X times
Setup Power BI dashboards, reporting, and apps

Staff augmentation:
Augmented DBA functions (scaling up to 24x7 support) using RDX Remote DBA services company 
Signed an SME to replace an old Active Directory to a new one on AWS including connecting to a company on-premise AD
Brought in an expert in Entity Framework to analyze performance bottlenecks

Data Hygiene Project:
Solicited RFPs from multiple vendors (Melissa, Valid, 360Science, Epsilon, and Experian)
Prepared side-by-side comparison to provide metrics on QoS, pricing, and implementation
Designed a process to validate/fix/append 1.3M+ customer information and de-dup to help with Direct & Email Marketing campaigns efforts

Lead, Database Architecture and Engineering Team

Helped business to increase revenue, optimize cost and boost profits
Environment: SQL Server 2017 on AWS EC2 (OLAP)
Analyzed requirements and created a Data Warehouse (dimensional modeling using star schema) with facts/measures and dimension tables
Utilized CDC w/SSIS to get real-time OLAP data
Enabled Dedicated Administrator Connection and Resource Governor to create a stable environment

ETL:
Built SSIS packages to populate the DW
Utilized BIML Express to save time on creating SSIS packages
Enhanced SSIS with CozyRoc SSIS+ components (Square/Zendesk/MailChimp/PureCloud REST Components)
Upgraded SSIS packages from full/partial load into an incremental load by leveraging CDC 
Employed OData to extract data from SharePoint 2016 Lists
Implemented a feed (floatrates.com) to source daily currency exchange rate changes (SSIS/XML) to convert multinational revenues to USD

Reporting and Database Development:
Created Data Governance reports using SSRS
Worked closely with Accounting, Finance, Sales, Marketing, Operations, Product Management, Email Marketing and Customer Service to develop Reports, KPIs and Dashboards, DataFeeds using SSRS/SSIS
Built Customer LTV and RFM models, Product/Catalog Matrix, Fraud Detection, CustomerList upload for Facebook Ads and MailChimp and SailThru
Enabled SSRS subscription delivery via email and file share
Established Product/General Ledger feed for Microsoft Dynamics GP
Created Vendor disbursement payment profiles feed for SAP consumption using SSIS 2017 that uploads added and updated records to SFTP (using CoreFTP command line)
Implemented CLR function to decrypt sensitive information
Utilized SAP HANA Studio, and SSIS 2017 in conjunction with SAP ODBC drivers to create constant data pull from SAP HANA
Made 10 custom reports for Ops Team based on SAP S/4HANA data using SSRS and T-SQL 
Utilized ApexSQL Refactor to standardize T-SQL code 
Employed MERGE to capture new and changed data elements
Developed Multi-Dimensional SSAS Cubes

Sr. Data Engineer - Data Architecture and Descriptive Analytics on SQL Server 

Environment: SQL Server 2012 on AWS RDS (OLTP) with SQL Server 2017 on AWS EC2 (OLAP)
Spearheaded adaptation of MinionWare BACKUP, CHECKDB, and REINDEX tools to replace native SQL Server maintenance plans for routine check-ups
Pre-sized volumes for AWS EC2 SQL Server 2017 instance
Configured DatabaseMail, Operators, and Jobs for real-time alerting 
Boosted server performance and enabled real-time data from AWS RDS
Installed, configured, patched and administered Server 2017, SSIS, SSRS and Report Portal on AWS EC2
Utilized AWS DMS with homogenous SQL Server replication (Endpoint, Replication, Lambda, and CloudWatch Events) to replicate data from an OLTP server to an OLAP server
Scaled-up and upgraded (in-place) AWS RDS SQL Server 2012 from Standard to Enterprise Edition
Enabled AWS DMS ongoing replication with Change Data Capture for real-time transactional data
Scaled-up and upgraded (side-by-side) AWS EC2 SQL Server 2017 from Standard to Enterprise Edition
Provided Performance Tuning Optimization reviews using SentryOne Plan Explorer
Surveyed SQL Server security perimeter and created a plan to match industry best practices
Analyzed unused database objects and worked on cleanup
Configured Full Text Search to search through order notes to identify fraud orders
Assessed required user activities and provisioned access
Created database maintenance plans to backup, check integrity, and apply retention policy
Worked with the PwC Auditing Team to share the data
Configured AWS Route53 to connect hostnames and public/private IPs
Utilized PowerShell to check on instance connectivity
Tested Disaster Recovery by restoring all database backups (msdb, ReportServer + SSISDB with encryption keys, and user databases)
Enabled AWS VPC pairing to bridge between different local network inside AWS public cloud
Utilized SYNONYMs to save time by shortening and obfuscating database object names
Enabled Machine Learning (Python 3) on SQL Server 2017 to support basket analysis (apriori algo)

Sr. Data Engineer - AWS infrastructure 

Community Health Group

Initial Health Assessment project
Environment: SQL Server 2012, SSIS 2012, C# with SSMS 2017, TFS 2015
Familiarity with TriZetto QNXT database schema
Built 10+ reports using SSRS 2012 per business requirements
Leveraged OFFSET and FETCH to support database-based paging
Utilized SYNONYMs to save time by shortening and obfuscating database object names
Employed MERGE for daily data refreshes
Evaluated Change Data Capture a.k.a. CDC to support auditing needs
Scripted out all the objects using Visual Studio and checked-in to TFS

Sr. SQL Developer

JAFRA Cosmetics USA

BI Reporting project
Environment: SQL Server 2016, SSIS 2016, C# with SSMS 2017, TFS 2015
Created 25+ reports using T-SQL for Excel-based consumption
Developed 20+ reports using SQL Server Reporting Services 2016 (drill-through, charts, etc...)
Scripted out all the objects using Visual Studio and checked-in to TFS 
Built packages using SQL Server Integration Services 2016 to consume data from SAP ECC
Created ad-hoc queries using PL/SQL and Oracle SQL Developer to consume data from SAP Hybris

Principal Database Engineer

Valid

Environment:
SQL Server 2008/2008R2/2012/2014
Windows command line, Batch files, 7z, osql, sqlcmd, bcp, 
T-SQL, BULK INSERT, LogShipping, transaction log backups aka trn files, RESTORE WITH RECOVERY/NO RECOVERY/STANDBY
PowerBI, Visual Studio 2015, SSIS 2016/C# 2015, SSIS 2014/C# 2012, SSRS 2014/2016, SSMS 2014

Miscellaneous:
Leveraged CSC.exe/DLL/CLR/C# for string clean up manipulations
Employed SQL Server Spatial data and functions to match DMA areas based on longitude and latitude
Utilized ASCI ActiveBatch: Folders, Plans, Jobs, Queues, and Triggers, Variable, and System Views to schedule repetitive tasks

Sales and Marketing optimization for Weissman Dance Costumes:
Implemented BlueHornet ESP Web API using SSIS 2014, C#, and XML
Developed a custom SSIS XML Source Data Flow control to parse XML files
Leveraged SSIS 2014 and SQL Server 2014 to load the data
Consumed IIS 8.0 weblogs using SQL Server 2008, SSIS 2014, C#
Ingested Retail Activity (OrderHeaders, OrderLineItems, and OrderCharges) text files using SQL Server 2014, SSIS 2014, C#

Sales and Marketing optimization for Vein Clinics of America:
Automated daily backup files SFTP download based on CoreFTP core functionality
Architectured a synchronization of 2 databases between 2 disparate physical locations (Chicago and Los Angeles)
Leveraged Transaction Log Backup files with SQL Server 2008 R2/2014, SSIS 2014 to keep it in-sync
Enabled Log Shipping in STANDBY mode to support "near-simultaneous" reads/writes
Ingested various lead generation sources using SQL Server 2014, SSIS 2014, C#
Consumed various Media campaigns sources applying SQL Server 2014, SSIS 2014, C#

Sr. Database Warehouse Architect

Bank of America

DOJ and CFPB metrics:
• Created new tests per new mortgage compliance regulations
• Modified existing tests to align with mortgage compliance regulation changes

SQL Server SME:
• Guided developers on the latest T-SQL best practices
• Improved existing code-base by providing feedback to developers thru peer review process
• Provided ongoing mentoring, coaching and knowledge transfer on SQL Server to Bank's employees
• Co-authored department-wide 40+ pages long best practices document

Sample Automation Framework:
• Automated, combined and improved over 150 manual T-SQL-based test scripts
• Identified staging table candidates from commonly used tables to reduce resource contention
• Enhanced and added new features to SSIS 2008 automated sampling framework
• Identified all the user permissions and mapped them to a service account
• Promoted the process to a fully automated and scheduled execution using SQL Server Agent
• Created an Audit Trail mechanism to log all the database object level/DDL changes

Ad-hoc querying guide: 
• Authored a comprehensive 35+ pages long user guide 
• Expanded on various access techniques: Linked Server, OPENROWSET, OPENQUERY 
• Compared side-by-side static and dynamic SQL methods (accompanied by code samples)
• Highlighted the differences between Windows and SQL Server authentications
• Incorporated detailed comparison between each access and authentication approaches
• Included code snippets to speed up reuse, adoption, and implementation

Sample Dependency Framework:
• Gathered and analyzed requirements
• Designed and created a solution that uses SQL Server 2008/2012, C# and SSIS to stage the data
• Leveraged SSIS to integrate data from: DB2 iSeries/VMS/UDB/AS400, Teradata, Oracle, SharePoint, MySQL/Workbench
• Enabled fail-safe execution of dependency processes (stored procedure and/or SSIS package)
• Created a daily HTML-based email report with color-coded status table
• Upgraded from SSIS 2008 to SSIS 2012
• Documented the solution

Sr. SQL Server Consultant / IT Program Manager

Segment Interactive

Managed 4 offshore (Eastern Europe) developers on the following 4 projects:
DW Architecture & Development:
• Analyzed business requirements and designed DW solution using SQL Server 2008 R2, SSIS & C# 
• Designed ETL processes to consume data from Adobe Omniture/Google Analytics sources
• Implemented complex business logic for analytical purposes using SQL Server 2008 R2, SSIS & C#
• Experienced in handling multilingual data (Windows 1251: Cyrillic)

Data Acquisition Framework (Database Development): 
• Gathered requirements and evaluated existing solutions
• Created database objects to support the framework
• Designed and implemented highly reusable SQL Server table-driven SSIS-based solution
• Utilized FileStream with FileTable to act as a File Watcher process
• Implemented various delivery methods (FTP/HTTP/Open Socket) and archive functionality
• Employed the Framework to act as a trigger to different feeds

Very large database (“VLDB”) setup:
• Pre-sized and configured TempDB files
• Enabled Instant File Initialization to speed up data file allocations
• Boosted performance using Page-based Data Compression 
• Utilized database snapshot for deployment rollback purposes 
• Archived data out to increase performance
• Partitioned large tables between different File Groups/Database Files
• Prevented creation on new objects on PRIMARY File Group using DDL triggers

VP, Data Architecture

Outlook Amusements

Database Administration:
• Installed, upgraded and configured SQL Server 2008/2008 R2
• Applied SQL Server 2008 Service Packs
• Administered clustered (Active/Passive) and stand-alone SQL Server 2005/2008/2008 R2
• Implemented Business Continuity policy using SQL native and Quest LiteSpeed backup utilities
• Analyzed dependencies, implemented, delivered and documented replacement of SQL Server boxes 
• Performed proactive performance tuning optimization
• Managed code reviews for Database Developers
• Mentored SQL Server best practices
• Enforced database objects naming convention using SQL Server 2008 Policy Framework
• Produced process to correct orphan database/job ownership using SQL Server
• Released code to Production

Technical Lead for StrongMail (PostgreSQL-based) MTA Appliance enhancement project:
• Analyzed existing StrongMail to SQL Server data pull process for reporting purposes
• Mitigated the risk by switching to an official 64-bit compatible PostgreSQL OLEDB driver
• Researched and implemented brand new process using SSIS, SQL Server and C# 
• Boosted performance by utilizing parallel processing capability of SSIS
• Achieved higher data availability leveraging SSIS Raw File Component
• Upgraded the process to support simultaneous work of 2 StrongMail boxes using Indexed Views 
• Rewritten and enhanced Email Feedback Loop (FBL) process using AAMailServer, SSIS and C#
• Rebuilt and improved Email Soft & Hard Bounce processes using SQL Server, SSIS and C#
• Introduced a process to help correct subscribers email addresses using SSIS Fuzzy Lookup
• Created a real-time drill-through performance SSRS reporting for SSIS packages
• Produced 15+ SSRS reports for Marketing/Finance/Executive Teams
• Utilized pgAdmin for administration

Database initiatives: 
• Demonstrated SSRS 2008 R2 features and capabilities 
• Finalized SQL Service Reporting Services adoption as a companywide reporting tool
• Produced full documentation for Company Reporting environment

Production Sr. SQL Server DBA/Developer (Database Engineer)

EQUATOR®

Development DBA:
• Introduced Full-Text Index Search to improve text-based execution performance
• Developed scripts to automate repetitive database administration tasks
• Provided performance tuning optimization (PTO)
• Established Database Mail to enable fast & streamlined status reporting 
• Mentored SQL Server Standards and Best Practices
• Performed regular T-SQL code reviews
• Applied advanced T-SQL Error Handling

	Database Development:
• Redesigned Agent Accounts Merge process to offer scalability and fail-safe execution
• Lead alternative solutions for SSIS repository, deployment & error handling 
• Created SSIS real-time performance monitoring using SSRS
• Trained SSIS naming convention
• Demonstrated SSIS framework architecture design
• Presented BIDS Helper Visual Studio add-in
• Worked on data extracts (loan/mortgage data) from ODS for various clients

SQL Server DEV DBA

Motto: DATA is my passion! 
Servant Leader | Cloud DBA | Database Developer/Engineer
Blogger @ https://www.datasteve.com
AWS/Azure/GCP Data Platform Engineer/Architect, Microsoft Data Platform Enthusiast & Data Therapist
COZYROC-Star, Melissa MVP, SentryOne PAC 
Strategical thinker, energetic leader, manager (and hands-on contributor). Passionate Microsoft Data Platform enthusiast with an MBA and 15+ years of experience in Technology and SQL Server combining Administration/Business Intelligence/Advanced Analytics with domain knowledge in the following industries:
eDiscovery
Investment Banking
Real Estate Marketing
Banking and Mortgage Compliance
Entertainment and Online Media
Retail and eCommerce
Direct Mail and Email Marketing
Healthcare, Cosmetics, and Skincare
Technical Consulting
Non-profit

Taplio

Steve Rezhener, MBA's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Steve Rezhener, MBA's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Steve Rezhener, MBA's Linkedin Analytics