Programmer Analyst

ZURITECH, INC.
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Tech stack

Microsoft Windows
Unit Testing
Unix
Databases
Data Cleansing
HP Systems Insight Manager
Microsoft Office
Operational Databases
Oracle
Oracle Applications
Performance Tuning
Shell Script
Software Engineering
SQL Stored Procedures
PL-SQL
SQL Databases
Database Optimization
Vba Programming Language

Job description

Study and document there As Is and To Be planning processes and reporting requirements. Functional specification creation for reports, forms, enhancement, and conversions Testing (Integration, User acceptance, Unit Testing). Interacting with clients and understanding the business requirement and their expectation from ERP. Conduct functional walkthroughs, User Acceptance Testing (UAT) sessions, and supervise the development of User Manuals for business users. Develops SQL Scripts to create datasets to perform reporting and includes interactive drill down reports, report models and reports. Involve in Software Development Life Cycle (SDLC). Actively participate in scrum meetings and reviews. Perform modification on some Oracle Stored Procedures to integrate the different tasks of Oracle Developers. During analysis, he will be involving in tuning SQL and PL/SQL for better performance of the database. Coordinate with DBA for database tuning during Cleansing execution. Maintain application monitoring, performance tuning and testing. Provides the automation for copying of production database and restoring the data to a non- production development system using shell scripting. Involve in creating the backup database to track the tape usage and ensure all the environments were backed up consistently. Required Minimum Qualifications: Bachelor's degree (or equivalent). Technologies: Unit Testing, PL/SQL scripting for interaction with database. Oracle 11g for data migration.PL/SQL for tuning and performance increase for database. Oracle 11g for modifying stored procedure. Production support and data cleansing. Tools & Utilites: PL/SQL, Oracle 11g, Windows OS, UNIX/LINUX, Shell scripting, MS Office and UAT and Visual Basic

Requirements

Do you have experience in Windows?, Do you have a Bachelor's degree?

Apply for this position