Required Skills

PostgreSQL DBA

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 21st Oct 2024

JOB DETAIL

•  Design and Setup DR for cloud databases - Aurora PostgreSQL Global, Dynamo DB etc..

•  Setup the data replication from/to PostgreSQL/Aurora to Data Lake, Sqlserver, Azure Synapse, Redshift etc.

•  Prioritize work based on the project needs and work effectively with minimum supervision.

•  Manage, Monitor, Troubleshoot Database Operations, Optimize database performance, tuning.

•  Implement high availability, replication, and cluster on databases.

•  Database refreshes in on-prem and cloud.

•  Support application release deployment and perform data fixes.

•  Working with the application team to rewrite the Stored Procedures.

•  Troubleshooting performance issues in real time.

•  Work in a globally distributed team in an Agile/Scrum approach

•  Provide routine status reports to leadership and escalate as necessary.

•  Maintain Service Levels and department goals for problem resolution.

•  Follow security stands and effectively manage software patches and upgrades.

•  Utilize best practices, standard procedures.

•  Write and maintain clear documentation.

•  Ensure 24x7 availability for critical database systems hosted “on premise” and on AWS & Azure Cloud.

•  Be available to participate in 24x7 on-call rotation for the team.

Company Information