Our client is seeking a Database Administrator to join their team in Portland, Oregon. The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of all SQL Server systems to ensure the availability and consistent performance of internal applications.
Manage SQL Server databases through multiple product lifecycle environments from development to mission-critical production systems. Configure and maintain database servers and processes including monitoring system health and performance, to ensure high levels of performance, availability, and security.
Test and configure database backups to meet the business s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes. Assist developers with complex query tuning and schema refinement.
Provide application developers with feedback on resource-intensive queries on the server and suggesting ways to improve performance on each. Design indexes for existing applications, proactively monitor query performance, and determine when to add or remove indexes.
Troubleshooting SQL Server service outages as they occur, including providing Oncall support during after-hours and weekends. After-hours work may also include, but not limited to scheduled maintenance, supporting application deployment, and hardware/software upgrades.
Plan and schedule the installation and configuration of new SQL Servers. Analyze the requirements for new projects and determine whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies to solve a business problem.
Implement SQL Server monitoring utilities; refine and automate regular processes, track issues, and document changes. Configure access levels for each segment of the database.
Share expertise with team members providing technical mentorship and cross-training as needed.
Bachelor s degree in computer science or a related field from an accredited college or university AND 3+ years in support of a MS SQL Server Administration operating system, database management system or a related field OR two years of experience at the lower level Database Administrator 2 or position equivalent.
Hands-on experience working with Microsoft SQL Server 2008, 2012, 2016 & higher (stored procedures, triggers, functions, views, constraints & indexes).
Experience with Performance Tuning and Optimization (PTO) using native monitoring and troubleshooting tools.
Ability to execute backup, restore, and database recovery.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
Experience working with Windows server including Active Directory.
Understanding of different database models and styles (OLTP, OLAP).
Excellent written and verbal communication skills. Ability to give effective verbal presentations to stakeholders, and respond to questions from a diverse audience.
Must be able to act both independently and as a team member. Flexible, get-it-done personality.
Ability to multi-task and context-switch effectively between different activities and teams. Preferred.
Expertise in/hands-on experience with failover clustering, SAN replication, and other high availability technologies.
Hands-on experience with SQL Server patching and upgrades.
Experience with developing scripts for SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.
SQL Server merge, peer to peer, or transactional replication.
Analysis Services, Integration Services, or Reporting Services.
Experience in Enterprise Design for high volume, transactional environments.
Experience in virtualized environments.
SQL 2012 2016 MCTS, MCITP, and/or MCDBA certifications are a plus.
Bachelor s degree in computer science or a related field from an accredited college or university.
Support of a MS SQL Server Administration operating system, database management system (3 years).
Microsoft SQL Server 2012 AND/OR 2016 & higher (3 years).
Experience with Performance Tuning and Optimization (PTO) (3 years). Active Directory (3 years). Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server (1 year).
Understanding of different database models and styles (OLTP, OLAP) (3 years).
Test and configure database backups to meet the business s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) (3 years).
MCDBA certifications are a plus SQL Server Database Administrator -- SQL Server 2012, SQL S Bachelor s Degree, Active Directory, High Availability (HA), Disaster Recovery (DR), Integrity Check, Performance Tuning and Optimization (PTO).
Benefits are available to eligible VanderHouwen contractors and include coverage for medical, dental, vision, life insurance, short and long term disability, and matching 401k.
VanderHouwen is an award-winning, Women-Owned, WBENC certified professional staffing firm. Founded in 1987, VanderHouwen has been successfully placing experienced professionals throughout the Pacific Northwest and nationwide. Our recruitment teams are highly specialized in either Technology and IT, Engineering, or Accounting and Finance career markets. Our recruiters value building meaningful, professional relationships with each candidate as well as developing honed knowledge of companies' staffing needs and workplaces. Partner with us to land your next exciting career.
VanderHouwen is an Equal Opportunity Employer and participates in E-Verify. VanderHouwen does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state or federal civil rights laws.
Not Ready to Apply?