Desired Skills and Experience
- Utilizing and sharing your extensive knowledge of database: design, development, performance tuning, sharding, distributed architectures, security, etc.
- Designing scalable, maintainable, high availability database solutions that align with future data needs across our entire cloud product line.
- Providing support and technical expertise including schema and query design to development, QA and other teams.
- Acting as the development team database liaison with DevOps
- Recommending solutions for SQL Server performance monitoring and tuning.
- Analyzing problems, anticipate future problem areas and implement solutions.
- Being available outside of normal business hours as second tier DevOps support as needed to help resolve database related system outages.
- 5+ years of experience with Microsoft SQL Server developing and tuning high traffic websites and SaaS applications.
- Extensive knowledge of best practices for ORMs like Entity Framework.
- Experience with PowerShell scripting, Visual Studio Database Projects and SSDT
- Extensive knowledge of Microsoft T-SQL, stored procedures, triggers, and indexing and statistics.
- Experience working with very large databases.
- Knowledge of NoSql databses such as DynamoDB, Cassandra, and BigTable is a huge plus.
- Knowledge of other aspects of Microsoft SQL Server including administration, replication, backup/restore procedures and related components such as Reporting Services, Analysis Services and Integration Services is a plus.
- Excellent work ethic and willingness to put in extra time as needed.
- Positive attitude and ability to work in a fast-paced environment