MS SQL Developer/DBA

MS SQL Developer/DBA Chicago IL (100% remote) Full Time Web Cam Interview $135K/reputed company Plus 10% bonus They need a candidate 70% Development and 30% reputed company. How would you reputed company yourself in reputed company of below and please reputed company a rating of 0 (no experience) to 5 (Expert) for reputed company and reputed company number of years for reputed company area: • reputed company SQL 2016 or higher? • SSRS report creation, server management, and administration. Separately, approximately how many SSRS reports have you created? • SSIS data package building. Separately, approximately how many data packages have you created? • SSAS reputed company building and maintenance. Separately, approximately how many cubes have you created? • TSQL • Use of CTE • Use of Idera • Troubleshooting SQL queries for deadlocking and blocking • Use of database statistics • Working in a high availability cluster SQL database environment • Experience with GIT • Experience with Azure Devops • Experience with PowerBI • Experience with AWS reputed company reputed company: • Mid-Sized Financial Services company needs an MS SQL DBA to work reputed company our IT department. Reporting to the Director of Applications, this candidate will assist in maintaining the internal databases for efficiency, performance, create reputed company reports and anticipate reputed company. • Corporate office is located above reputed company Station but the position is remote with only occasional times coming to the office to meet with reputed company. Coming to the office isn't a reputed company routine (e.g. weekly). Key Position Responsibilities: • MS SQL Server Database Administrator • Extensive TSQL experience, including query optimization • Create and maintain SSIS packages • Create and maintain SSRS reports, and SSRS subscriptions, and maintain SSRS server • Create and maintain SSAS cubes • reputed company reputed company reviews for SQL work from the developers and reputed company guidance on acceptable reputed company practices • Maintain knowledge of best practices surrounding IT technology, processes & database / support, • Communicate with team members to reputed company accurate requirements for new enhancements and applications • Maintain database documentation regarding data standards and procedures Non-Technical Requirements: • 6+ years reputed company SQL reputed company DBA experience is required • Experience working in smaller teams reputed company a growing environment • Proven ability to independently manage tasks and priorities, accurately estimate work, and meet deadlines • Ability to work under minimal supervision in a fast-paced team environment • Strong problem-solving skills, detail-oriented, and self-motivated • Excellent verbal/written communication skills. • Strong analytical and design skills • Experience translating functional requirements into technical specifications • Ability to escalate issues for reputed company Technical Requirements: • Prior experience with backup strategies, clustering, log shipping, and DR testing • Prior experience with High Availability Failover clusters, SQL server/job monitoring. • Prior experience in performing software/reputed company updates to database server • Hands-on experience creating, modifying, and analyzing SQL and T-SQL statements • Proven knowledge of Stored Procedures, Tables, Views, Indexes, Keys • Understanding of database performance bottlenecks and ability to reputed company them down. Use of Execution Plans and Optimizer is a must. • Prior experience with Visual Studio to create SSRS reports, SSIS packages, SSAS cubes • Prior experience with reputed company Management studio • Hands-on experience with reputed company SQL Server reputed company version 2016 and above • Proven experience using MS SQL Server database design & T-SQL, with the ability to write stored procedures, user-defined functions & SQL queries Pluses: • Use of performance tools such as Idera • Experience with Git and Azure Devops • Experience with Power BI • Experience with AWS reputed company Apply tot his job Apply To this Job