About the role we are seeking a highly skilled and motivated microsoft sql server dba administration and troubleshooting along microsoft azure and any ci/cd and automation is most relevant to manage, optimize and automate sql server environments for our client (a leading us based p & c insurer). You’ll ensure database integrity, performance and security—while leveraging azure devops ci/cd pipelines and scripting to support global development, test and production environments. Key responsibilities - administer and automate sql server instances (installation, configuration, upgrades, performance tuning, backup & restore). - automate repeatable tasks via azure devops pipelines (e.g. build/release, backups, restores, environment refreshes). - maintain performance and system integrity; optimize queries and server configurations. - enforce database security and access controls; manage permissions via self-service group structures. - define, enforce and document database standards and architectures. - review software changes for compliance with standards. - create and keep up-to-date architectural documentation and system design. - support integral environments (development, test, production) and provide on-call troubleshooting as needed. - recommend and implement new database technologies, tools and best practices. - build reports, dashboards and visualizations using sql server reporting tools. - where applicable, step up to mentor colleagues and promote a continuous learning culture within the team. Experience & qualifications - required (minimum): - 5 years of hands-on experience in microsoft sql server administration including backups, restores, performance tuning, ssrs/ssis/ssas and scripting (powershell, bash). - experience with azure devops pipelines and ci/cd processes for database automation and deployment. - familiarity with both windows/linux server environments. - exposure to cloud environments (microsoft azure; exposure to aws is a plus). - knowledge of data warehousing concepts and working with large, complex data sets. Technical skills & tools needed: - experience with microsoft sql server (2012-2019) - experience with ssrs, ssis, ssas - experience with scripting: powershell, bash - azure devops, azure sql/vm - performance monitoring tools (dmvs, profiler) - ci/cd deployment tools (dacpacs, sql server database projects) - basic linux and windows server administration soft skills - strong problem-solving and analytical abilities - good communication and documentation capabilities - team-oriented mindset with a commitment to continuous improvement - ability to collaborate across global teams and time zones - on-call support may be required as needed job types: full-time, permanent pay: $50,000.00 - $70,000.00 per month education: - bachelor's (required) experience: - ssrs/ssis/ssas : 5 years (required) - azure devops, azure sql/vm: 5 years (required) - linux and windows : 5 years (required) - scripting: powershell, bash: 5 years (required) - ci/cd : 5 years (required) - sql: 5 years (required) - sql server: 5 years (required) language: - english (required) j-18808-ljbffr