Database Administrator 2
Epsilon
Bangalore, Karnataka, IN
2d ago

About BU

Seeking a highly motivated and well-rounded Oracle DBA with a strong development background to be part of a fast-paced production support and full-lifecycle implementation team.

Candidate is expected to be familiar with database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL / SQL programming, backup & recovery concepts, and database performance and tuning.

Candidate must have good analytical, verbal, and written skills.

Why we are looking for you

Seeking a highly motivated and well-rounded Senior Oracle DBA with a strong development background to be part of a fast-paced production support and full-lifecycle implementation team.

What will you enjoy in this role

Epsilon is seeking a Senior Database Administrator with a balance of skills in design, physical implementation, and performance tuning to work out of our Bengaluru, India location supporting Cloud Data Warehouses and Data Warehouse appliances powering solutions for Epsilon Marketing clients.

What you will enjoy in this role

What will you do

  • faImplement, configure, and manage Data Warehouses at AWS using Amazon Redshift and Amazon EMR.
  • Support and manage IBM Netezza and IIAS (IBM Integrated Analytics System) Data Warehouse appliances on premises.
  • Monitor and report on performance metrics, system health, and logging compliance on the managed Data Warehouses.
  • Perform database administration tasks including backup and recovery, troubleshooting, performance tuning and SQL optimization.

    Duties and Responsibilities :

  • Implement, configure, and manage Data Warehouses at AWS using Amazon Redshift and Amazon EMR.
  • Support and manage IBM Netezza and IIAS (IBM Integrated Analytics System) Data Warehouse appliances on premises.
  • Monitor and report on performance metrics, system health, and logging compliance on the managed Data Warehouses.
  • Perform database administration tasks including backup and recovery, troubleshooting, performance tuning and SQL optimization.
  • Contribute to design of database schemas, tune data types and data distribution for performance optimization.
  • Configure and implement workload management for resource allocation and query event handling.
  • Monitor and proactively remediate Amazon EMR HBase hbck inconsistencies.
  • Consult Product Engineering on the best practices to automate cloud services provisioning and default settings related to performance and security.
  • Support internal and client users, troubleshoot data access applications and ad hoc SQL queries.
  • Closely work with account teams to ensure that system availability, performance, and user support timeliness meet customer SLAs.
  • Develop and support shell scripts for database activities, such as data loading, unloading, and maintenance.
  • Manage data replication, data encryption, backup storage and archiving procedures.
  • Follow Database and Hadoop standards and best practices for availability, security, backup and recovery, and integrity of client solutions.
  • Evaluate new Database and Big Data technologies and products and recommend to technical management
  • Contribute to documenting company Database and Big Data standards, guidelines, and operational procedures.
  • Perform a variety of tasks relying on experience and judgment to manage time, plan and accomplish goals on several client engagements concurrently.
  • Interact with vendor support to ensure that defects found in the supported Data Warehouse products or services are timely resolved
  • Provide 24 x 7 x 365 support through on-call rotation
  • Qualifications

  • 5+ years of Information Technology experience with a DBA background
  • 2+ years of experience working with cloud technologies (AWS preferred)
  • Working knowledge of Hadoop eco system components, such as YARN, MapReduce, HDFS, Hive, Zookeeper, and Spark
  • Experience in administrating, troubleshooting and tuning Apache HBase
  • Knowledge of Amazon Redshift, Amazon EMR or Snowflake is a plus
  • Familiarity with Data Warehouse appliances such as Netezza, Greenplum, ParAccel, Teradata or similar is a plus
  • Ability to diagnose problems and resolve issues across various tiers (application, database, server, network, and storage)
  • Proficiency in replication, backup and recovery methodologies and techniques
  • Ability to write and analyze complex SQL queries for performance
  • Strong Unix / Linux and shell scripting
  • Adherence to SDLC, Change Management, troubleshooting and development methodologies
  • Ability to perform work with minimal supervisory direction
  • Excellent written and verbal communication skills
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form