Senior Engineer Database - Hadoop

Employer
AbbVie
Location
Lake County, IL, US
Posted
Sep 13, 2019
Ref
1905951
Required Education
Bachelors Degree
Position Type
Full time
The database administration function provides in-depth technical expertise of data storage systems, including Hadoop and technical support of DBMS software. The engineer m anages the administration of the organization's Hadoop Clusters in the traditional Bare Metal and Cloud hosting environments. Responsible for designing, securing, and maintaining the data structures used to store data for computer systems. Responsible for the backup and recovery of corporate data. Provides technical support for data extraction, transformation, and load (ETL) tools, which are used to extract data from various database technologies, manipulate the data, and load to a new database environment. Performs database administration activities such as modifications, enhancements, expansions, and capacity planning. Provides technical support and assistance to Systems analysts and Sr. Systems Analysts in the design and tuning of computer applications. Provides technical expertise related to the ongoing maintenance and support of the data storage software.

Key Responsibilities Include:
  • Analyzes the organization's needs and develops a long-term strategy for data storage.
  • Establishes policies and procedures related to data security and integrity and monitors and limits database access as needed.
  • Oversees the design, maintenance and implementation of the systems that manage an internal database.
  • Familiar with a variety of the field's concepts, practices, and procedures. Performs a variety of tasks. Leads and directs the work of others. A wide degree of creativity and latitude is expected
  • Provides guidance in database administration activities to less experienced DBAs.
  • Responsible for compliance with applicable Corporate and Divisional Policies and procedures.
  • Review, validate and enhance logical database designs. Define and implement physical databases.
  • Perform database administration activities (e.g., modifications, enhancements, expansions).
  • Conducts production database performance monitoring and capacity planning. Install, test and upgrade database releases and associated products.
  • Diagnoses database-related issues (e.g., database outages, application performance).
  • Lead the development of database standards and procedures. Evaluate and recommend new database software, utilities, and tools.
  • Daily interaction with clients on divisional and enterprise wide projects and peer resources in other technical support organizations (e.g. hardware, storage, etc.).


Basic:

  • Bachelor's degree with at least 5 years of experience in the field. 3 years of professional experience working with Hadoop stack, preferably with Cloudera CDH.
  • Experience with Hive, Impala, Kerberos, Ranger/Sentry, HDFS ACLs
  • Fluency in other DBMS software such as Oracle or SQL Server with the ability to pick up new data storage technologies quickly.