SQL Server Database Consultant

Pythian; Stati Uniti; Remoto; USD 110.000 - 170.000; Tempo pieno

Vantaggi offerti da questo lavoro

Remote work

Training allowance

Wellness budget

Paid vacation

Volunteer day

Descrizione del lavoro

Pythian is seeking a community-minded SQL Server Database Consultant to join the world’s largest MSSQL professional team. You will provide end-to-end database and application infrastructure support for diverse clients, with a focus on SQL Server administration, performance tuning, backup and disaster recovery, and BI tooling.

As part of a collaborative, remote-friendly team, you will work on on-call rotations, implement cloud migrations (Azure/AWS/Google Cloud), and contribute to proactive

Competenze

• Undergraduate degree in computer science, computer engineering, information technology or related field or equivalent experience.
• Experience administering Microsoft SQL Server environments and related BI tooling.
• Proven ability to design and implement backup/recovery strategies for mission-critical databases.

Mansioni

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

Conoscenze

SQL Server Administration

T-SQL scripting

Performance tuning

Backup and recovery

Always On Availability Groups

PowerShell

Cloud migrations

Communication skills

Formazione

Undergraduate degree in computer science or related field

Strumenti

SSMS

Power BI

SSIS

VSCode

GitHub

Azure

AWS

Google Cloud

Descrizione del lavoro

Why you:

Are you a community-minded SQL Server DBA? Inspired by ever-shifting challenges, constant growth and collaboration with a team of peers who push you constantly to up your game? At Pythian, we are actively shaping what it means to be a database administrator, and we want you to be a part of the world’s largest team of MSSQL professionals. As a SQL Server Database Consultant you will, as part of a team based approach, supply complete support for all aspects of database and application infrastructure to a variety of clients, as assigned.

What you will 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 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 2025 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.
• Experience in VSCode and GitHub integration
• 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 you will receive:

• Love your career : Competitive total rewards 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.

Hiring Disclaimer

• The successful applicant will need to fulfill the requirements necessary to obtain a background check.
• Accommodations are available upon request for candidates taking part in any aspect of the selection process.

AI Disclaimer

Pythian may utilize Enterprise Generative Artificial Intelligence (AI) tools or features throughout its hiring process. These tools help us manage high volumes of applications efficiently and may be employed to review applications, analyze resumes, and assist with other recruitment steps. While Pythian uses AI in its hiring process, it does not substitute for human judgment. Our Talent Acquisition Team reviews all AI-generated recommendations, and the system is subject to regular bias audits to ensure fairness and compliance with all applicable employment and human rights laws. All final hiring decisions are made by, and remain the responsibility of, human decision-makers. By applying for this position, you consent to Pythian’s use of these AI tools in the evaluation of your application. You have the right to request a human review of any solely AI-driven decision or to request an accommodation. Should you require further details regarding the processing of your data, please reach out to us.