Database Administrator (term-limited)

Salary range is $70k to $165k, with a midpoint of $115k.  New hires typically receive between minimum and midpoint, however, we may go slightly higher based on experience, internal equity and market.

This is a term-limited position expected to last 4 years.

Sound Transit also offers a competitive benefits package with a wide range of offerings, including:

• Health Benefits: We offer two choices of medical plans, a dental plan, and a vision plan all at no cost for employee coverage; comprehensive benefits for employees and eligible dependents, including a spouse or domestic partner.
• Long-Term Disability and Life Insurance.
• Employee Assistance Program.
• Retirement Plans: 401a – 10% of employee contribution with a 12% match by Sound Transit; 457b – up to IRS maximum (employee only contribution).
• Paid Time Off: Employees accrue 25 days of paid time off annually with increases at four, eight and twelve years of service. Employees at the director level and up accrue additional days. We also observe 12 paid holidays and provide up to 2 paid floating holidays and up to 2 paid volunteer days per year.
• Parental Leave: 12 weeks of parental leave for new parents.
• Pet Insurance.
• ORCA Card: All full-time employees will receive an ORCA card at no cost.
• Tuition Reimbursement: Sound Transit will pay up to $5,000 annually for approved tuition expenses.
• Inclusive Reproductive Health Support Services.
• Compensation Practices: We offer competitive salaries based on market rates and internal equity. In addition to compensation and benefits, you’ll find that we provide work-life balance, opportunities for professional development and recognition from your colleagues.

GENERAL PURPOSE: 

Under general direction, is responsible for the monitoring, integrity, and security of assigned Agency databases; performs database backups and disaster recovery; monitors SQL servers and databases and provides research, analysis, and troubleshooting; assists with designing and creating new databases; and data modeling and optimization to improve database performance.

ESSENTIAL FUNCTIONS:
The following duties are a representative summary of the primary duties and responsibilities. Incumbent(s) may not be required to perform all duties listed and may be required to perform additional, position-specific duties.

• Validates completion of database scheduled backup jobs by reviewing the backup logs; ensures the backup strategies are implemented based on the appropriate data repository business need; performs ad-hoc SQL backups before and after making changes to the databases to ensure database recoverability; creates a Disaster Recovery plan and follows the processes identified in the plan by periodically testing database restores to ensure that backups are viable.
• Reviews SQL Server and Windows Error logs, Alerts, SQL Server Agent and Database Mai to identify any upcoming issues and resolve by coordinating work with other IT teams; performs 24/7 operational support of key Agency database systems; troubleshoots database performance issues using Internet resources, performance monitor, profiler and other SQL tools; resolves issues by testing changes in test/development environment; implements changes to the production systems based on change management process; establishes and maintains high database stability, performance, accuracy and redundancy; creates databases required for new applications and removes obsolete databases using standardized process; regularly validates completion of SQL jobs and maintenance plans to proactively ensure databases integrity and optimization; and troubleshoots and corrects issues with the failed SQL Jobs in a timely manner.
• Implements the best practices for administering security on SQL Server and databases to ensure minimum permissions are assigned to database users; designs and maintains data security models to protect core business databases from unauthorized access; and performs routine clean-up and security audit on all SQL Servers by following procedures and documenting changes.
• Applies transactional-SQL coding for database monitoring, data refreshes, and promoting developer code to production; develops, implements, administers and maintains Agency’s scripts, stored procedures, triggers, ETL (exact, transform, load) and SSIS (SQL Server Integration Services) packages; extracts, transform, and load (ETL) data between databas