Postgresql DBA + Mongo DB

About the job

Postgres MongoDB Location: Bangalore/Hyderabad Job DescriptionJob Responsibilities

• PostgreSQL Database Administrator will be providing technical and operational support for activities of Database Servers including installation troubleshooting performance monitoring tuning and optimizing
• Minimum Three 3 years of experience with PostgreSQL version 10 up till latest version hosted on on-premises and Cloud Platform
• Install monitor and maintain PostgreSQL implement monitoring and alerting implement backup and recovery processes provide system and SQL performance tuning
• Min two 2 years of experience as a PostgreSQL database administrator deploying PostgreSQL databases on Cloud platforms such as Azure Cloud Environment AWS
• Strong Knowledge in IaaS PaaS cloud database environment and configuration
• Programming languages such as UNIX shell scripting PLpgSQL Python or Perl experience
• Two 2 years of experience with PostgreSQL native tools like pg Admin pgAudit pgBadger pgPool pSQL
• Estimate PostgreSQL database capacities develop methods for monitoring database capacity and usage
• Must have experience in PostgreSQL database architecture logical and physical design automation documentation installs shell scripting PL SQL programming catalog navigation query tuning system tuning resource contention analysis backup and recovery standby replication etc
• Strong understanding of command line and server administration
• Participate in the creation of development staging and production database instances and the migration from one environment to another
• Hands on experience in regular maintenance on databases eg Vacuum Reindexing Archiving
• Handson knowledge in proactive remediation of database operational problems
• Ability to proactively identify troubleshoot and resolve live database systems issues MongoDB Skills
• Extensive experience with MongoDB installation configuration and management
• Proficiency in MongoDB query language and performance optimization
• Experience with backup restore and disaster recovery procedures
• Ability to monitor database performance and troubleshoot issues
• Familiarity with NoSQL database principles and architecture
• Knowledge of data modelling and schema design for MongoDB
• Experience with replica sets sharding and scaling MongoDB clusters
• Proficiency in scripting languages such as Python Bash or similar
• Understanding of cloud-based MongoDB services e.g. MongoDB Atlas

Desirable Secondary Skills