Database Engineer

This is primarly a sql database engineer but you will also need to have some experience doing DBA work: Leverage advanced knowledge of relational database systems, including strong T-SQL development skills and hands-on administration of Microsoft SQL Server and Azure SQL environments. Develop, configure, and support database architectures that meet operational requirements, application functionality, and organizational data standards. Monitor database environments to ensure optimal performance, quickly troubleshoot issues, and maintain system stability, uptime, and data accuracy. Establish and maintain database security measures to safeguard confidential information and minimize potential vulnerabilities or unauthorized access. Manage backup processes and support disaster recovery planning by testing and maintaining reliable recovery and restoration procedures. Produce and maintain detailed technical documentation related to database configurations, processes, architecture, and performance reporting. Utilize analytical thinking and problem-solving abilities to investigate and resolve complex database and system issues. Work collaboratively with software developers and technical teams to enhance database performance and support application integrations. Build and manage scalable data pipelines for collecting, transforming, and processing data from diverse sources while maintaining efficient data structures and schemas. Partner with business stakeholders, analysts, and data science teams to translate business needs into practical and scalable technical solutions. Maintain high standards for data governance by implementing validation, monitoring, and testing practices that ensure data quality and integrity. Coordinate with infrastructure and IT operations teams to oversee cloud-based database services and data processing platforms. Apply best practices in relational database management, data modeling, and database optimization techniques. Support database release management activities, including deployments and environment promotions across production and non-production systems in alignment with SLA requirements. Keep up to date with evolving technologies, trends, and industry standards related to database administration and data engineering. Contribute to additional projects and responsibilities as needed to support departmental and organizational goals. 3-5 years of practical experience supporting and managing relational database management systems in enterprise environments. At least 2 years of hands-on experience working with Microsoft Azure technologies, including Azure SQL, Managed Instances, Azure Automation, Logic Apps, Azure Synapse, and Azure Data Factory. Strong background in SQL and T-SQL development with experience in performance optimization, transactional replication, auditing, and remediation of compliance or security vulnerabilities. Proven experience designing, developing, optimizing, and troubleshooting scalable data pipelines and data integration processes. Two or more years of experience across data management disciplines, including data integration, data modeling, data optimization, data quality, archiving, and data purging. Experience implementing CI/CD pipelines in cloud environments using DevOps tools such as Git and GitHub. Proficiency in database diagnostic and performance tools, including SQL Profiler and SQL Dynamic Management Views (DMVs). Experience creating logical and physical data models using industry-standard data modeling tools. Proficiency with development and database tools such as Visual Studio 2022 or later, SQL Server Management Studio (SSMS), and Visual Studio Code. Must be available to participate in a rotating 24x7 on-call schedule to support production systems.