Senior Database Developer - Ahmedabad, India - HyringNinja

    HyringNinja
    HyringNinja Ahmedabad, India

    2 weeks ago

    Default job background
    Description

    Key Responsibilities


    • Gathering all salient information regarding the intended functions of each database.


    • Receiving requests pertaining to the layout, appearance, and special features of each database.


    • Provide guidance and support to Application Developers about DB access and usage.


    • Provide hands on guidance and leadership through the entire lifecycle of development projects.


    • Provide DB schema design and architecture, code development and review, SQL query tuning and optimizations.


    • Install, patch, upgrade, configure and monitor DBMS installations.


    • Upgrade and improve application schema and data upgrades.


    • Proactively and regularly make recommendations for system improvements.


    • Support production application databases as the need arises.


    • Analyze structural requirements for new system development in terms of features and functions.


    • Develop plans, processes, and hands-on migration of data from legacy systems to new solutions.


    • Support migration and implementation of new Compas software version from the DB perspective


    • Designs and implement future ETL frameworks ensuring the high data quality to our customers environments.


    • Design conceptual and logical data models and flowcharts


    • Improve system performance by conducting tests, troubleshooting, and integrating new elements.
    • Optimize new and current database systems.


    • Define and security, backup and DB maintenance procedures.


    • Enable and support a Data Science capability to identify future needs and requirements as the organization gets more entrenched in data mining and AI frameworks.


    • Design, develop and support data pipelines that enable data analytics and data modelling using different datasets.


    • Create data analytics reporting to expose the findings of the analysis.


    • Design, develop and support DB CI/CD pipelines.

    Skills and Experience Required

    Essential:


    • Proven work experience as a Database developer


    • Experience on architecture, design, development, and documentation of DB solutions


    • Experience working on source control environments (git)


    • In-depth understanding of database structure principles


    • Experience gathering and analyzing system requirements.


    • Expertise in SQL, Oracle, and other relational and non-relational Database technologies


    • Experience working with XML, Json, yml formatted data on SQL and outside SQL


    • Experience with MS technologies MS-SQL, .net, MVC


    • Experience developing testing and tuning stored procedure for data access by front end application.


    • Proficiency in MS Excel to display DB data as needed.


    • Familiarity with data visualization tools (e.g., Power BI, Tableau, , SSRS)


    • Experience on DAX, Python, R


    • 3+ years of experience in directing other DB development and DB staff.


    • 4+ years of experience with Microsoft database environment


    • Expert level proficiency in SQL, SSIS and ETL.


    • Database administration experience


    • Installation/patching/security/maintenance/configuration/monitoring


    • Experience on windows server environments


    • Experience creating/configuring/supporting DB CI/CD pipelines from a DB perspective


    • On Azure DevOps


    • Proficiency in SQL, C++, or Java, with a preference for more than one of these.


    • Proven analytical skills.


    • Problem-solving attitude


    • Strong communication skill


    • BSc in Computer Science or relevant field