Database Administrator

by | Dec 11, 2023 | Uncategorized

Job Description

Database Administrator

United States – Remote OK

Full-Time

TechSurSolutions is a digital services company whose mission is to enable digital transformation for our customers improving quality and efficiency.Based in the DC metropolitan area,TechSurspecializes in advanced cloud services, modernization for both ITstructuresand applications, leveraging Agile development, and Data Analytics.Since we were formed inAugust of2016,we have supported multiple impactful and excitinggovernment programs.

As a Database Administrator, you will be responsible for deploying and managing PostgreSQL databases within containerized and cloud environments. While the primary work is on PostgreSQL, work will also include managing MongoDB for document storage. This application platform consists of multiple cloud based and DevOps tools and technologies and is used by development, QA, and system integration teams.

Responsibilities

  • Working with Development, and Security teams to define and document requirements for deployment, configuration, hardening, and optimization of databases and database tasks.
  • Deploy and manage databases per requirements.
  • Monitor, analyze, and troubleshoot problems within PostgreSQL specific and general DevOps tools and processes.
  • Management of backup files and recovery processes.
  • Manage accounts and roles on the databases per documented processes.
  • Document database architecture and processes.
  • Reviewing vulnerability scans and remediating vulnerabilities in addition to participating in periodic security audits.
  • Coordinate with other teams to continually improve delivery of product to customer.
  • Maintaining and driving modernization of legacy applications, tools and systems.
  • Design, implement ensuring quality and security controls are met.
  • Prioritize work and close out tickets in a timely manner.

Required

  • PostgreSQL (versions 9.6 13) on Linux, including system configurations
  • Experience with database replication (streaming, file based, or logical)
  • Experience managing both file-based and logical backups (pg_basebackup, pg_dump, pg_restore)
  • Highly Available database configurations using replication, connection poolers (pgbouncer, pgPool) and failover
  • Database recovery from backups (single table, entire database, point in time, missing transaction logs)
  • Query optimization (analyzing explain plans, index management)
  • Log Aggregation/Analysis (pgBadger, Splunk or similar)
  • Application/Database monitoring (pgMonitor, Datadog, NewRelic, DynaTrace, AppDynamics, Zabbix or similar)
  • Good verbal and written communication skills
  • Team player that fully embraces DevOps culture, eliminate barriers and bridge moats

Preferred

  • Multiple PostgreSQL distributions (EDB, Crunchy Data, 2nd Quadrant)
  • Multiple Databases (PostgreSQL, MySQL, MS SQL Server, Oracle)
  • Scripting/development skills. Python and Bash scripting are preferred
  • Debugging database connections (proxies, networking, java/tomcat, database)
  • Linux (RHEL preferred)
  • Test data generation and database benchmarking
  • NoSQL Databases (Mongo DB)
  • Containerization (Docker)
  • Openshift/Kubernetes and PostgreSQL Operators (Crunchy Data, 2nd Quadrant, EDB)
  • Nexus – Artifact Repository
  • Twistlock
  • VMware or VirtualBox
  • Bitbucket (Git)
  • Ansible
  • Cloud based services (AWS, Google Cloud, …)
  • Networking/DNS/Certificates
  • Security scanning / vulnerability remediation (Nessus, Retina, )
  • Government or large organization experience

APPLY HERE