Database Administrator

IBA InfoTech Inc.

Cincinnati, OH, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

4 years minimum

Working hours

Regular working hours

Job source

ibainfotech.com

Tech stack

Microsoft Windows Agile Methodology Information Systems Computer Programming Databases Extract Transform Load (ETL) Data Warehousing Database Schema Software Debugging Microsoft SQL Server Windows Servers Networking Basics

+10 more

Package Development Process Performance Tuning Software Systems SQL Stored Procedures SQL Databases SQL Server Integration Services Systems Integration Transact-SQL Web Services Information Technology

Job description

Design, develop and implement database schema, Microsoft SQL Server objects ( tables, views, functions, stored procedures, etc.)
Follow Agile practice
Design, develop and deploy ETL software, primarily in SQL Server Integration Services
Ongoing support and maintenance of databases for data warehouse applications
Write and debug complex SQL and understand the best ways to incorporate database requests into application programs
Perform database change management, performance tuning for data warehouse
Write the documentation of design specifications and implementation details
Collaborate with other team members to develop system designs, interfaces and protocols etc.
Collaborate with system DBAs
Coordinate with Information Systems Application groups and Vendors for SQL Server upgrades
Manages workload to deliver quality deliverables that meet requirements and timelines
Assists Manager in tracking progress, prioritizing work, developing time estimates and work plans and assisting less experienced team members
Provide backup support for Systems DBA

Requirements

4 + years of SQL Server database development experience; knowledge of software systems, infrastructures and Data Warehouse concepts and ETL development
Strong analysis and troubleshooting skills
Strong organizational skills with attention to detail a must as well as good interpersonal and time management skills required
Working knowledge of computer operating systems (mainly Microsoft Windows Servers )
Bachelor’s degree in Computer Science, Information Systems and/or related fields

Skills :

Working knowledge of SQL Server Databases and T-SQL programming (at least 4 years of proven experience)
Strong understanding of SQL Server database security
Experience with SQL Server from 2000 - current preferred
Experience in ETL package development using Microsoft SQL Server Integration Services (SSIS)
Basic knowledge of Web Services
Basic Windows server administration experience
Basic Networking experience
Excellent written and oral communication skills
Knowledge of ITIL best practices is a plus