Senior Cloud BI Database Administrator
Northwest Software, Inc
Portland, OR
This is a long-term position with our valuable client in public sector located in Portland, Oregon.
POSITION REQUIREMENTS
Background: The Development, Data and Analytics Team provides the development platforms and the enterprise data in our Data Warehouses. We are focused on the successful adoption of Business Intelligence tools throughout the organization. The officially supported BI tools are: SQL Server Reporting Services (SSRS), Tableau, and Power BI. We have On-Prem servers as well as databases in the Azure Cloud and in Snowflake.
This Senior BI DBA will be assigned production support and new projects.
Scope of Work:
This staff should provide analysis, design, implement, installation, maintenance and troubleshooting for our BI databases and servers (On-Prem, Azure Cloud, and Snowflake). This position also must be able to do Tableau Server Admin and PBIRS Server Admin. This will be a mix of production support work, standard maintenance, as well as small to large projects.
Required Skills and Abilities:
- Seven (7) years of IT DBA experience.
- Azure Cloud experience (Azure SQL Managed Instance, Azure Synapse, Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure DevOps, Azure Boards, Azure Blob Storage, etc)
- Snowflake on Azure Commercial experience preferred
- This position must pass a criminal history records check.
The work:
- Develop large-scale databases and data warehousing
- Perform database architecture and develop technical standards for large-scale databases for our data warehouse (SQL Server and Azure) on countywide or multi-department platforms.
- Troubleshoot problems and provide technical assistance to developers and database users.
- Provide project management and work with other departments or outside agencies to integrate data from multiple database platforms and data providers.
- Formulate scope and objectives for database projects; define outcomes; develop and recommend solutions; problem solve and build consensus with management, customers, and vendors to negotiate project priorities and outcomes.
- Maintain integrity and security of databases; coordinate and perform database software installations, upgrades, and patches.
- Design, implement, and schedule physical and logical database backups; plan and perform database restoration and recovery.
- Develop database scripts and triggers; migrate data between database environments (development, testing, and production).
- Monitor, adjust, and optimize space utilization and database performance.
- Act as an expert in database architecture and technical standards for large-scale databases and data warehousing
The skills:
- Advanced experience with Azure, Azure DevOps, Azure Data Lake, Azure Blob Storage, and Azure SQL Server
- Advanced experience doing DBA work both On-Prem and Azure Cloud
- Advanced experience in data warehousing design, BI concepts and best practices
- Advanced experience working with developers to build ETLs for loading data for reporting
- Advanced experience in Tableau server administration, upgrades, and support
- Advanced experience in PBIRS server administration, upgrades, and support
- Experience that provides a plus:
- Snowflake experience
- Power BI experience
Other Details:
- Is remote work permitted? Yes
If there is an interview, how will it be conducted? By video call (Skype, Zoom, Google Hangouts etc.)
Roles and Responsibilities
Day to Day Basis:
This DBA Senior must be able to do database and server tasks with on prem SQL Servers and dbs and Azure Servers and dbs. This person will also be responsible for Tableau Server administration and upgrades/patching as well as PBIRS Server admin and upgrades/patching. Snowflake knowledge is nice to have. We are moving from on prem to Snowflake on the Azure Commercial cloud.
About Us
Founded in 1988, NSI has set the standard for attracting and retaining the best Professionals in the business. As a NSI candidate (either consultant or direct-hire), we will enhance your experience in many different ways.
Thanks & Regards,
Manny
Northwest Software Inc.
111 SW 5th Ave suite 3150
Portland Oregon 97204
mani@nwsi.com
About the Company
Northwest Software, Inc
Adisys Corporation
Adisys is a software development and consulting services organization. Since 2009, Adisys has grown into a trusted advisor role for our customers and partners. In more than half a decade, Adisys has acquired significant YOY growth and has earned significant customer credibility.
Our focus, here at Adisys, is to build upon this strong foundation through ongoing innovation in our integrated software platforms, by delivering compelling value to our customers, by responding effectively to customer and partner needs, and by continuing to emphasize the importance of product excellence, business efficiency, and accountability.
With extensive experience across numerous industries and business functions, and broad research on the most successful companies, Adisys is well suited to help clients become cost effective and efficient organizations.
Adisys is also stepping into software plus services, a vision that reflects our belief that what is most powerful for end-users is a computing or communication device running sophisticated software that interacts with cloud-based resources. We develop hybrid CRM based solutions that can be hosted On-premise and in the Cloud platform in a monthly subscription model.
Adisys is dedicated to providing customers with numerous services including Technology Consulting, Managed Services, Software Development, Outsourcing, Global Delivery, Customer Relationship Management (CRM), ERP, Cloud Services Planning and Development, Infrastructure Solutions including planning and design, system deployment and implementation, as well as Support & Operations management.
Quick Fact Sheet
- Established in 2009
- A certified Women owned and Minority Business Enterprise (MWBE)
- Established Offshore R&D center in Trivandrum, India
- A Dynamics CRM preferred partner for various Fortune 500 companies
- Microsoft Silver Partner
Visit us for more jobs: https://adisys.hrhub360.com/Careers/Jobs