Padmi

DBA - Data Base Administrator (Pune)

MumbaiPosted 1 month ago
Infrastructure And DatabasesMid-levelFull Time; Regular
Apply at AyanWorks Technology Solutions

Opens the source posting on shine.com

Source description

About the role

View original

Must have the following skills: - 3 + years of experience in Databae administration with hands-on in PostgreSQL and at least one more additional DB - Positive 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 .

One address, no account. We’ll tell you when matching roles go live.

More at AyanWorks Technology Solutions

Related open roles

View all roles