< Back to search results

Sr.SQL Database Administrator

Redmond, Washington

Job number
008

Date posted
May 2,2018

Role Type
Employee

Profession
Engineers

Job Description:

You will be responsible for the design, development and support of the SQL Server Warehouse, ensuring its operational qualifiers like security, & speed, executing data loads and performing data modelling in support of multiple & global development teams. The data warehouse supports an enterprise application suite of program management tools. As a DBA you must be capable of balancing independence with collaboration.

Responsibilities:

  • 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 of system health and performance, to ensure high levels of performance, availability, and security.
  • Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
  • Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
  • Refine and automate regular processes, track issues, and document changes.
  • Assist developers with complex query tuning and schema refinement.
  • Provide 24x7 support for critical production systems.
  • Perform scheduled maintenance and support release deployment activities after hours.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Qualifications

  • Hands-on experience with SQL Server implementations including design, security, testing, troubleshooting, maintenance, optimization and support
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experience with backups, restores and recovery models
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Experience working with Windows server, including Active Directory
  • Experience generating SQL statements and stored procedures
  • Maintain and operate SQL Server development, test and production environments
  • Experience with database monitoring and troubleshooting
  • Relevant SQL Server database administration experience, ideally including development life cycle and Azure Cloud services
  • Working knowledge of native iOS and Android platforms

Additional experience beneficial would be

  • PowerShell scripting
  • Triggers and error handler development
  • Logging design and management