Synapse XTL - Senior Database Administrator - SQL Server

Job Description

Synapse is a digital transformation company. We provide end-to-end services, from managed cloud operations to application development. We are a unique technology group-a firm with highly passionate, driven team members who constantly push the boundaries on innovative technology solutions to enterprise-level clients. We also have one of the world's automated multi-cloud deployment and monitoring systems, which can inject massive amounts of enterprise data for real-time threat monitoring and data visualization. The Database Administration team, supporting the CA and Pacific Northwest regions, performs database and production operational functions in support of SQL Server environments across multiple CDOs. We are looking for a Senior SQL Server DBA with expertise in all areas of SQL Server to support database management, security, performance tuning, capacity planning, high availability, disaster recovery, and lifecycle management. This role will be interfacing with multiple teams to meet business objectives and deliverables. The ability for the candidate to work independently, with strong communication and organizational skills, is required. Experience : 7+ years Location : India (Remote) Primary Responsibilities Assess the health of the database environment, troubleshoot issues, and determine course of action for resolution. Ensure proactive monitoring, notification, and maintenance is in place to optimize the availability and performance of systems and applications. Perform database management activities with planning for security, performance, and scalability. Automate operational processes. Provide and implement solutions for high availability and disaster recovery of critical databases. Perform capacity planning and management to ensure databases are adequately configured to support business growth. Facilitate dialog across functional areas and provide consultative direction. Deploy system and application database changes in accordance with change management procedures. Evaluate lifecycle management requirements and implement solutions. Job Requirements Undergraduate degree or equivalent. 7+ years of SQL Server Database Administration experience. 5+ Years of SQL language and Transact-SQL experience. 5+ Years of experience with SQL Server Always On Availability Groups. 5+ Years of experience with SQL Server Integration Services, Reporting Services, Analysis Services. 3+ Years of experience with 3rd party database backup solutions. 2+ Years of experience with SQL Server on a Cloud platform. Proficient in troubleshooting performance issues using native monitoring and troubleshooting tools. Experience with SQL Server 2012 thru 2022 to support SQL Server Upgrades. Experience automating processes with PowerShell. Strong communication and organizational skills. Must Have Skills Server Database Administration. SQL language and Transact-SQL. SQL Server Always On Availability Groups. SQL Server Integration Services, Reporting Services, Analysis Services. 3rd party database backup solutions. SQL Server on a Cloud platform. (ref:hirist.tech)