LTD Lane Transit District
Senior Database Administrator
LTD Lane Transit District, Eugene, Oregon, United States, 97403
Lane Transit District, named
Best Mid-Sized Transit System in North America
for 2014, is one of the most successful and highly regarded public transit systems in the nation; has received numerous national, state, and local awards for service to the community; and, for transit districts its size, is consistently ranked among the nation's leaders in the successful implementation of Bus Rapid Transit, bus ridership, and service efficiency. LTD is committed to the values of working together, taking initiative, being professional, and practicing safety.
This is an excellent career opportunity with a progressive and innovative transit organization that offers an attractive starting salary, an excellent benefit package, and equal opportunity. Lane Transit District values diversity at all levels of its workforce. Women and minority applicants, including members of the LGBTQ community, are encouraged to apply.
Job Summary:
The Senior Database Administrator will manage the administration, maintenance, and security of database systems at LTD as part of the Information Technology team. This role emphasizes ensuring database performance, data integrity, and availability. Responsibilities include implementing backup, recovery, and disaster recovery plans. Key tasks involve monitoring and tuning databases, implementing data security measures, and maintaining database documentation.Essential Job Functions:
Work closely with the Data Warehouse Manager, SQL Developer, and Business Intelligence Analysts to support LTD's overall Business Intelligence Strategy
Design, develop, and deploy code (ETL, Visualization, Design Modeling, SQL, and other tools, languages, and technologies)
Configure and administer Power BI Report Server (development, testing, and production environments)
Monitor performance of ETL processes and build in redundancies to avoid risk of an information outage
Build up repository of data that can be used to move forward in the case of catastrophic loss of data (disaster recovery)
Implement backup and recovery plans
Suggest courses of action for database high availability
Preparations for systems upgrades
Maintain documentation and versioning
Investigate data flows, identify automation opportunities and create updated data flows
Ensure performance, security, and integrity of database systems
Monitor database performance and tune SQL queries
Manage database access, user permissions, and security measures
Develop and implement source control and deployment standards
Script and automate database maintenance tasks
Knowledge, Skills and Abilities:
Administration and Management - knowledge of business and management principles involved in planning, resource allocation, and coordination of people and resources
Strong troubleshooting and problem-solving skills and experience within an IT environment
Advanced proficiency of Microsoft Windows
Strong cybersecurity knowledge - Role-based access controls, network security, vulnerability management, patching, and encryption
SQL: Advanced proficiency in writing complex queries, and knowledge of SQL commands, functions, and procedures
Relational Databases: Proficiency with SQL Server
Data Modeling: Proficiency in ER diagrams and normalization techniques
Schema Design: Ability to design and implement database schemas
Performance Tuning: Skills in optimizing SQL queries and managing indexes.
Monitoring: Experience with database performance tools
Troubleshooting: Ability to diagnose and resolve performance issues
Backup and Recovery: Knowledge of backup strategies and disaster recovery plans.
Security: Knowledge of access control, encryption, and data protection regulations
Automation: Experience with automation tools for database tasks
ETL Processes: Knowledge of ETL processes and tools like SSIS, PowerShell, and SFTP file transfers
Database Tools: Experience with tools like SSMS and Redgate Tools
SQL Performance Monitoring Tools like Redgate Monitor
Cloud Databases: Knowledge of AWS RDS, Azure SQL Database
Virtualization: Understanding of VMware and virtualization concepts
Replication and Clustering: Experience with database replication and clustering.
Development: Skills in stored procedures, and API integration
Good oral and written communication including regular communication inside and outside the District to exchange ideas and gather information that can be used to influence decisions, policies, projects, or program design/management with some degree of tact, negotiation, and/or confidentiality
Adapt to shifting priorities and demands, effectively integrating diverse functions and interests
Identify opportunities for improving existing processes and procedures, and collaborate with relevant teams to implement solutions
Analyze problems or concepts and make decisions based on the information.
Work under minimal supervision
Effectively communicate technical information to both technical and non-technical audiences, collaborate with cross-functional teams to achieve project goals, and demonstrate strong problem-solving skills in time-sensitive situations
Qualifications:Required Education and Experience
Any equivalent combination of education and experience which provides the knowledge, skills, and abilities required to perform the job. Education and course work can substitute for years of experience.Experience:
Minimum of a Bachelor's degree from an accredited college or university in a technical discipline or experience equivalent (at least 5 years of on-the-job database administration experience)
10 years' experience in technical domains, including at least 5 years' experience in database administration
Experience with BI tools (SSRS and Power BI)
Experience with data integration from multiple different systems including knowledge of API data transfers
Able to read, write and interpret advanced T-SQL database programming
Advanced proficiency of standard office software (MS Office), reporting applications, and analytical techniques
Experience developing detailed project plans and project documentation
Preferred:
Technology skills to include: database management, Visual Studio for Integration services, tabular models, and console applications (C#); Power BI/M & Power BI Report server; HTML; Redgate for SQL monitoring; data profiling; advanced Excel skills; DAX; MDX; TSQL, JSON Data manipulation, PowerShell
Professional Certifications
ITIL Foundations
Work Schedule:
May work onsite at our Administrative offices in Eugene, OR and/or remote office as approved. Will occasionally be required to work and/or attend meetings or events in public and at all LTD locations
Monday through Friday 8am to 5pm
Occasional shift work and/or flexible work schedule as needed; occasional abnormal hours are expected
How to apply:
Visit our website: http://ltdjobs.applicantpool.com/jobs/.
The Lane Transit District is an Affirmative Action/ Equal Employment Opportunity Employer.
Best Mid-Sized Transit System in North America
for 2014, is one of the most successful and highly regarded public transit systems in the nation; has received numerous national, state, and local awards for service to the community; and, for transit districts its size, is consistently ranked among the nation's leaders in the successful implementation of Bus Rapid Transit, bus ridership, and service efficiency. LTD is committed to the values of working together, taking initiative, being professional, and practicing safety.
This is an excellent career opportunity with a progressive and innovative transit organization that offers an attractive starting salary, an excellent benefit package, and equal opportunity. Lane Transit District values diversity at all levels of its workforce. Women and minority applicants, including members of the LGBTQ community, are encouraged to apply.
Job Summary:
The Senior Database Administrator will manage the administration, maintenance, and security of database systems at LTD as part of the Information Technology team. This role emphasizes ensuring database performance, data integrity, and availability. Responsibilities include implementing backup, recovery, and disaster recovery plans. Key tasks involve monitoring and tuning databases, implementing data security measures, and maintaining database documentation.Essential Job Functions:
Work closely with the Data Warehouse Manager, SQL Developer, and Business Intelligence Analysts to support LTD's overall Business Intelligence Strategy
Design, develop, and deploy code (ETL, Visualization, Design Modeling, SQL, and other tools, languages, and technologies)
Configure and administer Power BI Report Server (development, testing, and production environments)
Monitor performance of ETL processes and build in redundancies to avoid risk of an information outage
Build up repository of data that can be used to move forward in the case of catastrophic loss of data (disaster recovery)
Implement backup and recovery plans
Suggest courses of action for database high availability
Preparations for systems upgrades
Maintain documentation and versioning
Investigate data flows, identify automation opportunities and create updated data flows
Ensure performance, security, and integrity of database systems
Monitor database performance and tune SQL queries
Manage database access, user permissions, and security measures
Develop and implement source control and deployment standards
Script and automate database maintenance tasks
Knowledge, Skills and Abilities:
Administration and Management - knowledge of business and management principles involved in planning, resource allocation, and coordination of people and resources
Strong troubleshooting and problem-solving skills and experience within an IT environment
Advanced proficiency of Microsoft Windows
Strong cybersecurity knowledge - Role-based access controls, network security, vulnerability management, patching, and encryption
SQL: Advanced proficiency in writing complex queries, and knowledge of SQL commands, functions, and procedures
Relational Databases: Proficiency with SQL Server
Data Modeling: Proficiency in ER diagrams and normalization techniques
Schema Design: Ability to design and implement database schemas
Performance Tuning: Skills in optimizing SQL queries and managing indexes.
Monitoring: Experience with database performance tools
Troubleshooting: Ability to diagnose and resolve performance issues
Backup and Recovery: Knowledge of backup strategies and disaster recovery plans.
Security: Knowledge of access control, encryption, and data protection regulations
Automation: Experience with automation tools for database tasks
ETL Processes: Knowledge of ETL processes and tools like SSIS, PowerShell, and SFTP file transfers
Database Tools: Experience with tools like SSMS and Redgate Tools
SQL Performance Monitoring Tools like Redgate Monitor
Cloud Databases: Knowledge of AWS RDS, Azure SQL Database
Virtualization: Understanding of VMware and virtualization concepts
Replication and Clustering: Experience with database replication and clustering.
Development: Skills in stored procedures, and API integration
Good oral and written communication including regular communication inside and outside the District to exchange ideas and gather information that can be used to influence decisions, policies, projects, or program design/management with some degree of tact, negotiation, and/or confidentiality
Adapt to shifting priorities and demands, effectively integrating diverse functions and interests
Identify opportunities for improving existing processes and procedures, and collaborate with relevant teams to implement solutions
Analyze problems or concepts and make decisions based on the information.
Work under minimal supervision
Effectively communicate technical information to both technical and non-technical audiences, collaborate with cross-functional teams to achieve project goals, and demonstrate strong problem-solving skills in time-sensitive situations
Qualifications:Required Education and Experience
Any equivalent combination of education and experience which provides the knowledge, skills, and abilities required to perform the job. Education and course work can substitute for years of experience.Experience:
Minimum of a Bachelor's degree from an accredited college or university in a technical discipline or experience equivalent (at least 5 years of on-the-job database administration experience)
10 years' experience in technical domains, including at least 5 years' experience in database administration
Experience with BI tools (SSRS and Power BI)
Experience with data integration from multiple different systems including knowledge of API data transfers
Able to read, write and interpret advanced T-SQL database programming
Advanced proficiency of standard office software (MS Office), reporting applications, and analytical techniques
Experience developing detailed project plans and project documentation
Preferred:
Technology skills to include: database management, Visual Studio for Integration services, tabular models, and console applications (C#); Power BI/M & Power BI Report server; HTML; Redgate for SQL monitoring; data profiling; advanced Excel skills; DAX; MDX; TSQL, JSON Data manipulation, PowerShell
Professional Certifications
ITIL Foundations
Work Schedule:
May work onsite at our Administrative offices in Eugene, OR and/or remote office as approved. Will occasionally be required to work and/or attend meetings or events in public and at all LTD locations
Monday through Friday 8am to 5pm
Occasional shift work and/or flexible work schedule as needed; occasional abnormal hours are expected
How to apply:
Visit our website: http://ltdjobs.applicantpool.com/jobs/.
The Lane Transit District is an Affirmative Action/ Equal Employment Opportunity Employer.