Occupation:Datawarehouse Designer |
Location:Cincinnati, OH |
Education Level:Associate |
Will Relocate:YES |
Description
Project Management, Data Architecture, Database Engineer and Administrator with 16+ years extensive experience designing, Data Modeling, coding, testing and supporting next-generation database solutions with 10 years of SQL Server and MySQL, 7 years of Oracle, 3 year PostgreSQL in an enterprise environment. Proficient in an assortment of technologies, including Oracle 8i, 9i, and 10g, 11gR2, MS SQL Server 7 to 2012, including SQL 2012 code named Denali, Access, Sybase, MySQL, DB2, PostgreSQL, JDBC, Visio, Apache Web Server, IIS web Server, Erwin, ER Studio, ModelRight Pro, Oracles SQL DataModeler, Navi DataModeler, Toads Data Modeler, Java, C++, Visual Basic, .NET, MVC Framework, SQL, T-SQL, PL/SQL, XML, PHP, Version Control, Windows and Linux OS(RedHat, CentOS, Ubuntu, SuSe, and Fedora). Skills: Project Scoping, Project planning, scheduling, vendor management, risk assessment, budgeting, change management. Data Architecture MS SQL Server 2000 to 2012 Database Administration Data Security, Backup & Recovery Failover Clustering Setup and Administration Data Modeling and Development SQL Tuning in a MS SQL Server Environment SQL Tuning in an Oracle Environment MS SQL Server Installation and Configuration MS SSAS, SSIS, and SSRS Solutions Development Data Architecture Design and Analysis BI Design and Development Data Warehouse Design and Development. Performance Tuning & Capacity for SQL Server and Oracle Databases Servers Oracle RAC & ASM Administration/Installation Number of RAC installs 4 Number of RAC re-installs 6 Oracle Grid Control Database-Backed Web Solutions Oracle 8i, 9i, 10g, 11gR2 Database Administration Monitoring of Databases Engineering of Environments Development of Triggers and Stored Procedures Database Modeling of OLTP, OLAP, ROLAP, MOLAP, and HOLAP Databases MySQL: Database Administration PostgreSQL Database Administration MySQL Replication and Cluster PHP Development Java Development VMWare During my down time between Projects I do work on getting familiar with new technologies currently I am working on getting more familiar with Hadoop, Cassandra Data Stage, Big Data and Algorithms using C++ and Java, JQuery, and Spring.