Database Developer, Database Administrator, Data Warehouse Developer, BI Developer

Location:Calgary, AB, Canada (Anywhere)

Education level: College/University
Education field: Computer Sciences
Years of experience: more than 5
Attributes that best describes:
Team player
Independent worker
Strong analytical skills
Good communicator
Pragmatic

Skills:
• 18+ years experience implementing Relational Database and Business Intelligence solutions
• High level of analytical and problem solving skill; resourceful, ability to think outside to box
• Team player with exceptional communication, project management, and presentation skills

TECHNICAL PROFICIENCY

SQL Server: 10+ years experience incl. 2000, 2005, 2008R2, 2012, Architecture, Installation, Upgrade, Patching, Administration, Configuration, Migration, Security, T-SQL programming, Performance Tuning, Backup, Recovery, Replication, Mirroring, HA Clustering, Always-On, BI Toolsets (SSIS, SSRS, SSAS), Dynamics AX

Oracle: 10+ years experience incl. 8, 8i, 9i, 10g, 11g, 12c Architecture, Installation, Administration, Patching, Configuration, Security, PL/SQL programming, Auditing, Performance Tuning, AWR, Backup, Recovery, RMAN, Real Application Clusters (RAC), Data Guard, OEM Grid Control, SAP Basis

MySQL: 5+ years experience incl. 5.0, 5.5, Architecture, Installation, Administration, Programming, Security, Performance Tuning, Backup, Recovery, Master/Slave Replication, HeidiSQL

Data Warehouse / Business Intelligence: 10+ years experience incl. Data Warehouse, Data Mart, Operational Data Store (ODS), Data Modeling (Star, Snowflake), Forward/Reverse engineering, Query Writing, Optimization, Object Development (fact/dimension tables, hierarchies, views, cubes, functions), Partitioning, Performance Tuning, Indexing, Storage, Business Intelligence Development Studio (BIDS)

Integration: 10+ years experience incl. SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Extraction, Transformation, Loading (ETL), AutoMate BPA Server

Reporting: 10+ years experience incl. SQL Server Reporting Services (SSRS), Crystal Reports, Oracle Reports, Oracle Forms, Visual Basic (VB), FileMaker Pro, Microsoft Access

Data Modeling: 10+ years experience incl. Logical/Conceptual Data Modeling, Forward/Reverse Engineering, Data Architecture Diagrams, Data Flow Diagrams, Entity Relationship Diagrams (ERD), Unified Modeling Language (UML), ER/Studio, ERwin, MS Visio

Application / Web Design: Visual Studio .NET, Macromedia Dreamweaver MX, Visual Basic for Applications (VBA), Active Server Pages (ASP), Java Server Pages (JSP), Apache HTTP Server, Internet Information Services (IIS), Oracle Application Server, Oracle APEX (HTMLDB), HTML, Cascading Style Sheets (CSS), Adobe Photoshop, Adobe Illustrator

Programming: C, C++, ColdFusion, FoxPro, Groovy, HTTP, Java, JavaScript, MySQL, PHP, PL/SQL, Pro*C, SOAP, SQL, SQL*Plus, T-SQL, UNIX Shell, CRON, Visual Basic (VB), Windows CMD, XML

Versioning: ServiceNow, BMC Remedy, Tortoise SVN, StarTeam, Visual SourceSafe, Test Director

Contact by email View CV