Senior SQL Database Administrator

Summary

Join uShip as a Senior SQL Database Administrator and oversee the maintenance and optimization of SQL Server, MongoDB, PostgreSQL, and Solr instances. You will monitor system health, troubleshoot issues, and collaborate with development teams to enhance data models. Responsibilities include optimizing queries, conducting code reviews, and supporting analytics and reporting teams. This role requires extensive experience in performance tuning, high availability solutions, and T-SQL. You will also participate in an on-call rotation to ensure 24/7 operational reliability. The position offers a competitive salary and a range of benefits, including remote work options and wellness reimbursements.

Requirements

• 5 years of experience as a SQL Server DBA or similar role
• Extensive experience in Performance Tuning and Optimization, including execution plan analysis and indexing strategies
• Proficient in backup, restore, and recovery models, ensuring reliable data protection
• Strong knowledge of High Availability (HA) and Disaster Recovery (DR) solutions, particularly SQL Server Always On
• Expert in T-SQL DDL/DML with proficiency in scripting and SSIS
• Familiar with cloud-based database management on AWS, including EC2, RDS, and DynamoDB, with additional exposure to PostgreSQL, MongoDB, and Solr
• Understanding of Change Data Capture
• Solid grasp of Windows Server administration, including Active Directory integration
• In-depth understanding of SQL Server internals, including isolation levels, transaction and batch processing, lock management, and error handling
• Willingness to adopt a database-agnostic approach and learn and embrace emerging technologies
• Strong critical thinking and problem-solving abilities
• Excellent communication and interpersonal skills
• Proficiency with Windows PowerShell or Python for scripting and automation
• Proven ability to work collaboratively within a team, mentor other data professionals, and contribute to shared knowledge and development
• Proactive and self-motivated, with a strong ability to independently create and manage tickets, prioritize work effectively, and see projects through to completion

Responsibilities

• Oversee and maintain SQL Server, MongoDB, PostgreSQL, and Solr instances, ensuring optimal configuration, system integrity, and sustained site stability
• Continuously monitor system health and database performance to uphold high standards of availability, scalability, sustainability, security, and compliance
• Diagnose, troubleshoot, and resolve issues in real-time; communicate critical incidents promptly and manage recovery coordination
• Optimize and automate routine administrative tasks, manage incident tracking, and maintain thorough documentation of all changes using change management and proper procedures
• Collaborate closely with development teams to optimize queries, refine database schemas, and enhance data models
• Conduct thorough SQL code reviews with a focus on performance tuning, security, and scalability best practices
• Support analytics and reporting teams by managing and evolving existing data reporting systems
• Own critical system support through participation in an on-call rotation, ensuring rapid response and 24/7 operational reliability

Preferred Qualifications

• Experience with writing infrastructure as code
• Exposure to working inside an Agile development organization

Benefits

• Remote or hybrid work options
• Monthly Wellness Reimbursements
• Home office Reimbursements
• Company paid meal delivery pass
• 100% Paid Health and Dental available
• 401(k) matching, no vesting
• Stock Options
• Pet Insurance