MS SQL DBA
MS SQL DBA
Syntricate Technologies
Chicago, IL
See who Syntricate Technologies has hired for this role
Job Title: MS SQL DBA
Location: Remote- Need local to IL only
Job Type: Full-Time
Key Position Responsibilities
Location: Remote- Need local to IL only
Job Type: Full-Time
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
- 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
- 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
- Use of performance tools such as Idera
- Experience with Git and Azure Devops
- Experience with Power BI
- Experience with AWS Aurora
-
Seniority level
Entry level -
Employment type
Full-time -
Job function
Information Technology -
Industries
Information Technology & Services
Referrals increase your chances of interviewing at Syntricate Technologies by 2x
See who you knowGet notified about new SQL Database Administrator jobs in Chicago, IL.
Sign in to create job alertSimilar jobs
People also viewed
-
Database Administrator
Database Administrator
-
SQL Server Database Administrator (DBA
SQL Server Database Administrator (DBA
-
Database Administrator
Database Administrator
-
Senior Database Administrator
Senior Database Administrator
-
Database Administrator II
Database Administrator II
-
Senior Database Administrator
Senior Database Administrator
-
Database Administrator
Database Administrator
-
Database Administrator - Remote | WFH
Database Administrator - Remote | WFH
-
Remote Work - Need Database Administrator
Remote Work - Need Database Administrator
-
Remote Sr SQL DBA/Developer
Remote Sr SQL DBA/Developer
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub