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 (DBA) 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 DBA 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, providing flexibility while ensuring that the DBA is closely integrated with the team and operations. In this role, the DBA will assist in the design, implementation, and maintenance of databases, ensuring optimal performance and efficient disk usage. The DBA 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 is essential, along with documenting these processes for future reference. The DBA will also participate in disaster recovery drills, ensuring that the company is prepared for any potential data loss scenarios. The position requires the DBA to provide primary on-call support for production problems, understand and support corporate data standards, and recommend new DBMS and operational standards. Additionally, the DBA will participate in testing and evaluating new software and software release upgrades, maintaining metadata repositories to ensure data integrity and accessibility.

Responsibilities

  • Assists with the design, implementation, and maintaining databases
  • Manage database performance and disk usage
  • Provides support in database access methods
  • Provides consultation support in database analysis, modelling, 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 in evaluations of new software and software release upgrades
  • Maintains metadata repositories

Requirements

  • Bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business
  • 3+ years' experience developing and maintaining complex applications that make extensive use of a 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 modelling 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
  • 7+ years' experience with PostgreSQL
  • 7+ years' experience with DB2 LUW; preferably on Red Hat Linux
  • Proficient with coding and review of SQL, stored procedures, and triggers
  • 1+ year' Terraform, Ansible, Jenkins & CI/CD skills
  • 1+ years' EDB Postgres & EDB Postgres Distributed experience
  • 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