IT Software-Engineer Jobs - Chennai - Protechsoft Technologies Pvt Ltd

Database Developer

Protechsoft Technologies Pvt Ltd

0 Years

200000 Yearly

Expired

Posted: 20 Oct 16

Job Description

Description
The Database Developer's role is to develop and maintain databases across the organization, while ensuring high levels of data availability. The Database Developer will in addition evaluate and advise on all technology components, such as software, hardware, and networking capabilities, for database management systems and applications. As part of the role they will be responsible for implementing data dashboards to all levels of the organization.

Candidate should have proficient knowledge in the following

How SQL Query works
The concepts of REGEXP functions, Analytical functions, XML handling, PLSQL tables, cursors, Pivot etc.
Knowing the Basic concepts like joins, subqueries, group by, inbuilt functions etc.
Process of connecting different Databases using synonyms, views, users/schema.
Performance Tuning of queries.
Analysis of the Data issues and generating a report.
Live data analysis for generating the statistical report for each year.
Writing night run batches and scheduling for daily, weekly or monthly process.
Ability to migrate the code and data from one platform to another (like SQL Server-Oracle, Oracle - SQL Server).
Handling of File Extraction/Creation.
Retrieve of all the attribute data for each unique transactions/events.
Forecasting events through 'R' language conversion to SQL.
Handling of amount distribution and disbursement process.