Employment Type : Full-Time
Founded in 1991 with the idea to be the alternative to the big banks, Wintrust has since grown into a financial services company with more than $45 billion in assets, headquartered in Rosemont, Illinois. Through our multiple companies and divisions, we provide traditional community banking and commercial banking services, wealth management solutions, commercial and life insurance premium financing, mortgage origination, and short-term accounts receivable financing and certain administrative services, such as data processing of payrolls, billing, and treasury management services. We provide community-oriented personal and business banking services to customers located in the greater Chicagoland area, northwest Indiana, and southern Wisconsin through more than 175 community bank locations. Position Overview Excellent opportunity for the candidate to work in a great cultured environment. Veterans First is a nationwide VA loan provider with a strong focus on helping our veterans find a home. The company uses up to date technologies and encourages a culture of learning and improvement. This role is primarily focused around managing and maintaining a large reporting repository. The candidate’s responsibilities include writing and maintaining complex SQL queries and scripts, creating and improving new and existing ETL processes through Scribe, and creating custom reports using Logi Analytics. In addition candidate will provide a high degree of coordination between user, technical, application, and corporate entities to ensure effective data management. This role will have the ability to set standards, and implement a wide array of processes. Key Accountabilities The position consists of developing and maintaining master data repositories (e.g. SQL Server database) for use in reporting company metrics and data RDBMS performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency Reorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or defragment database table spaces, tables, and indexes; provide efficient database environment to maximize productivity and improve performance. Provide the appropriate tools, procedures, and facilities for creating and maintaining the entity data enterprise model Capacity planning and reporting: Monitor file system space, database allocation, etc.; verify efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out-of-space conditions Maintain database backup/recovery environment: Respond quickly to refresh data; verify implementation of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error. Responsible for the integrity of production test and QA database environments Install and upgrade RDBMS and related products: Keep RDBMS at current release and maintenance levels; install supporting products; provide current, stable production and development environments Experience or ability to learn ETL processes using Scribe to transform and translate data into a standardized data warehousing model Provide database designs as needed: Research and recommend optimal design criteria; publish standards and work with development staff; standardize environment and improve efficiency The candidate will work closely with other team members and his or her manager to develop, deliver, and support effective, creative data management solutions aligned to company objectives Strong customer focus and management of client expectations; ability to establish and maintain a high level of user trust and confidence in IT’s knowledge of and concern for users’ business needs. Excellent oral and written communications skills. Ability to present and explain technical information to diverse types of audiences (management, users, vendors, technical staff) in a way that establishes rapport, persuades others, and gains understanding. Ability to write clear proposals and technical documents Strong interpersonal skills at all levels of management and ability to motivate employees/teams to apply skills and techniques to solve dynamic problems; excellent teamwork skills Effectively managing multiple small to large projects in a cross-functional environment Weigh various suggested technical solutions against the original business needs and choose the most cost-effective solution Work with long-established senior staff, provide guidance, and assign and follow up on tasks. Provide technical guidance and direction for other team members when needed. Communicate complex technical information in a concise and articulate manner Develop rules, procedures, and standards for the access and maintenance of shared data resources Participate in the evaluation and recommendation of DBA tools and new DBMS technologies Serve as business liaison to database vendors Perform impact analyses, research products, configure software, and establish standards and procedures that support the company’s database environment needs Develop utilities for monitoring and evaluating data quality Assist in the definition and development of database documentation and standards Conduct application transaction volume and traffic analysis, and interpret impact on database and network performance Participates in the on-call production support rotation and may occasionally be required to work hours outside of the traditional work schedule. Requirements 3-5 years of related experience. Bachelor’s degree or equivalent. Experience running and maintaining a 24x7 production enterprise computing environment. Understanding of SQL Server Relational Database Technology concepts and designs with knowledge of MS Windows Server Operating Systems Experience implementing/maintaining database failover mechanism (mirroring, log-shipping, clustering, always-on, etc.) and perform disaster recovery exercises for mission-critical databases. SQL/T-SQL skills with hands-on experience in successful database design, schema design, SQL performance tuning and optimization. Experience with developing software at the data layer in a SQL server environment using Transact-SQL Software development skills in object oriented programming including C# .Net. Knowledge of backups, restores, recoveries, high availability, and disaster recovery scenarios. Experience configuring and administrating MSSQL technologies outside the relational engine (SSIS, SSRS, MDX, and SSAS). Knowledge of SQL Server performance tuning, backup and recovery methods. Experience with MySQL is a plus Preferred Certification - Microsoft Certified Solutions Associate: SQL Server 2014/2016 Wintrust Financial Corporation, including community banking and financial services subsidiaries, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, citizenship status, sex, sexual orientation, gender identity and expressions, genetic information, marital status, age, disability, or status as a covered veteran or any other characteristic protected by law.