ICONMA - Salt Lake City, UT

posted 3 months ago

Full-time
Salt Lake City, UT
Professional, Scientific, and Technical Services

About the position

As part of the Firm's Technology Services Operations Team, the Database Administrator will perform operational support activities that are critical to maintaining the integrity and performance of the database infrastructure. This role involves providing production support for a variety of database systems including Sybase Adaptive Server Enterprise, Sybase IQ, UDB DB2, Sybase Replication, UDB DB2 SQL Rep and Q Replication, Paraccel, Postgres, Hadoop, MSSQL, Mongo DB, and Oracle databases on a global scale. The Database Administrator will also be responsible for supporting specific hardware configurations such as Sun v240/440/4800/420r, Consumer Electronics company r610/710, and Client 385/585/480 Blades. The position requires the administration and maintenance of an existing local and global database infrastructure, which includes the implementation, operational support, and periodic upgrades of all database servers. Effective communication and coordination with application support and other IT support teams are essential to provide timely responses for critical requests. Daily monitoring of the database infrastructure for health checks, application alerts, and replication alerts is a key responsibility. The Database Administrator will also manage provisioning activities, user requests, and resolution alerts. In addition to these responsibilities, the role includes managing small project initiatives within the database team, which may involve datacenter migrations and the end-of-life processes for database software and hardware. The Database Administrator will also organize training sessions for the database team both locally and globally. Basic file system administration tasks, including expansion and device carving using native Red Hat Enterprise Linux 5/6 multipath utilities, will also be part of the job.

Responsibilities

  • Provide production support for various database systems including Sybase Adaptive Server Enterprise, Sybase IQ, UDB DB2, and others.
  • Administer and maintain local/global database infrastructure including implementation and operational support.
  • Communicate and coordinate with application support and IT support teams for critical requests.
  • Perform daily monitoring of database infrastructure for health checks and alerts.
  • Manage provisioning activities, user requests, and resolution alerts.
  • Oversee small project initiatives within the database team, including datacenter migrations.
  • Organize database training sessions for the team.
  • Perform basic file system administration tasks using Red Hat Enterprise Linux.

Requirements

  • Minimum 3+ years of experience in Database Administration or a related role.
  • Strong experience with UDB/DB2 database administration, maintenance, and implementation.
  • Extensive exposure to DB2 Replication including SQL Rep and Q replication.
  • Strong knowledge of DB2 HADR (High Availability Disaster Recovery).
  • Experience with DB2 version upgrades and builds.
  • Knowledge of DB2 Transportable Tablespaces.
  • Strong experience in Sybase ASE, Sybase IQ, and Sybase Replication administration.
  • Strong knowledge in performance tuning for databases.
  • Solid understanding of banking, retail, healthcare, and insurance domains.

Nice-to-haves

  • Experience with job scheduler bash; Autosys, cron jobs, etc.
  • Good interpersonal skills to interact with global teams.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service