Lead Database Engineer

Lead Database Engineer

Requirements

• Experience with designing and implementing large-scale database systems at enterprise and/or Internet scale
• Minimum of 10+ years of experience in administering and managing SQL Server.
• Minimum of 3+ years of experience in SQL Server 2019 and above.
• Minimum of 5+ years of experience in administering either MySQL, MariaDB or PostgreSQL.
• Hands-on experience with SQL Server Always On, Failover Clustering, and Log Shipping.
• Familiarity with PowerShell & python scripting and automation frameworks.
• Ability to lead and influence others in a highly flexible and fast-moving environment
• Intrinsic self-starter and problem solver
• Good communication skills
• Desire to work in a fast paced, evolving, growing, and dynamic environment
• Experience with performance tuning and a broad knowledge base of indexing strategies, In-Memory OLTP technologies and best practice SQL standards
• Ability to collaborate with SQL developers and solve problems
• 5+ years of developing and scaling MS SQL Server SaaS applications.
• Solid understanding and experience with NoSQL dbs
• Experience with administration and configuration of sharded, multi-tenant databases
• Experience with Database Encryption Strategies (Encryption per Client, PIP encryption)
• Experience with scaling databases on Cloud platforms (preferably Azure)
• Familiarity with one or more industry standard source control solutions (Git preferred – experience with DACPAC a plus)
• Familiarity with monitoring tools like SolarWinds DPA or Datadog.
• Agile experience
• Bachelor’s in computer science, Engineering, Information Technology, other relevant degrees, or comparable work experience

Responsibilities

• Collaborate with stakeholders from across the organization to set priorities and drive toward implementation
• Partner with our Architecture team in the design, build, and creation of our data platform
• Ensure database systems meet all requirements of performance, availability, scalability, quality and security to produce world class products
• Lead by example, delivering high-quality work products; champion quality standards, performance and scalability
• Research new technologies and stay ahead of industry
• Design and implement resilient and performant database processes and solutions
• Develop custom stored procedures, views, or user-defined functions
• Participate in database design and data access strategies
• Collaborate with cross-functional teams
• Debug and tune/optimize SQL code either directly or indirectly from application
• Support Tier2 development team with database requests as needed (including bug fixes, production data manipulation and feature testing)
• Coach, develop and mentor the database engineers in technical tools and techniques to maximize their individual contribution and professional growth to ensure they are successful
• On-call duty may be required, responding to critical DB alerts and escalate if needed

Preferred Qualifications

• Experience designing and building Distributed Database ecosystems
• Solid understanding of Spark, Cassandra, Snowflake SSIS and SSRS
• AWS/Azure/Azure SQL
• Elasticsearch
• Data visualization and analytic software tools such as Tableau