SQL Server Database Consultant

What will you be doing?

• Coordinating, analyzing, designing, implementing and administering IT solutions based on Microsoft's Data Platform.
• Recommending best practices for improvements to current operational processes. Configuring and maintaining database servers.
• Supporting SQL Server Database services. Administering backup procedures and disaster recovery plans.
• Troubleshooting operational problems.
• Administering proactive daily checks.
• Responding to monitoring alerts.
• Presenting technical courses to customers and peers.
• Participating in on-call coverage rotation plan.
• Communicating status and planning activities to customers and team members.

What do we need from you?

• While we understand you might not have everything on the list, to be successful you are likely to have skills such as:
• Installing, configuring and upgrading from previous SQL Server versions like 2008 up to 2022 databases.
• SQL Server Administration including: Managing Server and Database storage.
• SQL Server third party tools.
• Performance tuning of database server.
• SQL Server management tools.
• Designing and implementing various backup/recovery strategies.
• Replication, log shipping, mirroring, clustering, Always On Availability Groups.
• SSRS & Power BI, SSIS, and BI experience.
• Coding scripts, procedures, functions, etc.
• Strong T-SQL scripting and tuning experience. Performance tuning experience.
• Developing methods for monitoring database systems.
• SSAS: Support of cubes, ETL processes and data warehouse environments.
• Supporting cloud migrations and environments would be considered an asset.
• Awareness of development practices including but not limited to agile and waterfall.
• Working directly with external customers.
• Project management notions.
• White paper writing, blogging and presentation skills.
• Excellent written and verbal communication skills.
• Administering cloud solutions inc but not limited to Azure, AWS and Google Cloud.
• Developing cloud solutions inc but not limited to Azure, AWS and Google Cloud.
• Ability to lead and design technical project roadmaps with clients and internally.
• PowerShell experience is an advantage.
• Automation experience is an advantage.

Personal attributes:
• Interfacing with external customers, strong customer service focus with the ability to maintain customer expectations and priorities.
• Excellent oral and written communication.
• Self-motivated and directed, while working in a fast-paced demanding environment.
• Keen attention to detail.
• Strong analytical, evaluative, and problem-solving abilities.
• Very effective organizational skills.
• Ability to work in a team.
• Demonstrate sound work ethics.
• Understanding of current IT service standards such as ITIL.
• Undergraduate degree in computer science, computer engineering, information technology or related field or equivalent experience.

What do you get in return?

• Love your career: Competitive total rewards and salary package. Blog during work hours; take a day off and volunteer for your favorite charity.
• Love your work/life balance: Flexibly work remotely from your home, there’s no daily travel requirement to an office! All you need is a stable internet connection.
• Love your coworkers: Collaborate with some of the best and brightest in the industry!
• Love your development: Hone your skills or learn new ones with our substantial training allowance; participate in professional development days, attend training, become certified, whatever you like!
• Love your workspace: We give you all the equipment you need to work from home including a laptop with your choice of OS, and an annual budget to personalize your work environment!
• Love yourself: Pythian cares about the health and well-being of our team. You will have an annual wellness budget to make yourself a priority (use it on gym memberships, massages, fitness and more). Additionally, you will receive a generous amount of paid vacation and sick days, as well as a day off to volunteer for your favorite charity.