← Back to jobs
AAyanWorks

DBA - Data Base Administrator

AyanWorks

Pune
Full-Time
0-3 Years experience

Description

Must have the following skills:

  • 3 + years of experience in Databae administration with hands-on in PostgreSQL and at least one more additional DB
  • Good experience on PostgreSQL architectures (Memory components, Different processes, and fair understanding of the working of PostgreSQL).
  • Working experience on PostgreSQL Installation, setting up PGBouncer, PGPool, suparvisor.
  • Experience in building enterprise scale database infrastructure supporting a high volume of transactions in a mission-critical environment.
  • Hands-on experience in indexing, DB objects such as SPs, triggers, views in addition to experience in backup, restore and point-in-time recovery, switchover/failover tasks depends on the scenarios
  • Experience in scheduled maintenance activities such as VACUUM ANALYZE, indexing, performance optimization for improving query response time.
  • Deploying and managing PostgreSQL on AWS Cloud infrastructure including both EC2 & RDS instances and setting up cluster of database.
  • Maintaining different clients on AWS and monitoring them using CloudWatch.
  • Working experience on upgrades (Minor and major versions).
  • Troubleshooting Day-to-day operations and issues like (CPU and Load average, locking blocking, long-running sql, and Disk-space issues ).
  • Proficient with Structured Query Language.
  • Hands-on experience in configuring and supporting replication using different replication tools.

Good to have following skills:

  • Working experience additionally in any other database such as Supabase, MySQL, SQL Server, MongoDB, etc. will be plus.
  • Exposure to shell scripting, linux environment, cloud

Ideal candidate will:

  • work with several project/product teams
  • take complete ownership of managing the DB instances for each of the project.
  • help development team(s) on day-to-day basis in development/QA/production setup & maintenance.
  • communicate across teams to provide standard/best practices for DB queries, tabel structures, normalizations
  • may need to work directly with client stake holders as and when needed

Requirements

Must have the following skills:

  • 3 + years of experience in Databae administration with hands-on in PostgreSQL and at least one more additional DB
  • Good experience on PostgreSQL architectures (Memory components, Different processes, and fair understanding of the working of PostgreSQL).

Must be an IT graduate or Post-Graduate

Benefits

Reward points for

· Experience working on global projects/teams.
· Hands-on learner and explorer.
· Experience in both larger mature enterprises and startup / tech environments.
· You will have a working knowledge of developer tools like SDKs and APIs

Why Join Us?

· Passionate and friendly team in an innovative casual, positive and open work environment
· Be the technical face of a rapidly expanding startup in an evolving field.
· Recognized in the blockchain and Web3 ecosystems
· One of the well-known SSI development companies serving global clients.

Salary: As per Industry standards
Notice Period: Able to join at the earliest (15 days)
Work Location : Work from Office - Pune

About AyanWorks

-

Industry: no-mentionEmployees: 25+Website