PostgreSQL Database Infrastructure Administrator

PostgreSQL Database Infrastructure Administrator

24 Jan 2024
Maryland, Baltimore, 21201 Baltimore USA

PostgreSQL Database Infrastructure Administrator

Vacancy expired!

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, in an IT field in lieu of a degree.
  • 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 start-up, 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

Related jobs

  • Description:

  • IT@JH Enterprise Business Solutions (EBS) is seeking an IT Sr. Project Administrator who will be responsible for all phases of project management of implementing complex technology solutions that support the mission of the Johns Hopkins Institutions. This individual will participate in planning and tactical execution of technology initiatives; facilitate communications between departments within the Johns Hopkins Institutions as they relate to the use of technologies; coordinate the work of teams of IT and non-IT professionals.

  • EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities. At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

Job Details

  • ID
    JC32335319
  • State
  • City
  • Job type
    Contract
  • Salary
    $70 - $75
  • Hiring Company
    Pace Computer Solutions Inc.
  • Date
    2022-01-17
  • Deadline
    2022-03-18
  • Category

Jocancy Online Job Portal by jobSearchi.