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 (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, $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)