Sr. SQL Server DBA
Coyote Logistics was founded in 2006, built with passion and dedication to create a phenomenal company culture. We are a company that has heart and soul, and a drive for success. As a third-party logistics (3PL) provider, Coyote is dedicated to helping its customers move their products and manage their supply chains efficiently, and we take care of our carriers to keep them moving so they can grow their businesses too. We are fanatical in our goal to provide unparalleled service excellence to each and every customer and carrier we work with. In addition to its recognition as one of the Leading 3PLs in the industry, Coyote continues to change the industry expectation by executing with unprecedented service and unmatched innovation.
SQL Server DBA
This MS SQL Server DBA position is largely responsible for providing database services as well as development support to our organization. We are looking to fill a need to have a competent and highly motivated individual in this role. This is a production DBA role, as such it will require a commitment on your part as well as ours. Some of the primary responsibilities of this role would include the design, installation, monitoring, and performance tuning of production, test/development, and QA database environments while ensuring high levels of data availability. The DBA is also responsible for implementing, and overseeing database policies and procedures to ensure the integrity and availability of our SQL databases and their accompanying software.
Our Environment
Our team is responsible for various instances in a mixed physical & virtual environment (VMware & HyperV) running SQL Server 2012 & 2014 & 2016. We're utilizing log shipping, transactional replication as well as high availability groups, have a large SSRS implementation and are in the process of improving our BI capabilities utilizing a data warehouse with SSAS. We support our internal & external operations and are an important partner for the development teams working on our mobile, web- and client server applications.
Essential Skills, Characteristics, & Experience
- A BS in Information Technology, Computer Science or a related technical field or equivalent work experience.
- At least 5 years recent hands on experience in SQL Administration from SQL Server 2008 R2 onwards.
- Basic knowledge of Windows Server administration (incl. Active Directory) & an idea about proper disk configurations.
- Experience with SQL Server in both physical & virtual environments.
- Familiarity with backups, restores and recovery models.
- Experience utilizing various high availability (HA) and disaster recovery (DR) options for MSSQL Server.
- An interest in performance tuning along with a basic understanding of how to read execution plans.
- Experience working in an agile 24/7/365 environment.
- The ability to discuss database related topics with both technical & business audiences.
- Strong problem solving skills and a commitment to getting things done right.
- Eagerness to learn and help others.
Valued Skills & Experience
- Working with code repositories, done code reviews and heard of continuous integration/deployments before.
- A fan of automation with the ability to bring additional knowledge around this topic (e.g. Powershell etc.) to our team.
- Familiarity with one or more of the 3rd party products we use (Quest Spotlight/Litespeed, Redgate Toolbelt, SQLSentry Plan Explorer, TFS, Octopus Deploy, ServiceNow)
- Active in the SQL Server community (e.g. have a blog, go to user group meetings etc.).
- Thrive in a collaborative environment and are overall fun to be around.
- MongoDB a plus
Why Coyote?
- A spot in a tight-knit team of professionals who love SQL Server.
- A chance to work with a large variety of technologies across the SQL Server stack (if you ever thought about replicating into a high availability group that spans two separate datacenters - we do it).
- Focus on learning and development that will help further your career (our team members took classes with some of the best last year)
- Colleagues that will hold you to the highest standards and support you in doing your best work (we don’t like quick & dirty solutions that work for now instead of doing what’s right).
- A unique and casual work-environment (we do work hard but also like to have fun!).
- A competitive base salary.
- A comprehensive benefits package.
- Other great perks like on-site haircuts, massages and intramural sports.
Coyote is an at-will Employer.
- Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.
- Please view Equal Employment Opportunity Posters provided by OFCCP here.
- The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)