Syntricate Technologies
MS SQL Developer/DBA
Syntricate Technologies, Chicago, Illinois, United States, 60290
MS SQL Developer/DBAChicago IL (100% remote)Full TimeWeb Cam Interview
$135K/Base Plus 10% bonus
They need a candidate 70% Development and 30% Admin.
How would you rate yourself in each of below and please provide a rating of 0 (no experience) to 5 (Expert) for each and provide number of years for each area:
Microsoft 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 cube building and maintenance. Separately, approximately how many cubes have you created?TSQLUse of CTEUse of IderaTroubleshooting SQL queries for deadlocking and blockingUse of database statisticsWorking in a high availability cluster SQL database environmentExperience with GITExperience with Azure DevopsExperience with PowerBIExperience with AWS Aurora
Summary:
Mid-Sized Financial Services company needs an MS SQL DBA to work within our IT department. Reporting to the Director of Applications, this candidate will assist in maintaining the internal databases for efficiency, performance, create ad-hoc reports and anticipate growth.Corporate office is located above Union Station but the position is remote with only occasional times coming to the office to meet with the team. Coming to the office isn't a standard routine (e.g. weekly).Key Position Responsibilities:
MS SQL Server Database AdministratorExtensive TSQL experience, including query optimizationCreate and maintain SSIS packagesCreate and maintain SSRS reports, and SSRS subscriptions, and maintain SSRS serverCreate and maintain SSAS cubesPerform code reviews for SQL work from the developers and provide guidance on acceptable code practicesMaintain knowledge of best practices surrounding IT technology, processes & database / support,Communicate with team members to gather accurate requirements for new enhancements and applicationsMaintain database documentation regarding data standards and proceduresNon-Technical Requirements :
6+ years Microsoft SQL Enterprise DBA experience is requiredExperience working in smaller teams within a growing environmentProven ability to independently manage tasks and priorities, accurately estimate work, and meet deadlinesAbility to work under minimal supervision in a fast-paced team environmentStrong problem-solving skills, detail-oriented, and self-motivatedExcellent verbal/written communication skills.Strong analytical and design skillsExperience translating functional requirements into technical specificationsAbility to escalate issues for resolutionTechnical Requirements:
Prior experience with backup strategies, clustering, log shipping, and DR testingPrior experience with High Availability Failover clusters, SQL server/job monitoring.Prior experience in performing software/patch updates to database serverHands-on experience creating, modifying, and analyzing SQL and T-SQL statementsProven knowledge of Stored Procedures, Tables, Views, Indexes, KeysUnderstanding 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 cubesPrior experience with Microsoft Management studioHands-on experience with Microsoft SQL Server Enterprise version 2016 and aboveProven experience using MS SQL Server database design & T-SQL, with the ability to write stored procedures, user-defined functions & SQL queriesPluses:
Use of performance tools such as IderaExperience with Git and Azure DevopsExperience with Power BIExperience with AWS Aurora
$135K/Base Plus 10% bonus
They need a candidate 70% Development and 30% Admin.
How would you rate yourself in each of below and please provide a rating of 0 (no experience) to 5 (Expert) for each and provide number of years for each area:
Microsoft 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 cube building and maintenance. Separately, approximately how many cubes have you created?TSQLUse of CTEUse of IderaTroubleshooting SQL queries for deadlocking and blockingUse of database statisticsWorking in a high availability cluster SQL database environmentExperience with GITExperience with Azure DevopsExperience with PowerBIExperience with AWS Aurora
Summary:
Mid-Sized Financial Services company needs an MS SQL DBA to work within our IT department. Reporting to the Director of Applications, this candidate will assist in maintaining the internal databases for efficiency, performance, create ad-hoc reports and anticipate growth.Corporate office is located above Union Station but the position is remote with only occasional times coming to the office to meet with the team. Coming to the office isn't a standard routine (e.g. weekly).Key Position Responsibilities:
MS SQL Server Database AdministratorExtensive TSQL experience, including query optimizationCreate and maintain SSIS packagesCreate and maintain SSRS reports, and SSRS subscriptions, and maintain SSRS serverCreate and maintain SSAS cubesPerform code reviews for SQL work from the developers and provide guidance on acceptable code practicesMaintain knowledge of best practices surrounding IT technology, processes & database / support,Communicate with team members to gather accurate requirements for new enhancements and applicationsMaintain database documentation regarding data standards and proceduresNon-Technical Requirements :
6+ years Microsoft SQL Enterprise DBA experience is requiredExperience working in smaller teams within a growing environmentProven ability to independently manage tasks and priorities, accurately estimate work, and meet deadlinesAbility to work under minimal supervision in a fast-paced team environmentStrong problem-solving skills, detail-oriented, and self-motivatedExcellent verbal/written communication skills.Strong analytical and design skillsExperience translating functional requirements into technical specificationsAbility to escalate issues for resolutionTechnical Requirements:
Prior experience with backup strategies, clustering, log shipping, and DR testingPrior experience with High Availability Failover clusters, SQL server/job monitoring.Prior experience in performing software/patch updates to database serverHands-on experience creating, modifying, and analyzing SQL and T-SQL statementsProven knowledge of Stored Procedures, Tables, Views, Indexes, KeysUnderstanding 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 cubesPrior experience with Microsoft Management studioHands-on experience with Microsoft SQL Server Enterprise version 2016 and aboveProven experience using MS SQL Server database design & T-SQL, with the ability to write stored procedures, user-defined functions & SQL queriesPluses:
Use of performance tools such as IderaExperience with Git and Azure DevopsExperience with Power BIExperience with AWS Aurora