63857: Columbus, OH – IT – DMH – Database Administrator 4/DBA4

Job Title: DBA4
NFP Rate: $61.15
Will close to submission: Monday 7/29/2019 at 10:00am EST
Interviews: Onsite only

Job Title:  Database Administrator 4 (DBA4)

Job Description:  Full-time contractor position with the Ohio Department of Mental Health and Addiction Services (OhioMHAS).  Located in downtown Columbus, Ohio.  Onsite only.  Hybrid application development/database administration position.  7+ years of experience. SQL Server.

We are looking for our ideal candidate to handle multiple enterprise projects from design, implementation, tuning, maintenance, performance tuning and configuration to also being the technical lead. This resource will work with SQL query development, performance monitoring/tuning of stored procedures and queries, and will assist the software engineering and professional services team with SQL development. Our ideal candidate will be able to identify business requirements and transform them into data models, queries, stored procedures/SSIS packages, reports and Business Intelligence Tools

Role Description:

  • Creating and maintaining database processes to support our key business systems
  • Assist software engineering team as needed to develop solutions in an Agile environment
  • Identify data sources, construct data decomposition diagrams, provide data flow diagrams and document the process
  • Review, evaluate, design, implement and maintain complex company databases using Microsoft SQL Server
  • Write codes for database access, modifications, performance tuning and construction including stored procedures;
  • Review data layouts/requirements
  • Create new databases or maintain/improve current databases
  • Ensure data consistency & accuracy
  • Review execution plans and optimize databases
  • Generate queries or stored procedures
  • Create SSIS packages to automate any needed actions
  • Creating and maintaining reporting and auditing to support our customers
  • Engage in ongoing process improvement
  • Lead estimation efforts
  • Optimizing queries and Stored Procedures for optimal execution time
  • Should have an understanding of data warehousing and relational databases like MS SQL Server; Data Warehouse, Data Mart, Operational Data Store
  • Performs data analysis including data profiling and data quality analysis
  • Design ETL (SSIS) logic and load strategies along with reporting functions
  • Analysis and execution of data migrations from legacy applications
  • Database deployment using Visual Studio SQL Server Data Tools
  • TFS and git source control
  • SQL Server installation, configuration, version upgrades, patching
  • Capacity planning
  • Performance monitoring/tuning
  • Data security – HIPAA compliance, user administration, encryption, masking, auditing
  • Records retention/archival policy
  • Business continuity/disaster recovery strategy
  • Contribution to DBA team standards and best practices

Environment

  • SQL Server
  • SSIS/SSRS
  • Visual Studio
  • TFS
  • Microsoft Office

Bonus:  .NET, PowerShell

Comments are closed.