*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 global 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 *+)
- 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,* - $70,* 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)