1.0 - 5.0 years

0 Lacs

noida, uttar pradesh

On-site

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.,

Posted 1 month ago

Apply

Postgresql Database Administrator Eazy Erp Technologies

1.0 - 6.0 years

1 - 6 Lacs

Gurugram, Bengaluru

Work from Office

Job description for a PostgreSQL Database Administrator: Key Responsibilities 1. *Database Design and Implementation*: Design, implement, and maintain databases to meet organizational needs. 2. *Database Administration*: Manage and administer databases, including data modeling, normalization, and optimization. 3. *Data Security and Backup*: Ensure data security, integrity, and availability by implementing backup and recovery procedures. 4. *Performance Monitoring and Optimization*: Monitor database performance, identify bottlenecks, and optimize database configuration for improved performance. 5. *Troubleshooting and Support*: Troubleshoot database issues, provide technical support, and resolve database-related problems. 6. *Data Migration and Integration*: Plan, coordinate, and execute data migrations and integrations with other systems. 7. *Database Upgrades and Patches*: Apply database upgrades, patches, and fixes to ensure database stability and security. 8. *Documentation and Reporting*: Maintain accurate documentation, reports, and metrics on database performance, security, and usage. Requirements 1. *Technical Skills*: Proficiency in database management systems (DBMS) such as Oracle, Microsoft SQL Server, MySQL, or PostgreSQL. 2. *Database Design and Development*: Knowledge of database design principles, data modeling, and normalization. 3. *SQL and Query Optimization*: Strong understanding of SQL, query optimization, and performance tuning. 4. *Data Security and Backup*: Knowledge of data security best practices, backup and recovery procedures, and disaster recovery planning. 5. *Problem-Solving and Troubleshooting*: Excellent problem-solving and troubleshooting skills, with the ability to analyze complex database issues. 6. *Communication and Collaboration*: Effective communication and collaboration skills, with the ability to work with technical and non-technical stakeholders. Nice to Have 1. *Certifications*: Database certifications such as Oracle Certified Professional (OCP), Microsoft Certified Database Administrator (MCDA), or Certified Data Administrator (CDA). 2. *Cloud Experience*: Experience with cloud-based databases such as Amazon RDS, Google Cloud SQL, or Microsoft Azure Database Services. 3. *Data Warehousing and Business Intelligence*: Knowledge of data warehousing and business intelligence concepts, including data modeling, ETL, and data visualization.

Posted 1 month ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.