Senior Database Administrator

$100,000 - $195,000/Yr

SOUND TRANSIT - Seattle, WA

Full-time - Mid Level

Seattle, WA

Executive, Legislative, and Other General Government Support

About the position

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.

Responsibilities

• Serves as a technical resource on Agency database systems and works on problems or projects of advanced complexity.
• 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.
• 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.
• 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.
• 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.
• 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.
• Develops and designs automation scripts for database maintenance and monitoring.
• Researches, analyzes, and evaluates new data delivery methods.
• Develops and maintains complicated ETL packages used in the transformation and loading of data.
• Uses .Net technologies to enhance the functionality of SSIS packages.
• Develops complicated SQL scripts for various uses.
• Troubleshoots and enhances legacy DTS packages, ETL systems, SQL, and VB scripts.
• Designs, maintains, and alters new and existing database backend systems.
• Provides support to the division/department on matters as directed.
• Champions and models Sound Transit's core values and demonstrates values-based behaviors.
• Contributes to a culture of diversity, equity and inclusion.
• Integrates sustainability into everyday business practices.

Requirements

• Bachelors degree in computer science, information technology, business management information systems, or closely related field.
• Six years of information technology experience that includes four years of database administration and development experience.
• Operational characteristics of a variety of database systems.
• Principles and practices of database design and administration.
• Database architecture.
• 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.
• Advanced project management techniques and principles.
• Principles and procedures of record keeping.
• English usage, spelling, grammar, and punctuation.
• Principles of customer service.
• Supervisory/lead principles, methods, and techniques.

Nice-to-haves

• Microsoft Certified Database Administrator certification.
• Experience in working with setup and maintenance of heterogeneous databases including SQL Server, MySQL, Oracle, Postgres.
• Familiarity with working on Linux environment and heterogeneous cloud platforms such as Azure, AWS.

Benefits

• Health Benefits: Two choices of medical plans, a dental plan, and a vision plan at no cost for employee coverage.
• 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.
• Paid Time Off: Employees accrue 25 days of paid time off annually with increases at four, eight and twelve years of service.
• 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: Up to $5,000 annually for approved tuition expenses.
• Inclusive Reproductive Health Support Services.