Intellectual Capitol, founded in 2003, is a leader in providing outstanding talent to our clients for enterprise projects. We focus on State and Local Government in the Southeastern United States with active contracts in South Carolina, North Carolina and Florida.
Intellectual Capitol is an award winning, growth oriented organization with a strong culture, deep history and focus on our clients, consultants, team members and the communities in which we serve!
We are blessed to serve a wide variety of clients who have IT talent needs. Our unique partnering approach is a key driver for the continued growth and expansion of our offerings.
You'll join a gifted and motivated team who is creating the future each and every day!
Daily Duties / Responsibilities:
- SQL Server
- Setup and maintain data replication and mirroring
- Configure maintenance automation
- Backup and Recovery
- Troubleshoot SQL Server performance issues as they occur, including after-hours and weekends
- SQL Server monitoring
- Install and configure new SQL Servers
- Develop and support data warehouse and cubes through SQL Server Analysis Services
- Migrate SQL Server database to SQL Server 2012, 2014
- Develop Reports using SSRS
- Support SSIS packages
- Develop database design, development, and management standards
- Consult with developers regarding database design.
- Implement 3rd party databases for vendor supplied applications
- Oracle 11/12: Desired
- Analyze, develop, and support stored procedures and SQL.
- Business Intelligence
- Assess business intelligence tools for appropriateness to SCDMV data architecture, SQL and Oracle.
- Design and develop and manage the design and development of dashboards and reports through a BI solution
- Develop and present end user training for BI solution
- Develop and present developer training for BI solution
Required Skills (rank in order of Importance):
- SQL Server 2008,2012
- Sql Server Reporting Services
- Sql Server Analysis Services
- Reports Designer
Preferred Skills (rank in order of Importance):
- SQL Server 2014,2016
- DD Boost to support backup and restore operations for SQL Server
- Oracle 11/12 Business Intelligence Microsoft Office
- Microsoft Project
- Microsoft Visio