Introduction to Multnomah County
At Multnomah County, we are driven by a mission to serve our community with dedication and passion. As one of the most innovative government IT organizations in the nation, we are constantly evolving to align ourselves with emerging industry trends. Our team is comprised of creative, smart, and talented individuals who foster an inclusive environment of collaboration and fun. We believe that our strength lies in the diversity of our people, and we are committed to creating a culture of dignity and respect for all our employees.
About the Role
We are seeking an experienced Senior IT Database Administrator to join our team and play a crucial role in advancing the County's Business Intelligence and Data Warehousing platforms. As a Senior Database Administrator, you will be responsible for designing, implementing, and managing large-scale databases and data warehousing solutions. You will work on both day-to-day production support and exciting new projects, including redesigning our Data Warehouses to run on platforms like Azure Cloud and Snowflake.
Key Responsibilities
- Develop and maintain large-scale databases and data warehousing solutions, including database architecture and technical standards for SQL Server, Azure, and Snowflake.
- Manage and maintain SQL Server and Cloud (Azure, Snowflake, etc.) databases for development, testing, and production, ensuring security, backups, and recovery processes are in place.
- Provide consulting and support for IT projects involving database solutions, including guidance on SQL tuning and error debugging.
- Assist in troubleshooting complex SQL statements and database problems, and provide training as needed.
- Participate in data quality efforts and architecture design, and migrate data between databases as required.
- Define performance tuning goals and objectives, monitor database performance, and recommend optimizations for applications, databases, I/O, and OS.
- Install database software, SQL Server, and Windows patches, and develop project plans for installing new software releases or patches.
Essential Qualifications
To be successful in this role, you will need:
- A Bachelor's degree or equivalent years of experience in IT development and database administration.
- At least 5 years of experience in IT development and database administration, with advanced knowledge of Azure Cloud, Snowflake, and Business Intelligence Data Marts and Data Warehousing.
- Advanced experience working with developers to build ETLs for loading data for reporting, and advanced knowledge of database logging tools.
- Working knowledge of BI reporting platforms, functionality, and tools, including Tableau and Tableau Server, Power BI and Power BI Report Server, and SSRS.
- Advanced knowledge of installing, performance tuning, maintaining, securing, and administering an on-prem MS SQL Server database and Cloud environments.
Preferred Qualifications
While not essential, the following qualifications are highly desirable:
- Working knowledge of MS SQL Server and Azure cloud backup and recovery design and implementation.
- Basic knowledge of networking and firewall concepts, Microsoft Windows Server administration, and SAN/NAS Storage management and concepts.
- Basic knowledge of virtualization technology using MS Windows Hyper-V or VMWare, and Application Development, architectures, languages, and/or tools.
- Advanced knowledge of RDBMS management tools, including MS SQL Server Management Studio.
- Working knowledge of developing on a SQL Server platform using Transact SQL (T-SQL), including stored procedures, query plans, functions, views, indexes, and triggers.
Skills and Competencies
To excel in this role, you will need to demonstrate the following skills and competencies:
- Creativity and innovation, with a willingness to improve processes and foster a work environment of imagination and critical thinking.
- Adaptability, with the ability to navigate change and adapt plans as needed.
- Strong communication skills, with the ability to share information clearly, timely, and effectively.
- Empathy and a "Think Yes" attitude, with a focus on collaboration and customer service.
- Ability to work in a fast-paced environment, with multiple priorities and deadlines.
Career Growth Opportunities and Learning Benefits
At Multnomah County, we are committed to supporting the growth and development of our employees. As a Senior IT Database Administrator, you will have access to a range of training and development opportunities, including:
- Professional development courses and workshops to enhance your technical skills and knowledge.
- Mentorship and coaching from experienced colleagues and leaders.
- Opportunities to work on exciting new projects and initiatives, including the redesign of our Data Warehouses to run on platforms like Azure Cloud and Snowflake.
- A collaborative and inclusive work environment that values diversity and promotes a culture of dignity and respect.
Work Environment and Company Culture
At Multnomah County, we pride ourselves on our positive and supportive work environment. As a Senior IT Database Administrator, you will be part of a dynamic team that values collaboration, creativity, and innovation. Our company culture is built on the following principles:
- A commitment to diversity, equity, and inclusion, with a focus on creating a culture of dignity and respect for all employees.
- A collaborative and inclusive work environment that values the contributions of all employees.
- A focus on customer service, with a "Think Yes" attitude and a commitment to delivering high-quality services to our community.
- A commitment to supporting the growth and development of our employees, with access to training and development opportunities.
Compensation, Perks, and Benefits
As a Senior IT Database Administrator at Multnomah County, you will be eligible for a range of compensation, perks, and benefits, including:
- A competitive salary, with a pay range of $59.19 - $72.85 hourly.
- A comprehensive benefits package, including medical, dental, and vision insurance, as well as retirement savings and paid time off.
- Opportunities for professional development and growth, including training and development courses, mentorship, and coaching.
- A collaborative and inclusive work environment that values diversity and promotes a culture of dignity and respect.
Conclusion
If you are a motivated and experienced IT professional looking for a challenging and rewarding role, we encourage you to apply for the Senior IT Database Administrator position at Multnomah County. With a competitive salary, comprehensive benefits package, and opportunities for professional development and growth, this is an exciting opportunity to join a dynamic team and make a real difference in our community. Don't miss out – apply today!
Apply Now