Database Analyst

DATABASE ANALYST - MILWAUKEE, WI - CONTRACT TO HIRE

Take your career to the next level with COMPUCOM. We offer jobs with Fortune 1000 companies nationwide.

This position will work extensively in Microsoft SQL and Oracle database environments. The candidate is responsible for all global database support by following established build processes and procedures. The candidate handles software issues related to daily database operations.

ESSENTIAL FUNCTIONS:

- Design, Develop, Test, and Debug SQL Server Integration Services (SSIS) packages
- Design SSIS packages using various workflow, control flow tasks and data flow transformations for heterogeneous data integrations, migrations, and splits
- Establish and document procedures outside the scope of the standardized SSIS package design methodologies
- Create and design databases using industry best practices
- Create T-SQL scripts for testing data migration splits and for data import integrations
- SQL Server Business Intelligence Development Studio (BIDS) for importing and migrating data
- Microsoft Excel 2007 or 2010 data manipulation techniques and common data housekeeping functions
- Create, troubleshoot, debug, and manage SQL Server Management Studio (SSMS) data migration jobs and stored procedures
- Create, troubleshoot, debug, and manage SQL Server Management Studio (SSMS) indexes and compressions for large data migrations

REQUIREMENTS:

- Bachelor's degree in Computer Science, Management Information Systems or equivalent
- Current MS SQL certification and/or Oracle certification
- Requires 2-5 years related experience

FUNCTIONAL EXPERTISE

- Strong SQL, T-SQL, and ETL analytical and problem solving skills
- Knowledge of Cisco Best Practices
- Experience with Microsoft Visual Studio 2008 for an effective design of the data migration packages
- Microsoft SQL Server 2000, 2005, 2008, 2008 R2 and 2012 platforms
- SQL Server Management Studio (SSMS)
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- SQL Server compression, mirroring and replications
- Microsoft Windows and SQL Server clustering
- Microsoft SQL Server and Windows account management
- Oracle 8i, 9i,10g, 11g and 12c
- Microsoft group permissions and Active Directory Architecture
- Oracle 9i, 10g and 11g database administration as well as an understanding of new features of Oracle 12c
- Performance monitoring techniques on SQL and/or Oracle server software and hardware
- Tuning diagnosis via scripts and/or interfaces (TOAD, SQL Developer, etc.)
- Allocating and deallocating disk space to logical and physical objects in Oracle
- Oracle PL/SQL
- Scripting languages including PERL and PowerShell
- Familiarity with Regular Expressions
- Oracle RMAN concepts
- UNIX/Linux operating system (including ksh, bsh and/or csh Scripting) and Veritas Cluster Management
- Familiarity with Azure and/or other Cloud based technologies
- Ability to work remotely on database support with a global team

CompuCom, the leading IT outsourcing specialist, delivers IT your way. Our clients like working with us because they know that, with CompuCom, it's all about you. Our unique ITSM strategy blends your data center, network, voice, and end user computing environments in an innovative fashion. This radically simplifies your IT, allowing you to focus on growing your business and serving your customers. We are highly regarded by worldwide and regional organizations alike for our pragmatic approach, best practices, and highly skilled workforce. This balance provides the perfect alternative to address the evolving challenges facing you, today and in the future. More than a trusted advisor, CompuCom is your trusted doer.