MS SQL DBA

RESPONSIBILITIES:
The Senior Database Administrator will be assigned to work with one or more development project teams. In this role they will be expected to:

·           The System Engineer will be responsible for building, supporting and managing end-to-end solutions within Amazon AWS and Azure Cloud environments.
·           Support SCRUM teams in an Agile development environment.
·           Working with the Solutions Designer, Development Architect and third parties as appropriate, the engineer will be responsible for ensuring that a technical design document describing the technical architecture for the program/project is produced.
·           Understand the business and application requirements and translate into a database design.
·           Ensure that all technology selected for the program conforms to the organizations technical long-term strategy.
·           Be responsible for the availability, stability, recoverability and performance of the database environment by ensuring all systems are monitored, patched, and operating optimally. 
·           Design and develop complex SQL queries and appropriate database code such as stored procedures, triggers, functions to support complex business processes.
·           Develop and deliver extensible/sustainable/quality database solutions based on defined business needs.
·           Review and update stored procedures for optimal performance. Identify and correct performance bottlenecks related to SQL code.
REQUIREMENTS:

•            B.S. Degree in Information Technology, Computer Science or a related discipline is preferred.
•            MCSE/Azure Certification preferred.
•            5-8 years of experience in database development and support in MS SQL Server environment.
•            3+ years working experience in deploying physical and cloud instances of SQL Server. (Azure preferred)
•            2+ year of working with PostgreSQL.
•            Working Knowledge of Databricks administration and Datalake, is a plus. (Azure Preferred)
•            Working knowledge noSQL database technology. (Mongo, Cosmos, Others)