This job offer is no longer available
About
Mid-Sized Financial Services company needs an MS SQL DBA to work within our IT department. This candidate will assist in maintaining the internal databases for efficiency, performance, create ad-hoc reports and anticipate growth. *Only candidates residing in Chicago, Texas, Florida, Indiana, or Georgia will be considered.*
*Key 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
* Perform code reviews for SQL work from the developers and provide guidance on acceptable code practices
* Maintain knowledge of best practices surrounding IT technology, processes & database / support,
* Communicate with team members to gather accurate requirements for new enhancements and applications
* Maintain database documentation regarding data standards and procedures
*Non Technical Requirements:*
* 6+ years Microsoft SQL Enterprise DBA experience is required
* Experience working in smaller teams within 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 resolution
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/patch 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 track 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 Microsoft Management studio
* Hands-on experience with Microsoft SQL Server 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/monitoring tools such as Redgate Monitor
* Experience with AWS Aurora MySQL databases
* Experience with Git and Azure Devops
* Experience with Power BI
*How to Apply*
If you’re interested please feel free to send your resume to beckerman@paylinkdirect.com with the subject line: “*Senior SQL Database Administrator*”.
Job Type: Full-time
Pay: $120,000.00 - $135,000.00 per year
Benefits:
* 401(k)
* 401(k) matching
* Dental insurance
* Employee discount
* Health insurance
* Health savings account
* Life insurance
* Paid time off
* Professional development assistance
* Vision insurance
Experience:
* Senior Sql Database Administrator: 6 years (Required)
Location:
* Illinois (Preferred)
Work Location: Remote
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.