Aurigo Software - Bengaluru, India - Aurigo Software Technologies Pvt Ltd

Description

Aurigo is an American technology company founded in 2003 with a mission to help public sector agencies and facility owners plan, deliver and maintain their capital projects and assets safely and efficiently.

With more than $300 billion of capital programs under management, Aurigo's award-winning software solutions are trusted by over 300 customers in transportation, water and utilities, healthcare, higher education, and government on over 40,000 projects across North America.

We are a privately held corporation headquartered in Austin, Texas, USA, with software development and support centers in Canada and India.

If you are ready to work for a fast-paced software company growing exponentially and interact with some of the brightest minds in the industry to solve real problems, we want to talk to you.

• 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/biweekly 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 (compensatoryoff will be provided).

• B. E/ B. Tech (CS, IS, IT, ECE)
• Analyze Queries and Stored Procedures, tune the SQL for optimal performance.
• Strong Experience and handson 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, "onpremises" or on "Cloud".
• Understanding of streaming data analytics and resources.
• Minimum 5 years of experience in Postgresql administration, preferably on AWS cloud.
• 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.

• Clear and confident communication is highly preferred.
• Team Management experience of 3 years plus is highly preferred.