Database Administrator

Job Title:                 Database Administrator

Location:                  L&T Technology Services limited, Edison, NJ (to be deputed to client location when required)

Qualifications:          Bachelor of Engineering in an IT or any IT related field (Computer Science, Information Systems or Electrical Engineering or Electronic Engineering) or a closely related field with 02 years of experience.

Number of positions:  1

Job Description:   Updating engineering drawings in different engineering tools like Smart Instrumentation, smart P&ID, Smart Electrical & AutoCAD. Migration of electrical legacy data from one database to other database type without any data loss, upgrading to latest SEL, aligning electrical TNC as per the global standards, migrating data to new environment using Import/Export database scripts and troubleshooting issues. Coordination with team for Management of Change (MOC) execution and supporting DDO team in getting ad-hoc clarification on queries for smooth operation. Co-ordinating with official tool support service (Vendor) for tool related issues. Installation of Smart Electrical and oracle server in virtual machine, Creation of Oracle Database, Configuring application, Restoration of Production backup. Analyzing the electrical legacy data and preparing the as-is report, Installation of Smart Electrical (upgrade version) and SQL server, SQL Instance and Database Creation, Migrating electrical data from Oracle to SQL, Performing quality check post upgrade, Transferring data from one system to new system by generating SQL scripts, Troubleshooting issues faced during migration by querying in SQL Server, Developing tool to compare two database tables.