Application Support DBA

Company: Fisher Investments
Location: Camas
Posted on: January 27, 2025

Job Description:

The Opportunity:
As an Azure Data Platform Administrator, you will perform administration of our Azure data and analytics platform, including Azure Synapse, Azure Data Factory, ADLS, Azure ML/AI and reporting as part of a collection of systems in a large technology ecosystem. You will ensure the smooth operations of systems including uptime and performance. As a technical expert for our data and analytics ecosystem you will support Fisher Investments business line reporting teams, Technology Business Services Data Services teams, 3rd party vendors, and implementation partners. You will report to the Application Development Team Lead.
The Day-to-Day:
* Work with stakeholders (Infrastructure and Operation and Information Security) to ensure smooth and secure operations of Azure data and analytics platform including Azure Synapse, ADF, Azure ML/AI, Power BI and etc
* Oversee data warehouse and analytics platform on Azure from implementation, maintenance to enhancements and ongoing operations
* Manage various Azure data pipelines, job schedules and systems to ensure performance and uptime
* Maintain up-to-date platform documentation and provide technical support to database, application and business intelligence (BI) developers
* Perform maintenance and troubleshooting activities for data warehouse and BI platform on Azure and resolve issues
* Ensure metadata (data catalog) are tracked for all data objects in the platform
* Perform system monitoring and performance analysis
* Perform ongoing security controls audit and review to ensure compliance
* Review system application logs and identify potential issues and improvements
* Participate in capacity planning, cloud cost analysis and cloud resources optimization
* Provide after-hour system and application support
* Develop and implement various work plans for projects
* Minimum of 5 years of experience as a MS SQL Server administrator, system or cloud administrator
* Experience with investment management systems and processes
* Experience with cloud data warehouse and analytics technologies, specifically Azure Synapse, Azure Data Factory, ADLS and SQL Server (SSIS and SSAS), Power BI is required
* Knowledge or experience with infrastructure (operating system and networking) and cloud administration is required
* Knowledge or experience with data access control/security models
* Knowledge or experience with CI/CD, DevOps (such as GitHub Actions, Octopus Deploy) or ML Ops
* Azure certifications (data related)
* Experience with Agile methodologies in a cloud, database, data warehousing and BI space
* BS/MS or equivalent in Computer Science or related field or a combination of technical skills, cloud, system administration and operations
Your Qualifications:
* Minimum of 5 years of experience as a MS SQL Server administrator, system or cloud administrator
* Experience with investment management systems and processes
* Experience with cloud data warehouse and analytics technologies, specifically Azure Synapse, Azure Data Factory, ADLS and SQL Server (SSIS and SSAS), Power BI is required
* Knowledge or experience with infrastructure (operating system and networking) and cloud administration is required
* Knowledge or experience with data access control/security models
* Knowledge or experience with CI/CD, DevOps (such as GitHub Actions, Octopus Deploy) or ML Ops
* Azure certifications (data related)
* Experience with Agile methodologies in a cloud, database, data warehousing and BI space
* BS/MS or equivalent in Computer Science or related field or a combination of technical skills, cloud, system administration and operations
Compensation:
* $90,000 - $140,000 base salary per year in the state of WA. New hires should expect to start at the lower end of the range depending on experience
* Eligible for a discretionary bonus based on firm and individual performance
Why Fisher Investments:
We work for a bigger purpose: bettering the investment universe. We take great pride in our inclusive culture, our learning and development framework customized for every employee, and our Great Place to Work Certification. It's the people that make the Fisher purpose possible, and we invest in them by offering exceptional benefits like:
* 100% paid medical, dental and vision premiums for you and your qualifying dependents
* A 50% 401(k) match, up to the IRS maximum
* 20 days of PTO, plus 10 paid holidays
* Family Support programs including 8 week Paid Primary Caregiver Leave, $10,000 fertility, family forming, and hormonal health assistance, and back-up child, adult, and elder care
* Opportunity to participate in our hybrid work from home program. This program is subject to change. Based on tenure and performance eligibility, you will have the opportunity to work from home up to 75 days per year
FISHER INVESTMENTS IS AN EQUAL OPPORTUNITY EMPLOYER

Keywords: Fisher Investments, Portland , Application Support DBA, Other , Camas, Oregon