Database Administrator

IBA InfoTech Inc.
Cincinnati, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Cincinnati, United States of America

Tech stack

Microsoft Windows
Agile Methodologies
Information Systems
Computer Programming
Databases
ETL
Data Warehousing
Database Schema
Software Debugging
Microsoft SQL Server
Windows Server
Networking Basics
Package Development Process
Performance Tuning
Software Systems
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Systems Integration
T-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

Apply for this position