Build the future, spark innovation and align your career with purpose.

McKinstry is innovating the waste and climate harm out of the built environment and creating lasting impact. Together, we’re building a thriving planet.

Buildings are a leading contributor to the climate crisis, generating nearly 40% of total global energy-related carbon emissions. We’re making a lasting impact on our industry and within our communities by addressing the climate, affordability and equity crises through:

renewables and energy servicesengineering and designconstruction and facility services

To get where we’re going, we need big thinkers, problem solvers and collaborative mindsets. Does that sound like you?

 

The Opportunity with McKinstry

We are adding a Database Administrator to our growing Technology division in Seattle, WA. You will be responsible for providing technical support for the database environment.  This includes overseeing the security, development and organization of the databases, assessment and implementation of new technologies, and providing IT with insights to align database technology with the company’s business needs. Other responsibilites include:

Database Environment

Manage database backup and recovery procedures to meet the company’s Recovery Point Objectives (RPO).  Test backups to ensure Recovery Time Objectives (RTO) can be met.Take ownership to drive Tier-1 database-related incidents/tickets to completion in a timely manner.Collaborate with McKinstry Business Systems, Corporate Services Systems, Finance & Accounting Systems, and IT Operations to help achieve a state-of-the-art environment that meets current and future business objectives.Perform application tuning and database performance monitoring.Troubleshoot database server service outages as they occur, including after-hours support.Assist developers in improving the performance of poor-performing queries.Ensure that data is protected from unauthorized access and maintain database access security and integrity.Configure monitoring of database servers and resources.  Develop support plans for all database environments, including creating stored procedures and scripts to automate recurring database administration processes.Create and maintain documentation on McKinstry’s database environment.Install, upgrade, and manage database applications.Perform scheduled maintenance and support release deployment activities during maintenance window.Deploys database change scripts provided by developers and third-party vendors.Uses established change control, documentation and communications processes.Ensures SQL Server license compliance and cost-effective use of existing licensing.When performance issues arise, determines the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.Other duties as assigned.

Communication

Closely collaborate with technology team, and other staff from across the enterprise in data and application integrations.Provides internal stakeholders with regular reports of resource-intensive queries and suggests ways to improve performance.Organize, articulate, and advocate on best practices for the use of SQL tools.Excellent verbal, written and interpersonal communication skills, including the ability to communicate effectively with the IT organization, project and application development teams, management, and business personnel. 

What You Need to Succeed at McKinstry

Five (5) years of experience with Microsoft SQL Server in a production environment required.Three (3) years of demonstrated experience as a SQL Server DBA required.Experience with the following is required:Supporting MS SQL Servers in an enterprise environmentSecurity best practicesSQL Server high availability technologies, such as failover clustering, database mirroring and Always-on Availability GroupsSQL Server Integration Services and Reporting ServicesProfiler tracesDMV queries to proactively manage servers and individual database performanceT-SQL, stored procedure development, query optimization and tuning.Experience with the following is a plus:Strong System Administration background in Active Directory, authentications (e.g. Kerberos, gMSA), and Windows Server OS.Database monitoring with Redgate and SolarWinds/DPA is a plus.Supporting enterprise payroll and ERP systems is a plus.Power BI Report ServerExperience with cloud-based offerings, technologies and architecture. Demonstrated experience in transitions between on-prem and cloud hosting services is a plus.Experience developing and owning data warehouse solutions in large scale, complex enterprise environments is a plus.Strong team player, able to work independently and as a participating member of technology team in charting initiatives, direction and best practices across the enterprise.

PeopleFirst Benefits

When it comes to the basics, we have you covered:

Competitive pay401(k) with employer match and profit-sharing planPaid time off and holidaysComprehensive medical, prescription, dental, and vision with low or zero deductible options and low out of pocket maximums

People come first at McKinstry, and we go beyond the basic benefits with:

Family formation benefits, including adoption and IVF assistanceUp to 16 weeks paid parental leaveTransgender inclusive benefitsCommuter benefitsPet insurance“Building Good” paid community service timeLearning and advancement opportunities via McKinstry UniversityMcKinstry Moves onsite gyms or reimbursement for remote workers

See benefit plan documents for complete details.

If you’re driven by our vision to build a thriving planet together, McKinstry is the place to build your career.

The pay range for this position is $80,100 - $134,400 per year; however, base pay offered may vary depending on job-related knowledge, skills, and experience. Base pay information is based on market location. A bonus may be provided as part of the compensation package, in addition to a full range of medical, financial, and/or other benefits, dependent on the position offered.

The McKinstry group of companies are equal opportunity employers. We are committed to providing equal employment opportunities to all employees and qualified applicants without regard to sex, gender identity, sexual orientation, age, race, color, creed, marital status, national origin, disability, veteran status, genetic information or any other basis protected by law. This policy applies to all terms and conditions of employment including, but not limited to employment, advancement, assignment, and training. This commitment to Equal Employment Opportunity is made equally as a social responsibility and as an economic and business necessity.

McKinstry is a drug-free workplace. Employment is contingent upon successfully passing a pre-employment drug and alcohol test, complying with the requirements of the Immigration Reform and Control Act and a Confidentiality Agreement, in addition to successful outcomes of background and reference checks.

Applicants for this role will only be considered if they possess current US Work Authorization, and do not require employer-sponsored VISA support to begin or remain in this role.

#LI-LB1

Share