SQL Developer - Johannesburg, South Africa

Job Ref No.: SQLD-SA-16916

About our Client

Our client is a German MNC who has been into Logistics for the past 160 years having office in all major countries. They cater to  integrated logistics of Air, Sea & Supply chain Management etc.

Desired Profile

Qualification

·         Graduate / BE /MCA

·         Relevant certification in Microsoft SQL

Experience – 3+ yrs relevant experience as SQL Developer

Job Location - Johannesburg, South Africa

Key Responsibilities

·         Develop reports in SQL Server Reporting Services (SSRS) .

·         Design, Develop and Deploy SSIS Packages.

·         Identify columns for Primary Keys in all the tables at the design time and create them.

·         Create functions to provide custom functionality as per the requirements.

·         Participate in development and creation of Data warehouses.

·         Create cubes in SQL Server Analysis Services (SSAS ).

·         Write and optimize in-application SQL statements

·         Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.

·         Ensure performance, security, and availability of databases

·         Prepare documentations and specifications

·         Handle common database procedures such as upgrade, backup, recovery, migration, etc.

·         Profile server resource usage, and optimize and tweak as necessary

·         Configuring popular database engines and orchestrating clusters as necessary

·         Plan resource requirements from high level specifications

·         Troubleshooting common database issues

·         Create Entity Relationship (ER) Diagrams to the proposed database

·         Create database objects such as tables, views, stored procedures, Triggers etc.

·         Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

Desired Skills

·         Expert in whole Microsoft technology stack, from database design to front-end user experience.

·         .NET Framework 1.0 - 4.0 ,C#

·         Strong SQL development skills :MS SQL Server 2008 - 2012 :SSIS, SSRS, database tuning, etc.

·         Windows Forms Client-Server applications

·         ADO.NET, WPF, HTML 5, Web services

·         Visual Studios

·         DevExpress components (8.3 - 11.3)

·         Unit testing : MS Test, Rhino Mocks

·         Good communicator who seeks to improve the software development process in any given environment

·         Excellent understanding of the full SDLC

·         Good stakeholder management

·         Demonstrate keenness to learn new technologies and development languages

·         Dynamic self-starter that doesn’t need to be told what to do and how to do it

·         Proactive, business oriented team player with solid problem solving skills

·         Adaptability -  as this is a constantly changing environment

Apply : vaidyanathan@p3synergy.com ; jobs@p3synergy.com

Contact : R.Vaidyanathan – 9840919226 ; Priya G - 9840919226