SQL Server Database Consultant

Employment Type: Full Time Location Type: REMOTE - USA Salary: Not specified

Position Overview

Pythian is seeking a community-minded SQL Server DBA to join their team. As a SQL Server Database Consultant, you will provide comprehensive support for all aspects of database and application infrastructure for a variety of clients, working as part of a team. Pythian is an expert in strategic database and analytics services, driving digital transformation and operational excellence.

Why Pythian?

• Experts in strategic database and analytics services.
• Driving digital transformation and operational excellence.
• Multinational company founded in 1997 with a strong reputation for solving tough data challenges.
• Experienced in on-premises to cloud migrations and advanced analytics.
• Empowering organizations with AI and advanced technologies.
• Strong partnerships with Google Cloud, AWS, Microsoft, Oracle, SAP, and Snowflake.
• Opportunity to work with the world's largest team of MSSQL professionals.

Why You?

• Inspired by ever-shifting challenges, constant growth, and collaboration.
• Desire to shape the future of database administration.
• Community-minded SQL Server DBA.

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 plans.
• Communicating status and planning activities to customers and team members.

Requirements

• SQL Server Installation, Configuration, and Upgrades: Experience installing, configuring, and upgrading SQL Server databases from versions like 2008 up to 2022.
• SQL Server Administration:
  • Managing Server and Database storage.
  • Utilizing SQL Server third-party tools.
  • Performance tuning of database servers.
  • Proficiency with SQL Server management tools.
  • Designing and implementing various backup/recovery strategies.
  • Experience with Replication, Log Shipping, Mirroring, Clustering, and Always On Availability Groups.
• BI and Development:
  • SSRS & Power BI, SSIS, and BI experience.
  • Coding scripts, procedures, and functions.
  • Strong T-SQL scripting and tuning experience.
  • Performance tuning experience.
• Monitoring: Developing methods for monitoring database systems.
• SSAS: Support of cubes, ETL processes, and data warehouse environments.
• Cloud Experience: Supporting cloud migrations and environments is considered an asset.
• Methodologies: Awareness of development practices including but not limited to Agile and Waterfall.
• Customer Interaction: Working directly with external customers.
• Project Management: Notions of project management.
• Communication Skills: White paper writing, blogging, and presentation skills. Excellent written and verbal communication.

Company Culture & Engagement

• Explore life at Pythian using #pythianlife on LinkedIn.
• Follow @loveyourdata on Instagram.
• Check out other job openings at Pythian Careers.