Database Developer 8- Third Party Payroll
• 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)