Aurigo - Senior Database Administrator - Implementation & Maintenance (3-7 yrs)

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.