Senior Database Administrator
Senior Database Administrator
Posted on :
28-04-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
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 competitivebenefits packagewith 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.
- LongTerm 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 fulltime employees will receive an ORCA card at no cost.
- Tuition Reimbursement: Sound Transit will pay up to $5000 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 youll find that we provide worklife balance opportunities for professional development and recognition from your colleagues.
GENERAL PURPOSE:
Under general direction administers Agencys 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 positionspecific 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 indepth 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 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 Transits core values and demonstrates valuesbased behaviors in everyday interactions across the agency.
- Contributes to a culture of diversity equity and inclusion in alignment with Sound Transits 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.
Required Experience:
Senior IC
Employment Type
Full-Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
