What are the responsibilities and job description for the PostgresSQL DBA - Local to NJ position at TekIntegral?
Role: PostgresSQL DBA
Location: Holmdel, NJ (Hybrid)
Duration: 6 months contract
Visa: USC & GC (NEED LOCALS)
Mode of Interview- Video (Teams) Interview
About The Job
PostgreSQL DBA
The ideal candidate should also possess a green card or be of citizenship.
Must Have Skills
Location: Holmdel, NJ (Hybrid)
Duration: 6 months contract
Visa: USC & GC (NEED LOCALS)
Mode of Interview- Video (Teams) Interview
About The Job
PostgreSQL DBA
The ideal candidate should also possess a green card or be of citizenship.
Must Have Skills
- 10 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
- Ability to accommodate flexible work schedules
- 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 programsBachelor's Degree or similar required
