Database Administrator

Apply now »

Date: Sep 19, 2022

Location: FL, US

Company: ArisGlobal

ArisGlobal is a dynamic and growing global software company dedicated to serving the Life Sciences industry (pharmaceutical, biotechnology and medical device) in the management of their clinical trials, drug safety and regulatory information.  Our global team – located in major corners of the world – includes some of the industry’s leading authorities, subject matter experts and experienced professionals in their respective areas of life sciences. All are focused on advancing our innovative and market-proven solutions and services.  We are growing quickly and looking for people with the best blend of experience, knowledge, talent and ambition to join our team. If you are committed to making a difference and have the skills and experience to make things happen then you should consider joining ArisGlobal.

GENERAL SUMMARY

The Database Engineer is a crucial role that is responsible for the administration, operation and performance of ArisGlobal databases supporting mission-critical applications.

ESSENTIAL DUTIES AND RESPONSIBILITIES

  • Responsible for implementing, managing, and tuning databases for 24x7 high availability
  • Perform database installations, configurations, upgrades, and migrations.
  • Define and implement database schema and configurations with development teams.
  • Database Administration (Oracle, PostgreSQL, MySQL, MongoDB)
    • AWS Data Migration Services, AWS Schema Conversion Tool
    • Homogeneous and Heterogeneous Database Migrations
    • Database Consolidation, Continuous Data Replication.
  • Develop, manage, and test backup & recovery strategies, verifying data integrity.
  • Implement automation to improve process efficiency and risk compliance
  • Proactively review database performance and capacity trends
  • Manage high severity database issues with cross functional
  • Perform root cause analysis on DB incidents, performance tuning and major outages
  • Review consistently on the usage of database inventory on-going basis and work on consolidation, migration and deletion of assets associated and ensure savings to IT spend
  • Perform review of schema, stored procedures, and other changes to the database DDL.
  • Audit for data integrity and consistency across systems.
  • Help maintain and execute disaster recovery plans
  • Work in an on-call rotation and available after business hours

 

EXPERIENCE REQUIRED

Experience:

  • 5+ years as Oracle DBA
  • 5+ years as PostgreSQL DBA
  • Experienced in migration projects, especially Oracle to PostgreSQL
  • In-depth understanding of relational and dimensional database theory and concepts.
  • Significant practical hands-on experience with database administration, backup and recovery, performance tuning and high-availability solutions.
  • Detailed understanding of PostgreSQL database server architecture, concepts, features, and high-availability technologies.
  • Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization
  • Experience with database replication, hot stand-by, clustering, and table partitioning.
  • Linux platform familiarity, system resource monitoring and tuning.
  • High-level of proficiency with PostgreSQL in a Linux environment
  • Previous experience with MongoDB, DynamoDB, and Redis a plus.
  • Previous experience with PostgreSQL in the cloud, including Amazon RDS is a plus.
  • Ability to handle stressful problems and solve complex problems under pressure
  • Ability to communicate effectively with others, both in oral and written communication
  • Excellent planning, problem solving, organization and project management skills

COMPENSATION & BENEFITS

ArisGlobal proudly offers an impressive package of compensation and benefits, including a competitive salary, sales commissions, paid time off, and healthcare and retirement benefits.