Back-End Engineer – SQL/.NET – Burlington

Back-End Engineer – SQL/.NET – Burlington

POSITION SUMMARY

 

The Software Engineer back end – develops and maintains applications by studying operations, designing, developing and installing software solutions and supports the software solutions in production.  The ideal candidate has the ability to prioritize well, communicate clearly and have a consistent track record of delivery. S/he should have strong software and analytical skills and the ability to create innovative solutions with a willingness to learn industry standards, technological advancements, express opinions and seek ideas.

 

POSITION RESPONSIBILITIES

 

Essential Functions

  • Develop software using disciplined processes, adhering to industry standards and best practices, including agile development methods throughout the SDLC
  • Code, debug, and automated unit test systems per requirements and technical design.
  • Code, update, debug and optimize SQL
  • Analyzing business and use cases and functional requirements and working with product managers and business analysts to produce detailed designs and provide detailed estimates for new features, enhancements or repairs to existing programs.
  • Adhere to design, architecture, performance, and operability and documentation standards.
  • Document software applications, its configuration options, and expected results.
  • Supporting testing activities by QA and service delivery teams.
  • Team player who is delivery-oriented and takes responsibility for the team’s success
  • Enthusiastic, can-do attitude with the drive to continually learn and improve
  • All other related duties as assigned.

 

 

POSITION QUALIFICATIONS

 

Experience

  • 4-6 years software engineering experience with enterprise class or large scale SaaS applications
  • Extensive experience with SQL and relational databases such as Oracle / SQL Server / MySQL is required
  • Extensive experience writing SQL queries, database concepts, query optimization, stored procedure writing and debugging
  • Extensive experience with Visual studio, C# programming language and .Net framework, developing business layer and data access layer using .Net / C# is required.
  • Proven track record of analyzing and solving performance issues as they relate to middle tier and back end / database processes
  • Object-oriented design skills and knowledge of design patterns is a strong plus
  • Some knowledge of Web-Service based technologies such as SOAP, REST, experience with microservices architecture pattern is a strong plus
  • Extensive knowledge of unit testing, experience with continuous integration and deployment methodologies, code instrumentation techniques, code quality metrics.
  • Knowledge of cloud technologies such as AWS or Azure is a strong plus.
  • Familiarity with queuing technologies such as RabbitMQ, MSKQ is a strong plus.
  • Must thrive in fast-paced environment and be adept at problem solving and delivery high-quality software
  • Must be able and willing to collaborate in a team/cooperative environment as well as exercise independent judgment and initiative.
  • Demonstrated ability to prioritize work load and meet multiple project deadlines.
  • Ability to adapt in a dynamic work environment and make independent decisions.
  • Excellent verbal and written communication skills.

 

Education

  • Bachelor’s degree in computer science or related field required, Master’s degree preferred

 

 

SSAS/SQL DBA -Hedge Fund NYC-Midtown

My client is a global hedge fund that manages over 20 billion in assets. They are actively looking for a SQL Server DBA/BI(SSAS) engineer with at least 7 years experience managing environments of over at least 1 Terabytes in size and range up to 20 terabytes (largest). Candidate should have in depth knowledge of SQL Server and have at least 2 years of SSAS. Breakdown would be 50% DBA/ 50% Architecture(SSAS/TSQL/C#)
Description of the Role:
Day to day tasks will revolve around maintaining databases, database servers, and database storage. There are over 50 developers with varying degrees of SQL expertise, many require a high level of expertise to complete their work and improve existing processes. Solutions are built using of best of class technologies, with the common expectation of an enterprise grade resiliency and performance.

The successful candidate will be capable of collaborating with the IT team on the development and deployment of systems and solutions. The successful candidate must be able to take ownership of multiple tasks and measure the work on those tasks against the work of the group to complete larger tasks successfully with a minimum of daily supervision.

SQL Server administration(7+ Years)
Query writing(TSQL)
Query tuning
SQL Server performance tuning
Always On Availability and clustering
Replication Technologies (SQL Server and Storage based)
Multidimensional databases (SSAS, OLAP)
Some scripting and programming experience a plus.
Knowledge of and experience with, various storage platforms.
Loves Technology
Capable of strategic thought
Not discouraged by complexity
Self-confidence (not arrogance)
Capable of compromise
Helpful and accommodating
Strong verbal and written communication skills
Capable of working independently and as part of a team
Calm demeanor under stress
Detail oriented

Senior Database Developer/Manager

We are one of the largest media agency networks in the world. Our core business is media buying and media planning but as the media landscape has become more complex we have diversified our capabilities. The candidate will play a key role in the work of the Analytics & Insight team Require skills include SQL 2008/2012, SSIS, S ETL, reporting, working with SQL Server databases as well as the ability to work with non-technical constituents. We are looking for someone that has a strong SSIS background, good SQL skills and would be able to read through (but not necessarily write) C# code. Any experience with PDW would be a huge plus. Management experience is essential for this role.

SQL Developer

We are one of the largest media agency networks in the world. Our core business is media buying and media planning but as the media landscape has become more complex we have diversified our capabilities.

The candidate will play a key role in the work of the Analytics & Insight team by developing and maintaining client & competitive data. Data is to be gathered from API calls or existing databases, processed through SSIS, and stored in MSSQL data warehouse. Knowledge of working with or building API calls is necessary. Additional roles will require skill in ETL, reporting, working with SQL Server databases as well as the ability to work with non-technical constituents. We are looking for someone that has a strong SSIS background, good SQL skills and would be able to read through (but not necessarily write) C# code. Any experience with PDW would be a huge plus.