Seeking for candidates with 5+ yrs of experience in Oracle background using PL SQL.
Responsible for writing PL/SQL Stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc
Responsible in writing complex queries with varied large data sets
Analyse, Design, Code and Debug using Oracle/PL SQL
Good in PL SQL concepts like Oracle Packages, stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc.
Ability to write efficient, complex queries against very large data sets using SQL Developer and TOAD
Expertise in pl/sql concepts- Oracle Packages, stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc
Experience in performance tuning - Strong analytical, design and debugging skills

About Careator Technologies Pvt Ltd
About
Careator Technology is an end-to-end service provider for all your Application Development, Recruitment, and Staffing related requirements. Our primary competitive advantage is our ability to provide customized solutions that cover the whole process from beginning to finish. Careator maintains a broad variety of productive partnerships with organizations of the highest tier, and the firm ensures that each of its commercial associates is provided with an effective solution.
The founders of Careator understand that the combination of people and technology is essential to the success of a business. The company places a high premium on its employees and their relationships. This is reflected in the way that it creates its operational and strategic models, how it responds to consumers, how it connects with people, and how it promotes diversity in the workplace and the community.
Connect with the team
Similar jobs
Job Description
Build and maintain bots on Azure platform. Integration with Active directory, WEB API based integration with external systems. Training and Integrate bots as per users’ requirements. Work in line with design guidelines, best practices and standards of bot deliverable. Creative approach to the conversation flow design, human aspects in the bot responses and sentiments
Qualifications
- a) 5 years of experience in software development with clear understanding of the project life cycle
b) Min 2-3 years of hands-on experience in Microsoft Azure Bot Framework, LUIS and other Cognitive services offered by Azure
c) Hands on experience with Machine Learning based chat bots
d) Experience with Azure bot services like Text Analytics etc.
e)Strong database skills and hands-on experience on databases like SQL Server/Oracle - f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.
- g) Strong experience designing and working with
with service-oriented architectures (SOA) and WebAPIs.
- h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C#/VBNET
- i) Knowledge of Python and NodeJS is a plus
- j) Ability to design and optimize SQL Server 2008 stored procedures.
- k) Experience with JQuery, CSS3, HTML5 or similar technologies.
- l) Ability to adapt quickly to an existing, complex environment.
Job brief
We are looking for a qualified Database developer to design stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively.
As part of our IT team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.
Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis.
Responsibilities
- Design stable, reliable and effective databases
- Optimize and maintain legacy systems
- Modify databases according to requests and perform tests
- Solve database usage issues and malfunctions
- Liaise with developers to improve applications and establish best practices
- Gather user requirements and identify new features
- Develop technical and training manuals
- Provide data management support to users
- Ensure all database programs meet company and performance requirements
- Research and suggest new database products, services and protocols
Requirements
- Proven work experience as a Database developer (5+ Years)
- In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
- Knowledge of software development and user interface web applications
- Advanced proficiency and hands on experience with T-SQL, Stored Procedures, Cursors, Triggers, Schedulers etc.
- Familiarity working with MS SQL Server, MySQL, .Net Framework, java
- Excellent analytical and organization skills
- An ability to understand front-end users’ requirements and a problem-solving attitude
- Ability to craft detailed technical manuals.
- Excellent verbal and written communication skills
- BE/MCA/MSc Degree in Computer Science or relevant field.
Java - SSE/ Senior Developer
Singapore
Company Profile: Nucleus Software has been providing Products and Services to various Global and Regional Financial institutions, from past 36 years. As a pioneer IT Service provider, Nucleus carry deep banking domain expertise and experience on latest technological trends. Nucleus’s developed platforms powers the operations of more than 150 institutions in 50 countries, supporting multiple business veritcals, accessible through Mobile and internet channels
JOB ROLE & RESPONSIBILITIES
- Develop & support application through all stages of the project life cycle, including Design, Construction, Testing support and Warranty support
- Having experience in Java 1.6 and above, JEE, Spring, Struts,microservices ORM and Oracle.
- Good understanding of Design Principles and Object-Oriented Programming
- Develop Low level design documents
- Responsible for Coding, Developing Test cases using Junits, Unit Testing
- Adhering the schedule and scope of the project
- Ensure to follow the Technology and Process standards set for the project
- Produce high quality technical delivering for the customer
- Interact with project lead to review technical deliverables
Key deliverables
- Design and Develop Programs with high quality and agreed processes, within the planned schedule
- Review Unit Test Cases with Project Lead
- Design, Develop and Unit Test
- Technical Design documents (LLD)
- Support throughout testing, implementation and warranty phases
Desired for the Position:
- Hands on experience in Designing and Developing web applications using Java EE platforms (Spring, Struts, EJB), ORM and Oracle Database)
- Strong background of Object-oriented analysis and design using common design patterns
- Profound insight of Java and JEE internals (Class loading, Memory Management, Transaction management etc)
- Good knowledge of Relational Databases (Oracle) and PL/SQL
- Carries good analytical and communication skills
Location: Base: Chennai , Bangalore and Noida, Projects-Singapore
Package: upto 17 L
Experience: 5 yrs

- Actively participate in the exchanging of ideas and information within the department
- Participate in rollout of new business system integrations.
- Serve as escalation point for system and troubleshooting issues, assist in resolving production issues.
- Participate in or lead solution design sessions.
- Ability to work effectively under pressure with changing priorities and tight deadlines
- Provide technical advice, code reviews and assistance to other programmers.
- Write complex integration solutions, optimized data extracts, updates and interfaces.
- Interface with functional specialists to ensure solution design and integrity.
- Devise sample input data to test accuracy of program.
- Observe or runs test of program using sample or actual data, assist in user acceptance training.
- Understand and embrace the global IT strategic direction
- Adhere to all safety and health rules and regulations associated with this position and as directed by superior.
- Proactively organize verbal and written ideas clearly and use an appropriate business style
- Be effective and consistent in providing regular updates to appropriate managers
Communication :
- Ask questions; encourage input from team members
- Able to work with and participate within a small multicultural professional team.
- Provide regular updates to appropriate managers
- Confer with reporting manager on complex or unusual situations
- Maintain a thorough knowledge and in-depth field experience regarding emerging or job technologies required to fulfill the job, this could include formal or self paced professional development. Participate in the exchange of ideas and information within the department
- Offer new ideas and suggestions for improvement. Identify and implement new practices and processes that are - best in field-
Requirements:
KNOWLEDGE REQUIREMENTS :
- Experience in analysis, design, coding, and implementation of enterprise integration solutions.
- Experience with webMethods components: Integration Server, Broker, Trading Networks, and SAP Adapter. webMethods 9.x version preferred.
- Experience with RosettaNet PIP's and standards.
- Experience with XML and webservices (SOAP/REST).
- Experience with PL/SQL.
- Experience with FlatFile processing
- General understanding of scalability and high-availability systems.
- Excellent communication/documentation skills
- Experience in system administration a plus.
EDUCATION & EXPERIENCE REQUIREMENTS :
- B.E./B.Tech/M.Tech/MCA
- 3 to 5 years experience in a relevant IT position OR equivalent external work experience
WORKING CONDITIONS :
- Location:
- Travel requirements: Domestic and/or International, up to 10%.
- Climate controlled office environment during normal business hours
- Basic knowledge of Oracle Forms and reports - (Must)
- Good experience on SQL*Loader.
- Should Knowledge on Agile / Scrum.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Using SQL developer tool we debugged the code and unit test
- Knowledge of oracle programming
- MySQL, Oracle,
- Knowledge of Unix platform
- PostgreSQL
- advance database knowledge.
- Writing PL/SQL and PL/MySQL
- Coding support
- Debugging & Project module management
- Deployment and fine-tuning as per team lead.
● Good knowledge of Dimensional data warehouse systems
● Reporting data models with SSIS and MS SQL Server
● Knowledge of all aspects of BI preferably data modeling, data
● integration, data analysis, and reporting
● Good working knowledge of MS Azure environment
● Knowledge of BI tools like Tableau or PowerBI
● Good communication skills
Required Qualifications and Skills:
- 3-5 years of work experience in the development background, with at least 2 years experience in Java, Spring, Sprint Boot, Hibernate or JPA, MySQL, Oracle, Spring MVC.
- B.E. degree in Computer Science, Graduate in Software Engineering or equivalent
- Experience in Core JAVA, Spring, Spring Boot Frameworks.
- Experience with ORM's like Hibernate.
- Good knowledge of developing RESTful web services using Spring Boot, Java1.x,Servlet2.4, JSP2.0, JDBC3.0, Java Mail, Struts2.x, HTML, HTML5, Angular7+, JavaScript, JSF, Bootstrap2.x-3.x, JQuery & CSS 3.x, Maven 3.x, Apache Tomcat7
- Knowledge of Cloud AWS.
- Experience in any Messaging Queue e.g. Apache Kafka, ActiveMQ, etc.
- Experience on Web services with REST and SOAP.
- Experience working on tool set like Eclipse IDE, SQL clients.
- Experience using application server like Jboss, TomCat, Wildfly, glassfish.
- Experience in using tools like SOAP UI, POSTMAN
- Ability to write SQL queries to fetch data.
- Knowledge of Micro services, Redis Cache and Mongo DB (or any other NoSQL) is good to have

