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:
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
All your information will be kept confidential according to EEO guidelines.
Job details are sourced from the employer's original posting.
Open job postingAbout the company
Imagine designing world-class online educational experiences for hundreds of thousands of K-12 students, teachers, parents, and school staff in Arizona. Ww award-winning educational web applications and you can contribute to our success by crafting the very best user interfaces using the bleeding-edge web technologies.