Get your dream job within 2 days (HURRY UP)ENROLL NOW
+


Job Id : 967

Jobtitle : PosGreSQL DBA

Location : Washington, DC

Company Name : ASM Research

Industry : Information Technology

Salary : $80,000 - $100,500  YEAR

Job type : Fulltime

Posted on: 2019-07-01


Required Skills : Databases, Information Security, Amazon Web Services, Installations (Computer Systems), PostgreSQL, Data Integrity, Netezza, Database Administration, Maintenance, Capacity Planning, Attention To Detail, Scheduling, MySQL, Systems Development Life Cycle, Apache Hadoop, Ansi Sql, Access Controls, Incident Management, Stress Management, Multitasking, Amazon Relational Database Service, Analytical, Complex Problem Solving, Data Dictionary, Infrastructure, Operating Systems

Benefits : No benefits are available


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

Latest jobs for you

  • MDM Solution Architect

    3S Business Corporation Inc. Greenville, SC

    Job Description: Provide a bridge between specific business problems and issues and the ...

    View Job
  • GIS DEVELOPER - C2C

    3S Business Corporation San Francisco, CA

    Job Description: Mandatory Skills: 12 years experience in developing applications with ESRI...

    View Job
  • Big Data Engineer

    3S Business Corporation Reston, VA

    Job Description: Minimum 8 plus years of proven software development experience and a good ...

    View Job
  • SQL Developer

    Quantum Analytics Inc. Long Beach, CA

    Skills and Experience: Experience with SQL Server databases. Experience with SQL Server ...

    View Job
  • .NET Developer

    Quantum Analytics Inc. Long Beach , CA

    Primary Responsibilities: 8 years of experience in .Net   Mandatory Skills:...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First