Position: Middle/Senior MS SQL Server DBA
Company: TEAM International
Experience required: 3y
Category: SQL
English level: intermediate
Published: 2021-09-01T00:00:00+03:00

Description
TEAM International Services Inc., is a US-owned and managed software development and technology consulting company with almost 30 years of experience and 1000+ employees on board globally. With delivery hubs in the US, Colombia, Ukraine, and Poland, we create dedicated teams for organizations to fill technological and expertise gaps. Furthermore, we develop our own products for the healthcare and oil & gas industries.

We are looking for MS SQL Server DBA to contribute to the big project in the US hiring industry. We develop, implement and maintain comprehensive enterprise level IT solutions for the hiring agencies. Our customers are using for hosting our datacenter equipment or on-premises solutions or mix of both.

Responsibilities:
• Administration and maintenance of MS SQL database (backup / restore, security, replication, T-SQL scripts, performance monitoring / tuning)
• Ensuring the reliability, availability and security of the centralized system infrastructure of the MS SQL database
• Working with highly loaded databases, large databases operating in High Availability mode
• Analyzing the performance of database servers, interacting with developers in writing and optimizing scripts, stored procedures, T-SQL queries, code review
• Configuring and optimizing performance of MS SQL 2012-2019 database servers (planning computing power, building fault-tolerant solutions, data replication, log shipping)
• Operational improvements, analysis of existing IT services, technologies, solutions and business needs for IT services
• Working with SSIS, SSRS services
• Ability to work overtimes for the high severity issues
• Ability to work with on-call schedule (on-call rotation for the DBA team members)
• Processes automation.

Requirements
• Administration of MS SQL database servers MS SQL 2012-2019, 3+ years
(backup / restore, security, replication, log shipping, T-SQL scripts, performance monitoring and tuning, queries performance tuning using plans, SSIS, SSRS)
• Hands-on experience with High Availability technologies: AlwaysON, Windows Cluster Services
• Hands-on experience in troubleshooting and tuning database and OS performance
• Practical experience with Extended Events, Query Store, SQL Server Profiler
• Designing and Optimizing Queries and Stored Procedures Using T-SQL (for the DBAs usage), ability to understand and optimise t-sql code, written by developers
• Experience with t-sql code optimization, code reviews
• Experience with SQL Central Management Server
• Network skills
• Intermediate or higher level of spoken/written English
• Ability to learn quickly and share experience
• Experience with versioning system.

As a plus:
• Experience with Azure SQL
• Practical experience with MS Windows Server 2012-2019
• Windows Performance logs
• PowerShell scripting.

Benefits
• Remote or office work according to your preferences
• Experience exchange
• Friendly team of professionals
• Competitive salary based on your experience level
• Free English classes
• 23+ working days of 100% paid vacation and sick days
• Sports reimbursement program
• Medical insurance health plan
• Modern and comfortable office facilities near the city center.