Job Description :
SQL DBA/Architect
Troy, MI
6+ Months
F2F interview after telephonic.
Description:
This SQL DBA/Architect role is responsible for all activities relating to the design, implementation and maintenance of databases.
In addition, the individual is responsible for database design, implementation, security, backup/restore and recovery strategies. Proactively monitor databases. Use best practices for performance tuning. Monitor performance and disk space requirements, taking corrective action as needed. Review statistics for efficiency and tuning; determine problem areas and design solutions. Mentor developers on database development best practices and assist application programmers with database designs and query optimization. Audit, manage, and deploy database scripts. Automate DBA processes.
Define and document daily support processes.
Skill Requirements:
Minimum 8-10 years of recent experience with SQL Server 2005/2008/2012
Requires in-depth experience and understanding of database architecture, data modeling, schema design and development.
Minimum 8-10 years of recent SQL server development including complex triggers and views.
4-5 years of experience in supporting SSIS & SSRS is required
5-7 years of experience of replication and mirroring is required
Proactively monitors the production database and optimizes stored procedures for better performance; resolves any conflicts and resource utilization issues
Administers, maintains, develops and recommends policies and procedures for ensuring the security and integrity of the client’s databases
Designs, reviews and implements production SQL Server database objects, models and database designs.
Identifies and resolves database performance issues
Prior upgrade experience from 2008 to 2012 is a plus
Experience with Red Gate tools is a plus
Experience with Business object server is a plus