Senior Database Administrator

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

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, administers Agency's database and ensures the health, integrity, security, recoverability, and availability of all Agency data repositories 24/7; serves as technical and process lead and directs the work of less experienced database administrators and contractors; recommends and implements standards for administering Agency data repositories; develops processes and tools for use with Agency data repositories; and researches industry technology trends to identify strategic changes in Agency data repository planning.

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.

• Serves as a technical resource on Agency database systems and works on problems or projects of advanced complexity where analysis of situations or data requires in-depth evaluation of various factors; installs, patches, and upgrades database management systems and associated tools; administers and upgrades the code repository software; maintains, administers, reviews, and develops systems for monitoring functionality and integrity; monitors database systems and identifies potential data or other system bottlenecks; checks and maintains data integrity using automated and manual methods; makes monitoring results available to other members of the IT staff for use in preventative maintenance; performs advanced database troubleshooting and performance optimization; performs 24/7 operational support of key Agency database systems; evaluates database needs and applies technical principles and concepts to develop business solutions; directs, monitors, and maintains database security; and designs and maintains data security models to protect core business databases from corruption, improper use, and unauthorized access.
• Monitors and maintains system storage and retrieval systems; oversees the coordination of the backup of database systems with IT infrastructure staff; ensures implementation of backup solutions; implements and administers data redundancy systems; ensures high availability of Agency databases; assists application owners with recovery model selection for various databases; optimizes scripts and stored procedures to increase database performance; directs the scheduling of maintenance and backup jobs to provide optimal server performance to users; maintains a current understanding of the applications using the Agency database systems; and establishes, develops, and maintains Database Administration standards, procedures, and documentation.
• Provides technical and process lead for other database staff and consultants; coordinates work load and priorities of other database administrators (DBAs); trains and mentors less experienced DBAs; provides staffing recommendations to supervisors; serves as primary technical database liaison with business units and other IT staff; and manages database related projects by coordinating staff, resources, and schedules.
• Develops and designs automation scripts for database maintenance and monitoring, schemas, stored procedures, triggers, ETL and SSIS packages, schedules, publications, subscriptions, and database architecture; researches, analyzes, and evaluates new data delivery methods; develops and maintains complicated ETL packages used in the transformation and loading of data from many different sources and in many different formats; develops and recommends methods of reducing reporting and ETL traffic on our transactional database systems; uses .Net technologies to enhance the functionality of SSIS packages; develops complicated SQL scripts for a variety of uses including, but not limited to: ETL, data loading, data modification, database administration, and database monitoring; troubleshoots and enhances legacy DTS packages, ETL systems, SQL, and VB scripts; uses other scripting technologies to assist in database administration, ETL, and maintenance; assists in the development and develops database models; initiates, adheres to, and helps develop Agency development standards.
• Has the ability to work on heterogeneous platforms including, but not limited to cloud platforms, Linux, etc.
• Designs, maintains, and alters new and existing database backend systems including database storage design such as physical file location, database architecture, logical and physical drive assignments, hardware selection and configuration, SAN related recommendations, and software version selection; scans for hot fixes, service packs, and security patches or problems; makes recommendations on what needs to be applied to our current database systems; monitors and adjusts servers to ensure optimal performance; monitors capacity; and makes hardware purchase recommendations.
• Provides support to the division/department on matters as directed; serves as staff on a variety of committees; maintains awareness of new trends and developments in the fields related to area of assignment; ensures processes, policies, and practices are interpreted and applied consistently and effectively; ensures accountability and compliance with all current and applicable state and federal laws, Agency policies and procedures, rules and regulations.
• Champions and models Sound Transit's core values and demonstrates values-based behaviors in everyday interactions across the agency.
• Contributes to a culture of diversity, equity and inclusion in alignment with Sound Transit's Equity & Inclusion Policy.
• It is the responsibility of all employees to follow the Agency safety rules, regulations, and procedures pertaining to their assigned duties and responsibilities, which could include systems, operations, and/or other employees.
• It is the responsibility of all employees to integrate sustainability into everyday business practices.
• Other duties as assigned.

MINIMUM QUALIFICATIONS:

Education and Experience: Bachelors degree in computer science, information technology, business management information systems, or closely related field and six years of information technology experience that includes four years of database administration and development experience; OR an equivalent combination of education and experience.

Preferred Licenses or Certifications:

• Microsoft Certified Database Administrator certification.

Required Knowledge and Skills:

• Operational characteristics of a variety of database systems.
• Principles and practices of database design and administration.
• Database architecture.
• Database management systems, tools, and utilities.
• Concepts and principles of database technology.
• Knowledge of a wide variety of applications that use SQL Server, Oracle, and MySQL as a RDBMS.
• Methods and techniques of maintaining database security.
• Working knowledge of MS Windows operating systems.
• Methods and techniques of evaluating database models.
• Methods and techniques of developing technical documentation for database systems.
• Pertinent federal, state, and local laws, codes, and regulations.
• Advanced project management techniques and principles.
• Principles and procedures of record keeping.
• English usage, spelling, grammar, and punctuation.
• Principles of business letter writing and basic report preparation.
• Principles of customer service.
• Supervisory/lead principles, methods, and techniques.
• Utilizing personal computer software programs affecting assigned work and in compiling and preparing spreadsheets and reports.
• Establishing and maintaining effective working relationships with other department staff, management, vendors, outside agencies, community groups, and the general public.
• Interpreting and administering policies and procedures sufficient to administer, discuss, resolve, and explain them to staff and other constituencies.
• Performing database administration duties on Agency fare collection Oracle database(s).
• Experience in working with setup and maintenance of heterogeneous databases including, but not limited to SQL Server, MySQL, Oracle, Postgres, etc.
• Familiarity with working on Linux environment and heterogeneous cloud platforms such as Azure, AWS, etc.
• Developing SQL, .NET, and other types of scripts, stored procedures, triggers, ETL, DTS and SSIS packages, schedules, publications, and subscriptions.
• Updating, patching, and upgrading Agency databases to maintain supportable, high availability systems, database stability, performance, accuracy, and redundancy.
• Developing, implementing, and directing database security.
• Performing and/or directing preventative maintenance on Agency databases to maintain data security and integrity.
• Creating and adhering to technical standards and processes.
• Data gathering and analysis abilities.
• Demonstrating a positive customer service orientation with both internal and external clients.
• Responding to general inquiries and in effective oral and written communication.
• Working cooperatively with other departments, Agency officials, and outside agencies.
• Technical leadership and mentoring abilities.

Physical Demands / Work Environment:

• Work is performed in a standard office environment.
• Subject to standing, walking, bending, reaching, stooping, and lifting of objects up to 25 pounds.
• The Agency promotes a safe and healthy work environment and provides appropriate safety and equipment training for all personnel as required.

Sound Transit is an equal employment opportunity employer. No person is unlawfully excluded from employment action based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status or other protected class.