SQL Server Database Consultant

About the role

Pythian, a multinational provider of database and analytics services, is looking for a SQL Server Database Consultant. Working in a team-based approach, you will provide complete support for database and application infrastructure to a variety of clients, as assigned.

Key responsibilities

• Coordinate, analyse, design, implement and administer IT solutions based on Microsoft's Data Platform
• Recommend best practices for improving current operational processes
• Configure and maintain database servers and support SQL Server database services
• Administer backup procedures and disaster recovery plans, and run proactive daily checks
• Troubleshoot operational problems and respond to monitoring alerts
• Present technical courses to customers and peers, and communicate status and plans to customers and team members
• Take part in the on-call coverage rotation

Required profile

• Undergraduate degree in computer science, computer engineering, information technology or a related field, or equivalent experience
• Experience working directly with external customers and project management awareness
• White paper writing, blogging and presentation skills, plus excellent written and verbal communication
• Ability to lead and design technical project roadmaps with clients and internally
• Understanding of IT service standards such as ITIL

Required skills

• SQL Server administration, including storage management, third-party tools, performance tuning and management tools
• Backup and recovery strategies, replication, log shipping, mirroring, clustering, Always On Availability Groups
• SSRS, Power BI, SSIS and BI experience; coding scripts, procedures and functions
• Strong T-SQL scripting and tuning, and monitoring methods
• SSAS cubes, ETL and data warehouse support; cloud migration support is an asset
• Advantages: cloud solutions (Azure, AWS, Google Cloud), PowerShell, automation, Agile/Waterfall awareness

What we offer

• Competitive total rewards package
• Flexible remote work from home with a laptop and annual workspace budget
• Training allowance, professional development days and certification support
• Annual wellness budget, paid vacation and sick days, plus a day off to volunteer