Senior SQL Server DBA

<p>Location: Poland (Office-Based/ Hybrid / Home-Based)</p> <p> </p> <p>Position Summary:</p> <p>Solving user’s technology problems is about attacking big problems with design, engineering, and compassion. We're committed to continually improving what we build and staying focused on user needs for the long haul.<br/> As part of our team, you will work with a group of engineers to design, develop, and deliver applications and services. You'll work in collaboration with our product and platform teams to better understand and translate policy and business requirements into features, user stories, automated tests, and working code. You will leverage your expertise to challenge our assumptions about the reliability of our deployment and the effectiveness of our processes as we strive to improve.<br/> The DBA will be responsible for working with development and operations teams to design and build resilient, well-performing data environments that meet our application needs in the most efficient, economic way possible.</p> <p> </p> <p>Your Day-to-Day:</p> <p>We're looking for experienced DBA to join our team in helping deliver the very best for our users, as they’re the reason we’re striving for excellence in everything we do.</p> <ul> <li>SQL Server database administration, configuration, load balancing, performance tuning, backup, high availability, and disaster recovery.</li> <li>Support SQL Server databases in a large-scale deployment both in Azure and On-Prem environments.</li> <li>Help applications migrate from On-Prem to Azure SQL.</li> <li>Upgrade end-of-life SQL Server versions.</li> <li>Monitor and optimize/tune SQL Server database performance.</li> <li>Troubleshoot database issues, maintain database systems availability and scalability, and do capacity planning.</li> <li>Analyze data access and modification requirements to ensure efficient SQL and optimal database design.</li> <li>Should be able to write, analyze, explain, troubleshoot, optimize, and improve advanced SQL queries.</li> <li>Willingness to learn and support other DBMS platforms.</li> <li>Create pipelines to deploy various self-service DB capabilities.</li> <li>Participate in enhancing and deploying new DBaaS offerings.</li> <li>Develop and enforce standards, policies, and procedures for managing databases.</li> <li>Promote a “one-team” approach for sharing common processes and practices.</li> <li>Support database operations and adhere to Change Management policies and procedures.</li> <li>Participate in On call rotation and immediately respond to alerts.</li> <li>Build a network of strong, collaborative relationships among all the stakeholders.</li> <li>Challenge established ways of doing things to improve the organization’s capabilities around commitments, actions, and results.</li> <li>Collaborate across teams to consolidate and simplify tooling and services.</li> <li>Build libraries, modules, and packages for services developed in order for others to integrate with their projects.</li> <li>Work closely with our product teams to ensure that we are shipping software that meets security, SLA, and performance requirements.</li> <li>Solve problems in ways that drive towards simplicity of architecture and operations.</li> <li>Share on-call responsibilities, including collaborating with other engineers to triage and fix issues that come up in production for our users.</li> <li>Help determine the future technical direction of our environment with a focus on improving reliability and performance.</li> <li>Work closely with product and platform engineers to triage production issues and determine appropriate remediation including code changes and performance considerations.</li> </ul> <p> </p> <p>What You Bring to The Team:</p> <ul> <li>5+ years of experience as an SQL Server DBA supporting both On-Prem and DBaaS solutions<a>.</a></li> <li>Must be familiar with SQL tools like: Azure Data Factory, SSIS, PowerShell, SQL Server Data Tools, T-SQL, bcp, and sqlcmd.</li> <li>Proficient in Azure SQL DB – creation, administration, and troubleshooting.</li> <li>Proficient in HA and DR technologies like SQL Always-on, SQL Clustering, log-shipping, Mirroring, Transactional replication, Load Balancing.</li> <li>Proficient in SQL Server and SQL Clusters database installation, upgrade, patching, maintenance, security, sysadmin functions and administration.</li> <li>Good knowledge of Azure platform services like network, storage, security, firewall etc.</li> <li>Strong problem solving and prioritizing skills.</li> <li>Knowledge of scripting languages, such as PowerShell and BASH considered a plus</li> <li>Ability to root-cause sources of instability on high-traffic, distributed systems.</li> <li>Strong understanding of reliability challenges of large-scale deployments.</li> <li>Strong critical thinking skills. You make sound decisions when faced with competing priorities and limited information.</li> <li>Someone interested in the why, not just the how. You like