11+ Oracle Enterprise Manager Ops Center Jobs in India

• Bring in industry best practices around creating and maintaining robust data pipelines for complex data projects with/without AI component
  • programmatically ingesting data from several static and real-time sources (incl. web scraping)
  • rendering results through dynamic interfaces incl. web / mobile / dashboard with the ability to log usage and granular user feedbacks
  • performance tuning and optimal implementation of complex Python scripts (using SPARK), SQL (using stored procedures, HIVE), and NoSQL queries in a production environment

• Industrialize ML / DL solutions and deploy and manage production services; proactively handle data issues arising on live apps
• Perform ETL on large and complex datasets for AI applications - work closely with data scientists on performance optimization of large-scale ML/DL model training
• Build data tools to facilitate fast data cleaning and statistical analysis
• Ensure data architecture is secure and compliant
• Resolve issues escalated from Business and Functional areas on data quality, accuracy, and availability
• Work closely with APAC CDO and coordinate with a fully decentralized team across different locations in APAC and global HQ (Paris).

•  Expert in structured and unstructured data in traditional and Big data environments – Oracle / SQLserver, MongoDB, Hive / Pig, BigQuery, and Spark
• Have excellent knowledge of Python programming both in traditional and distributed models (PySpark)
• Expert in shell scripting and writing schedulers
• Hands-on experience with Cloud - deploying complex data solutions in hybrid cloud / on-premise environment both for data extraction/storage and computation
• Hands-on experience in deploying production apps using large volumes of data with state-of-the-art technologies like Dockers, Kubernetes, and Kafka
• Strong knowledge of data security best practices
• 5+ years experience in a data engineering role
• Science / Engineering graduate from a Tier-1 university in the country
• And most importantly, you must be a passionate coder who really cares about building apps that can help people do things better, smarter, and faster even when they sleep

Job Description

Job Responsibilities

• Design and implement robust database solutions including

  • Security, backup and recovery

  • Performance, scalability, monitoring and tuning,

  • Data management and capacity planning,

  • Planning, and implementing failover between database instances.

• Create data architecture strategies for each subject area of the enterprise data model.

• Communicate plans, status and issues to higher management levels.

• Collaborate with the business, architects and other IT organizations to plan a data strategy, sharing important information related to database concerns and constrains

• Produce all project data architecture deliverables..

• Create and maintain a corporate repository of all data architecture artifacts.

Skills Required:

• Understanding of data analysis, business principles, and operations

• Software architecture and design Network design and implementation

• Data visualization, data migration and data modelling

• Relational database management systems

• DBMS software, including SQL Server  

• Database and cloud computing design, architectures and data lakes

• Information management and data processing on multiple platforms 

• Agile methodologies and enterprise resource planning implementation

• Demonstrate database technical functionality, such as performance tuning, backup and recovery, monitoring.

• Excellent skills with advanced features such as database encryption, replication, partitioning, etc.

• Strong problem solving, organizational and communication skill.

• Required Skill - Operating systems & Tools (SUSE Linux 1 IBM AIX 1 IBM Spectrum i.e. IBM Tivoli)
  • Should be experienced in administration of SUSE Linux, IBM AIX operating systems Have hands-on experience in managing & troubleshooting IBM Tivoli (Spectrum Protect) backup utility with SAP HANA & Sybase DB environment.
  • Monitor status of BACKUPs, perform need based restore when require.
  • Report & coordinate with team lead for incident management process. Take corrective actions for incidents related to OS & backup related issues.
• Desirable Skills - SAP NetWeaver BASIS Administration
• SAP user management for ABAP & Java stacks, Business Objects, Central User Management, etc.
• Maintain Roles and Authorization using PFCG
• SAP Transport Management using ST MS and ChaRMs
• Knowhow of using SAP Solution Manager for MoPZ, ITSM, CHARMS, CUA, EWA, System Monitoring and Technical Administration
• BASIS administration (monitoring & maintenance) of SAP systems at Primary & DR-sitesMonitor & Troubleshoot the performance of SAP systems, Troubleshoot issues and follow-up with End Users and Development team to resolve the issues.
• Data Volume Management activities like index quality analysis and rebuilding.
• Monitoring & control database growth and perform DBA operations as required. Monitor status of database archive logs for smooth operation of SAP systems.

Desirable Skills - Database Administration (HANA I Sybase I Oracle) Manage and maintain database for SAP and Non-SAP applications/systems Monitor, administer the database and troubleshoot database related issues.

Role and responsibilities

·      Collect requirements, design, develop and test software code.

·      Fix bugs and provide production support.

·      Prioritize multiple tasks and manage time effectively.

·      Learn new technologies outside his/her primary skills.

·      Develop solutions to challenging problems.

·      Effectively communicate with team members, project managers and clients, as required.

Technical skills requirements

The candidate must demonstrate proficiency in,

·      SQL, PL-SQL & RICE Components.

·      Develop applications, reports and interfaces using standard Oracle development methodologies.

·      BI Publisher, RDF/XML & Discoverer Reports.

·      Form Personalizations.

·      Unit test the reports with standard E-Business suite application.

·      Performance Tuning & Optimization.

·      Table-level technical knowledge of OM, Inventory Management, Purchasing, GL, AR, AP, and FA.

·      SQL Developer, TOAD, SQL Loader

Nice-to-have skills

·         SQL Tuning

·         EBS Finance/SCM functional knowledge

·         Performance Improvements and External Integrations

·         Ability to develop applications and modules keeping scalability and performance in mind.

HIRING SQL Developers with max 20 days Of NOTICE PERIOD

Job ID: TNS2023DB01

Who Should apply?

• Only for Serious job seekers who are ready to work in night shift
• Technically Strong Candidates who are willing to take up challenging roles and want to raise their Career graph
• No DBAs & BI Developers, please

• Exposure to the latest technology
• Opportunity to work on different platforms
• Rapid Career Growth
• Friendly Knowledge-Sharing Environment

• BE/MTech/MCA/MSc
• 2yrs Hands Experience in MS SQL / NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 20 days
• Candidates will be selected based on logical/technical and scenario-based testing
• Work time - 10:00 pm to 6:00 am

Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible.

1. Technical Skills Desired:
   1. Experience in MS SQL Server, and one of these Relational DB’s, PostgreSQL / AWS Aurora DB / MySQL / any of NoSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch
   2. Design database tables, views, indexes
   3. Write functions and procedures for Middle Tier Development Team
   4. Work with any front-end developers in completing the database modules end to end (hands-on experience in the parsing of JSON & XML in Stored Procedures would be an added advantage).
   5. Query Optimization for performance improvement
   6. Design & develop SSIS Packages or any other Transformation tools for ETL

1. Functional Skills Desired:
   1. The banking / Insurance / Retail domain would be a
   2. Interaction with a client a

1. Knowledge in a Cloud Platform (AWS / Azure)
2. Knowledge on version control system (SVN / Git)
3. Exposure to Quality and Process Management
4. Knowledge in Agile Methodology

1. Soft skills: (additional)
   1. Team building (attitude to train, work along, and mentor juniors)
   2. Communication skills (all kinds)
   3. Quality consciousness
   4. Analytical acumen to all business requirements
   5. Think out-of-box for business solution

• Experience implementing large-scale ETL processes using Informatica PowerCenter.
• Design high-level ETL process and data flow from the source system to target databases.
• Strong experience with Oracle databases and strong SQL.
• Develop & unit test Informatica ETL processes for optimal performance utilizing best practices.
• Performance tune Informatica ETL mappings and report queries.
• Develop database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Hands-on Experience in Unix.
• Experience in Informatica Cloud (IICS).
• Work with appropriate leads and review high-level ETL design, source to target data mapping document, and be the point of contact for any ETL-related questions.
• Good understanding of project life cycle, especially tasks within the ETL phase.
• Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment.
• Excellent communication and presentation skills.
• Effectively worked on the Onsite and Offshore work model.

We are looking for a Senior Database Developer to provide a senior-level contribution to design, develop and implement critical business enterprise applications for marketing systems 

1. Play a lead role in developing, deploying and managing our databases (Oracle, My SQL and Mongo) on Public Clouds.
2. Design and develop PL/SQL processes to perform complex ETL processes. 
3. Develop UNIX and Perl scripts for data auditing and automation. 
4. Responsible for database builds and change requests.
5. Holistically define the overall reference architecture and manage its overall implementation in the production systems.
6. Identify architecture gaps that can improve availability, performance and security for both productions systems and database systems and works towards resolving those issues.
7. Work closely with Engineering, Architecture, Business and Operations teams to provide necessary and continuous feedback.

1. Automate all the manual steps for the database platform.
2. Deliver solutions for access management, availability, security, replication and patching.
3. Troubleshoot application database performance issues.
4. Participate in daily huddles (30 min.) to collaborate with onshore and offshore teams.

Qualifications: 

1. 5+ years of experience in database development.
2. Bachelor’s degree in Computer Science, Computer Engineering, Math, or similar.
3. Experience using ETL tools (Talend or Ab Initio a plus).
4. Experience with relational database programming, processing and tuning (Oracle, PL/SQL, My SQL, MS SQL Server, SQL, TSQL).
5. Familiarity with BI tools (Cognos, Tableau, etc.).
6. Experience with Cloud technology (AWS, etc.).
7. Agile or Waterfall methodology experience preferred.
8. Experience with API integration.
9. Advanced software development and scripting skills for use in automation and interfacing with databases.
10. Knowledge of software development lifecycles and methodologies.
11. Knowledge of developing procedures, packages and functions in a DW environment.
12. Knowledge of UNIX, Linux and Service Oriented Architecture (SOA).
13. Ability to multi-task, to work under pressure, and think analytically.
14. Ability to work with minimal supervision and meet deadlines.
15. Ability to write technical specifications and documents.
16. Ability to communicate effectively with individuals at all levels in the company and with various business contacts outside of the company in an articulate, professional manner.
17. Knowledge of CDP, CRM, MDM and Business Intelligence is a plus.
18. Flexible work hours.

This position description is intended to describe the duties most frequently performed by an individual in this position. It is not intended to be a complete list of assigned duties but to describe a position level.