PostgreSQL DBA

1 month ago

Kensington, United States Horus Technology Solutions Full time
Overview

This is an opportunity for a PostgreSQL DBA on a highly visible, fast paced grants management program. This position includes collaboration with both technical and non-technical personnel across all project stakeholders. The customer location is at Fort Detrick in Frederick, MD. This is a hybrid position working remotely and going to customer site as needed (usually once or twice per week - this changes based on COVID restrictions).

Responsibilities

  • Install, configure, administer, and patch PostgreSQL database
  • Maintain data integrity and database performance, stability, and scalability. Analyze and resolve complex technical problems, including performance tuning and application design and debugging.
  • Proactivity monitor the health of databases and make recommendations to optimize performance and efficiency.
  • Collaborate with various teams in tuning and load testing of mission-critical database systems.
  • Comply with Department of Defense (DOD) database security standards.
  • Document database administration and management related processes and procedures.
  • Provide support to the application developers, including, but not limited to data refresh, PL/pgSQL performance tuning, and best practice recommendations.
  • Automate database administration and maintenance activities.
  • Support off-hours and weekend releases and emergency production issues as needed
Qualifications
  • U.S. Citizenship required
  • Ability to obtain DOD T3 Clearance
  • DBA Experience working with PostgreSQL (or enterprise RDBMS) in DOD production environments on mission-critical systems
  • Bachelor's degree in computer science or related field or an equivalent amount of work experience
  • 2+ years of professional PostgreSQL DBA experience
  • 5+ years of hands-on database administration experience using an enterprise RDBMS, such as Oracle
  • Advanced understanding of database backup and recovery strategies.
  • Advanced understanding of high availability solutions and strategies.
  • Proficient with SQL and performance tuning. Create indices and perform database tuning in line with application performance requirements.
  • PostgreSQL Server certification is a plus.
  • Ability to work independently in a team environment
  • Experience being part of Scrum or other Agile development teams
  • Excellent problem solving and analytical, and technical skills
  • Ability to think critically and act expeditiously to evaluate situations, make decisions and solve problems
  • Strong oral and written communication skills, and ability to work well with a variety of personalities
  • Ability to work effectively with dynamic environment with changes in priorities and aggressive deadlines.
Have current certification in at least one of these :
  • A+ CE
  • CCNA-Security
  • CND
  • Network+ CE
  • SSCP