Request Technology - Dallas, TX

posted 2 months ago

Full-time - Mid Level
Dallas, TX
Administrative and Support Services

About the position

The Associate Principal, Database Administrator position is a critical role within our prestigious company, focusing on the management and support of our database systems. This position requires a seasoned professional with over 7 years of experience specifically with DB2 LUW on Red Hat and PostgreSQL. The successful candidate will be responsible for production support, performance tuning, backup strategies, and overall database management system (DBMS) operations. The role is hybrid, requiring three days onsite and two days remote work, and it is a permanent full-time position without sponsorship options. In this role, the DBA will assist in the design, implementation, and maintenance of databases, ensuring optimal performance and efficient disk usage. The candidate will provide support in database access methods and offer consultation in database analysis, modeling, coding, and resolving production issues. Developing maintenance, backup, and recovery procedures, along with comprehensive documentation, will be essential. The DBA will also participate in disaster recovery drills and provide primary on-call support for production problems, ensuring adherence to corporate data standards. The position involves recommending and assisting with new DBMS and operational standards, participating in testing and evaluations of new software, and managing software release upgrades. The DBA will also maintain metadata repositories, ensuring that all database systems are functioning optimally and securely. This role is ideal for a candidate who thrives in a dynamic environment and is eager to contribute to the success of our database management initiatives.

Responsibilities

  • Assists with the design, implementation, and maintenance of databases.
  • Manages database performance and disk usage.
  • Provides support in database access methods.
  • Offers consultation support in database analysis, modeling, coding, and production problem resolution.
  • Develops maintenance, backup, and recovery procedures and documentation.
  • Participates in disaster recovery drills.
  • Provides primary on-call support for production problems.
  • Understands and supports corporate data standards.
  • Recommends and assists with new DBMS and operational standards.
  • Participates in testing and evaluations of new software and software release upgrades.
  • Maintains metadata repositories.

Requirements

  • Bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business.
  • 7+ years' experience with PostgreSQL.
  • 7+ years' experience with DB2 LUW, preferably on Red Hat Linux.
  • 3+ years' experience developing and maintaining complex applications that utilize supported database technology or 3+ years' experience as an associate DBA.
  • Experienced in two or more programming languages and two or more scripting languages.
  • Practiced at Entity/Relationship or Object modeling and translation to physical database designs.
  • Proficient in DML, DDL, and database utilities for at least two DBMS technologies.
  • Proficient in all access methods of a DBMS as well as the underlying operating system access methods.
  • Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment.

Nice-to-haves

  • 1+ year experience with Terraform, Ansible, Jenkins & CI/CD skills.
  • 1+ years' experience with EDB Postgres & EDB Postgres Distributed.
  • Basic Java, Perl & Linux Shell script skills.
  • 1+ years' experience with SQL Server.
  • 1+ years' experience with DB2 in a z/OS environment.
  • 1+ years' experience with MySQL/MariaDB.
  • Experience with BMC tools for DB2 (Change/Catalog Manager, MainView, Log Master).
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service