This site uses cookies. To find out more, see our Cookies Policy

SQL Server DBA in Indianapolis at Vaco

Date Posted: 2/15/2018

Job Snapshot

Job Description

SQL Server DBA

Vaco Technology is assisting a client in their search for a SQL Server DBA. This role offers a variety of responsibilities including day-to-day administration, designing tables, creating stored procedures, views and functions and ETL work.

Responsibilities:

  • Database back-up and recovery
  • Day-to-day support and maintenance of all internal databases
  • Manage database security and control access permissions and privileges
  • Respond to alerts and produce maintenance plans and scripts
  • Manage release life cycles in development and production environs
  • Monitor database events and proactively optimize system performance
  • Perform health checks to ensure integrity of schema and data
  • Complete data mappings from source to destination
  • Work with internal clients and third-party vendors to understand data needs
  • Provide data imports, exports and migration duties
  • Implement and improve ETL processes
  • Provide troubleshooting, updates and documentation to existing procedures as necessary

Requirements:

  • Minimum 4 years of experience in a DBA capacity
  • Experience monitoring and tuning databases
  • Experience working with complex SQL views

Preferred:

  • Current MS SQL certification(s)
  • Bachelor of Science Degree in Information Technology
  • Advanced knowledge of T-SQL, complex SQL queries, joins, sub-queries, best practices
  • Familiarity with Crystal Reports
  • Experience with SSIS and SSRS

Job Requirements

SQL Server DBA back-up recovery security SQL T-SQL ETL data mappings schema data third-party vendors monitoring tuning queries SSIS SSRS Crystal Reports T-SQL joins