Job Description: As a Database Administrator at our Tech-Support department, you will play a crucial role in setting up, configuring, administering, and maintaining various production and development environments. These environments may consist of both Relational databases such as SQL Server, PostgreSQL, MySQL, as well as NoSQL databases like MongoDB or others. You will be based at our Noida office and should have 1-2 years of relevant experience in this field. Your primary responsibility will be to collaborate closely with the tech team to design, build, and operate the database infrastructure. You will provide support to the tech team in identifying optimal solutions for data-related issues such as data modeling, reporting, and data retrieval. Additionally, you will work alongside deployment staff to address any challenges related to the database infrastructure effectively. Requirements: - Ideally, you should hold a BE/B.Tech degree from a reputed institute. - Proficiency in SQL Server/PostgreSQL database administration, maintenance, and tuning is essential. - Experience with database clustering, high availability, replication, backup, auto-recovery, and pooling, such as pgpool2, is required. - Strong familiarity with Logging and Monitoring tools like Nagios, Prometheus, PG-badger, POWA, Data-Dog, etc., is preferred. - Expertise in analyzing complex execution plans and optimizing queries is a must. - Good understanding of various database concepts including indices, views, partitioning, aggregation, window functions, and caching. - Up-to-date knowledge of the latest features in PostgreSQL versions 11/12 and above. - Experience working with AWS and its database-related services like RDS is a necessity. - Previous exposure to other databases like Oracle, MySQL will be advantageous. - Familiarity with NoSQL technologies is a plus. If you meet these requirements and are interested in this role, please share your updated profile with us at hr@techybex.com.,
As a Database Support Engineer at our company, you will play a crucial role in setting up, configuring, administering, and maintaining multiple production and development environments comprising both Relational and NoSQL databases such as SQL Server, PostgreSQL, MySQL, MongoDB, and others. **Role and Responsibilities:** - Collaborate closely with the tech team to design, build, and operate the database infrastructure. - Assist the tech team in identifying optimal solutions for various data-related challenges, including data modeling, reporting, and data search. - Work with deployment staff to troubleshoot and resolve issues with the database infrastructure. **Requirements:** - Preferably hold a BE/BTech degree from a premier institute. - Proficient in SQL Server/PostgreSQL database administration, maintenance, and tuning. - Experience in database clustering, high availability, replication, backup, auto-recovery, and pooling (e.g., pgpool2). - Good working knowledge of Logging and Monitoring tools like Nagios, Prometheus, PG-badger, POWA, Data-Dog, etc. - Expertise in reading complex execution plans and query optimization. - Sound understanding of various indices, views, partitioning, aggregation, window functions, and caching. - Familiarity with the latest features in PostgreSQL versions 11/12 and above. - Prior experience working with AWS and their database-related services, such as RDS, is essential. - Working experience with other databases like Oracle, MySQL is desirable. - Knowledge of NoSQL technologies is a plus. If you find yourself aligned with the requirements mentioned above and are excited about this opportunity, kindly share your updated profile with us at hr@techybex.com.,