Database Reliability Engineer

Working as a part of the Database Operations team within a larger operations group, this position will design and support the database environments for multiple high-volume e-commerce and back-office applications in On-premises and Cloud-based databases. This role will collaborate with developers and analysts in creating and ensuring the reliability, performance, and scalability of database systems within the Internet Business organization. ACCOUNTABILITIES & ESSENTIAL FUNCTIONS

• Performing Development team database queries and database design reviews.
• Installing and configuring Databases (primarily SQL Server), applying patches, fixes, and monitoring.
• Assist in troubleshooting and resolving database-related issues, including performance tuning, backup and recovery, and replication in Production environments.
• Working in Azure to identify performance issues and then remediate them as necessary.
• Working in a team environment to construct and maintain database systems to meet agreed-upon resiliency patterns.
• Collaborate with technical & business teams to understand and select appropriate configurations for their application and review database and query design.
• Monitor lower environments to detect any performance impact as changes are implemented.
• Utilize monitoring solutions to provide prompt alerting of issues and outages.
• Supporting both on-premises and cloud database topologies in terms of performance and uptime.
• Assisting the Internet Operations team in patching and maintenance duties.
• Deploying Database systems and code changes via pipelines / IAC.
• Communicating proactively with business users, stakeholders, technical peers, and project teams.
• Research and stay up to date with the latest technologies, trends, and best practices in SQL Server and Azure to propose and implement innovative solutions.
• Perform on-call rotation duties.

• Experience in Microsoft SQL 2016, 2019, 2022
• Experience in Azure SQL, CosmosDB, and/or Azure Database Management.
• Experience in TSQL programming and querying databases.
• Working with Azure Dev Ops Pipelines to assist the teams in reviewing and promoting the work, desired.
• Experience in Source Control (GIT, Evolve/Flyway), desired.
• Experience in working with SSIS packages, desired.
• Excellent problem-solving and analytical skills, with the ability to quickly identify and resolve database-related issues.
• Understanding of Database design with both relational and document-based systems.
• Certification on SQL 2019 and (or) on Azure SQL, desired.

• Bachelor's degree in computer science or engineering, Software Engineering, Information Technology, or relevant discipline
• Industry knowledge of performance monitoring, backup principles, and oversight.
• Experience in monitoring of Database technologies in Azure and on-premises solutions.
• Experience in designing, deploying, and monitoring database systems in Azure and or other Cloud platforms.
• Experience in scripting using PowerShell, desired.
• Experience in IAC (Terraform), desired.