Position: Data Architect
Company: JustAnswer
Experience required: 5y
English level: upper

**Requirements:**
**Must have:**

— High-level proficiency in SQL within OLTP systems
— A drive for excellence in data modeling
— Good problem-solving capabilities
— Ability to coordinate multiple tasks, set and negotiate priorities
— Strong communicator both in Ukrainian/Russian and English

**Nice to have:**

— NoSQL experience
— SQL Server experience
— Database Administration familiarity
— PowerShell and C# knowledge
— Power BI familiarity
— Experience with database process automation
— Experience in Agile/Scrum and Lean development methodologies
— Experience with 24×7 database operation
— Experience optimizing database queries for performance
— Knowledge of any relational database hosted in the cloud

**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

**Responsibilities:**

— Advocate continuous improvement of the data persistence layer, with a focus on high-quality data modeling
— Extend our CICD database deployment with more automated checking and error monitoring
— Develop and document database standards
— Provide coaching and mentorship for developers on data modeling and our database standards
— Review designs and code from software developers
— Refactor the SQL code base regularly
— Analyze the efficiency of data access in production, devise and implement optimizations to improve that efficiency
— Produce and track metrics around database efficiency and performance
— Troubleshoot issues with relational and NoSQL databases
— Assist DBAs in troubleshooting data performance issues, planning data storage, optimizing indexes
— You may be required to work weekend or evening hours to support the resolution of production issues on occasion