Senior PostgreSQL DBA/Developer

Centurion is actively looking for a Senior PostgreSQL Database Administrator/Developer to support the Social Security Administration. The selected candidate must RESIDE WITHIN 2 HOURS OF SSA Headquarters just outside of Baltimore in Woodlawn, MD, and must be willing/able to obtain a Public Trust.

Position Description:Design, architect, build, test, update, and document PostgreSQL databases.Administer PostgreSQL databases throughout the development and production lifecycles in an AWS environment.Design and develop logical and physical database designs.Brief management, customer, team, or vendors using written or oral skills at appropriate technical level for audience.All other duties as assigned or directed.Skill Requirements: Basic Qualifications:Bachelor's Degree in Computer Science, Mathematics, Engineering, or a related fieldMaster's or Doctorate degree may substitute for required experience5+ years of experience with database infrastructure tasks on Linux/Unix operating systems.5+ years of experience with relational database administration/management.Required Skills:Experience working in a cloud environment (e.g. AWS) and with deployment of AWS Cloud Infrastructure.Knowledge of PostgreSQL architecture.Experience setting up and managing PostgreSQL on AWS RDS and AWS EC2 Virtual Server.Experience with data architecture, logical and physical design, reporting and analysis.Experience developing and testing Linux or Bash scripts for startup, shutdown, backups, database scripts, and other scripting.Experience with programming languages like PL/pgSQL and Groovy.Experience with Replication and Change Data Capture (CDC) techniques and tools.Experience with data conversion and management strategies.Experience with database partitioning and microservices.Expertise in writing complex SQL queries in PostgreSQL and optimize queries.Strong communication and collaborative skills in providing technical direction and hands-on database administration to include design, development, and testing. Desired Skills:Comprehensive knowledge of Scrum and Kanban Agile development process and ceremonies including scrums, planning events, backlog grooming, retrospectives, and demos.Experience working as part of a large team and working with upstream and downstream dependencies.Experience with various administration and development platforms for PostgreSQL (e.g., pgAdmin)Experience with Liquibase and LiquiGen plug-in.Experience with Jenkins CI/CD tools and scripting.Experience with source code versioning and Pull Requests with Git and Stash.Experience with performance tuning and increasing efficiency of a large enterprise system.Education:Bachelor's Degree in Computer Science, Mathematics, Engineering, or a related fieldMaster's or Doctorate degree may substitute for required experienceMust obtain Public TrustPosition 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

Key Skills

• SQL
• PostgreSQL