What are the responsibilities and job description for the PostgreSQL DBA position at André Global, Inc.?
This is a contract-to-hire position with our Insurance Client. Client is actively seeking a passionate, driven Senior, Database Engineer to provide operational support for Database Systems, design and build database systems using automation in both data center and cloud platforms, including identifying build defects and create self-healing routines.
Location : Bethlehem, PA or Holmdel, NJ. Local candidates are preferred. The Database Service is scheduled to work Monday through Friday 8 : 00 AM ET till 5 : 00 PM ET. Today we are working 3-days remote and 2-days in the office. We operate on a 24x7x365 using an on-call rotation which the candidate will be a part of.
You have
In-depth knowledge and troubleshooting skills in the following :
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
- Keen analytical and structured approach to problem solving
- Ability to accommodate flexible work schedules
Desired skills :
You will :
