Syntax is a leading Managed Cloud Provider for Mission Critical Enterprise Applications and has been providing comprehensive technology solutions to businesses of all sizes since 1972. Syntax has undisputed strength to implement and manage ERP deployments (Oracle, SAP) in a secure and resilient private, public or hybrid cloud. With strong technical and functional consulting services, and world-class monitoring and automation, Syntax serves some of North America’s largest corporations across a diverse range of industries. Syntax has offices worldwide, and partners with Oracle, SAP, AWS, Microsoft, IBM and other global technology leaders.
Greetings from Syntax (https://www.syntax.com).
We have an Urgent requirement for the position of Senior Microsoft SQL Server DBA
Job Type: Permanent
Experience: 8+years
Location: Remote-India
Job Title: Senior Microsoft SQL Server DBA
Shift Timings: This position will work Rotational shifts (Morning, Afternoon IST Hours)
Position Summary
Reporting to the Manager of DBA Operations, the individual will be fully responsible for all technical matters related to Microsoft SQL Server databases, including but not limited to installation, upgrades, high availability/disaster recovery, performance tuning, security, and coordinating/executing all code and data migrations across on-premises and cloud platforms.
Responsibilities
- Should have deep, hands-on expertise administering Microsoft SQL Server (2016 through 2022) in enterprise, multi-customer environments.
- Must have advanced experience with SQL Server High Availability/Disaster Recovery technologies such as Always On Availability Groups, Failover Clustering, Log Shipping, and Replication.
- Install, configure, and maintain SQL Server instances on-premises and on cloud platforms such as AWS RDS/EC2 and Azure SQL/Managed Instance.
- Perform database refreshes, schema/table refreshes, and creation/management of logins, users, roles, and permissions.
- Perform backup, restore, and point-in-time recovery (PITR) of databases, including validation of backup integrity.
- Monitor database performance using native and third-party tools; identify and resolve blocking, deadlocking, and query performance issues.
- Perform index maintenance, statistics updates, and query/execution plan tuning.
- Lead and execute SQL Server patching and version upgrade activities with minimal downtime.
- Participate in and lead disaster recovery (DR) planning, testing, and execution for customer environments.
- Configure and maintain SQL Server Agent jobs, alerts, and automated maintenance plans.
- Implement and maintain database security, including Transparent Data Encryption (TDE), Row-Level Security, and auditing.
- Work with development and application teams on database design review, capacity planning, and migration projects.
- Open and manage support cases with Microsoft, AWS, and/or Azure as needed.
- Work in flexible shifts as demanded by project or on-call requirements.
- Communicate regularly and professionally with clients via email and phone.
- Work within a ticketing tool (e.g., ServiceNow) to track and resolve incidents and requests.
- Demonstrate strong analytical and problem-solving skills in a fast-paced, multi-client environment.
Qualifications
- 8+ years of strong, hands-on experience as a SQL Server DBA, supporting installation, configuration, administration, and performance tuning in production environments.
- Proven experience with Always On Availability Groups, Failover Clustering, Log Shipping, Replication, and Mirroring.
- Experience administering SQL Server in cloud environments such as AWS RDS/EC2 and/or Azure SQL Database/Managed Instance is highly desirable.
- Strong experience with backup and recovery strategies, including native backups, third-party tools (e.g., Redgate, Quest LiteSpeed), and PITR.
- Solid experience with performance monitoring and tuning, including execution plan analysis, indexing strategy, and wait-statistics analysis.
- Experience with SQL Server security hardening, TDE, auditing, and compliance requirements.
- Working knowledge of PowerShell and T-SQL scripting for automation of routine DBA tasks.
- Experience with SSIS, SSRS, and/or SSAS is a plus.
- Experience supporting ERP or other mission-critical enterprise applications on SQL Server a plus.
- Experience working in a managed-services or offshore/onshore delivery model supporting multiple customers concurrently.
- Familiarity with monitoring tools such as SolarWinds, SentryOne/SQL Sentry, or Redgate Monitor a plus.
- Excellent troubleshooting and root-cause analysis skills for issues arising from day-to-day production operations.
- Ability to work independently and interact effectively with diverse teams (application, network, infrastructure, and business users).
- Microsoft Certified: Azure Database Administrator Associate, MCSE: Data Management and Analytics, or equivalent certification a plus.
- Excellent written and verbal communication skills.
Why Syntax?
Become a part of our success story and work in a company with exciting innovation projects that are causing a stir across the industry. We recently launched one of the world's most advanced manufacturing facilities based on SAP S/4HANA Cloud and SAP Digital Manufacturing Cloud for Execution - for Smart Press Shop, a pioneering joint venture between Porsche and forming specialist Schuler.
- Competitive, above-average compensation
- Global tourist: With us, you can also work from abroad from time to time
- Flexible working time models, home office
- Attractive benefits, e.g. company pension scheme or various health offers
- A modern environment in which the "you" is part of it
- Open feedback culture, flat hierarchies and a motivated team
- Individual career planning with continuous training and coaching on the job
You see a personal challenge in this responsible task? Apply now - and become part of the SYNTAX team!
