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

• C++ , Unix Environment ( Linux/AIX/HP UX), Oracle/MySQL
• Excellent command on OOPS
• Minimum of 3 years (for Mid and Junior) of hands-on work experience in C++, Unix
• Oracle/MySQL
• Hands-on experience of using data structures, STL, Boost libraries, Design patterns
• Exposure to XML or Edifact is desired
• Exposure to XSLT mappings is a plus
• Excellent troubleshooting skills
• Exposure to CppUnit (or similar tools)
Experience range:
• 4 to 8 years of experience
Joining Location:
• Pune, Gandhinagar & Hyderabad (Preferably Pune & Gandhinagar)
Intuitive is the fastest growing top-tier Cloud Solutions and Services company supporting Global Enterprise Customer across Americas, Europe, and Middle East.
Intuitive is looking for highly talented hands-on Cloud Infrastructure Architects to help accelerate our growing Professional Services consulting Cloud & DevOps practice. This is an excellent opportunity to join Intuitive’ s global world class technology teams, working with some of the best and brightest engineers while also developing your skills and furthering your career working with some of the largest customers Intuitive is the fastest growing top-tier Cloud Solutions and Services company
JD:
Years of Database Technologies experience:
- 8+ Years supporting Core database technologies
Mandatory Skills:
- Experience in providing 24x7 support
- Highly organized and self-motivated, handling multiple projects and deadlines
- Experience in multiple core SQL database technologies like Oracle, SQL Server, MySQL,
- Certification in some of the Cloud Database technologies like Oracle Cloud, AWS RDS, Aurora, Azure SQL Server, GCP Databases
- Experience in designing, building, and supporting highly available databases using Oracle RAC, MySQL master/slave configuration, MongoDB replica Sets, SQL Server Always On etc.
- Experience in migration and conversion of heterogeneous & homogeneous databases from on-prem to cloud platforms like AWS, GCP, Azure
- Cloud migrations skills from basic networking, storage, capacity planning, performance benchmarking
- Experience in Oracle Cross-Platform database migration and use of transportable tablespaces
- Experience in using native database backup and recovery technologies like Oracle RMAN and Cloud Platforms backups like AWS Snapshots, AWS S3
- Experience in Databases Performance Tuning, Capacity Planning and Benchmarking
Highly Desirable Skills:
- Experience in 2-3 Automation technologies like Ansible, Bash, Chef, Puppet, CloudFormation, Terraform etc.
- Experience in installing, configuring, and managing database monitoring technologies like Oracle OEM, Percona’s Monitoring Toolset (Promethius), HPOV, Newrelic
- Experience in supporting Big Data Technologies, Data Warehouse, Data Lake, Data Analytics and Machine Learning solutions
• Hands on RDBMS experience with Oracle/ PostgreSQL/ MySQL/SQL
Server including transaction management, SQL programming, data
modelling, etc.
• Must have proven track record of logical data modeling and physical
data modeling
• Experienced in using ORM frameworks like Hibernate, etc.
• Basic understanding of NoSQL systems like Redis (Key-Value store),
MongoDB (Document store), Elasticsearch (Search / Document store)
• Design, Development & Deployment of Microservices using Spring
Boot or any other framework.
• Understanding of building EDA-based (Event Driven Architecture)
systems.
• Basic understanding of any public cloud (AWS, Azure, GCP)
• Ability to design & architect a system that exhibits basic
characteristics like modularity, configurability / extensibility, scalability
& availability.
• Maven / Gradle
• Experience in using & configuring Jenkins.
• Experience in using & configuring SonarQube.
Essential Requirements
• Hands-on with Java Platform (1.5 & above) having proficiency in OOPs
concepts, Collections,
• Generics, Streams, Multi-threading (Executor Framework), Functional
Programming.
• Design & Development of REST Web Services (Spring MVC / REST /
Jersey / Apache CXF, etc.)
• Hands-on experience using Spring framework (4.x & above)
• Core / Beans
• MVC / REST
• Security
• Spring Data / JPA
• Spring Test / JUnit
• JMS
Job Description for Drools developer -
- Hands on experience in design and development in Drools rule engine (minimum 1.5 years) and Core Java
- Exceptional ability to communicate with both technical and non-technical people
- Expertise in object oriented programming
- Experience in Deploying and supporting core and advanced features
- Good exposure to SQL and/or Oracle/ MySQL,
- Candidate should be well verse with Agile processes
- Strong ability to work collaboratively across diverse groups of business and technical stakeholders is required.
- Design & build a highly scalable, robust backend architecture for our cloud services
- You will be part of a software development team for developing and enhancing SaaS applications.
- Take responsibility of entire module/feature set and develop, test, debug and maintain the application software throughout the product lifecycle
- Working with the Product Management Team to validate and plan new features
- Working with cross-functional teams to deliver stellar end user experience
- Research new technologies and tools that help in building the next generation of our services
- Test, debug and maintain the application software throughout the product lifecycle
Desired Candidate Profile
- Must have experience with web development in Java 8+, Spring/J2EE or similar frameworks and technologies. (Mandatory)
- Must have worked on REST API (Mandatory)
- Should be an enthusiast for writing clean, reusable code, willing to learn new things as a self-starter person
- 2+ years of strong relevant experience in developing Object-oriented technologies.
- Strong working experience with any of the following DBs - Postgres / MySQL / Oracle or MSSQL
Responsibilities
- Plan, develop and implement large-scale projects from conception to completion.
- Interface with clients and gather business requirements and objectives.
- Translate clients’ business requirements and objectives into technical applications and solutions.
- Understand and evaluate complex data models.
- Design, develop and implement new integration.
- Execute system development and maintenance activities.
- Develop solutions to improvise performance and scalability of systems.
- Mentor junior and mid-level engineers.
Minimum Requirements
- 3-5 years of relevant experience, working in Java related technologies.
- A Good Engineering or Masters degree from a reputed university
- Should have strong technical skills with a good grasp of OO concepts and design patterns
- Good knowledge of SQL database ( MySQL, Oracle, etc )
- Good understanding of frameworks like Spring, Hibernate, etc.
- Good understanding of spring boot and microservices.
- Exposure to AWS services - S3, SQS, Lambda, DynamoDB, API Gateway, etc.
Good to have
- Knowledge of No-SQL DBs like mongo, dynamoDB, etc.
- Knowledge of message brokers/queuing services like SQL, rabbitMQ, Kafka, etc.

- 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
● Good knowledge of Dimensional data warehouse systems
● Reporting data models with SSIS and MS SQL Server
● Knowledge on 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
Comes with the opportunity to upskill on Big Data cluster

