Previous Job
Previous
Database Administrator/SR
Ref No.: 17-12429
Location: Phoenix, Arizona
Position Type:Contract
Start Date / End Date: 09/27/2017 to 06/30/2018
RDM:Chet Mann
Description
  • Implement and review appropriate security guidelines / mechanisms. Develop and test database migration procedures.
  • Troubleshoots application key selection, creation of appropriate indexes, and query needs. Perform database maintenance functions, move, rebuild, or change database objects as required in production. - 50%
  • Proactively solves complex problems. Problem solves environmental differences and .net based applications. Translates user's needs into sound database design with tables, fields, and relationships documented.
  • Assist in developing purge / archive criteria and procedures for historical application data on a relation model database environment. Reviews, evaluates, designs, implements and maintains company database(s). - 30%
  • Develops database administration tools / utilities / operation procedures. Educates user and maintains database documentation. - 10%
  • Establishes database procedures and standards; assists in database design. Documents data requirements in a logical entity relationship diagram. - 10%

Tools:
  • Windows Server - Required
  • Basic T-SQL Skills - Advanced - 3 years
  • SQL Server 2008 R2
  • SQL Sentry
  • Familiarity with SSRS
  • Waterfall and Agile
  • .Net 4.0 and above
  • TFS (team foundation server)
  • Deploy web apps using MSI
  • IDEARA