- Database Administration
**This is a Limited Duration position. Please see information under "Supplemental Information" for details about limited duration assignments.
This posting is for a Limited Duration position. The position is projected to last 24 months.
The City of Eugene Information Services Division (ISD) builds and maintains the City of Eugene's technologies to meet the evolving needs of the community.
We are looking for dedicated and innovative people who share a love of working with technology to solve problems. Join our fun, friendly, and diverse Application Team. We develop and support city-wide applications for an organization with extensive opportunities to learn, grow, and make a difference in a community that cares about you.
Part-time, grant funded position - 20 hours/week, Monday - Friday with additional or flexible hours to meet business needs.
Information Services, 100 W. 10th Avenue, Suite 450, Eugene
Database Administrator 1:$33.64 - $43.52/hour
Database Administrator 2: $36.60 - $48.32/hour
THIS POSITION IS OPEN UNTIL FILLED
The next review of applications will take place:
Wednesday, April 8, 2020 at 5:00 pm PST
ONLINE APPLICATIONS ONLY
Calling Eugene Home
Eugene is located at the southern end of the agriculturally rich Willamette Valley. From here, it is a short jaunt east to the Cascade Mountains, west to the stunning Pacific Ocean coastline, or north to Portland. We're a small city with unlimited things to do: Downtown Eugene is revitalizing; the Oregon Bach Festival and Eugene Symphony call the Hult Center for the Performing Arts home; you can float the Willamette River and hook a salmon after work in the shadow of downtown; a booming food and beverage economy, including topnotch local craft breweries and wineries in the surrounding countryside, is the foundation of a local restaurant scene; the University of Oregon brings arts, culture, and educational opportunities, as well as championship athletics (Go Ducks!); a nationally-recognized transit system helps you move around the city; and our Gold rating as a Walk- and Bicycle-Friendly Community ensures that safe travel options abound! Known as Track Town USA, the community annually plays host to numerous track and field events at historic Hayward Field, including the IAAF World Championships in 2021! The impact of track and field can be seen beyond the track, with abundant trails coursing through the south hills, along the Willamette River, and through hundreds of acres of city parks. To learn more about Eugene, visit Eugene Cascades and Coast.
The City of Eugene has a Council-Manager form of government. In this form of government, the city council develops legislation and policies to direct the City. The city manager, hired by the city council, provides administrative direction to the organization, oversees City of Eugene personnel and operations, and carries out the city council's direction. The City of Eugene has over 1,500 employees and a $722 million total budget. The City of Eugene is a service-oriented and welcoming organization that provides services through six departments: Central Services, Fire and Emergency Medical Services, Police, Public Works, Planning and Development, and Library, Recreation and Cultural Services. The State of the City video shows how the city is meeting new challenges, learning from one another, building connections, and celebrating our city.
As an organization we are focusing on six Core Competencies for employees:
Trust & confidence – Making our intent and actions be transparent and honest while fostering healthy, inclusive relationships, actively listening and maintaining open communications, delivering on our promises, investing in other's success, and engaging each other and the community
Creative work environment – Exploring meaningful new ideas and relationships to foster innovation and encourage collaboration and creativity. Challenging the standard method of doing business in a positive environment.
Now & later perspective – Looking beyond day to day challenges to better anticipate the future and adjust to change.
Respectful & inclusive work environment – Seeking out a wide range of voices and making each other feel respected and included.
Self-awareness & emotional intelligence – Learning to recognize and understand our own emotions and the emotions of others and recognizing our individual strengths and weakness to raise self-awareness so we can perform better.
Wellbeing - We take care of ourselves and each other.
Examples of Duties Performed - Duties may include but are not limited to the following
The successful Senior Enterprise Engineer candidate for our team will demonstrate:
Excellent communication skills & a drive to understand customers
The ability to bring an understanding of Data Governance; Shows an understanding and adherence to established industry standard policies (such as DGI) and related experience
Performance optimization of databases in a multi-tier architectural environment
Obsessive attention to detail with a strong interest in automating any duplicate systems
The ability to provide direct support for the integration of data from, and interfaces and data flows between and among multiple applications from multiple sources, both in-house and vendor-provided.
The scope of the position includes:
Oversee all aspects of database security, business continuity, database usage standards and practices, database infrastructure design, implementation, integration, troubleshooting, and administration.
Support database architecture strategy, data modeling, and database design
Provide Tier-2 and Tier-3 support to development teams and business users with database operations, including the development of complex SQL, tuning of DML and the creation of stored procedures.
Develop, install, maintain and monitor globally-distributed hybrid-cloud corporate databases in a high performance/high availability environment supporting existing and new enterprise products
Manage backups and synchronization of multiple databases between data centers.
Support design and development of SQL code and SSRS reports or other reporting platforms
Transact-SQL experience and SQL Server clustering/failover qualifications required
Performs other technical tasks relative to the administration of City databases.
Performs related and other duties as assigned.
Any equivalent combination of education and experience which provides the applicant with the knowledge, skills and abilities required to perform the job. A typical way to obtain the knowledge and abilities would be:
Working-knowledge of data integration, data movement, global database administration, traffic shadowing, test driven development, and software development life cycle.
Big data dimensional design leveraging star or snowflake schema.
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) or other reporting services.
Python, R, Tableau, or other programming languages and analysis tools preferred but not required.
Knowledge of Agile methodology and frameworks like Scrum, Kanban, XP
Build and execute Big Data strategies, systems, and platforms addressing the capture of data, data storage, data analysis, search, sharing, transfer, visualization, querying, updating, information privacy, and data source.
Cluster enterprise relational and document-oriented databases with RESTful services and traffic mirroring.
Integrate database strategies with data larger than 1TB using relational databases, especially MS SQL Server.
Database Administrator 1
Equivalent to a Bachelor's degree from an accredited college or university in computer science or a closely related field.
Four years of increasingly responsible experience in system and database administration in client-server environments. Experience with Microsoft SQL Server required.
Database Administrator 2
Equivalent to a bachelor's degree from an accredited college or university in computer science or a closely related field.
Six years of increasingly responsible experience in system and database administration in client-server environments. Experience with Microsoft SQL Server required.