We are storming the marketplace with the highly skilled, experienced, and certified professionals that businesses need.

Find your perfect job.

PostgreSQL - Database Infrastructure Administrator (Closed)

Description of Work:

  • Design, architect, and build databases from determining business requirements to planning and deploying test and production systems.
  • Administration of PostgreSQL databases throughout the development and production lifecycles in an AWS environment.
  • Design and develop logical and physical database designs from customer requirements.
  • Analyze/Develop business description of user needs, program functions, and steps required to develop or modify systems, including Business Requirements Documents and supporting documents, diagrams, data and database specification.
  • Assist the project/application manager with release, configuration, and change management activities.
  • Provide advice and support to development resources.
  • Liaise with business customers and business analysts to support the design of intuitive end user reporting.
  • Provide guidance in the creation and modification of standards and procedures.
  • Provide mentorship to group members and will be expected to help develop and support mid and junior level staff.
  • Scheduled for after hours on-call support and will be required to apply production packages during non-peak hours.

Basic Qualifications:

Minimum knowledge, skills, abilities needed.

  • Bachelor’s degree and 4 years of relative experience, Master's degree and 2 years of relative experience, along with 10 years of IT experience.
  • At least 5 years hands-on experience in database infrastructure tasks on Linux/Unix operating systems with demonstrated experience in each of the following:
    • Installing databases preferably on-premise and Cloud PostgreSQL
    • Designing/developing/maintaining database schemas
    • Converting database schemas from on-premise DB2 or Oracle databases to PostgreSQL database structures.
    • Writing data conversion scripts from on-premise DB2 or Oracle databases to PostgreSQL database structures.
    • Developing, writing, and testing of Linux or Bash scripts for startup, shutdown, backups, database scripts, and other scripting as required
  • At least 3 years of experience in database administration tasks such as DB analysis, maintenance, development, and reporting
  • Must be able to obtain and maintain a US Public Trust clearance

Preferred Qualifications:

Candidates with these skills will be given preferential consideration.

  • Experience with deployment of AWS Cloud Infrastructure
  • Experience working in a cloud environment like AWS/Google cloud
  • Experience setting up and managing PostgreSql on AWS RDS and AWS EC2 Virtual Server.
  • Knowledge of PostgreSQL Architecture Python Development and Ansible Deployment.
  • Experience with data architecture, logical and physical design, reporting and analysis.
  • Prior SSA experience
  • Liquibase experience

#LI-DNI

Similar Jobs

Entry Level Software Engineer

Contract job in Philadelphia

Entry Level Software Engineer

Contract job in Kansas City

Entry Level Software Engineer

Contract job in St. Louis