About the position
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 services, engineering and design, and construction and facility services. 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.
Responsibilities
- 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.
- Deploy database change scripts provided by developers and third-party vendors.
- Use established change control, documentation and communications processes.
- Ensure SQL Server license compliance and cost-effective use of existing licensing.
- When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
- Other duties as assigned.
Requirements
- 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 supporting MS SQL Servers in an enterprise environment.
- Experience with security best practices.
- Experience with SQL Server high availability technologies, such as failover clustering, database mirroring and Always-on Availability Groups.
- Experience with SQL Server Integration Services and Reporting Services.
- Experience with profiler traces.
- Experience with DMV queries to proactively manage servers and individual database performance.
- Experience with T-SQL, stored procedure development, query optimization and tuning.
Nice-to-haves
- Strong System Administration background in Active Directory, authentications (e.g. Kerberos, gMSA), and Windows Server OS.
- Database monitoring with Redgate and SolarWinds/DPA.
- Supporting enterprise payroll and ERP systems.
- Power BI Report Server.
- Experience with cloud-based offerings, technologies and architecture.
- Demonstrated experience in transitions between on-prem and cloud hosting services.
- Experience developing and owning data warehouse solutions in large scale, complex enterprise environments.
Benefits
- Competitive pay
- 401(k) with employer match and profit-sharing plan
- Paid time off and holidays
- Comprehensive medical, prescription, dental, and vision with low or zero deductible options and low out of pocket maximums
- Family formation benefits, including adoption and IVF assistance
- Up to 16 weeks paid parental leave
- Transgender inclusive benefits
- Commuter benefits
- Pet insurance
- "Building Good" paid community service time
- Learning and advancement opportunities via McKinstry University
- McKinstry Moves onsite gyms or reimbursement for remote workers
