• Save Job
  • 4 - 6 Years
  • Posted : above 1 month

Job Description:

Senior Consultant

Date Opened Aug 27, 2019

Company Allstate Insurance Company

Allstate is looking for accomplished database administrators to support an ever-changing landscape of applications Think that working in the insurance field cant be exciting, rewarding and challenging Think again Youll help us reinvent protection and retirement to improve customers lives Well help you make an impact with our training and mentoring offerings Here, youll have the opportunity to expand and apply your skills in ways you never thought possible And youll have fun doing it Join a company of individuals with hopes, plans and passions, all using and developing our talents for good, at work and in life Additional responsibilities include strategy and design of complex projects, support of project planning and peer mentoring

Effective written and verbal communication is important as you will be interfacing with many different areas including business clients, technology, architecture, and infrastructure services

You will provide Oracle DBA support for various Oracle databases You will perform database structure and software maintenance and implementations You will also support database basic tuning and consultation, assist with database configuration implementation, scripts creation and test plans execution You will participate in incident, change and problem management activities

Job Responsibilities

Essential criteria

4-6 or more years Oracle database experiences
Strong communication, collaboration, and problem-solving skills
Basic understanding of server/storage/network for the Unix/Oracle platform
Programming and/or scripting skills
Ability to analyze and solve problems in a creative and innovative fashion
Ability to engage subject matter experts and translate business goals into actionable solutions
Ability to meet deadlines, goals, and objectives
Passion for working collaboratively with multiple areas
A Global team player with positive attitude

Preferred Qualification

Knowledge in an additional DBMS is a plus

Skills and Responsibilities

Data definition language(DDL), data manipulation language (DML) and data control language (DCL) for Oracle
Database Logical design & Physical design
Oracle RDBMS performance & tuning
Query tuning
Database monitoring and alerting
Improve database availability and uptime by ensuring the appropriate monitoring and alerting configurations are in place
Database Backup, Restore and Recoveries
Improve database recoverability time by creating, maintaining and updating recovery and restore processes
Capacity Management
Knowledge in security measures to safeguard database integrity
Coordinates and implements security measures to safeguard information in database environment against accidental or unauthorized damage, modification or disclosure
Performs database related tasks associated to database server upgrades, expansions, security and/or automation and operational efficiency projects
Performs software installation, database creation, configurations, migrations and upgrades
Follows company specific procedures and Change Control processes when making all changes in customers environment
Provides guidance to customers on database related questions
Tests databases and performs the necessary modifications (including patches) to remedy issues
Works closely with developers on supported applications to build and maintain synergies
Current practical experience with debugging and trouble-shooting experience
Keeps informed of latest industry news, trends, products, services, competitors and relevant existing and emerging technologies
Able to take on-call rotation
Oracle 11g, 12C, RAC, RMAN, DataPump, Grid Control, ASM, CRS, AWR, SPM, DataGuard, Streams, GoldenGate, SQL, PL/SQL, Unix/Linux, Shell Scripting; SQLServer and Veridata knowledge will be a plus
Support product development teams in an Agile methodology
Task automation and other development

Primary Skills

Oracle DBA


4-6 years

Shift Timing

24 x7 rotating shift 830 shift

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Financial Services/Stockbroking, Banking
Functional Area : IT Software : Software Products & Services
Role : Software Engineer
Salary : As per Industry Standards
Deadline : 22nd Jul 2020

Key Skills:

These are some of our most popular tutorials

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status