Unclassified - Parker, CO

posted 3 months ago

Full-time - Mid Level
Parker, CO

About the position

As a Database Administrator, you will be responsible for the installation, tuning, implementation, and upgrading of Database Management Systems (DBMS) installations. Your role will involve building database systems that ensure high availability and quality tailored to the specialized roles of end users. You will design and implement databases by conducting thorough requirements gathering sessions with various business users to understand their needs and expectations. Additionally, you will provide guidance and support to Application Developers, assisting them with schema design, code reviews, and SQL query tuning. Your responsibilities will also include data modeling using ER Studio and other database modeling tools, as well as upgrading and improving application schemas and data structures. You will proactively make recommendations for system improvements and will be responsible for determining, enforcing, and documenting database policies, procedures, and standards. Regular testing and evaluations will be part of your duties to ensure data security, privacy, and integrity. You will monitor database performance, implement necessary changes, and apply new patches and versions as required. Proficiency in scripting languages such as Shell, Python, and R is essential, as you will work with various database technologies, including traditional RDBMS and document databases like IBM-DB2, Oracle, SQL Server, MySQL, Postgres, MongoDB, Amazon RDS, and RedShift. The role requires a willingness to travel to set up systems for various clients at unanticipated locations across the nation, as well as to perform feasibility studies and evaluate user requirements. International travel is not required, but domestic travel is a key component of this position.

Responsibilities

  • Install, tune, implement, and upgrade DBMS installations.
  • Build database systems of high availability and quality based on end user's specialized roles.
  • Design and implement databases through requirements gathering sessions with business users.
  • Provide guidance and support to Application Developers.
  • Assist with schema design, code review, and SQL query tuning.
  • Perform data modeling using ER Studio and other database modeling tools.
  • Upgrade and improve application schema and data.
  • Proactively make recommendations for system improvements.
  • Determine, enforce, and document database policies, procedures, and standards.
  • Perform tests and evaluations to ensure data security, privacy, and integrity.
  • Monitor database performance and implement changes as needed.
  • Apply new patches and versions when required.

Requirements

  • Proficient in scripting languages such as Shell, Python, and R.
  • Experience with database technologies including IBM-DB2, Oracle, SQL Server, MySQL, Postgres, MongoDB, Amazon RDS, and RedShift.
  • Strong understanding of database design and implementation principles.
  • Ability to conduct requirements gathering sessions with business users.
  • Experience in schema design and SQL query tuning.

Nice-to-haves

  • Experience with cloud-based database solutions.
  • Familiarity with data modeling tools other than ER Studio.
  • Knowledge of data security best practices.

Benefits

  • Health insurance coverage.
  • 401k retirement savings plan.
  • Paid time off and holidays.
  • Professional development opportunities.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service