Oracle OPM Consultant

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.

Torrent Power is an Indian energy and power company, having interests in power generation, transmission, distribution and manufacturing and supply of power cables.

           Executive - SAP BASIS

• 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

About us

1. Innoviti (http://www.innoviti.com/">innoviti.com) is India’s largest provider of payment solutions to Enterprise merchants. 
2. Processing $10 Bn of payments from 2000 cities. We today have 76% of Enterprise market share. 
3. Enterprises such as Reliance, Landmark Group, Shoppers Stop, Pantaloons, Hamleys, Van Heusen, Louise Phillipe, Madura Garments and several other hundreds of Enterprises are our customers.
4. Our vision is to use technology to unlock the hidden value in payments, helping large and small businesses constantly find new and unique ways to grow faster with lesser efforts.
5. We believe payment transactions are more than money moving pipes.  Whenever a payment happens, it is not only the merchant who makes money, but also the brand whose product was sold and the bank whose payment instrument was used.  A merchant, brand, and bank talk to the same consumer, however there is no easy way for them to talk to each other.  Our technology makes this collaboration happen, and makes it happen at the point of payment. We help them share customers and share marketing budgets, in turn targeting customers better than possible otherwise. By making it happen at the point of payment we ensure for each party that their marketing efforts are translating into sales.
6. Today our technology has helped large businesses grow faster with lesser efforts.  They have been able to offer EMI, BNPL, Cashbacks, Loyalty Point redemption and other offers with merchants, brands and banks participating in it.  Every day new use cases are designed and stitched using our technology platform.
7. Our next target are small merchants.  For them, the problems are far larger and more complex.  They have no means to access the marketing budgets or customers of large brands or banks.  They cannot even cross the regional offices of these businesses.  This is where we come in.  We are bringing the power of the technology created for large merchants to these businesses.  Helping bring the power of large brands and banks with whom we already partner to small merchants.
8. Innoviti’s first target category in this segment is small merchants selling electronic goods – mobiles, durables, laptops etc.  They are struggling the most as their customers find attractive offers online through partner brands and banks, which they can’t match in their stores.  These businesses offer the advantage of touch, feel and explanation in local language.  What they lack is the technology to discover, access customers and attract them with superior offers.
9. GENIE, our smart marketing platform helps them do that.  It is a mobile app that integrates with bank and brands on one end and Google and Facebook on the other.  It not only helps them discover and access customers searching for these products online, but also attract them to their stores with offers better than online.
10. The app was launched in July 2021 and has shown a 100% month-on-month growth, with more than 23% of the merchant’s monthly sales now happening through it.  
11. In the next 5 years Innoviti wants to scale up its GTV from $10Bn to $30Bn, multiplying its revenue 10X.  
12. We want to be recognized in this space as the company that transformed the payments industry by showing ways of extracting value from payment transactions better than anyone else.  We want to be setting the path for the next generation of payment solutions, that will be followed by others.
13. Towards this we need to hire aggressive talented individuals, who firmly believe that no problem is unsolvable.  That there is always a way to solve the toughest of problems.  Those who get excited by solving such tough problems at scale, and seeing the impact of that around them in the market.  Those who feel fulfilled when they see that it is making a difference to the lives of people around them.

 

To drive this roadmap the company is looking for talent who are ready to do what no payments platform has done before and what every payment platform will do thereafter.

 

Would you like to join this journey?

 

 

 

 

 

 

 

Job description:

 

Designation:  Database Administrator

 

Location:  Bangalore

 

Responsibilities

• Provision MySQL instances, both in clustered and non-clustered configurations
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary
• Collaborate with other team members and stakeholders

Skills and Qualification:

• Graduate degree in Computer Science, Computer Engineering, or related technical discipline from Tier-1 Institutes

• 4-6 years of proven experience in Database Administration
• Decent experience with recent versions of MySQL
• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
• Experience with replication configuration in MySQL
• Knowledge of de-facto standards and best practices in MySQL
• Proficient in writing and optimizing SQL statements
• Knowledge of MySQL features, such as its event scheduler
• Ability to plan resource requirements from high level specifications
• Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. 
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases

Personality:

The ideal person for this role would be someone who loves the challenge of an entrepreneurial environment, who has high ownership to be available 24x7 for our customers, who is able to deal with complexity and rapid change and who has large dreams to be part of interesting journey.

 

The person would be self-driven, results-oriented with a positive outlook and impeccable integrity. He/she would have a track record of delivering results consistently in uncertain environments. Excellent communication skills with an ability to manage crucial conversations with senior stakeholders.

 

Retail industry demands “I’ll do it now instead of tomorrow” attitude. Please be prepared for interesting journey if you want to grow fast with no age barriers.

 

The role and responsibilities of Oracle or PL/SQL Developer and Database Administrator:
• Working Knowledge of XML, JSON, Shell and other DBMS scripts
• Hands on Experience on Oracle 11G,12c. Working knowledge of Oracle 18 and 19c
• Analysis, design, coding, testing, debugging and documentation. Complete knowledge of
Software Development Life Cycle (SDLC).
• Writing Complex Queries, stored procedures, functions and packages
• Knowledge of REST Services, UTL functions, DBMS functions and data integration is required
• Good knowledge on table level partitions, row locks and experience in OLTP.
• Should be aware about ETL tools, Data Migration, Data Mapping functionalities
• Understand the business requirement, transform/design the same into business solutions.
Perform data modelling and implement the business rules using Oracle database objects.
• Define source to target data mapping and data transformation logic as per the business
need.
• Should have worked on Materialised views creation and maintenance. Experience in
Performance tuning, impact analysis required
• Monitoring and optimizing the performance of the database. Planning for backup and
recovery of database information. Maintaining archived data. Backing up and restoring
databases.
• Hands on Experience on SQL Developer

We are an early stage start-up, building new fintech products for small businesses. Founders are IIT-IIM alumni, with prior experience across management consulting, venture capital and fintech startups. We are driven by the vision to empower small business owners with technology and dramatically improve their access to financial services. To start with, we are building a simple, yet powerful solution to address a deep pain point for these owners: cash flow management. Over time, we will also add digital banking and 1-click financing to our suite of offerings.

 

We have developed an MVP which is being tested in the market. We have closed our seed funding from marquee global investors and are now actively building a world class tech team. We are a young, passionate team with a strong grip on this space and are looking to on-board enthusiastic, entrepreneurial individuals to partner with us in this exciting journey. We offer a high degree of autonomy, a collaborative fast-paced work environment and most importantly, a chance to create unparalleled impact using technology.

 

Reach out if you want to get in on the ground floor of something which can turbocharge SME banking in India!

 

Technology stack at Velocity comprises a wide variety of cutting edge technologies like, NodeJS, Ruby on Rails, Reactive Programming,, Kubernetes, AWS, NodeJS, Python, ReactJS, Redux (Saga) Redis, Lambda etc. 

 

Key Responsibilities

• Responsible for building data and analytical engineering pipelines with standard ELT patterns, implementing data compaction pipelines, data modelling and overseeing overall data quality

• Work with the Office of the CTO as an active member of our architecture guild

• Writing pipelines to consume the data from multiple sources

• Writing a data transformation layer using DBT to transform millions of data into data warehouses.

• Implement Data warehouse entities with common re-usable data model designs with automation and data quality capabilities

• Identify downstream implications of data loads/migration (e.g., data quality, regulatory)

 

What To Bring

• 5+ years of software development experience, a startup experience is a plus.

• Past experience of working with Airflow and DBT is preferred

• 5+ years of experience working in any backend programming language. 

• Strong first-hand experience with data pipelines and relational databases such as Oracle, Postgres, SQL Server or MySQL

• Experience with DevOps tools (GitHub, Travis CI, and JIRA) and methodologies (Lean, Agile, Scrum, Test Driven Development)

• Experienced with the formulation of ideas; building proof-of-concept (POC) and converting them to production-ready projects

• Experience building and deploying applications on on-premise and AWS or Google Cloud cloud-based infrastructure

• Basic understanding of Kubernetes & docker is a must.

• Experience in data processing (ETL, ELT) and/or cloud-based platforms

• Working proficiency and communication skills in verbal and written English.

 

Looking Data Enginner for our Own organization-

Notice Period- 15-30 days
CTC- upto 15 lpa

 

Preferred Technical Expertise 

1. Expertise in Python programming.
2. Proficient in Pandas/Numpy Libraries. 
3. Experience with Django framework and API Development.
4. Proficient in writing complex queries using SQL
5. Hands on experience with Apache Airflow.
6. Experience with source code versioning tools such as GIT, Bitbucket etc.

 Good to have Skills:

1. Create and maintain Optimal Data Pipeline Architecture
2. Experienced in handling large structured data.
3. Demonstrated ability in solutions covering data ingestion, data cleansing, ETL, Data mart creation and exposing data for consumers.
4. Experience with any cloud platform (GCP is a plus)
5. Experience with JQuery, HTML, Javascript, CSS is a plus.

If Intersted , Kindly share Your CV

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.