Shiritai

# Database Engineer - Schema Architect & Production DBA ## About the Role We're seeking a highly skilled Database Engineer to join our small, dynamic team. This role combines advanced database architecture with hands-on production management, offering unique opportunities to expand your technical expertise across multiple domains. As a core member of our collaborative team, you'll design mission-critical database systems while contributing to various technology initiatives. ## Key Responsibilities ### Database Architecture & Management •⁠ ⁠Design and implement complex, high-performance database schemas for mission-critical applications •⁠ ⁠Manage and optimize production database instances ensuring maximum uptime and reliability •⁠ ⁠Implement and maintain Redis caching strategies and data structures •⁠ ⁠Develop and maintain database security, backup, and disaster recovery strategies •⁠ ⁠Performance tune queries, indexes, and database configurations •⁠ ⁠Establish and enforce database development standards and best practices •⁠ ⁠Monitor database health, troubleshoot issues, and provide support as needed ### Collaboration & Cross-functional Work •⁠ ⁠Participate actively in team meetings and collaborative design sessions •⁠ ⁠Contribute to various technology projects beyond database management •⁠ ⁠Support team members with diverse technical challenges •⁠ ⁠Document database designs, procedures, and operational guidelines •⁠ ⁠Mentor team members on database best practices ## Required Qualifications ### Technical Expertise •⁠ ⁠*Expert-level proficiency in PostgreSQL* including advanced features (partitioning, replication, performance optimization) •⁠ ⁠*Strong experience with Redis* for caching, session management, and data structures •⁠ ⁠*Proficiency with Docker* and containerized database deployments •⁠ ⁠Proven experience designing complex database schemas for high-stakes production environments •⁠ ⁠Strong understanding of database normalization, denormalization, and data modeling principles •⁠ ⁠Experience with database migration strategies and version control •⁠ ⁠Proficiency in SQL query optimization and troubleshooting •⁠ ⁠Experience with backup, recovery, and high availability solutions ### Communication & Setup Requirements •⁠ ⁠*Excellent English pronunciation and verbal communication skills* - this is critical for our collaborative environment •⁠ ⁠Professional audio setup including quality microphone and headphones/speakers •⁠ ⁠Reliable high-speed internet connection suitable for video conferencing •⁠ ⁠Comfortable with frequent voice/video calls and real-time collaboration •⁠ ⁠Strong written communication skills for documentation and asynchronous communication ## Preferred Qualifications ### Homelab & Infrastructure Experience We highly value candidates with homelabbing experience and passion for self-hosted infrastructure: •⁠ ⁠*Networking*: Configuration of firewalls, VLANs, VPN servers (WireGuard, OpenVPN), network segmentation •⁠ ⁠*Container Orchestration*: Docker Compose, Kubernetes, Portainer, container networking •⁠ ⁠*Deployment & Automation*: CI/CD pipelines, GitLab/Jenkins, automated deployments •⁠ ⁠*Web Infrastructure*: Nginx/Traefik reverse proxies, SSL/TLS management, domain configuration •⁠ ⁠*Self-hosting Experience*: Running personal infrastructure, experimenting with various services •⁠ ⁠*Infrastructure as Code*: Terraform, Ansible, configuration management ### Additional Database Experience •⁠ ⁠Familiarity with other database systems (MySQL, MongoDB, Elasticsearch, etc.) •⁠ ⁠Experience with cloud database services (AWS RDS, Azure Database, Google Cloud SQL) •⁠ ⁠Database clustering and sharding strategies ### Tools & Processes •⁠ ⁠Experience with project management platforms (Jira, Asana, Monday.com, etc.) •⁠ ⁠Familiarity with CRM systems and their database requirements •⁠ ⁠Understanding of task management and internal process optimization •⁠ ⁠Experience with *Directus CMS* or similar headless CMS platforms •⁠ ⁠Knowledge of database integration with modern application stacks ### Bonus Skills •⁠ ⁠Experience with monitoring stacks (Prometheus, Grafana, ELK) •⁠ ⁠API design and development •⁠ ⁠Programming skills (web dev) •⁠ ⁠Security hardening and compliance experience •⁠ ⁠Backup automation and disaster recovery planning ## What We Offer •⁠ ⁠Opportunity to work on diverse, challenging technical projects •⁠ ⁠Skill development beyond traditional database roles •⁠ ⁠Small team environment with significant impact and visibility •⁠ ⁠Direct collaboration with all team members •⁠ ⁠Flexibility to contribute to various aspects of our technology stack •⁠ ⁠Growth opportunities in multiple technical domains •⁠ ⁠Environment that values curiosity and self-directed learning ## Work Environment This position requires active participation in a highly collaborative, small team setting. You'll be expected to: •⁠ ⁠Engage in frequent voice/video communications throughout the day •⁠ ⁠Adapt quickly to changing priorities and diverse technical challenges •⁠ ⁠Take ownership of critical database infrastructure •⁠ ⁠Contribute ideas and solutions across all technical areas •⁠ ⁠Maintain a professional remote work environment conducive to clear communication ## Ideal Candidate Profile The perfect candidate is someone who: •⁠ ⁠Runs their own homelab and enjoys experimenting with new technologies •⁠ ⁠Gets excited about solving complex data challenges •⁠ ⁠Can seamlessly switch between deep database work and broader infrastructure tasks •⁠ ⁠Enjoys learning and isn't afraid to dive into unfamiliar technologies •⁠ ⁠Values clear communication and collaborative problem-solving ## Application Requirements Please include in your application: 1.⁠ ⁠Examples of complex database schemas you've designed 2.⁠ ⁠Your experience with PostgreSQL, Redis, and Docker in production environments 3.⁠ ⁠Description of your current audio/video setup for remote work 4.⁠ ⁠Details about your homelab setup (if applicable) or infrastructure projects you've worked on 5.⁠ ⁠Any experience with Directus CMS or similar platforms *Note:* Strong verbal communication skills and reliable audio/internet setup are absolute requirements for this position. Candidates unable to maintain clear, consistent voice communication will not be considered. Job Type: Full-time Pay: ₹105,213.00 - ₹219,195.00 per month Benefits: Flexible schedule Work from home