Trova Search

MUST CURRENTLY RESIDE IN IL.

This is primarily a SQL database engineer position, 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.