SUMMARY

• A results - driven database, data warehouse administrator with extensive experience in application development and IT system integration with over 20 years of experience planning, designing, implementing and maintaining systems for local government, heavy duty machinery dealers, internet media, telecommunications, engineering, medical services, software houses, auto manufactures, financial and IT services
• Proven security and systems architecture, database design, reporting, data security and management skills
• Datawarehousing with deep knowledge of all layers including data quality, ETL strategy and optimization, cubes assembly, reports deployment and presentation
• Expert level knowledge in application performance analysis and optimization owing to vertical and horizontal knowledge of the software, hardware and storage stacks
• Infrastructure architecture with SAN, NAS specifications using design and optimization technics to achieve highest performance levels
• Disaster recovery strategies to ensure full data security
• Capacity planning analysis to assist future investment planning ahead of time
• System migration or upgrades to newer versions and / or different platforms
• Active learning, creative thinking, deep interest in new technologies, complex problem solving
• Service oriented, proactive monitoring and troubleshooting skills
• Worked on multimillion dollar projects collaborating globally in different languages with other system analysts, project managers, business analysts and development teams

TECHNICAL SKILLS

• SQL Server, SSIS, SSAS, SSRS,
• PowerBI, SharePoint
• Visio, Project, Github Jira,
• ER/Studio, VMWare, NetBackup,
• Quest Spotlight, Solarwinds DPA,
• Windows, IBM AIX, Linux, OSX,net, T-SQL, PL-SQL, VBA, C#
• PowerShell, Visual Basic
• SQL Server 2005 to 2017
• Oracle 11g, 10g, 9i, 8i,
• PostgreSQL 9, 8,
• MongoDB 3.4
• Cloud, Middle Layer
• AWS, Azure, .Net, Apache, Tomcat

PROFESSIONAL EXPERIENCE

Confidential

Database Developer

Responsibilities:

• SQL Server configurations for Prod, Dev environments
• Payroll database and ETL development

Confidential

Big Data Integration Specialist

Responsibilities:

• Business requirements, architecture development, data modelling
• SSIS ETL developer for ODS/DW using Change Data Capture (CDC)
• SSAS Tabular, Tableau models’ development
• Incorta implementation in a Linux cluster with security configuration
• Incorta schemas definition, data loading and exploring, business schemas definition
• Data governance assessment, Data Quality with MS DQS
• Knowledge transfer for newer teams on ETL framework for Google Analytics, SSAS Tabular,

Confidential

Database Administrator

Responsibilities:

• SQL Server maintenance, performance tuning, auditing, Disaster Recovery strategies, SOC1, PCI compliance
• Instance monitoring using T-SQL, Solarwinds DPA, Orion
• Support and code review for DevOps
• Administration, analysis, standards definition, assessment and documentation on premises and cloud based (AWS, Azure) environments
• Partitioning strategy for databases and cubes in order to improve performance and backup
• Data integration between AWS EC2/S3, SQL Azure and on premises in a hybrid environment
• ETL development and management using CDC replication

Confidential

Senior BI Datawarehouse Administrator

Responsibilities:

• Database management of more than 1300 databases distributed among 160 instances hosted in more than 40 servers
• Environments administration, analysis, standards definition, assessment and documentation
• SQL Server infrastructure planning, environment documentation, inventory, licensing, performance, disaster / recovery, auditing, backup strategies, licensing and release upgrades
• Statistics collection and reporting over databases capacity, performance, availability
• Worked extensively with internal PMs, SAs, BAs, BI team and 3 rd party vendors that support migrations and maintenance of applications and systems (TELUS, IBM, Microsoft, Lawson etc.)
• Data integration with heterogeneous platforms (IBM DB2 on AS/400) using SSIS, Informatica
• Data Warehouse specialist on SQL Server stack including SSIS, SSAS, SSRS, PowerBI
• Lawson data warehouse ETL analysis, improvements and high-performance optimization
• BI environment design, building, setting, tuning and maintenance using MSSQL 2012 integrated with SharePoint enabling Power BI solutions for power users

Confidential

Database Engineer

Responsibilities:

• Data model architect: implement business rules into the data models using referential integrity, functions, stored procedures and constraints
• IT architect: infrastructure redesign, planning, setting and management
• Advanced SAN architecture design and setting to improve throughput and performance
• Data model architect: implement business rules into the data models using referential integrity, functions, stored procedures and constraints
• Model / data dictionary published on the company’s intranet
• Perform data quality analysis with master data
• Business reports implementation using SSRS
• Performance tuning increases network traffic more than 5x pushing company revenues up
• Cost analysis for code migration to different platforms
• Cost savings archiving policies using Amazon Web Services
• Deployment and regression test routines for development and QA teams
• Management reports using pivot-tables with dynamic data sources