Database Administrator

$104,000 - $110,240/Yr

INSPYR Solutions - Washington, DC

posted 2 months ago

Full-time - Mid Level
Remote - Washington, DC
Administrative and Support Services

About the position

The Database Administrator is responsible for designing, implementing, and maintaining databases, ensuring optimal access methods, access time, batch processes, device allocation, validation checks, organization, protection, security, documentation, and statistical methods. This role involves maintaining database dictionaries and integrating systems through effective database design. The administrator will also maintain and document shell scripts and batch processes, ensuring that all documentation is complete and up-to-date. A critical aspect of this position is developing and applying procedures for periodic database backup to safeguard data integrity. In this role, the Database Administrator will implement designs and structures provided by Systems and Data Architects, performing timely installations of software and hardware environments in accordance with current release levels. They will create and maintain schedules for software maintenance and upgrades, ensuring that the database remains available to users. The administrator will also monitor database performance, assist with database security, and develop techniques to prevent system problems. Troubleshooting incidents to recover services and supporting root cause analysis are essential functions of this position. The Database Administrator will validate, load, test, and verify data, performing complete functional testing of database structures across all environments, including development, test, and production. Additionally, they will provide project management support regarding technical aspects of implementing project release upgrades for assigned systems, which includes following a project life cycle, developing project plans, and completing all necessary documentation and notifications to ensure timely resolution of issues.

Responsibilities

  • Design, implement, and maintain databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
  • Maintain database dictionaries and integrate systems through database design.
  • Maintain and document shell scripts and batch processes.
  • Ensure that documentation is complete and up-to-date.
  • Develop and apply procedures for periodic database backup.
  • Implement designs and structures provided by Systems and Data Architects.
  • Perform installation of software and hardware environments in a timely manner.
  • Create and maintain schedules for software maintenance and upgrades.
  • Prepare appropriate dimensional data structures and provide logical interfaces for the extract/transform/load process.
  • Maintain database availability to users and ensure database backup and recovery.
  • Monitor database performance and assist with database security.
  • Develop and implement techniques to prevent system problems and troubleshoot incidents to recover services.
  • Validate, load, test, and verify data; perform complete functional testing of database structures.
  • Provide project management support regarding technical aspects of implementing project release upgrades.

Requirements

  • Bachelor's Degree in Computer Science or IT related field.
  • 3 years of experience using relational databases.
  • Experience retrieving data to perform management and reporting duties.
  • In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required.

Nice-to-haves

  • Knowledge of Oracle and similar databases.
  • Ability to communicate effectively with analysts, developers, testers, and project managers in both oral and written form.
  • Ability to work with minimal supervision.
  • High-level analytical and troubleshooting skills.
  • Proficient in Microsoft Office applications.
  • Knowledge of structured query language (SQL).

Benefits

  • Comprehensive medical benefits
  • Competitive pay
  • 401(k) retirement plan
  • and much more!
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service