Trident Consulting is looking for a PostgreSQL DBA to join one of our prestigious clients.
Job Title: PostgreSQL DBA
Location: Tinton Falls, NJ / Fullerton, PA (Hybrid - 2-3 days a week) - Locals Preferred
Duration: Contract to Hire
****We are open for H1B Transfer as well****
Job Details
The PostgreSQL DBA will collaborate with the engineering team to create a standardized delivery of data management solutions that are aligned with enterprise strategy and architecture. You will define database maintenance standards to ensure these standards are implemented and followed consistently. You will be responsible for forecasting system requirements and providing a course of action to meet the growing workload demands.
Must have skills:
- 10+ years of PostgreSQL DBA experience
- Thorough knowledge of implementing and maintaining security controls in a highly regulated industry with PostgreSQL databases
- 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
- Solid 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
Desired skills:
- 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
About Trident: Trident Consulting is an award-winning IT/engineering staffing company founded in 2005 and headquartered in San Ramon, CA. We specialize in placing high-quality vetted technology and engineering professionals in contract and full-time roles. Trident's commitment is to deliver the best and brightest individuals in the industry for our clients' toughest requirements.
Some of our recent awards include: 2022, 2021, 2020 Inc. 5000 fastest-growing private companies in America 2022, 2021 SF Business Times 100 fastest-growing private companies in Bay Area
