Database Analyst 4 Job in West Des Moines, Iowa US
Database Analyst 4
Wells Fargo Education Financial Services Technology Group (EFSTG) is looking for a well qualified MS SQL Server DBA. Job responsibilities and role include, but not limited to: Plan, analyze, design, implement, maintain, and control the student loans's databases. Consults with and provides guidance to database Student Loans development and client groups, often recommending tactical and strategic solutions. Performs moderately complex server-class database activities across various platforms and environments including one or more of the following: business requirement identification and analysis; conceptual, logical, and/or physical database design; data modeling and/or mapping; moderate to complex programming and coding to automate and/or support the database environment; performance monitoring and tuning; analyzing database metrics and assisting with capacity planning; planning, testing, configuration and execution of installations, upgrades and migrations; and implementing security controls. Leads, mentors and/or provides guidance to less experienced database analysts, where applicable, including guidance for troubleshooting escalated issues. May participate in the development of data/ database architectures and management policies, procedures and standards; Helps define and support back-up recovery strategy. Creates and monitors backup processes and provides data recovery needs as required. Provides support to production teams as needed. Basic Qualifications: 5+ years database design and administration experience. Minimum Qualifications: 5+ years experience with MS SQL Server database and data warehouse environments (SQL 2005/SQL 2008) 3+ years SQL Server Integration Services (SSIS) experience 3+ years SQL Server Reporting Services (SSRS) experience Strong communication and organizational skills Preferred Skills: Detailed MS SQL Server (SQL 2005/SQL 2008) knowledge and experience including SSIS, SSRS, Security, backups, performance monitoring Powershell BixPress Knowledge of change management software and processes - Subversion, PVCS, TFS Knowledge of the student loan industry