Senior SQL Server Database Administrator
A US Company is searching for a Senior Database (SQL/MSSQL) Administrator for a Long-Term partnership.
Fully remote work (or in any of the 3 existing offices in Ukraine & Poland).
Start out as a part-time contractor 20+ hrs/wk to allow time to deeply integrate with the company's systems, processes, and team dynamics without the immediate pressure of a full-time workload. Grow into a full-time position as our current lead DBA moves towards retirement
Need to work during US Office Hours – 8 am – 5 pm MT (7 pm-2 am Kyiv time).
Role and Responsibilities
• High-Availability & Business Continuity: Architect, manage, and maintain our SQL Server Enterprise Always-On Availability Groups to ensure maximum uptime and business continuity. Develop, test, and document disaster recovery strategies and procedures to safeguard critical data.
• Performance Optimization & Tuning: Proactively monitor database health and performance, identifying and resolving bottlenecks in real-time. Optimize complex T-SQL queries, stored procedures, and indexing strategies across SQL Server, SSAS, and SSRS environments to enhance application responsiveness.
• Infrastructure & Automation: Administer and maintain our SQL Server environment running on AWS EC2 instances, ensuring stability and scalability. Develop and enhance PowerShell scripts to automate routine administrative tasks, monitoring, and deployments.
• Development & BI Support: Collaborate with software engineering teams to design, create, test, and deploy efficient and secure stored procedures for application data access. Administer and ensure the high availability of our load-balanced SQL Server Analysis Services (SSAS) and Reporting Services (SSRS) platforms.
• Security & Operations: Implement and enforce database security best practices, manage user permissions, and conduct regular security audits to protect sensitive financial data. Participate in a scheduled PagerDuty on-call rotation to provide 24/7 support for critical production incidents.
• Source Control & Deployment: Integrate database schema changes, stored procedure updates, and configuration modifications into our team's CI/CD pipeline using Git for version control.
Qualification Requirements
• A minimum of 5 years of hands-on experience administering Microsoft SQL Server Enterprise environments (2016 or later)
• Working knowledge of MDX for querying SSAS cubes.
• Proven, in-depth experience managing high-availability solutions, specifically with SQL Server Always-On Availability Groups.
• Demonstrable expertise in advanced performance tuning, query optimization, and index management.
• Hands-on experience managing and troubleshooting SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) in a load-balanced configuration
• Proficiency with T-SQL, including creating, editing, and performance testing complex stored procedures, views, and table-valued functions for application data access.
• Solid experience with Windows Server administration, specifically in the context of managing SQL Server on AWS EC2 instances.
• Practical experience using Git for version control of database scripts and code.
Preferred Skills
• Broader experience with other AWS services relevant to server/data management (e.g., S3, RDS, IAM).
• Prior experience administering databases that process financial transactions, with a strong understanding of data integrity, security, and compliance requirements.
• PowerShell scripting skills for database automation, monitoring, and reporting.
• Relevant industry certifications, such as Microsoft Certified: Azure Database Administrator Associate or AWS Certified Solutions Architect.
• 3rd party data visualization tools like AWS QuickSight, Tableau, and PowerBI.
• Infrastructure as Code (IaC) tools, particularly AWS CloudFormation.
• AWS RDS SQL Server instances, including backup / restore to Amazon S3 for our Data Warehouse product overring.
• AWS Database Migration Server (DMS) for performing data synchronization.
• Monitoring systems using tools like AWS CloudWatch and NewRelic.
Additional Notes
This position reports to the CTO and is a key component of the overall success of our engineering group. While this position initially starts out at 20/hrs/wk, it will grow into a full-time position as our current lead DBA moves towards retirement.
Hiring process:
Step 1 - preliminary interview (main questions) - up to 30 mins
Step 2 - internal tech interview (tech questions) - up to 60 mins
Step 3 - tech interview with team leader - up to 60 mins