Database Administrator

  • Salary

    $110,000 - $120,000 Per Year

Experience

5 to 15 Years

Posted On

Nov 11, 2022

Company

PB Consulting

Travel Requirements

0%

Job Overview

Required Skills

  • DBA
  • Postgres
  • MongoDB
  • Couchbase
  • ElasticSearch
  • HBase

Job Type

Full-time

Work Authorization

N/A

Location

Las Vegas, NV

Job Description

Primary Job Responsibilities    

  • All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery. 
  • Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
  • Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production. 
  • 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-though, and participation in weekly operations reviews. 
  • Proactive database monitoring and issue resolution through custom built scripts as well as using PgAdmin/Enterprise manager tools
  • Database optimization including performance tuning, query optimization and supportability. 
  • Actively participate and contribute to projects involving enterprise systems enhancements. 
  • Implementation and ongoing support of high availability architecture not limited to Active/Active and Active/Passive Clusters
  • Work with development project teams to design and implement database solutions to meet business requirements.
  • Regular proactive capacity planning and tending reviews of all databases. Producing weekly, monthly management reports. 
  • Develop and implement Database security polices and procedures, in line with corporate objectives

 

Job Requirements    

  • Must have 8+ years DBA working experience with PostgreSQL 9.6+ version and good understanding of Oracle Database and Microsoft SQL Server.
  • Must be knowledgeable and experienced in managing PostgreSQL on multiple operating systems including Microsoft Windows, Linux (RHEL) and Kubernetes in OpenShift platform
  • Experienced in setting up PostgreSQL clusters and supporting databases cluster in on-prem and hybrid cloud environment, and specifically in AWS RDS instance.
  • Strong skills in UNIX/Linux Shell Scripting
  • Experience in implementing Postgres STIG implementation, testing, and other vulnerability remediation. 
  • Working Knowledge of connection poolers (pgPool and pgBouncer).
  • Install, monitor and maintain PostgreSQL software, implement monitoring and alerting.
  • Experience in building high-scalable clusters, failover and hot standby solutions based on Maximum available architecture 
  • Experience in architecting, configuring, setting up Enterprise Fail over manager or similar technology for High availability solution.
  • Experience in leading efforts related to system and SQL performance tuning and assisting business process integration with various data sources.
  • Ability to work well with development and infrastructure teams in doing database design, changes and enhancement to new and existing applications
  • Proven ability to provide High Availability and Disaster Recovery solutions.
  • Maintain operational documentation (e.g., procedures, task lists, architecture blueprints)
  • Strong Troubleshooting Skills
  • Ability to maintain a positive attitude while working with high demands and short deadlines that leads to working after hours.
  • Must have excellent communications and interpersonal skills

 

Preferred:

  • Experience with database replication is a plus.
  • Enterprise DB Postgres Database Administration Certification.
  • Knowledge of administering NoSQL databases such as MongoDB, Couchbase, ElasticSearch, or HBase
  • Experience in data modeling tools such as Oracle Data Modeler, Erwin, Toad, Visio, etc.
  • Has strong Python programming skill and be able to develop dba applications for system automation and integration.

Job ID: PBC00062

  • Posted By

    William Christopher

Designation

Sr. Manager

Company

PB consulting

Last Login

Feb 27, 2024

Posted On

Nov 11, 2022


Related Jobs
  • JobType
  • Contract - W2

Posted On: Feb 23, 2024 01:59 PM


  • Company
  • COMPANY

    PB Consulting

  • Company
  • experience

    6 to 10 Years

  • Loction
  • work authorization

    N/A

  • Wallet
  • SALARY

    $50 Per Hour

  • Travel Requirements
  • Travel Requirements

    0%

  • Skills
  • SKILLS

    • Oracle
    • DB2
    • Configuration
    • Ansible / SHELL / Python
  • JobType
  • Contract - Corp-to-Corp
  • Contract - W2
  • Contract - Independent

Posted On: Dec 06, 2023 11:19 AM


  • Company
  • COMPANY

    Neshent Technologies

  • Company
  • experience

    10 to 12 Years

  • Loction
  • work authorization

    N/A

  • Wallet
  • SALARY

    $70 Per Hour

  • Travel Requirements
  • Travel Requirements

    0%

  • Skills
  • SKILLS

    • Oracle Exadata
    • OEM 12
    • RAC
    • Database
  • JobType
  • Contract - Corp-to-Corp
  • Contract - Independent
  • Contract - W2

Posted On: Dec 05, 2023 12:13 PM


  • Company
  • COMPANY

    Neshent Technologies

  • Company
  • experience

    6 to 10 Years

  • Loction
  • work authorization

    N/A

  • Wallet
  • SALARY

    $55 Per Hour

  • Travel Requirements
  • Travel Requirements

    0%

  • Skills
  • SKILLS

    • Python
    • GIT
    • ARM
    • PIM
  • JobType
  • Contract - Corp-to-Corp
  • Contract - Independent
  • Contract - W2

Posted On: Dec 05, 2023 12:01 PM


  • Company
  • COMPANY

    TechVilla Solutions

  • Company
  • experience

    8 to 10 Years

  • Loction
  • work authorization

    N/A

  • Wallet
  • SALARY

    $60 Per Hour

  • Travel Requirements
  • Travel Requirements

    0%

  • Skills
  • SKILLS

    • PostgreSQL
    • Oracle
    • DevOps
    • Database Product
  • JobType
  • Full-time

Posted On: Sep 12, 2023 04:22 AM


  • Company
  • COMPANY

    2T Consulting

  • Company
  • experience

    5 to 10 Years

  • Loction
  • work authorization

    N/A

  • Wallet
  • SALARY

    $90,000 - $100,000 Per Year

  • Travel Requirements
  • Travel Requirements

    N/A

  • Skills
  • SKILLS

    • SQL
    • data backup
    • recovery
    • replication