Open to opportunities

russell mazelsky

@russellmazelsky

Message

Senior Database Architect delivering BI/ETL, tuning, and scalable data platforms.

United States

Message

What I'm looking for

I’m looking for a Senior Database Architect role where I can own Oracle/MSSQL data platforms, design BI/ETL and data quality processes, and lead tuning and SDLC-ready architectures for large-scale, distributed systems.

I’m a Senior Database Architect with “15 + years of experience” across the full SDLC, specializing in database design, development, administration, tuning, implementation, troubleshooting, and quality management for “large scaled distributed systems.” I lead end-to-end data delivery—designing back ends, validating SQL, and ensuring operational excellence from dev through production.

In my current role as “DATABASE ARCHITECT / DEVELOPER / ADMINISTRATOR,” I act as “Lead Data Architect/DBA/Developer” in a team supporting automated and manual BI and ETL processes, data feeds, and database builds using Oracle and MSSQL plus internet technologies. I create and test “complex SQL queries across multiple environments including PL/SQL, t-SQL, and PRO*C,” and I develop stored procedures, functions, and batch programs to support OLTP updates and ETL ingestion.

I build ETL architectures that scale and stay compliant. For example, I developed an “ETL architectural solution” in MSSQL Server that integrated multiple large data sources into a “single isolated staging environment,” using metadata models to resolve bottlenecks, improve loading throughput, and provide documentation, reviews, and “data analysis summaries” aligned to SDLC and compliance needs.

Across past engagements, I’ve delivered enterprise reporting and data warehousing for healthcare and utility/security environments, working with data volumes from “thousands of rows” to “millions of rows.” I’m at home designing data models and reporting architectures (data profiling, data quality, star/snowflake schemas), converting large PL/SQL estates to T-SQL, and enforcing reliable configuration and security practices—so the business can trust the data and act faster.

Experience

Work history, roles, and key accomplishments

Database Architect

Sempra Energy

Sep 2012 - Jan 2013 (4 months)

Built an ETL architecture in MSSQL Server to integrate large source datasets into an isolated staging environment for Archer schema loading. Profiled, cleansed, validated, and mapped millions of rows for asset security compliance with SOX, using T-SQL and PRO*C while documenting and reviewing the SDLC end-to-end.

MS SQL Server T SQL ETL Data Profiler Data Cleanse SOX Compliance SDLC

Database Consultant

Esignal Corporation

Apr 2006 - Jun 2006 (2 months)

Provided production and application DBA support for Microsoft SQL Server and Oracle 9i, including release management for new production SQL Servers. Wrote and tested SQL Server stored procedures and Oracle PL/SQL, performed performance tuning and troubleshooting, and managed Oracle partitioning, RMAN/Statspack, and SQL*Loader tasks on Linux.

SQL Server T SQL Oracle 9i Pl SQL SQL Tuning Oracle RMAN Statspack SQL*Loader Partitioning

System Configuration Manager

Intuit

Apr 2004 - Feb 2005 (10 months)

Led system configuration management for legacy data warehouse repositories, establishing and enforcing best practices across Oracle and SQL Server. Managed build processes, QA testing, and architectural documentation, and directed teams through multiple enterprise intelligence migrations using Informatica, Business Objects, and Hyperion.

Configuration Management Informatica Business Objects Hyperion QA Testing SDLC

Technical Manager Consultant

Global Training & Consulting Inc.

Nov 2000 - Aug 2001 (9 months)

Managed teams delivering multimedia online training courses deployed on NT Server/IIS 4.0 to support Oracle DBA and Oracle Applications 11i certification. Administered Oracle 8i/9i on Solaris and Windows, supported backup/recovery and tuning for distributed clustered file systems, and handled Apps 10.x to 11i migration gap analysis and Siebel 2000 administration.

Oracle 9i Oracle Solaris Windows NT Apache Backup And Recovery Oracle Apps Installation Gap Analysis

Project Management Consultant

Nortel Networks

Feb 2000 - May 2000 (3 months)

Managed development of a web-based approval system (SBA) with an Oracle backend, gathering and documenting functional and design requirements. Served as test manager and configuration control manager, implemented schema/business rules, and led document/source code control through Visual Source Safe to complete the project on time and on budget.

Oracle 8.X Pl SQL Web Application Development Test Management Configuration Management Visual SourceSafe QA Management Schema Design NetDynamics

Senior Technical Consultant

Jusco Co., Ltd.

Apr 1998 - Dec 1999 (1 year 8 months)

Provided enterprise-level technical guidelines and analyses for future IT systems, leading evaluations for multiple major software systems and coordinating vendor technical demonstrations. Directed data warehousing efforts including business process/data modeling, migration/integration strategy, and enterprise operational tooling assessments (e.g., JP1/JP Walker, CA Unicenter/Tivoli).

Data Modeling Data Warehousing Oracle Windows NT CORBA Hitachi JP1 JP Walker CA Unicenter Tivoli

Medical Affairs IT Consultant

Genentech Inc.

Feb 1997 - Dec 1997 (10 months)

Supported Associate Director of Medical Affairs IT by selecting and implementing SDLC configuration management and Oracle*Clinical enhancements for batch scheduling and data warehouse work. Implemented pharmaceutical approval-cycle tooling (including firewall file transfer and preprocessing to Oracle*Clinical), developed UNIX shell scripts for daily processing with AutoSys, and applied tools such

Oracle*Clinical Informatica Cognos Configuration Management PVCS ClearCase Shell Scripting Autosys