Senior Database Administrator



Senior Database Administrator

Salary

Negotiable

Location

5th & Jackson, Seattle

Job Type

Full-Time

Job Number

18-01308

Department

Information Technology

Opening Date

08/15/2018

Closing Date

10/2/2018 12:00 AM Pacific

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.

This job posting may be used to fill multiple positions.
 

Essential Functions

The following duties ARE NOT intended to serve as a comprehensive list of all duties performed by all employees in this classification, only 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.
  • 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 of:
 

  • 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.
 
Required Skill in:
 
  • 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.

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.

Employee benefit and retirement plans are an important part of Sound Transit's total compensation approach and represent approximately 35% of an employee's salary package. Regular eligible employees at Sound Transit are provided a wide range of benefits.
 
Ask your Sound Transit Recruiter about the specific benefits tied to the position you've applied for.

Health Benefits:
  • Medical Insurance
  • Dental Insurance
  • Vision Insurance 
Income Protection:
  • Life Insurance and Accidental Death & Dismemberment
  • Long Term Disability (LTD)  
Retirement Benefits:
  • 401A Retirement Plan
  • 457 Deferred Compensation Plan
Paid Time Off and Leave:
  • Vacation
  • Sick Leave
  • Holidays
  • Personal Appointments for Non-Exempt only
  • Bereavement Leave
  • Family Medical Leave
  • Jury Duty Leave
  • Military Leave
  • Awarded Time
Life/Work Benefits:
  • Employee Assistance Program (EAP)
  • Flexible Spending Accounts
  • Orca & Guaranteed Ride Home
  • Discounts and Services
  • Merchandise Discounts
  • Resources and Referrals

Agency
Sound Transit
Address
401 S. Jackson Street

Seattle, Washington, 98104-2826