Remote GN - Sr. Database Administrator - 169

Description:

• We are seeking a seasoned professional with deep expertise in SQL Server to enhance our data team's capabilities.
• This role primarily focuses on designing, implementing, and maintaining robust data infrastructure solutions that underpin our organization's product offerings.
• Key responsibilities include creating enterprise-level data architectures, managing transactional databases for critical business applications, and ensuring optimal database performance through advanced administration and optimization techniques.
• You will play a pivotal role in developing data ingestion and processing workflows while ensuring data quality and integrity.
• The position sits within the larger data team and actively collaborates with application development teams to maintain and optimize databases supporting OLTP workloads.
• Embrace the challenge of working with large-scale transactional databases and utilize your proficiency in SQL Server, T-SQL, and scripting tools such as PowerShell and Python for automation tasks.
• Note that while containerization technologies and data visualization tools are beneficial, the primary focus remains on backend data engineering tasks.
• A strong understanding of Azure SQL Database and maintaining SQL Server instances is crucial for this role.

Requirements:

• 5+ years of hands-on experience with SQL Server (2016/2019/2022), with strong emphasis on SQL Server administration and optimization, including clustering and replication.
• Advanced proficiency in T-SQL, including the development of stored procedures, functions, and triggers.
• Extensive experience in designing and maintaining large-scale application databases, with a focus on ensuring performance and scalability.
• Proficient in database performance tuning and optimization for OLTP workloads, with a strong understanding of indexing strategies and query tuning.
• Proficiency in PowerShell and Python for automation and scripting tasks.
• Experience with transaction management, concurrency control, and locking mechanisms to ensure database integrity.
• Familiarity with data visualization tools (Power BI, Tableau, or similar).
• Knowledge of version control systems, such as Gitlab, and experience with database deployment and migration tools.
• Familiarity with cloud platforms, particularly Azure, and basic understanding of services like Azure SQL Database.
• Working knowledge of API integration and data exchange formats, including JSON and XML.
• Experience with application database monitoring and optimization under high transaction volumes.
• Understanding of database schema versioning and migration strategies.
• Intermediate proficiency in C# for scripting and automation is a plus.

Benefits:

• The position offers the opportunity to work with cutting-edge technologies and large-scale databases.
• You will be part of a collaborative team environment that values innovation and problem-solving.
• There are opportunities for professional development and growth within the organization.
• The role provides a chance to influence data governance standards and best practices.
• You will gain experience in cloud technologies and data engineering workflows.