SQL Server Database Consultant

Responsibilities:

• 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.

Skills:

• 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.

Benefits:

• 💼 Competitive total rewards and salary package.
• 💻 Flexibly work remotely from your home.
• 🌟 Collaborate with some of the best and brightest in the industry.
• 📚 Hone your skills or learn new ones with our substantial training allowance.
• 🖥️ We give you all the equipment you need to work from home.
• 🧘 Annual wellness budget to make yourself a priority.
• 🏖️ Generous amount of paid vacation and sick days.
• 🤝 Day off to volunteer for your favorite charity.

Qualifications:

• Interfacing with external customers, strong customer service focus.
• 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.

Application:

Apply at Up2staff