PostgreSQL Database Administrator at Remote, Remote, USA |
Email: [email protected] |
From: Ravina, Vyze Inc [email protected] Reply to: [email protected] PostgreSQL Database Administrator Type: Contract-to-Hire | Visa: USC & GC Location: NJ or PA Schedule: Hybrid 2 days onsite Responsibilities: Provide operational support for database systems Design and build database systems using automation in both data center and cloud platforms Identifying build defects and create self-healing routines Perform initial investigation and/or troubleshooting of database and database system issues to resolve issue & determine root cause Process all support requests within SLA by following procedural requirements Escalate to vendors, where necessary, to ensure timely resolution Thoroughly document steps taken to resolve incidents and fulfil catalog requests within ServiceNow tickets Develop, document, and update standard operating procedures and knowledgebase articles Identify, address, and resolve repeating alert trends to improve stability and performance Suggest defects and product/infrastructure enhancements to improve stability and automation Participation in periodic skills enhancement sessions and training courses Qualifications: 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 Keen analytical and structured approach to problem solving Ability to accommodate flexible work schedules Keywords: database green card New Jersey Pennsylvania PostgreSQL Database Administrator [email protected] |
[email protected] View all |
Wed Jul 24 06:12:00 UTC 2024 |