IT

Sr PostgreSQL DBA

Centurion Consulting Group

Sr PostgreSQL DBA Windsor Mill, MD

We are hiring for a highly motivated Senior PostgreSQL DBA to provide database development expertise and hands on implementation of the application using the latest open-source server-side java script technologies on the Node platform and other related open source products accessing an AWS RDS/PostgreSQL database. The candidate will be collocated with the government employees and subcontractors at a government facility in Baltimore, Maryland. The candidate must be able to pass a Federal Suitability Check for a position of public trust. Specifically the successful candidate will be a member of an Agile Database and Infrastructure Team working with other Agile development teams, System Architects, Test Architects, Database Engineers, IT Infrastructure & Operations Team and External System Owners to develop and administer the database architecture.

Key Required Skills: PostgreSQL 11 and 12 pgAdmin 4.8, Scripting, Query Tuning, CI/CD

Required Skills

  • Hands-on experience with Continuous Integration/Continuous Deployment pipelines and Database/Schema as Code tools and approaches. 8+ years
  • PostgreSQL 11 and 12 pgAdmin 4.8 – 3+ years
  • Strong SQL for database query and data updates in Production
  • Analyze database changes requested by the Agile development teams for impacts to database designs, naming standards, design standards, data conversions, and documentation.
  • Experience analyzing and tuning queries to improve query performance.
  • Hands-on experience with scripting to automate database changes/baselines including bash, pgplsql, or groovy (Jenkins).
  • Knowledge of installation, maintenance and administration of PosgtreSQL and configuration within AWS RDS.
  • Strong interpersonal and communication skills necessary to collaborate effectively with customers and other team members.
  • Ability to meet deadlines, concentrate, and to pay attention to detail.

Desired Skills

  • Experience with large enterprise solutions including but not limited to high availability, disaster recovery, and data management.
  • Hands-on experience and in depth knowledge of AWS database offerings (e.g. RDS, Aurora, and Dynamo).
  • Experience with transforming data from Legacy databases into archival data stores.
  • Experience developing databases with an Agile development process and ceremonies including scrums, planning events, backlog grooming, retrospectives and demos.
  • Experience with Jenkins CI/CD tools and scripting.
  • Experience with Liquibase and LiquiGen plug-in.
  • Experience with Replication and Change Data Capture (CDC) techniques and tools.
  • Experience with data conversion and management strategies
  • Experience with database partitioning and micro-services
  • Operating System and Infrastructure experience with RedHat Linux and Windows 10.
  • Experience with source code versioning with Git, Bitbucket, or other source control tools.

Education: Bachelors +7 years professional experience

Position Details: 

Clearance: Ability to Obtain a Public Trust

US Citizenship or Authorization to work in US required

Travel: < 10% (CONUS)

Centurion Consulting Group, LLC is an Equal Opportunity Employer EOE M/F/D/V

No third parties or subcontractors

Tagged as: Sr PostgreSQL DBA