VIVA USA Inc Phoenix, AZ 85067
Description 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 Experience with Database design Documentation skills VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.