Senior Engineer Database - Hadoop (Rockford)


: $91,730.00 - $131,820.00 /year *

Employment Type

: Full-Time


: Information Technology

The database administration function provides in-depth technical expertise of data storage systems, including Hadoop and technical support of DBMS software. The engineer manages the administration of the organization'sHadoopClusters 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 withHadoopstack, 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.

  • Additional Information
  • AbbVie is an Equal Employment Opportunity employer: gender identity or expression, sexual orientation, marital status, protected veteran status, or any other legally protected characteristic., we do not discriminate on the basis of race, color, religion, national origin, age, sex (including pregnancy), physical or mental disability, medical condition, genetic information, At AbbVie, we value bringing together individuals from diverse backgrounds to develop new and innovative solutions for patients. As an equal opportunity employer
  • Significant Work Activities and Conditions: Continuous sitting for prolonged periods (more than 2 consecutive hours in an 8 hour day)
  • Travel: No
  • Job Type: Experienced
  • Schedule: Full-time

  • Associated topics: data engineer, data manager, data quality, data warehouse, data warehousing, database, erp, mongo database, mongo database administrator, sybase * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

    Launch your career - Create your profile now!

    Create your Profile

    Loading some great jobs for you...