MS SQL DBA

Syntax is a leader in providing Cloud and Managed Services to businesses across North America. Syntax's cloud offerings, including their best-in-class Enterprise Cloud for ERP continues to grow and accelerate; a unique offering that safely hosts and manages critical business applications. Syntax partners with global IT leaders such as Oracle, IBM and others.

Location: Remote

Job Type: Permanent

Shift timings: 3:30pm to 1:30am IST/Normal Indian timings (Either any one)

Experience with Performance Tuning and Optimization (PTO), using native monitoring and

troubleshooting tools

Experience with backups, restores and recovery models DB

SQL Backups tools.

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL DB Server

General knowledge working with Windows Servers, including Active Directory

General Knowledge of operating systems such as Windows, Linux

Good scripting skills with at least one of the following (Python, Bash).

Proven experience with DB monitoring and performance tuning, including tracing database

performance issues, identifying common and uncommon performance bottlenecks, and tune SQL, PL/ SQL.

Advanced working SQL and query authoring (SQL) databases.

Hands on experience with MySQL

Expertise knowledge SQL & other database query languages.

Intermediate knowledge of ITIL Service Management concepts and methodologies

Established commitment to meeting organizational and departmental goals and objectives

Practical knowledge of creating and reporting metrics and KPI's

Understand SLA and ensure the SLAs are met as per the agreement with the customer

Keep the Inventory up to date for all instances

Lead and participate in outage calls

Generate daily SEP risk report and send to SEP site engineers and EUC team along with instructions and ensure daily SLA with the customer.

Experience working in software industry as on Application Development, Maintenance, Enhancement, Testing and support.

Experience in system & integration testing of the coding done.

Must have ability to multi-task

Ability to learn to learn newer technologies that are needed for the project.

Experience on Trading partner setup.

To maintain policies and procedures for the routine task, and emergency network deployment within the area of the client.