Database Developer

Database Developer - Third Party payroll

Department

None

Job Description

• Role Summary:
  • Development of functions, stored procedures, and packages
  • Development using external tables,  bulk statement processing, dynamic statement execution, the use of bind variables, and the use of ref cursors, PL/SQL object types
  • SQL statement tuning, reviewing explain plans, and utilizing optimizer hints
  • Dealing with large volumes of data (millions/billions of rows of data) and dealing with partitioned tables
  • Integration with ETL processes and experience in ETL tools
  • Coding applications using best practices, documentation.
  • Knowledge of Java/J2EE would be added advantage
  • Would be responsible for unit testing.   
  • Contribute in design improvement and product enhancement.
  • Demonstrate ability to understand unique requirements and implement them.
  • He/ She should be a self-learner, able to work independently and manage tasks in hand.
• Skills:
  • Excellent skills in relational database design
  • Knowledge of Oracle, MSSQL, MySQL, Maria DB
  • Extract Transform Load (ETL) concepts and technologies
  • Data Warehousing tools, patterns and processes
  • Knowledge of Scripting language (added advantage)
  • Web servers: Apache Tomcat, JBoss, Weblogic and any additional web server
  • Knowledge of Java/J2EE frameworks (added advantage)
  • Knowledge of Spark, Scala, Python (added advantage)

Open Positions

1

Mandatory Skills

PLSQL Developer, Performance Tuning, Data Warehousing, Etl Development, Scripting Language, Client Support

Education Qualification

BCA/BSC/MCA/MSC/BE or any other graduate with good academic background

Experience

3 to 5 years