Search Jobs

Oracle DBA

This requirement is valid till 25-05-2019

Required Skills:

  Oracle DBA
Location:  Bangalore
Domain:  Engineering Automobile & Manufacturing
Qualification:  Any Degree
Experience:  3-5 yrs.
Job Description with Roles & Responsibilities: 
• Overall database technical responsibilities, also encompassing the integration of add-on commercial database products suites.
• Customization, maintenance and support under 24x7 rigorous operational conditions
• Close integration work with various development teams for supporting and promoting products, features, and releases
• Contribution to continuous improvement of the deployment process.
• Identifying areas for automation.
• Driving expansion of fully automated deployment services.
• Setting up and maintain documentation and standards.
• Problem determination & debugging
• Diagnostic and tuning strategy for demanding OLTP applications, including SQL optimization
• Planning, scheduling and securing database backups
• Evaluation of new products and technologies
• Architecture of databases
• Project management and/or team core-member representation
• On-call roaster participation
• Mentorship and tutoring for newcomers and/or junior team members
Skillset: 
"A database administrator (DBA) is responsible for the performance, integrity and security of a database. Additional role requirements include planning, system development and troubleshooting."

• Expert core technology skills with hands-on exposure on latest or mainstream engine versions and features (2 RDBMS at least, Oracle and MySQL)
• Knowledge of new data store technologies (NoSQL), MongoDB, Hadoop, Couchbase, is a plus.
• Extensive field experience in supporting critical production HA workloads
• Expert HW, OS, and SAN infrastructure knowledge
• Proficiency in scripting capabilities (i.e. shell, perl, python)
• Knowledge of automation frameworks and group development tools, i.e.: Ansible, Puppet, GIT, Stash, SVN, BladeLogic.
• Extensive familiarity with Tuning tools (i.e. OEM's, SQL analyzer, Statspack, AWR, TOAD, else).
For SQL tuning using "Explain plan", "TKPROF", "SQL_TRACE", Optimizer modes, using Optimizer hints, Gathering statistics etc.
• Proficiency with RDBMS memory architecture and associated tuning techniques
• Expertise in SQL and RDBMS programming language extensions
• Hands on experience in database backups and Recovery strategies
• Successfully implemented Dataguard standby databases and/or other replication techniques
• Proficiency in creating database clones for test and training purposes
• Installation, Configuration and deployment of concurrent HA paradigms including exposition to multi-node installations and related load balancing solutions
( i.e. Oracle and RAC on different nodes with ASM)
• Experience in IaaS, PaaS environments
• Advanced Linux (RedHat and Suse) expertise.
• Good understanding of Business Process Management concepts and tools.
• Excellent analytical and problem solving skills
• Strong personality with good communication and consulting skills and experience in multinational environment
• Strong skills in technical project work and project management (extended to cross organizational projects)
• Ability to work independently
• Proactive minded in mitigating/avoiding foreseeable issues
• Knowledge of Amadeus products and service portfolio
• Ability to develop, initiate and execute training
• Perfect English verbal and written communication

 

Login to Apply