Published date Posted on Indeed on Sep 28, 2021 (27 d ago)
As the Azure Synapse Engineer, you will be part of a critical team involved in developing and operationalizing Azure Synapse. Experience with Spark is a must.

Responsibilities & Qualifications:
  • Understanding of Azure Synapse Analytics architecture and component integrations.
  • Proactively monitor Synapse workload (Dedicated SQL pool and Spark pool) and engage internal/external teams as appropriate to resolve errors/failures/throughput bottleneck.
  • Execute Change Tasks including but not limited to security provisioning, schema creation, DB role creation, DDL execution, data restoration etc.
  • Assist Application Developers and testers with re-engineering / deploying code from Infrastructure Support standpoint.
  • Review workload and provide recommendations for performance optimization and operational efficiency.
  • Identify, troubleshoot and resolve issues/backlogs related to slow/failed/abended jobs in both Spark and Dedicated SQL pools.
  • Proactively adjust capacity based on current utilization and upcoming usage guestimate projections.
  • Document and advise developers and end-users about best practices and housekeeping.
  • Support ingestion pipelines from Infrastructure Engineering / Operational Support standpoint.
  • Work on incidents/onboarding issues related to Pivoting to Cloud from on-prem datastores.
  • Be able to identify & resolve performance bottlenecks in Spark and SQL Pools.
  • Ensure overall system stability, reliability, and manageability of Azure Synapse Analytics deployments.
  • Experience with governing Azure Storage accounts and ACLs is nice to have.


About Harvard Partners, LLP, Trusted Advisors to IT:

Harvard Partners is a management consulting firm focused on helping companies more effectively leverage their IT investment. We engage with the C-Suite and Technology Team to help them better understand their IT infrastructure and process in order to align the technology strategy and organization to reach the firm’s strategic business goals.Some of our practices include:• Program/Project Management and "PMO as a Service"• IT Assessments• Business Continuity/Disaster Recovery• Optimized Infrastructure• Concierge Managed Services• Data Center Strategy, Transformation, and Migration• Cloud Management Programs• Security Assessments and Remediation• Staffing, technical & tacticalWorking with the client’s staff, vendors, and consultants, we deliver supportive and collaborative engagements where direct dialog, simplified reporting, productive meetings, and clear responsibility and accountability encourage active participation resulting in consensus-based business outcomes.


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Title: Informatica DeveloperArrangement: C2CLocation: RemoteDuration: 12 monthsRequired skills & experience:Informatica Power Center, Microsoft SQL Server, Azure DataOps, Tidal, and Azure Data FactoryKey responsibilities:Develop a new Informatica job and/or enhance an existing In

About PCRPCR is the leading provider of Private Wealth Aggregation solutions delivering consolidated investment data to worlds wealthiest families and their advisors. With extensive global electronic data sources and technology that automates the collection of non-structured data

Dauntless Discovery Dauntless Discovery |
19 d ago

SYSTEMS ADMINISTRATOR – RALEIGH, NCDauntless Discovery is an eDiscovery company that leverages technology to optimize accuracy and increase efficiency to provide our clients with world class eDiscovery services. We cover the entire Electronic Discovery Reference Model while

Cooler Screens Cooler Screens |
26 d ago

Cooler Screens was founded on the core idea that consumers deserve a far better experience than what is available today in bricks-and-mortar retail. We call this concept “CX” and it guides all that we do. We have begun the CX journey by bringing what consumers love ab

AlphaRidge AlphaRidge |
2 d ago

System AdministratorAbout the JobAlpha Ridge is the technology provider of choice for industry-leading property management, realty, finance, and healthcare organizations with over 20 years of IT expertise in highly regulated environments with strict compliance requirements. Alpha

More jobs by this company

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
10 d ago

As the .Net Application Developer, you will lead the team working on front-end web clients, micro-services, APIs, and new products under development. You will work in coordination with other members of the development team and with internal clients to develop, design, and maintai

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
22 d ago

Senior IT Project Manager - Database MigrationsThe Senior IT Project Manager will be responsible for managing the full project life-cycle of large and complex enterprise-wide IT Infrastructure projects, using best practice PMO methodology to create a project plan to fit the stake

Harvard Partners, LLP, Trusted Advisors to IT Harvard Partners, LLP, Trusted... |
28 d ago

As the .Net Application Developer, you will lead the team working on front-end web clients, micro-services, APIs, and new products under development. You will work in coordination with other members of the development team and with internal clients to develop, design, and maintai