Provides recommendations and insight on data management, governance procedures, and intricacies applicable to the acquisition, maintenance, validation, and utilization of data. Adds to team culture of diversity, equity, inclusion, and...
Description:Job responsibilities
- Provides recommendations and insight on data management, governance procedures, and intricacies applicable to the acquisition, maintenance, validation, and utilization of data
- Adds to team culture of diversity, equity, inclusion, and respect
- Works with other team members to resolve any high priority issues
- Helps to manage internal cloud (GAIA) application pools
- Designs and maintains robust software solutions for monitoring and alerting as needed
- Works with the team on any infrastructure and code database performance issue utilizing SQL Sentry
- Helps in monitoring and troubleshooting SQL Server Availability Groups including replication issues and database failovers
- Works with the team on certificate tracking and renewals
- Provide after-hours (on-call coverage) on weekly scheduled basis
Required qualifications, capabilities, and skills
- Formal training or certification on infrastructure engineering concepts and 3+ years applied experience
- Strong experience with relationaldatabase systems
- Experience and/or solid understanding of transact SQL
- Strong proficiency in SQL infrastructure, including Availability Groups.
- Knowledge of PowerShell and ETL processes
- Ability to work collaboratively with cross-functional teams, including non-technical business stakeholders
- Experience with operating internal cloud applications
- Excellent communication skills with the ability to convey complex technical concepts to non-technical audiences
- Experience with version control systems such as Git and bitbucket for data
- Experience working with development teams from operational and controls perspective
- Experience with overall SQL troubleshooting
Preferred qualifications, capabilities, and skills
- Proficient with PowerShell
- Experience tuning and troubleshooting T-SQL queries and indexes
- Experience with internal cloud application infrastructure