Title PostgreSQL - Database Infrastructure Administrator Duration Long term Contract Location Baltimore, MD (Need local candidates) Public Trust clearance Required Job Description 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. AnalyzeDevelop 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 projectapplication 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 7 years of relative experience, Master's degree and 5 years of relative experience, or 11 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 LinuxUnix operating systems with demonstrated experience in each of the following Installing databases preferably on-premise and Cloud PostgreSQL Designingdevelopingmaintaining 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 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 AWSGoogle 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.