Syntricate Technologies

MS SQL Developer/DBA

Syntricate Technologies • $135K — $148K *
Chicago, IL 60629In-Person
Information Technology
5 - 7 years of experience
1 month ago
Job Overview by Ladders

Qualifications

  • 6+ years of experience as an MS SQL Enterprise DBA
  • Proficiency in Microsoft SQL Server 2016 or higher
  • Hands-on experience with T-SQL, including creating stored procedures and functions
  • Experience in report creation and management using SSRS, SSIS, and SSAS
  • Knowledge of database performance optimization and troubleshooting
  • Ability to work independently in a fast-paced team environment
  • Excellent verbal and written communication skills

Responsibilities

  • Manage and maintain MS SQL databases for optimal performance
  • Optimize TSQL queries and perform code reviews for best practices
  • Develop and support ETL processes using SSIS packages
  • Create, manage, and document SSRS reports and subscriptions
  • Design and maintain SSAS cubes for business analytics
  • Collaborate with team members to gather requirements for enhancements
  • Document database standards and procedures for internal use

Benefits

  • Remote work flexibility with occasional in-office meetings
  • Opportunity to work in a mid-sized organization with a growing IT department
  • Engagement in a collaborative and fast-paced team environment
  • Ability to contribute to key technical decisions and improvements
  • Continuous learning opportunities with access to new technologies and tools
Full Job Description
MS SQL Developer/DBA
Chicago IL (100% remote)
Full Time
Web 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?
  • 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 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 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 Enterprise 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 Aurora

About Syntricate Technologies

Syntricate Technologies Careers

Joining Syntricate Technologies presents an unparalleled opportunity to advance a career in technology with a company at the forefront of digital innovation. Syntricate Technologies is renowned for its commitment to leadership, diversity, and leveraging technology to solve complex problems. This is where professionals come to not just seek job opportunities but to forge lasting careers in an environment that values growth and leadership.

Explore Career Opportunities

Syntricate Technologies is actively hiring and offers a variety of positions that cater to different skills and career aspirations. From entry-level roles to leadership positions, the potential for professional advancement is nearly limitless. Syntricate Technologies is not just a company; it's a place where talented individuals can thrive.

Innovation and Professional Growth

At Syntricate Technologies, innovation isn't just another buzzword—it's the cornerstone of the company culture. Employees are encouraged to push the boundaries of what is possible, bringing groundbreaking solutions to the table. With a team of dedicated professionals, Syntricate Technologies fosters a culture of continuous improvement and professional growth.

Diversity and Inclusion

Syntricate Technologies believes that diversity fuels innovation. With a commitment to creating a diverse and inclusive workplace, the company actively seeks to hire individuals from various backgrounds and experiences. Diversity training is integral, ensuring that all team members feel valued and understood.

Internship Programs and Employment Benefits

For those starting their careers, Syntricate Technologies offers robust internship programs that provide real-world experience and networking opportunities. Interns at Syntricate Technologies gain invaluable industry insights and professional skills that are crucial for future employment. Full-time employees enjoy a comprehensive benefits package that supports both their professional and personal lives. Benefits at Syntricate Technologies are designed to ensure employees are healthy, happy, and secure.

Applying for a Position

To apply for a position at Syntricate Technologies, candidates should prepare a resume that highlights relevant experience and skills. The interview process is designed to assess not only professional qualifications but also a candidate's fit within the company culture. Syntricate Technologies values curiosity, creativity, and a passion for technology.

Stay Connected with Syntricate Technologies Careers

Interested candidates are encouraged to explore the various job opportunities on the Syntricate Technologies careers page. Stay updated with the latest company news, employment trends, and career tips by subscribing to the Syntricate Technologies careers newsletter.

Join Syntricate Technologies

Discover the career possibilities that await at Syntricate Technologies. Search open positions that match your skills and interests. Syntricate Technologies is looking for passionate, driven, and innovative team players ready to contribute to a leading technology company.

SEARCH SYNTRICATE TECHNOLOGIES JOBS

Keep Up to Date

Stay ahead with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who work at Syntricate Technologies.

READ CAREERS BLOG

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. See what exciting and rewarding opportunities await at Syntricate Technologies.
Learn more about Syntricate Technologies
Size
51 employees
Industry
Information Technology
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Syntricate Technologies

More Information Technology Jobs

Find similar MS SQL Developer/DBA jobs:

NationwideChicago, IL