Outlook Amusements operates a leading B2C consumer marketplace through its flagship brand, California Psychics. They are seeking a Manager of Database Engineering to lead the design, development, and operations of enterprise SQL Server databases and other modern database technologies, ensuring high-performance and secure data environments.
Responsibilities:
- Lead and mentor the Database Engineering and DBA team, promoting collaboration and technical excellence
- Manage SQL Server databases across production, QA, and development environments, with a strong hands-on focus on performance, scalability, and reliability
- Design and maintain HA/AG clusters, Disaster Recovery strategies, Standard and Enterprise SQL Server configurations, seeking cost-effective and efficient solutions even beyond Enterprise features where possible
- Build and optimize data warehouses, data lakes (e.g., Snowflake), and ETL processes to support analytics and BI
- Develop, tune, and optimize SQL queries, stored procedures, and data models for high performance and scalability
- Proactively monitor and analyze performance using Datadog, SQL Profiler, PerfMon, and internal system views (DMVs)
- Create and maintain ERD diagrams, ensuring well-documented and scalable database architecture
- Collaborate closely with Product, QA, Engineering, and Data Analytics/BI teams to ensure database reliability, scalability, and alignment with business objectives
- Ensure compliance with data security, retention, and privacy policies, implementing proper auditing and encryption standards
- Provide technical guidance and mentorship to DBAs and developers, fostering a culture of continuous improvement and knowledge sharing
Requirements:
- 10+ years of hands-on SQL Server experience (administration and development)
- 3+ years managing or leading database teams in enterprise environments
- Proven experience with HA/AG, replication, partitioning, and indexing strategies in an online, high-availability environment meeting 99.99% uptime
- Strong knowledge of data warehouse and data lake design (Snowflake preferred)
- Advanced skills in SQL performance optimization and system-level diagnostics
- Experience with AWS RDS/EC2/S3 and Azure SQL environments
- Excellent analytical and problem-solving skills with strong attention to detail
- Strong communication and leadership skills, with the ability to collaborate across teams