Position: Database Administrator
Company: JustAnswer
Category: SQL
Experience required: 5y
English level: intermediate
Published: 2022-02-01T00:00:00+02:00

JustAnswer is an online marketplace that is revolutionizing professional services by making fast, affordable expert help accessible to people everywhere. Hailed by The Huffington Post as “destined for glory,” our company is made of smart, hard-working people who know how to have fun and get things done. From doctors, lawyers, and vets to auto mechanics and tech support, the 10,000 experts on JustAnswer have helped over eight million people in 196 countries since 2003. Headquartered in the beautiful Presidio of San Francisco, our mission is simple and inspiring: “We help people.” JustAnswer, LLC is backed by investors Crosslink Capital, Glynn Capital, and Charles Schwab.

**Responsibilities:**

-Monitor system’s health and performance
-Manage SQL Server databases and backups
-Database release process support
-Ensure high levels of performance, availability, sustainability, and security
-Analyze, solve, and correct issues in real-time
-Provide suggestions for solutions
-Perform scheduled maintenance

**Requirements:**

**Must have:**

-High-level proficiency in SQL within OLTP and DW systems
-5+ years of database administration with a primary focus on SQL Server
-Good problem-solving capabilities
-Ability to coordinate multiple tasks, set and negotiate priorities
-Experience with SQL Profile, Extended Events, QueryStore
-Extensive hands-on experience in tuning hardware for performance
-Strong understanding of SQL Server internals and issue resolution
-High Availability and Data recovery
-Experience designing and deploying large scale databases with multiple locations
-Experience with consumer-facing 24×7 high traffic websites
-SQL Server Audit and Security
-Experience with supporting high volume and high traffic OLTP environment

**Nice to have:**

-NoSQL and MySQL experience
-PowerShell and C# knowledge
-Power BI familiarity
-Experience with database process automation
-Experience optimizing database queries for performance
-Knowledge of any relational database hosted in the cloud
-Experience with Partitioning, Compression
-Experience with GIT
-Experience with CI\CD
-Experience with SQL Server AlwaysOn Cluster setup and Fail-over technology
-Familiar with Database Cloning technology
-Experience with SQL Server Analysis Services and supporting high volume data warehouses ETL

**We offer:**

-Time off throughout the year (paid and unpaid)
-Professional development support and encouragement
-Resources to help improve your overall well-being
-Free membership to dive into JA product