We are hiring a SQL Server Engineer and architect to join our team. You will be responsible for creating innovative 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-term strategy and compliance requirements.
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.
Identify, troubleshoot and address poorly performing queries, database waits and deadlocks in production systems.
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.
Recommend changes to the relational data model to solve performance issues with SQL code.
Monitor and troubleshoot SQL jobs and processes using available tools such as SQL Profiler, Redgate, review logs and triage issues.
Participate in the resolution of production data issues.
Perform code reviews, providing feedback in a timely manner. Incorporate feedback from code reviews as appropriate.
Participate in the review of all database schema projects; provide feedback and identify impacts to existing environment.
Participate in the release of all stored procedure projects, including release documentation.
Maintain knowledge as new versions of SQL Server are released and leverage new functionality as appropriate.
Proactively identify and act on opportunities to improve database systems and processes.
Contribute to standards documentation for database coding practices.
Prioritize multiple tasks so that aggressive deadlines are met.
Provide after-hours support as required to address system outages and perform system updates/upgrades/modifications.
Perform other duties as required.

Essential traits:

B.S. Degree in Information Technology, Computer Science or a related discipline is preferred.
MCSE, AWS Certified
8+ years of experience in RDBMS Systems, with at least 5 years of database development and support in MS SQL Server environments
3+ years working experience in deploying physical and cloud instances of SQL Server. (AWS preferred) and scripting languages like PowerShell, VB Script, Python, or similar.
Experience designing data storage solutions outside of the RDBMS stack including non-relational DB engines and techniques
Understanding of JSON and XML data storage fields and extraction.
Bulk upload techniques and optimizations
Power Bi or similar tools
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking & deadlocking issues, replication/log shipping issues, network/connectivity issues, security issues, etc.
Experience tuning queries and use of optimization tools like query analyzer, and SQL Monitor, Redgate, New Relic or other APM, and other related tools
Ability to detect and troubleshoot SQL Server related hardware resource contention such as CPU, memory, disk IO, etc.
Solid acquaintance with windows server, security models, and storage components such as SAN.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server or similar AWS DB platforms
Advanced experience with TSQL language and stored procedures, transactional replication, multi node clustering, mirroring, etc.
A broad understanding of enterprise-class technologies
Extensive knowledge and experience with large scale client facing online systems, Amazon AWS technologies and Windows based technologies
Ability to communicate and to interact effectively with co-workers and customers is required.
Ability to work and adapt in a dynamic environment and recognize priority issues, escalating accordingly
Experience with creating standards and documentation
Ability to work both independently or as part of a project group, with time constraints
Strong customer service oriented; organizational and communication skills, positive and can-do attitude

Database Developer

Senior Database Developer