Senior SQL Server Developer Microsoft

Thursday, February 7, 2019 - 20:38
Job Description: 


MSC Technology provides exclusive IT solutions to MSC Mediterranean Shipping Company. We believe engaged, talented and ideas-focused individuals are what makes an international business like ours so successful. Being a professional services firm, it’s about creating a workplace where we recruit skilled people able to deliver excellence service but first, a place where people can be inspired and be inspiring.

1 About the MSC OneVision Program

MSC continues to invest and lead the world-wide container business with ships, an extensive container fleet, intermodal and dedicated staff for its Customers. The Company’s evolution to becoming a leading brand requires a consistency to market. It is therefore paramount to standardize data, processes and management information. Hence, MSC has decided to launch The Program OneVision, a commitment led by MSC Geneva to review their operations and information systems from a central point. Adding or modifying key concepts, technical components and functionalities will enable this Solution to become the unique operational system for MSC worldwide.

2 The Role

The Senior SQL Server Developer works with the global teams (USA, India, Europe/Switzerland) and with external partners / vendors under the OneVision Architecture governance. They will work in coordination with the in-place “Community of Practices” to ensure the coherence of the database development within the program architecture. They will develop transversal components, perform Proof of concepts and studies, address database development problem and quality issues, proposes good database development practices, performs database code reviews, assess the other teams’ deliverables and participate in release management.

They will need to understand MSC business and application requirements. The Senior SQL Server Developer will be working very closely with the SCRUM teams, to provide leadership in a proactive manner, including product owners/product specialists, developers and testers. As such they could be expected to recommend solutions to address business needs thanks to studies, assessment and proof of concept.

3 Key Responsibilities

3.1 Development

The Senior SQL Server Developer is in charge:
•Implement data integration flows (ETL) and ad-hoc software solution with DB technologies following architecture guidance.
•Develop transversal/complex components (Scripts, procedures, queries) for broad internal reuse. Contribute and extend the library of shared components (OneVision Framework).
•Provide design and development guidance during review of development artifacts
•Propose and follow good development practices,
•Fix and fine tune existing systems as per request.
•Introduce innovation on purpose under IT management control.

The Senior SQL Server Developer will strive to provide MSC with the best IT services. According to these objectives, He/she will ensure that the IT systems fulfill the nonfunctional requirements and respect the service management constraints for efficient transition handover.

3.2 Software quality and Collaboration
•Execute his/her activities with methodology and transparency
•Support the OneVision strategy and help the needful transformation
•Adhere and implement good development practices to support ongoing IT changes.
•Perform code reviews and functional/nonfunctional tests
•Promote continuous improvement
•Ensure proper and efficient communication and collaboration within the projects and with the projects’ counterparts and stakeholders.
•Advise, promote, coach, coordinate the use of the architecture solutions related to his/her area of responsibility.
•communicate with stakeholders using clear and concise language, prepare and comment decision matrices tailored to the readers

3.3 Contribution
•Actively contribute as a team member in a matrixial/agile context.
•Collaborate on a daily basis with the Application Development Team to secure delivery in time and according to quality assurance standards
•Provide input, reviews, guidelines to the Community, evaluate implementation and manage continuous improvement
•Adopt and promote a pragmatic solution in solving issues related to business needs.
•Help decision makers to make the right design and technology choices.
•Contribute to the planning, study, design, implementation, testing and deployment phases of the software development projects
•Actively participate in the components identification and their dependencies with other systems in the enterprise architecture; review, assess and prepare decisions to be taken by Program’s Management and Architecture Committee(s)
•Build technical components user guides, guidelines for Global IT Teams
•Contribute to the development of training material and processes documentation

3.4 Management
The role does not manage a team.

3.5 Additional Responsibilities
•Develop a mutually respectful working relationship with all staff in to ensure a strong Team effort in all activities
•Provide timely, complete and accurate responses to all Program Stakeholders’ questions and inquiries in a positive and constructive manner
•Complete tasks as required by the Company
•Remain current on trends and innovation in IT, Software and Middleware industry
•Anticipate and address potential issues leveraging previous experience and strong problem solving skills

4 Performance Skills
•Listening and understanding
•Promoting and adopting a pragmatic approach
•Embrace change and improvement plan
•Result oriented and commitment to tasks
•Analytical skills
•Good communication skills, spoken and written proficiency in English.
•Ability to deal with peers and business counterparts
•Team spirit
•Tolerance of ambiguity
•Self-organization and planning
•Curious and willing to learn

5 Affectation
•Position to be filled in US-NJ Warren
•Availability to travel as required

6 Qualifications and Experience

(P) = Preferred, (R) = Required


- The maritime shipping industry (P)

- Support of large and distributed enterprise applications (P)

And related production services

- Delivery of inhouse enterprise software (R)

- Solution design (data model design) (R)

- SQL Development Code Review (R)

- Agile methodology (SCRUM) (P)

- DevOps implementation (scripting/automation…) (P)

- Global IT services design and transition (ITILv3+) (P)


- MS SQL Server platform

SQL queries (R >8 years)

Transact SQL Store Proc (R >5 years)

SQL Data modeling (R >5 years)

SSIS (Integration services) (R >3 years)

SSRS (Reporting services) (R >1 year)

SSAS (Analytic Services)

- Software design patterns and practices (R)

- Software modeling (UML (R)

- Data synchronization, migration and transition (P)

- Data integration patterns (P)

- Azure IaaS and PaaS (P)

It should be clear that the job requires strong skills and practical experience in various software development technologies like:

- Security concept

- Code analyzers

- Microsoft development framework

- CI/CD, DevOps and operational products

- Other software technologies are plus


- Fluency in English (oral and written) (R)

- Requirements capture and documentation (R)

- Tests implementation and analysis (R)

-Communication skills in a global and multicultural envt (R)

- MS Office Products (R)

- Multicultural work collaboration (R)

- Fluency in other language is an asset (P)

7 Performance skills Guide

Team building

Developing and maintaining a team spirit within the group and in general within the systems department; participating in information sharing and teamwork to raise the performance and ensure a clear vision and commitment to everyone in the organization.

Organization and Planning

Organizing or scheduling people or tasks; developing realistic goals and action plans while being sensitive concerning time constraints and resource availability; communicating these goals and action plans to all people involved.

Listening and Understanding

Understanding clearly the users’ requirements and their business in order to go beyond what is expressed, including all required features in the delivered products or services.

Decision making and problem solving

Using a systematic approach in solving problems while exhibiting judgment and a realistic understanding of issues; dealing with facts objectively; taking proactive action to solve potential problems at the design level, impeding any negative outcomes.

Commitment to task

Starting and persisting with specific courses of action while exhibiting high motivation and time management.


Influencing the actions and opinions of others steering things in a desired direction; exhibiting judgment in leading others towards worthwhile objectives.

Spoken and written communications

Presenting information clearly through spoken communication; influencing or persuading others through oral presentation in positive and negative circumstances; be a good listener. Writing clearly and effectively present ideas and document activities; reading and interpreting written information thoroughly.

Tolerance of ambiguity

Filtering actions or speech in the absence of important information, while striving to get the required information; dealing with unresolved situations, frequent changes, delays or unexpected events.

Management and Coaching

Providing clear guidelines and objectives to staff; developing their abilities to reach their objectives; checking progress and achievement; helping in difficult situations; developing a win- win relationship with the staff in order to maximize motivation, efficiency and productivity; leading by example.

Special benefits Include

- Health Care Insurance

- Vision Care Insurance

- Dental insurance

- Life Insurance

- Short Term Disability

- Long Term Disability

- Paid Vacation

- 401K Savings Plan

- Casual Work Environment

- Flexible Work Hours

Job Restrictions

- Direct Hires (no Agencies)

- Only considering applicants in regional area

- US Citizens or those legally allowed to work in the US only

- Visa sponsorship is not available for this position

Not Disclosed by Recruiter
IT-Software / Software Services
Functional Area: 
IT Software - Application Programming, Maintenance
Role Category: 
Apply to this Job