SQL Developer - Gurgaon/Gurugram, India - Cocentrus

    Default job background
    permanent Technology / Internet
    Description

    Please find the Job responsibility as below :

    Job Profile:
    SQL Developer

    Experience: 4+Years


    Salary :
    Budget upto 18.0 lac


    Location:
    Gurgaon

    Working Hours: 10:00 am to 7:00 pm

    Working Days:
    Monday to Friday (Saturday & Sunday Off)

    KeyRolesAnd write and optimize in-application SQL statementsEnsure performance, security, and availability of databasesPrepare documentations and specificationsProfile server resource usage, and optimize and tweak as necessaryCollaborate with other team members and stakeholdersTranslate business needs to technical specificationsDesign, build and deploy BI solutions (e.g. reporting tools)Maintain and support data analytics platforms (e.g. MicroStrategy)Create tools to store data (e.g. OLAP cubes)Conduct unit testing and troubleshootingEvaluate and improve existing BI systemsCollaborate with teams to integrate systemsDevelop and execute database queries and conduct analysesCreate visualizations and reports for requested projectsDevelop and update technical proficiency with SQL and its variation among popular databasesExperience with some of the modern relational databasesSkilled at optimizing large complicated SQL statementsKnowledge of best practices when dealing with relational databasesCapable of configuring popular database engines and orchestrating clusters as necessaryProven experience as a BI Developer or Data ScientistIndustry experience is preferredBackground in data warehouse design (e.g. dimensional modeling) and data miningIn-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) frameworkFamiliarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)Proven abilities to take initiative and be innovativeAnalytical mind with a problem-solving aptitude
    )