POSITION SUMMARY STATEMENT:
The Applications Developer II is responsible for the analysis, design, construction, configuration, testing, and implementation of business and technical information technology solutions through application of appropriate software development life cycle methodology. The developer needs to have a sharp eye for spotting defects and should be a team player and excellent communicator.
DETAILED RESPONSIBILITIES/DUTIES:
- Proficient in Software development lifecycles namely Waterfall, Agile and Scrum Methodology.
- Will be responsible for designing, developing, implementing, customizing and integrating Oracle PL SQL process and ADF applications with other systems, and providing ongoing support and future enhancements of those solutions.
- To work with team members as needed to scope, design, develop, test, implement, support and responsible for coding and unit testing application software across production support, enhancements and projects
- Meet service level agreements for production support response and resolution
- Design and develop technical solutions to a pre-defined requirement and develop components including extensions, views, customizations, modifications, reports, and workflows independently or as a part of a team
- Design and develop high quality solutions on Oracle 19C and have good understanding of working on Oracle 23.
- Performance Improvement in the Applications environment. Tuning code, Application health check, Application improvement proposals and implementations. Familiarity with diagnostic tools and perform ongoing query performance analysis and code optimization.
- Follow documentation, software development methodology, version control and testing, and migration standards
- Understand the key integration points, work cross-functionally across different business processes, and understand challenges faced by business teams and address those.
- Meet service level agreements for production support response and resolution. Troubleshoot issues, find their root cause, and any necessary corrective actions to resolve them permanently
- Serve as a mentor to less experienced Application Developers.
- Develop a cooperative environment that fosters knowledge sharing
- Perform additional duties as assigned.
- Ability to effectively prioritize and execute tasks in a high-pressure environment
- Experience working both independently and, in a team-oriented, collaborative environment
Qualifications:
B.E/B.Tech/MCA
Skills:
Required
- Strong attention to detail, problem-solving skills, and verbal/written communication
- Ability to work in an agile environment
- Proficiency in Oracle PL/SQL, XML Publisher, Oracle Development Tools.
- Understanding of different interfacing mechanisms, Web Services, ETL, etc
- Strong understanding of relational databases (including tables, views, indexes, table spaces etc.), including understanding of Entity Relationship Diagrams (ERDs) and the translation of business requirements into them.
- Strong hands on creating collections (nested table, array and associative arrays, PL SQL tables)
- Extensive working knowledge in Tables, Indexes, Views and Cursors.
- Good experience with creating Oracle Tables, Partitions and develop using SQL Loaded scripts.
- Create PL/SQL API’s that use collections methods and objects. Implement a virtual private database with fine-grained access control.
- Extensive debugging with joins and views on oracle database and tuning them for optimized performance with oracle automated tools preferred.
- Experience in scheduling automated jobs from PL/SQL and invoking them using any scripting languages.
- Experience on PL/SQL code to interface with external Java and webservice applications.
- Able to deliver code to interface with large objects and use SecureFile LOBs, write and tune PL/SQL code effectively to maximize performance.
- Understand the basic concepts of relational databases, ensure refined code by developers. Create reports of sorted and restricted data.
- Run data manipulation statements (DML) to control database access to specific objects. Managing schema objects with data dictionary views.
- Retrieve row and column data from tables based on privileges at the object and system level.
- Create indexes and constraints by alter existing schema objects. Create and query external tables.
- Develop PL/SQL Packages, Triggers, Functions, Stored Procedures and utilizing standards debugging methodologies on exception handling.
- Exposer to debug Java code, invoking Webservice and REST API model from PL/SQL will be an added advantage.
- Exposure to Oracle Data Modeling, planning and architecture with performance tuning and debugging skills required.
- Understanding of relational and dimension modeling.
- Ability to identify system impact for small- and large-scale initiatives
- Coordinate migrations/implementation of changes between the different Application environments (i.e., Development, Test, and Production).
- Good experience in cloud solutions is an added advantage.
- Continuous Delivery, including source control practices, versioning, branching, pipeline development, automation acceptance, and release management Experience with application and performance tuning
- Exceptional communication, interpersonal, multitasking and presentation skills
- Hands-on software troubleshooting experience and Ability to conduct research into software-related issues and products
- Experience with development tools such as VS Code & GIT
Experience:
- 7+ years of proven experience in designing and building modern enterprise/large-scale applications.
- 7+ years of experience with SQL (advance queries, tuning) and PL/SQL
- 2+ years of experience in systems/application architecture
- 2+ years of experience in leading design and implementation of complex web applications
Education:
Required
- Bachelor's in Computer Science or equivalent
Preferred
- Master's degree in Computer Science, Information Technology or equivalent.
Preferred Qualifications:
- Experience with international or multi-level marketing business
- Experience with monitoring tools.
- Certifications for desired non-niche programming languages
- Ability to effectively manage multiple, competing, high-priority projects with varying deadlines
- Excellent oral and written communication skills
- Strong interpersonal skills
- Effective writing and diagramming skills
- Clear English-speaking skills
- Ability to interact effectively at all levels with sensitivity to cultural diversity
