Oracle DBA

Greetings !!!

We are a 20-year old IT Services company from Kolkata working in India and abroad. We primarily work as SSP(Software Solutions Partner) and serve some of the leading business houses in the country in various software project implementations specially on  SAP and Oracle platform and also working on Govt & Semi Govt projects as outsourcing project partner all over PAN India.

Designation :  Senior Database Administrator/Lead

Company- TSG Global Services Pvt Ltd

Client -  (CMM 5 Level)

Position –Permanent

Job Location – Jhansi

Experience- Min 5 Years

Notice Period: Immediate To 30 Days

Accommodation @ Jhansi is free & Transportation will reimburse.

Career options:  https://www.unisoltsg.com/career.php">https://www.unisoltsg.com/career.php

Skills:

DBA should have:

• Excellent problem-solving and analytical skills
• Good communication, teamwork skills
• familiarity with the main data manipulation languages and the principles of database design the ability to work to tight deadlines under pressure
• Good organizational skills flexibility and adaptability
• The ability to create and maintain strong working relationships with colleagues and client business awareness and understanding of business requirements of IT 
• a willingness to keep up to date with developments in new technology
• a commitment to continuing professional development (CPD)
• an understanding of information legislation, such as the Data Protection Act.

Tools:

• MySQL, MSSQL, PostgreSQL, Oracle Database, DevOps, ESM Tools.(Any)
• Visual Studio Code (Optional)

• 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.

ORACLE DATABASE ADMINISTRATION

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.

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

Company Description

At Bungee Tech, we help retailers and brands meet customers everywhere and, on every occasion, they are in. We believe that accurate, high-quality data matched with compelling market insights empowers retailers and brands to keep their customers at the center of all innovation and value they are delivering. 

We provide a clear and complete omnichannel picture of their competitive landscape to retailers and brands. We collect billions of data points every day and multiple times in a day from publicly available sources. Using high-quality extraction, we uncover detailed information on products or services, which we automatically match, and then proactively track for price, promotion, and availability. Plus, anything we do not match helps to identify a new assortment opportunity.

Empowered with this unrivalled intelligence, we unlock compelling analytics and insights that once blended with verified partner data from trusted sources such as Nielsen, paints a complete, consolidated picture of the competitive landscape.

We are looking for a Big Data Engineer who will work on the collecting, storing, processing, and analyzing of huge sets of data. The primary focus will be on choosing optimal solutions to use for these purposes, then maintaining, implementing, and monitoring them.

You will also be responsible for integrating them with the architecture used in the company.

We're working on the future. If you are seeking an environment where you can drive innovation, If you want to apply state-of-the-art software technologies to solve real world problems, If you want the satisfaction of providing visible benefit to end-users in an iterative fast paced environment, this is your opportunity.

Responsibilities

As an experienced member of the team, in this role, you will:

• Contribute to evolving the technical direction of analytical Systems and play a critical role their design and development

• You will research, design and code, troubleshoot and support. What you create is also what you own.

• Develop the next generation of automation tools for monitoring and measuring data quality, with associated user interfaces.

• Be able to broaden your technical skills and work in an environment that thrives on creativity, efficient execution, and product innovation.

BASIC QUALIFICATIONS

• Bachelor’s degree or higher in an analytical area such as Computer Science, Physics, Mathematics, Statistics, Engineering or similar.
• 5+ years relevant professional experience in Data Engineering and Business Intelligence
• 5+ years in with Advanced SQL (analytical functions), ETL, Data Warehousing.
• Strong knowledge of data warehousing concepts, including data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools and environments, data structures, data modeling and performance tuning.
• Ability to effectively communicate with both business and technical teams.
• Excellent coding skills in Java, Python, C++, or equivalent object-oriented programming language
• Understanding of relational and non-relational databases and basic SQL
• Proficiency with at least one of these scripting languages: Perl / Python / Ruby / shell script

PREFERRED QUALIFICATIONS

• Experience with building data pipelines from application databases.
• Experience with AWS services - S3, Redshift, Spectrum, EMR, Glue, Athena, ELK etc.
• Experience working with Data Lakes.
• Experience providing technical leadership and mentor other engineers for the best practices on the data engineering space
• Sharp problem solving skills and ability to resolve ambiguous requirements
• Experience on working with Big Data
• Knowledge and experience on working with Hive and the Hadoop ecosystem
• Knowledge of Spark
• Experience working with Data Science teams

Preferred Education & Experience:

• Bachelor’s or master’s degree in Computer Engineering, Computer Science, Computer Applications, Mathematics, Statistics or related technical field or equivalent practical experience. Relevant experience of at least 3 years in lieu of above if from a different stream of education.

• Well-versed in and 5+ years of hands-on demonstrable experience with:
  ▪ Data Analysis & Data Modeling
  ▪ Database Design & Implementation
  ▪ Database Performance Tuning & Optimization
  ▪ PL/pgSQL & SQL

• 5+ years of hands-on development experience in Relational Database (PostgreSQL/SQL Server/Oracle).

• 5+ years of hands-on development experience in SQL, PL/PgSQL, including stored procedures, functions, triggers, and views.

• Hands-on experience with demonstrable working experience in Database Design Principles, SQL Query Optimization Techniques, Index Management, Integrity Checks, Statistics, and Isolation levels

• Hands-on experience with demonstrable working experience in Database Read & Write Performance Tuning & Optimization.

• Knowledge and Experience working in Domain Driven Design (DDD) Concepts, Object Oriented Programming System (OOPS) Concepts, Cloud Architecture Concepts, NoSQL Database Concepts are added values

• Knowledge and working experience in Oil & Gas, Financial, & Automotive Domains is a plus

• Hands-on development experience in one or more NoSQL data stores such as Cassandra, HBase, MongoDB, DynamoDB, Elastic Search, Neo4J, etc. a plus.