We are hiring a SQL Server Engineer and architect to join our team. You will be responsible for creating creative software solutions using existing SQL server tech stack and related technologies. Our ideal candidate has a deep understanding of database technologies and is familiar with various design and architectural patterns for data storage techniques. As a SQL server engineer and DBA, you will not only design and develop the backend of cutting-edge web applications using the latest technologies, but also lead our application stack to the next level of database technologies leveraging Azure and AWS services. You will be responsible for overseeing quality standards to ensure the best practices are being used in development across all persistence layers and collaborating with the offshore development team. You will also communicate effectively with the team and provide technical guidance and support as needed.
The day-to-day responsibilities include but not limited to:
The Database Administrator will be assigned to work with one or more development project teams.
In this role they will be expected to:
- Act as a technical subject matter expert for all persistence layers used in development, with specific skills in Microsoft SQL Server and T-SQL.
- Identify the appropriate persistence layer(s) for new development, considering both availability, performance, size and security.
- Work with 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.
- Maintain data models, schema diagrams and data dictionaries for business-critical data systems
- Understand the business and application requirements and translate into a database design.
- Ensure that all technology selected for the program conforms to the organization's technical long