Application dba and sql server

Company: Fisher Investments
Location: Garland
Posted on: November 13, 2024

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
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, fertility, family forming, and hormonal health assistance and back-up child, adult, and elder care
-$10,000 fertility, hormonal health and family-forming benefit
- 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, Keller , Application dba and sql server, IT / Software / Systems , Garland, Texas