Azure Synapse DBA

Azure Synapse Database Administrator Manages and maintains all production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. Bachelor’s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.

• 5 + years MS SQL Server database administration experience
• Prior experience of configuring large-scale deployment of SQL Server in Azure, Managed Instance/Azure SQL, in a 24X7 production support, development or test environments
• Experience with the provisioning/administration/operations of Azure Synapse Analytics/Dedicated SQL Pools
• Experience with Performance Analysis, query optimization & troubleshooting
• Identify, troubleshoot, and resolve performance issues including expensive SQL queries, blocking/deadlocking, excessive waits, etc.
• Experience using monitoring software
• Experience working with users to resolve issues
• Understanding network interactions, including on premise to Cloud
• Understanding and experience working with ETL/ELT and data migration tools
• Experience with the Azure portal, Azure PowerShell
• Experience supporting Azure or other cloud-based solutions
• Experience in PowerShell, TSQL
• Solid understanding of Database concepts, backups and restore

Supports multiple services and multiple databases of medium to high complexity (complexity defined by database size, technology used, multiple different systems and interfaces) with multiple concurrent users, ensuring control, integrity and accessibility of data. Works on multiple projects as a project leader or sometimes as a project advisor. May coach more junior technical staff. Database Administrator

• Install and maintain the performance of database servers.
• Develop processes for optimizing database security.
• Set and maintain database standards.
• Manage database access.
• Performance tuning of database systems.
• Install, upgrade, patching, and manage database applications.
• Diagnose and troubleshoot database errors.
• Engages with development teams throughout the software life cycle ensuring sustainable software releases and monitor application performance with the database
• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards.
• Capacity Planning
• Database reorganization planning
• Performance Tuning
• Be available for on-call support as needed.
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Understanding of relational and dimensional data modeling
• Unix shell scripting skills
• Excellent written and verbal communication skills
• Understanding and experience working with Active Directory/Azure Active Directory
• Previously experienced in a mid- to large-size firm and supporting multiple versions SQL Server environments
• Database security management, e.g. Design & implement Security framework, incl. database roles
• Experience creating Synapse resources, including schema creation
• Synapse Dedicated SQL Pool Workload Management
• Advanced performance monitoring and troubleshooting experience.
• Identify future risks in the environment before they happen and work with team to get the work prioritized.
• Strong problem solving and troubleshooting skills, an ability to use various data collection tools and methodologies to analyze problems, determine root cause and develop solutions
• Ability to follow standards
• Understands the importance of security
• Advanced performance monitoring and troubleshooting experience. Samprasoft