Job description

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)

Requirements