Position: Cloud DBA
Company: Yallah
Category: SQL
Experience required: 5y
English level: upper

As a technical specialist, this individual will work closely with our software architecture, information architecture, software development and DevOps teams providing technical guidance and expertise relating to data, databases, and supporting systems in solving complex problems and creating innovative solutions.

**Responsibilities:**

•	Oversee maintenance, configuration, and implementation of our Databases
•	Design, architect, and build databases from business requirements
•	Develop DB innovation, strategies, processes, and best practices
•	Map out the conceptual design for a planned database
•	Establish, manage, control, and monitor access permissions and privileges
•	Transforming / mapping conceptual application schemas to specific data model
•	Maintain data standards and adherence to all regulatory and compliance requirements
•	Ethically handle private and healthcare data (PII / PHI)
•	Work with engineering staff on db design changes to meet business requirements
•	Define and implement changes and improvements for db maintenance or protection
•	Support software developers with database operations including the development of complex SQL, writing, and troubleshooting complex stored procedures
•	Install, setup and test new versions of the DB
•	Develop, manage, and test back-up and recovery plans in conjunction with DevOps 
•	Define and implement storage, replication, partitioning and archiving procedures
•	Monitoring DB system performance / associated infrastructure and software
•	Reporting on metrics regarding usage and performance
•	Optimize current DB systems to ensure quality system performance including index tuning, disk optimization, partitioning schemes, and various other methods 
•	Perform sizing and capacity planning
•	Maintain data integrity and security, manage roles and permissions of database users
•	Generate traces, execution plans, identify performance issues, deadlocks / contention and remediate
•	Manage in production and non-production database environments
•	Set up and maintain database infrastructure supporting Analytics / BI processes
•	Author database documentation, including data standards, procedures, and definitions 
•	Availability for an after-hours and on-call support

**Qualifications:**

•	Bachelor's degree in computer science or a related field, MS preferred
•	6+ years’ experience managing enterprise level database environments
•	Strong background implementing distributed applications across cloud platforms
•	Strong fundamentals, including OOD, data structures, interface protocols, design, and networking concepts
•	Experience in backend, server, and API development, including application and database / data development and architectures
•	Background in No SQL and in-memory databases preferred
•	Uses of normalization methods and design methodologies
•	Working knowledge of full stack software development tools and methodologies, experience in Scrum / Agile methodologies (JIRA cloud, Azure DevOps) preferred
•	Strong interpersonal, organizational and communications skills
•	Experience supporting and mentoring other engineers by providing advice or coaching preferred

**Skills:**

•	Microsoft SQL Server and Azure DB
•	DB performance troubleshooting skills
•	DB monitoring and DB performance tuning and associated tools (e.g., Azure SQL DB / Azure SQL Managed Instance, ADF)
•	SQL and stored procedures, SQL Profiler
•	Query optimization and index management
•	ETL development and data integrations
•	Backup and recovery, HA / DR implementation (e.g., mirroring, log shipping, failover, etc.)
•	Code reviews for SQL best practices and identifying inefficient query structures
•	Other database related technologies (e.g., ElasticSearch, Redshift, Snowflake, PostgreSQL, etc.) preferred
•	Azure cloud technology stack (ARM, Bicep) preferred
•	Terraform Cloud preferred
•	Agile scrum development, experience with version control, GIT 
•	Basic knowledge of .NET Entity Framework