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 type: full-time
pay: $50, $70,000.00 per month
experience:
* microsoft sql server (2012–2019+) : 5 years (required)
* ssrs, ssis, ssas: 3 years (required)
* scripting: powershell, bash: 3 years (required)
* azure devops, azure sql/vm: 3 years (required)
* performance monitoring tools (dmvs, profiler): 1 year (required)
* ci/cd deployment tools (dacpacs, sql server database): 1 year (required)
* • basic linux and windows server administration: 1 year (required)
language:
* english (required)