The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.
Mrg3pv6br2px0t34nrk

PosGreSQL DBA

Job Description

Database Administrator - PostgresSQL, MySQL and Oracle AWS RDS

Location: DMV / Telework

Supports database maintenance and provisioning for PostgresSQL, MySQL, and Oracle AWS RDS. Typical tasks include creating schemas, manage access credentials, monitoring, execute tasks to support developers. Provides database support by verifying databases associated with network tools and solutions function as required. Responsible for managing the routine operations and maintenance of databases and ensuring their reliable and efficient performance. Works with a team to manage multiple databases and implement updates.

Job Responsibilities

  • Performs preventive and corrective maintenance and incident management measures.
    * Schedules and executes regular system administrative activities, including system reboot, back up, recovery, archiving and restoration.
    * Checks and ensures all databases are online and can be connected. Monitors and tunes databases to ensure peak performance.
    * Checks database log files backup status and system hardware resources such as space, CPU, and memory. Designs and implements backup and recovery solutions.
    * Creates tests, develops databases, and tunes database performance, reviewing database performance trends and identifies opportunities for improvement.
    * Provides advanced system maintenance support, ensuring that any system disruptions mandated by an upgrade or patch follow the necessary guidelines and approvals.
    * Supports installation of operating systems, databases, applications, development upgrades, and new releases.
    * Plans and executes any needed upgrades to the software applications and maintains necessary licensing.
    * Establishes standards, controls and procedures to ensure data integrity and security.
    * Uses various databases and sources to research system vulnerabilities and potential security attacks.
    * Performs capacity planning and projection for future growth.
    * Assists and mentors junior Database Administrators.

Minimum Qualifications

Bachelor's Degree in a related field of study.
2-5 years of related work experience.
Must be eligible to pass public trust clearance, must be US CITIZEN or Green Card Holder

Other Job Specific Skills

* need to have either Oracle or SQL Server and PostGreSQL and preferably one of the others.

  • Nice to have: Hadoop, Netezza, and/or Columnar

Solid understanding of ANSI-SQL, PostgreSQL
* Basic understanding of AWS core infrastructure, including RDS is beneficial
* PostgreSQL Operations - P2 intermediate; AWS Database - P2 intermediate
* Hands on experience of AWS DynamoDB
* Strong attention to detail and analytical skills.
* Strong written and verbal communication skills.
* Ability to multitask and work well under pressure.
* Experience monitoring database usage, troubleshooting data compatibility and integrity issues, and making modifications for enhanced performance.
* Experience with DBA productivity and performance tools.
* Experience with DoD and Federal Government is desired.
* Working knowledge of security network and infrastructure tools, including access control and/or encryption.
* Thorough knowledge of the software/system development life cycle (SDLC).
* Ability to clearly and concisely document table mappings/layouts or data dictionaries for technical and non-technical audiences.

This candidate needs to be eligible for a minimum of a Public Trust level clearance.

#CJPost

Job Requirements

 

Job Snapshot

Location US-DC-Washington
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type Other, IT & Technical
Apply

Company Overview

ASM Research

ASM Research, an Accenture Federal Services Company, provides end-to-end application solutions that address the big data challenges of mission-critical business functions. We are recognized for supporting federal priorities for military readiness and strong national defense, harnessing the power of technology to transform healthcare management and delivery, and protecting the integrity and confidentiality of our clients data. Learn More

Contact Information

US-DC-Washington
ASM Research
910-208-2002
Snapshot
ASM Research
Company:
US-DC-Washington
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
Other, IT & Technical
Store Type:

Job Description

Database Administrator - PostgresSQL, MySQL and Oracle AWS RDS

Location: DMV / Telework

Supports database maintenance and provisioning for PostgresSQL, MySQL, and Oracle AWS RDS. Typical tasks include creating schemas, manage access credentials, monitoring, execute tasks to support developers. Provides database support by verifying databases associated with network tools and solutions function as required. Responsible for managing the routine operations and maintenance of databases and ensuring their reliable and efficient performance. Works with a team to manage multiple databases and implement updates.

Job Responsibilities

  • Performs preventive and corrective maintenance and incident management measures.
    * Schedules and executes regular system administrative activities, including system reboot, back up, recovery, archiving and restoration.
    * Checks and ensures all databases are online and can be connected. Monitors and tunes databases to ensure peak performance.
    * Checks database log files backup status and system hardware resources such as space, CPU, and memory. Designs and implements backup and recovery solutions.
    * Creates tests, develops databases, and tunes database performance, reviewing database performance trends and identifies opportunities for improvement.
    * Provides advanced system maintenance support, ensuring that any system disruptions mandated by an upgrade or patch follow the necessary guidelines and approvals.
    * Supports installation of operating systems, databases, applications, development upgrades, and new releases.
    * Plans and executes any needed upgrades to the software applications and maintains necessary licensing.
    * Establishes standards, controls and procedures to ensure data integrity and security.
    * Uses various databases and sources to research system vulnerabilities and potential security attacks.
    * Performs capacity planning and projection for future growth.
    * Assists and mentors junior Database Administrators.

Minimum Qualifications

Bachelor's Degree in a related field of study.
2-5 years of related work experience.
Must be eligible to pass public trust clearance, must be US CITIZEN or Green Card Holder

Other Job Specific Skills

* need to have either Oracle or SQL Server and PostGreSQL and preferably one of the others.

  • Nice to have: Hadoop, Netezza, and/or Columnar

Solid understanding of ANSI-SQL, PostgreSQL
* Basic understanding of AWS core infrastructure, including RDS is beneficial
* PostgreSQL Operations - P2 intermediate; AWS Database - P2 intermediate
* Hands on experience of AWS DynamoDB
* Strong attention to detail and analytical skills.
* Strong written and verbal communication skills.
* Ability to multitask and work well under pressure.
* Experience monitoring database usage, troubleshooting data compatibility and integrity issues, and making modifications for enhanced performance.
* Experience with DBA productivity and performance tools.
* Experience with DoD and Federal Government is desired.
* Working knowledge of security network and infrastructure tools, including access control and/or encryption.
* Thorough knowledge of the software/system development life cycle (SDLC).
* Ability to clearly and concisely document table mappings/layouts or data dictionaries for technical and non-technical audiences.

This candidate needs to be eligible for a minimum of a Public Trust level clearance.

#CJPost

Job Requirements

 
Mrj5ds65y6cpp7t56jt
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
PosGreSQL DBA Apply now