BI Database Administrator

Location: Birmingham, AL
Date Posted: 01-29-2018
About Seneca Resources:
Seneca Resources is client driven provider of strategic Information Technology consulting services and Workforce Solutions to government and industry.  Seneca Resources is a leading IT services provider with offices in Reston, Virginia, Alabama and Columbia, Maryland that service clients throughout the United States.  The key to our success lies within our strong corporate culture which drives our business.  We challenge our staff through engaging work, and we reward our staff through competitive compensation, extensive professional training, and excellent opportunities for career advancement.  In turn, we look for only the best and brightest to join our team.
We are an Equal Opportunity Employer and value the benefits of diversity in our workplace.
Position Title: BI DBA
Location: Birmingham, Alabama
Position Status: Full Time
Position Description:
The Business Intelligence Application DBA is responsible for providing dedicated service to the Business Intelligence team.  The BI technology utilizes the Microsoft SQL Server  platform stack running on  Microsoft Windows 2012/2016 platform running on Virtual platforms utilizing Microsoft Hyper-V and VMWare ESX in a 24 x 7 environment.  The BI Application DBA works within the Corporate Database Administration team and serves as a dedicated resource to the Business Intelligence team, as well as other departmental resources to best meet database administration responsibilities while strongly supporting department and company goals.

Required Skills:
  • Bachelor's Degree in MIS or Computer Science related field.  Proven experience and/ or certification can be substituted for a Bachelor's Degree.
  • 10+ years DBA experience with Microsoft SQL Server (2008 or greater) in a production environment is required.
  • 8+ years of experience configuring, implementing and supporting large highly available SQL Server business intelligence environments, including experience with Failover Cluster and database mirroring/ always on is required.
  • 8+ years of experience with SQL Server troubleshooting; ability to proactively identify, troubleshoot and resolve live database systems issues.
  • 5+ years of prior experience with a database on a virtual platform is desired.
  • 5+ years of experience with T-SQL and PowerShell Scripts is required.
  • Strong working knowledge of query, index and DB I/O performance tuning, and Stored Procedures and SQL coding is required.
  • Experience with Analysis Services MDX and Tabular a plus
  • 6+ years of experience with Enterprise OLAP Environment Administration, including SSIS/ SSRS/ SSAS experience, is required.
  • Database migration/ upgrade experience is highly desired.
  • Ability to cope with multiple demands and extremely precise, detailed and confidential work.
  • Ability to facilitate discussion, to teach, and to train concepts related to data retrieval, data analysis, data integrity and analytical information systems in RDBMS environments.
  • Ability to manage all DB maintenance plan activities including backups, indexing, integrity and consistency checks, etc.
  • Ability to work collaboratively with other internal departments and entities.
  • Deep understanding of database design principals.
  • Excellent organizational skills and the ability to prioritize work effectively.
  • Excellent understanding of query execution plans.
  • Experience running and supporting very large data warehouse databases (OLAP, Big Data) is a plus.
  • Experience running and supporting very large databases under high transaction rates (OLTP, VLDB).
  • Experience with word processing, spreadsheet and project management applications required.
  • Knowledge of disaster recovery principles and practices, including planning, testing, backup/ restore using disk-based backup solutions.‚Äč
this job portal is powered by CATS