MUST be local to Phoenix, this position will be required to be on-site at minimum once a week.
This position will be the subject matter expert and resource for all TSQL code and SSIS package reviews.
Perform code reviews to ensure best practices and optimization are achieved
Maintain all DBA code used for automated processes and maintenance.
Monitor capacity, performance, and tuning of all SQL servers; troubleshoot server related issues related to application/sql issues. Must have a good understanding of execution plans, general performance monitor counters and SQL Server profiler. Support of monitoring software including installation of upgrades. Installation of SQL Server patches when approved by management.
Ability to work closely with Quality Analysts and developers with specifications and requirements, review database designs ensuring best practices, validate proper database indexing architecture and the ability to determine poor performing queries.
Perform day-to-day administrative tasks and application support, such as troubleshooting unique database and application issues as they arise, releasing code to production and training environments with correct recovery procedures (backout plans), deploying SSIS package and SSRS reports, scheduling/configuration of jobs, database backup/recovery, daily SQL code reviews and security/access management. General windows OS administration is required. Provide on-call support on a team rotation.
Good problem-solving skills and attention to detail will be required daily. Must be willing to ask questions and take notes.
Documentation of processes, and enforcement of policies/procedures. Respond to Audit requests.
Collaboration with other IT teams, such as Network Operations, Firewall, Server Operations etc.
Bachelor’s Degree and 5 years of experience or minimum of 10 years equivalent experience
Skill Sets Needed:
Strong TSQL skills
Strong SQL optimization skills
Strong Problem-solving
Strong Knowledge of SSIS
Knowledge of SSRS
Working knowledge of PowerShell
Working knowledge of Window Servers and networking infrastructure