Database Administrator - Bengaluru, India - Siemens

Siemens
Siemens
Verified Company
Bengaluru, India

2 weeks ago

Deepika Kaur

Posted by:

Deepika Kaur

beBee Recuiter
Description

Database Administrator

Siemens founded the new business unit Siemens Advanta (formerly known as Siemens IoT Services) on April 1, 2019, with its headquarter in Munich, Germany.

It has been crafted to unlock the digital future of its clients by offering end-to-end support on their outstanding digitalization journey.

Siemens Advanta is a strategic advisor and a trusted implementation partner in digital transformation and industrial IoT with a global network of more than 8000 employees in 10 countries and 21 offices.

Highly skilled and experienced specialists offer services which range from consulting to craft & prototyping to solution & implementation and operation - everything out of one hand

Before our software developers write even a single line of code, they must understand what drives our customers.

What is the environment? What is the user story based on? Implementation means - trying, testing, and improving outcomes until a final solution emerges.

Knowledge means exchange - discussions with colleagues from all over the world. Join our Digitalization Technology and Services (DTS) team based in Bangalore and enjoy the freedom to think in completely new categories


This is your role. What part will you play?

  • Responsible for Database Tuning, Query Tuning, Schema changes, Data pump, Rebuild, reorg activities.
  • Maintaining and managing Procedure/ Packages.
  • Database operations (running scripts, Database scripting (stored procedures, triggers, scheduled tasks)
  • User management, Wallet creation, managing privileges and roles as required
  • Capacity management.
  • Gathering table, schema and index stats collection and rebuilding indexes.
  • Database cloning, backup and restoration process
  • Housekeeping for tablespaces, data files, backups.
  • A drive towards automating repetitive tasks (e.g., scripting via Bash, Python, Ruby, etc)
  • Creation and managing of database links as per the requirements
  • Support development team with additional testing (e.g. version upgrades, patching) and troubleshooting
  • Coordinate activities with data center team, Execute emergency drills for database operations
  • Escalate problems to software supplier(s), managing incidents


  • Root Cause Analysis

  • Experience diagnosing operational issues and determining root cause including any tools for analysis
  • Investigate problems associated with the Database performance.
  • Tuning of Oracle database systems. Tools included are AWR reports ADDM
  • Participate in rolling on call duty support for entire services (approx. 4 times per year, 1 week each)
  • Good experience working on DevOps tools like Jenkins, GIT, OpenShift
  • Selfdriven and problemoriented
  • Build and manage database jobs in Jenkins
  • Experience in Tools like Toad / PL SQL developer / SQL developer.
We don't need superheroes, just super minds

  • Experience: 8 years
  • Must have Experience: 6 plus Years in Oracle DB Admin experienced, Oracle Versions 12.2, 19c and Linux operating system expert, Jenkins, GIT, OpenShift,Shell scripting, Nagios basic, SQL/ PLSQL.
  • Data Warehousing Knowhow
  • Object Oriented Analysis and Design
  • Basic JAVA Programming Skills
  • Knowledge of Web services
  • Experience with ETL processes and tools
  • German Language Skills will be added advantage
  • Domain Knowledge of EDI will be added advantage
  • Conversant with agile software development processes / methodologies and exposure in working with multisite global teams.
  • Good exposure to business domains and ability and knowledge to connect business needs with database deliverables

What else do I need to know?

  • Oracle database
  • RAC
  • DB refresh
  • DB Point in time recovery, RMAN
  • Jenkins / Jenkins Pipelines
  • Data guard
  • Linux / basic shell scripting / Ansible
  • GIT
  • Tools: Nagios /Splunk, Putty
  • Service Now

Helpful Skills:


  • Cloud knowledge (AWS/Google cloud/Azure)
  • Groovy
  • Devops experience is added an advantage.
  • Database (MySQL / PostgreSQL)

We've got quite a lot to offer. How about you?


This role is in Bangalore, where you'll get the chance to work with teams impacting entire cities, countries - and the craft of things to come.


Organization:
Advanta


Company:
Siemens Technology and Services Private Limited


Experience Level:
Experienced Professional


Full / Part time:
Full-time
More jobs from Siemens
See all jobs of Siemens