Aurigo - Senior Database Administrator - Implementation & Maintenance

Job Description : Roles & Responsibilities : - Stay abreast of latest database SQL and NoSQL trends & technologies and work on implementing the same as per business requirements at Aurigo. - Put security first and maintain the complete database environment at Aurigo. - Prepare knowledge base articles, presentations to management periodically and participate in monthly/bi-weekly program/project and environment reviews. - Work on cost optimization, high availability and reliability architecture deployment and maintenance on Postgres and NoSQL (DynamoDB & MongoDB) database technologies. - Ensure 100% uptime of the database environment in Cloud. - Participate in company hackathon events and intercompany hackathon events or game days organized by top global cloud service providers. - Participate in On-Call rotation 2 weeks in a month. - Participate in monthly production patching activity one Saturday every month (compensatory-off will be provided) . Required Skills and Experience : - B. E/ B. Tech (CS, IS, IT, ECE) - Minimum 5 years of experience in Postgresql administration, preferably on AWS cloud. - Analyze Queries and Stored Procedures, tune the SQL for optimal performance. - Strong Experience and hands-on in database modelling, administration, tuning and troubleshooting performance problems. - Knowledge on Replication. - Strong knowledge on database backup & recovery. - Implementation and maintenance of High Availability & Disaster Recovery setup for Business Continuity Plan, "on-premises" or on "Cloud" - Understanding of streaming data analytics and resources. - Hands on experience with NO SQL databases (DynamoDB, mongo dB etc.) - Experience with cloud databases. - Monitor Production Servers for optimal performance. - Experience in Data Migration between disparate systems. - Powershell scripting for administration and job automation required. - Exposure to AWS cloud infrastructure and database tuning on Amazon RDS. - Strong exposure on database configuration for SaaS applications. - Postgres certification preferred. - Advanced knowledge of database structure and theory - Familiarity with reporting tools - Ability to work independently with minimal supervision and assistance. Preferred Skills and Experience : - Clear and confident communication is highly preferred. (ref:hirist.tech)

Location: bangalore, IN

Posted Date: 10/10/2024