Job Description
Customer Engineer for SQL Server + Power BI/ Data Platform We are seeking a skilled and experienced SQL Server & Data Platform Solution Architect with expertise in SQL Server, Azure SQL and Power BI. For SQL Server, there should be a strong focus on Performance, High Availability, and Disaster Recovery. An ideal candidate will play a key role in design, development and optimization of SQL Server Data Platform deployments as well as assisting in migration and modernization to Azure. For Power BI, there should be a strong focus on Power BI Embedded, tabular data modeling, report development, data warehouse integration, and DAX expertise.
Skills/ Job expertise needed: - Enterprise level support and administration focused specifically on:
- SQL performance and tuning optimization, Clustering, Always On Availability groups, High Availability, Core SQL +Migration, on-premises and cloud.
- SQL Server on IaaS experience on Azure/ Other public cloud required.
- All versions of SQL Server (2012 and onwards)
- Solving performance problems, query tuning, and optimization
- Architectural experience for Data Platform
- Architecting for High Availability and Disaster recovery solutions using FCI, Always on Availability groups
- Azure data factory, Azure SQLDB, Azure SQLDB Managed Instance, Azure Synapse, Microsoft Fabric knowledge is a plus.
- Delivering and/or authoring technical training
- SQL Server Integration Services, Reporting Services, Analysis Services
- Power BI experience and knowledge are a plus.
- Advanced Microsoft certifications preferred.
- Previous Consulting and/or customer facing role.
- Data modeling and database design.
Technical Skills: Mandatory - Indexing strategy
- Performance Optimization and Tuning Capabilities
- Partitioning data implementations
- Database schema creation and management.
- Backup, High Availability and Disaster Recovery.
- Ensuring data integrity.
- Ensuring High availability and Disaster recovery.
- SQL code reviews with ability to dissect query plan, T-SQL code
- Data security.
- Data Encryption
- Auditing
- Replication of data
- SQL Edition and version differences with discontinued and deprecated features
- Upgrade process.
- Storage management techniques.
- Data Engine Capacity planning.
- General database management, Policy based management.
- Extended events and Traces
- Basic Licensing and support scenarios
- Windows Failover Clustering
- SQL Server Reporting service
- SQL server Integration Service
- SQL Server Analysis Service
- Power Shell development skills needed.
- Power BI focus areas
- Power BI Solution design and Power BI Embedded development.
- Tabular Data modeling and database design.
- Optimize Tabular Data Models
- Troubleshoot slow running Power BI and paginated reports.
- DAX, Power Query M Language, development and optimization
- Paginated Report Development (SQL Server Reporting Services)
- Power BI Service, Power BI Desktop skills
- Create/modify Data Flows, Data Pipelines, Analytic Notebooks.
- Migration from Reporting services, Tableau and other reporting tools to Power BI.
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click here for more details.
Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.
Job Tags