Senior DBA (PostgreSQL)

Role: Senior PostgreSQL DBA
Location: Parsippany NJ (Hybrid: 3 days onsite in a week)
Long term role (Right to Hire)
What you will bring:
 

• 12+ years of PostgreSQL DBA experience.
• PostgreSQL replication experience.
• SQL coding and tuning experience.
• Shell scripting and automation experience.
• PostgreSQL PGAdmin client connectivity tool experience.
• AWS/Cloud Services experience: EC2, RDS, and Aurora.
• Cloud deployments experience: Jenkins, Bitbucket, Terraform.
• Hands-on, technically adept DBA, capable of performing required DB tasks experience.
• Strong troubleshooting/performance tuning skills.
• Ability to assess and improve SQL performance.
• Understanding of PostgreSQL’s underlying storage engines.
• Ability to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary.
• Expert level PostgreSQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments.
• Strong commitment to following SDLC/Change-Management principles.
• Self-starter and be able to perform work with minimal supervisory direction.
• Knowledge of data quality, data management, and data testing strategies and practices.
• Strong communication skills, both oral and written.
• Strong experience working with ticketing tools such as ServiceNow, Zenoss or any other monitoring tool, Cloud monitoring tools (CloudWatch, CloudTrail), AppDynamics (or similar APM tool).
• Strong problem-solving and troubleshooting skills.
• Keen analytical and structured approach to problem solving.
• Ability to accommodate flexible work schedules.

Huge Plus:
 

• Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers).
• Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, cron, or other techniques.
• Experience in DB2 UDB, Oracle, MySQL, Microsoft SQL Server, MongoDB, and/or Cassandra is plus
• Experience with configuration management tools: SCCM; Puppet; or Ansible.
• Development or enhancement of training and upskilling programs.
• Bachelor’s Degree or similar required.