
Database Developer, Database Administrator, Data Warehouse Developer, BI Developer
Location:Calgary, AB, Canada (Anywhere)
Education level: College/UniversityEducation 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
Languages:
Reviews
No reviews yet.