11+ Database performance tuning Jobs in Pune | Database performance tuning Job openings in Pune

Oracle OAS Developer

Senior OAS/OAC (Oracle analytics) designer and developer having 3+ years of experience. Worked on new Oracle Analytics platform. Used latest features, custom plug ins and design new one using Java. Has good understanding about the various graphs data points and usage for appropriate financial data display. Worked on performance tuning and build complex data security requirements.

Qualifications

Bachelor university degree in Engineering/Computer Science.

Additional information

Have knowledge of Financial and HR dashboard

Strong Lead – User Research & Analyst profile (behavioural/user/product/ux analytics)

Mandatory (Experience 1): Must have 10+ years of experience in Behavioral Data Analytics, User Research, or Product Insights, driving data-informed decision-making for B2C digital products (web and app).

Mandatory (Experience 2): Must have 6 months+ experience in analyzing user journeys, clickstream, and behavioral data using tools such as Google Analytics, Mixpanel, CleverTap, Firebase, or Amplitude.

Mandatory (Experience 3): Experience in leading cross-functional user research and analytics initiatives in collaboration with Product, Design, Engineering, and Business teams to translate behavioral insights into actionable strategies.

Mandatory (Skills 1): Strong expertise in A/B testing and experimentation, including hypothesis design, execution, statistical validation, and impact interpretation.

Mandatory (Skills 2): Ability to identify behavioral patterns, funnel drop-offs, engagement trends, and user journey anomalies using large datasets and mixed-method analysis.

Mandatory (Skills 3): Hands-on proficiency in SQL, Excel, and data visualization/storytelling tools such as Tableau, Power BI, or Looker for executive reporting and dashboard creation.

Mandatory (Skills 4): Deep understanding of UX principles, customer journey mapping, and product experience design, with experience integrating qualitative and quantitative insights.

Mandatory (Company): B2C product organizations (fintech, e-commerce, edtech, or consumer platforms) with large-scale user datasets and analytics maturity.

Mandatory (Note): Don’t want data analysts; looking for strategic behavioral insight leaders or research-driven analytics professionals focused on user behavior and product decision-making.

Mandatory Skills

• Backend: Java, Spring Boot
• Frontend: Angular
• Database: Oracle / SQL
• Node js

Job Description

Contribute to all software-development life-cycle phases including: domain and non-domain problem analysis, solution requirement gathering and analysis, solution design, implementation, code review, source-code control, source building deployment, validation, QA support, and production support.

Essential Duties and Responsibilities

•⁠ ⁠Maintain and enhance multi-tier messaging application suites (Java EE, Springframework, WAS, Oracle, DB2, MQ)

•⁠ ⁠Build and maintain IRIS4Health middle-tier message applications (IRIS Interop/Cache; Java, Drools, Kafka, Restful, MLLP, SQL)

•⁠ ⁠Build and maintain multi-tier Clinical Toxicology application (Angular, Java EE, Springframework, WAS, RHOS, Cache, SQL)

•⁠ ⁠Maintain stat-tracking application (two-tier Delphi, MySQL)

•⁠ ⁠Maintain and enhance Cytogenetics three-tier application (Java EE, WAS, DB2, Oracle, SQL, )

•⁠ ⁠Maintain and enhance Fibrosure application (Java EE, WAS, Derby)

•⁠ ⁠Define develop, validate, and release software products via agile processes for small and large projects

•⁠ ⁠Support applications and people via Kanban processes

•⁠ ⁠Collaborate with laboratory users to analyze problems, design and implement solutions for enterprise systems

•⁠ ⁠Provide support and troubleshooting of production systems according to an on-call schedule

•⁠ ⁠Document problem analysis, solution design, implementations, and system support guidelines

•⁠ ⁠Coach and train team members across lab system organizations to support and develop Java applications

•⁠ ⁠Communicate effectively and constructively with developers, QA, business analysts, and system users

•⁠ ⁠Design and depict via UML relational DB table models, object-oriented class models, messaging models, configuration models

•⁠ ⁠Understand, document, support, and improve inherited code and processes

•⁠ ⁠Help document knowledge and discovery with peer developers

Minimum Requirements

•⁠ ⁠Solid Java EE experience (Servlets, JMS, JSP, EJB, JCA, and JPA) development and support

•⁠ ⁠Solid InfoSystems Cache/IRIS for Health development and support

•⁠ ⁠A minimum of 1 years of JPA/ORM (Hibernate), Junit, XML/XSD, JSON experience or equivalent

•⁠ ⁠Solid SQL (and optionally PLSQL) experience

•⁠ ⁠Experience with Oracle DB including explain plan and or other query optimization techniques/tools

•⁠ ⁠Excellent verbal and written communication skills

•⁠ ⁠Strong UML modeling, ER and OO design, and data-normalization techniques

•⁠ ⁠Strong code-factoring philosophies and techniques

•⁠ ⁠Eclipse or NetBeans (or equivalent) IDE

•⁠ ⁠Strong understanding of client/server design, and smart recognition of separation-of-concern like functional behavior versus non-functional performance

Desired Requirements

•⁠ ⁠Java EE, Angular

•⁠ ⁠InfoSystem's Cache and/or IRIS for Health

•⁠ ⁠Springframework

•⁠ ⁠Modern deployment architectures using containers, API Gateways, load balancers, and AWS cloud based environments

•⁠ ⁠WebSphere or WebLogic, RHOS

•⁠ ⁠RESTful Web Services

•⁠ ⁠JMS interfacing, Apache Kafka, and IBM MQ

•⁠ ⁠Node.js/NPM, Bootstrap, or similar frameworks

•⁠ ⁠Git/BitBucket (git flow), Maven, Nexus, UCD, Jira (Kanban and SCRUM), agile workflow

•⁠ ⁠Unix shell script, DOS script

•⁠ ⁠SQL (optionally PLSQL)

•⁠ ⁠Design patterns

•⁠ ⁠HTML5, CSS3, and TypeScript development

•⁠ ⁠Ability to transform specific domain requirements into generalized technical requirements, and design and implement abstract solutions that are understandable and scalable in performance and reuse

•⁠ ⁠HL7 and/or Healthcare and/or Clinical Toxicology

•⁠ ⁠Oracle, MySQL, Derby DB

• Partners with business stakeholders to translate business objectives into clearly defined analytical projects.
• Identify opportunities for text analytics and NLP to enhance the core product platform, select the best machine learning techniques for the specific business problem and then build the models that solve the problem.
• Own the end-end process, from recognizing the problem to implementing the solution.
• Define the variables and their inter-relationships and extract the data from our data repositories, leveraging infrastructure including Cloud computing solutions and relational database environments.
• Build predictive models that are accurate and robust and that help our customers to utilize the core platform to the maximum extent.

• 12 to 15 yrs of experience.
• An advanced degree in predictive analytics, machine learning, artificial intelligence; or a degree in programming and significant experience with text analytics/NLP. He shall have a strong background in machine learning (unsupervised and supervised techniques). In particular, excellent understanding of machine learning techniques and algorithms, such as k-NN, Naive Bayes, SVM, Decision Forests, logistic regression, MLPs, RNNs, etc.
• Experience with text mining, parsing, and classification using state-of-the-art techniques.
• Experience with information retrieval, Natural Language Processing, Natural Language
• Understanding and Neural Language Modeling.
• Ability to evaluate the quality of ML models and to define the right performance metrics for models in accordance with the requirements of the core platform.
• Experience in the Python data science ecosystem: Pandas, NumPy, SciPy, sci-kit-learn, NLTK, Gensim, etc.
• Excellent verbal and written communication skills, particularly possessing the ability to share technical results and recommendations to both technical and non-technical audiences.
• Ability to perform high-level work both independently and collaboratively as a project member or leader on multiple projects.

About Propacity:

Propacity is a leading real estate company committed to transforming the real estate landscape through innovative technology and data-driven solutions. Our mission is to empower stakeholders in the real estate ecosystem with cutting-edge tools and insights. We are seeking a passionate and creative Content Writer Intern to contribute to our dynamic marketing team.

Responsibilities:

Content Creation:

-Collaborate with the marketing team to produce compelling and informative content for various platforms, including blogs, articles, social media, and website copy.

-Conduct in-depth research on real estate industry trends, market analysis, and related topics.

SEO Optimization:

-Work closely with the SEO team to optimize content for search engines and improve organic visibility.

-Implement best practices for keyword usage and on-page SEO.

Social Media Engagement:

-Assist in the creation and scheduling of engaging social media content.

-Monitor social media channels for industry trends and contribute to relevant conversations.

-Cross-Functional Collaboration:

-Coordinate with design, product, and data analytics teams to ensure content aligns with brand guidelines and messaging.

-Participate in brainstorming sessions to generate creative ideas for content campaigns.

Data Analysis:

-Utilize analytics tools to track and analyze the performance of content.

-Provide insights and recommendations based on data to enhance content effectiveness.

-Professional Development:

-Stay informed about industry developments, content marketing trends, and emerging technologies.

-Actively seek feedback and incorporate it into continuous improvement.

Requirements:

-Currently pursuing a degree in Marketing, Communications, Real Estate, or a related field.

-Exceptional written and verbal communication skills.

-Strong creative thinking and storytelling abilities.

-Ability to work independently and collaboratively in a remote or office setting.

-Basic understanding of SEO principles and content optimization.

-Familiarity with social media platforms and trends.

-Proficiency in Microsoft Office and/or Google Workspace.

Benefits:

-Hands-on experience in content creation and marketing within the real estate and technology sectors.

-Exposure to a fast-paced and innovative work environment.

-Mentorship and guidance from experienced professionals.

-Networking opportunities within the real estate and tech industries.

Job Location: Kharadi, Pune.

Mandatory Skills: Exp in anyone MNC framework (Laravel/Codeigniter/CakePHP)

Roles and Responsibilities:

1. As a PHP Developer, you will be responsible for developing and coding all server-side logic using the CakePHP framework.
2. Writing back-end code and building efficient PHP modules.
3. Understand existing software products and contribute towards improving it.

Required Candidate profile

4 - 6years of experience in web and API development

4+ years experience with http://asp.net/MVC/C" target="_blank">ASP.NET/MVC/C#.

4+ years working with SQL Server (2012+).
Good Knowledge of scripting libraries like jQuery, Knockout, Angular JS