Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Naukri_Rajan[3y_0m]

    Uploaded by

    kgirwar

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Naukri_Rajan[3y_0m]

    Uploaded by

    kgirwar
    3 views2 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    3 views2 pages

    Naukri_Rajan[3y_0m]

    Uploaded by

    kgirwar

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    +91 7835890392

    RAJAN rajansinghrs1998@gmail.com
    DATABASE ENGINEER New Delhi , India

    https://www.linkedin.com/in/rajan-singh-73a870194/

    SUMMARY
    I have over 2.8 + years of experience providing high level support .
    Work on servers, different databases and having good command over
    Linux, SQL, Data Science, Python and Power BI. Possess exceptional communication and interpersonal
    skills with a proven ability to work independently and as part of a team.

    EXPERIENCE

    STJ ELECTRONICS PVT LTD - New Delhi Feb 2023 - Present


    Database & Application support engineer

    Part of the team responsible for working with databases, particularly using Structured Query Language
    (SQL) to design, develop, maintain and optimize databases. The primary role is to create and manage the
    data structures, write SQL queries and ensure the efficient retrieval and manipulation of data.
    Roles & Responsibilities :-
    Handling databases of Automobile industries like (Ashok Leyland, L&T , Honda , Tata Steel ,etc.)
    Software installation (like Time Office, Payroll, AERM, VID, Mobile App etc.) at the client end.
    Responsible for designing the structure of databases, including creating tables, defining relationships
    between tables
    Write SQL queries retrieve, update, insert and data from databases.
    Responsible for migrating data from database platform to another.
    Develop database schemas and tables.
    Take regular database backup. 
    To extract data from back end using SQL queries. 
    Creates a database and writes SQL queries by using SQL.
    Took hot and cold backup and other server activities and SRS software Implementation.
    Monitoring SQL server jobs like backup, database space ,log space, etc Having a versatile practical
    hands on SQL Objects(Complex Query, Views ,trigger , Stored procedure , Index , DML/DDL).
    MSSQLSERVER- Installation, create the credentials, database creation, backup and restoration. and
    scedule backup Jobs.
    ORACLE- create user and grant permission, backup from existing user and restoration.

    EIE COMPLETE SOLUTION PVT LTD - New Delhi April 2021 - JAN 2022
    Technical Project Engineer

    Working as a Technical support engineer , resolve technical issues, maintenance of analyzers and
    dataloggers (IOT device ) with completing all projects on time
    Upgrade hardware promptly to minimise services disruption.
    Manage all data to server and check data comes through analyzers, using modbus Protocol.
    Site creation & configuration on the portal.
    Work under the project manager and assist the technical team Members to complete work on time.
    Responsible for creating schedule and overseeing project to make sure those goals are met on time.
    Envirozone Instruments & Equipments - New Delhi July 2020 - March 2021
    Technical Service Engineer

    Diagnose, troubleshoot, and resolve issues by questioning customers about the issues.
    Testing the water analyzer UV300 and UV500.
    Knowledge of installing UV300 & UV500, System (water analyzers), flowmeter, Fuji electric and HNL (air
    and dust analyzer).
    Developing relationships and maintaining customer relations.
    Supporting the sales team with all technical related queries. Supervising site engineers regarding online
    connectivity & hardware and software issues.

    EDUCATION

    Bachelor of Technology in Electrical & Electronics from HMR Institute of Technology and
    Management(GGSIPU) , New Delhi, 2016-2020 (Percentage- 75%).
    Completed 12th from GRM SR. SEC. Public School, New Delhi, 2014-2016(Percentage- 65%).
    Completed 10th from Govt Boys Middle School, New Delhi, 2013(CGPA-7.0).

    PROJECTS

    Create Dashboard using Super Store Sales Data in Power BI.


    Create Dashboard using E-Commerce Sales Data in Power BI.
    Create Dashboard using Techno Sales Data in Power BI.
    Create Digital Clock using Python and its Tkinter Library.
    Create Bank Account System using Python and its Tkinter Library.

    CERTIFICATION

    Python with Data Science


    Certification in SQL
    PLC and Scada

    SKILLS

    Database/Data Warehouse : MySQL, PostgreSQL, Microsoft SQL Server.


    SQL : SQL Commands (DDL, DML, TCL, DCL, DQL), Data Types, Constraints, Operators, SQL Clause,
    CASE Statement, Joins, Aggregate Functions, CTE Table, Window Functions (RANK, DENSE RANK,
    ROW NUMBER LEAD, LAG, FIRST VALUE, LAST VALUE, Nth VLAUE, NTILE), Views.
    Python : Basic Python Programs, Variables, Operators, String, Loops, List Comprehension, Tuple,
    Set, Dictionary, Functions, Exceptional Handling, File Handling, Regular Expressions, OOPs
    (Inheritance, Encapsulation, Abstraction and Polymorphism).
    Data Analysis : Using SQL and Pandas.
    Data Visualization : Matplotlib, Seaborn and Power BI.
    Power Bi
    Microsoft Excel

    You might also like