Opening for SQL Server with Oracle BI Experience :: Columbia, SC
Location: Columbia, SC
Duration: 12+ months
Manages and maintains all production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
Client supports in the neighborhood of 100 plus sql server databases and are in the process of migrating those databases from sql server 2008 to sql server 2012. in addition client is implementing high availability solutions on a number of the systems supported by these databases and increasing out use of reporting services and analysis services implemented in a number of support systems such as sharepoint, ms system center, team foundation server, and others. Client is also facing increasing security concerns around these assets. Client is also standing analysis and reporting services for its oracle data assets through oracle business intelligence. this engineer will be developing and presenting training to business users in the use of oracle bi solutions.
Client is looking for assistance to support these initiatives. This is expected to be a long term, on site, assignment. candidate will be working in a team environment consisting of 5 database engineers and administrators and working directly with application developers and server support team.
Daily Duties / Responsibilities:
• SQL Server
o Setup and maintain data replication and mirroring
o Configure maintenance automation
o Backup and Recovery
o Troubleshoot SQL Server service performance issues as they occur, including after-hours and weekends
o Manage SQL Server monitoring utilities to minimize false alarms
o Install and configure new SQL Servers
o SQl Server Analysis Services
o Migrating Sql Server database to Sql Server 2012.
o Developing Reports using SSRS
• Oracle 11/12
o Develop Dashboard and reports using Oracle BI
o Develop and present end user training in Oracle BI
SQL Server 2008,2012, 2014
SQL Server Reporting Services
SQL Server Analysis Services
ORACLE 11/12 Business Intelligence Reports Designer and BI Server Setup and Maintenance.