SQL DATABASE ADMINISTRATOR

INT Technologies; Phoenix (AZ); On-site; USD 75,000 - 95,000; Full time

Job summary

A technology solutions company located in Phoenix, Arizona, is seeking a Database Administrator. This role involves implementing security guidelines, developing maintenance procedures, and designing databases. Candidates should have advanced T-SQL skills with at least 3 years of experience, familiarity with SQL Server 2008 R2, and knowledge of Agile methodologies. The company values innovative problem-solving and offers an environment conducive to professional growth.

Qualifications

• Advanced T-SQL skills with at least 3 years of experience.
• Familiarity with SQL Server 2008 R2 and SQL Sentry.
• Understanding of Waterfall and Agile methodologies.

Responsibilities

• Implement and review security guidelines for database management.
• Develop database tools and educate users.
• Establish database procedures and assist in database design.

Skills

Windows Server

T-SQL Skills

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

Job 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 solve 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.

Qualifications

• Windows Server - Required
• 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

Additional Information

All your information will be kept confidential according to EEO guidelines.