AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Premium Employer
i
This company page is being actively managed by
Innominds Software Team. If you also belong to the team, you
can get access from
here
Innominds Software
Compare
All Filters
40 Innominds Software Jobs
Postgres SQL EDB
Innominds Software
posted 8hr ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Job Description:
As a Senior Database Administrator, you will be responsible for managing and maintaining highly available EDB PostgreSQL and MySQL database environments. Your role will include database architecture design, performance tuning, replication setup, backup and recovery, and ensuring data security. You will also provide expertise in cloud migrations and ensure database environments meet high availability and disaster recovery requirements.
Key Responsibilities: - Database Management:
- Install, configure, and maintain EDB PostgreSQL and MySQL databases.
- Manage database schemas, perform upgrades, and apply patches.
- Monitor database health, availability, and performance across multi-node clusters.
- Ensure high availability and disaster recovery setups using replication, clustering, and failover mechanisms.
- Performance Tuning and Optimization:
- Conduct performance tuning and optimization for SQL queries, indexes, and overall database design.
- Monitor and optimize resource utilization (CPU, memory, storage) for both EDB PostgreSQL and MySQL.
- Troubleshoot and resolve performance bottlenecks and database-related application issues.
- Backup and Recovery:
- Implement robust backup strategies, including full, incremental, and point-in-time backups.
- Plan and perform database recovery operations to ensure minimal data loss.
- Use tools such as pgBackRest, WAL archiving, MySQL dump, and physical and logical backup techniques.
- Replication and Clustering:
- Set up and maintain replication (e.g., streaming replication, logical replication) and clustering solutions.
- Configure and manage failover solutions to enhance database resilience and availability.
- Administer and troubleshoot EDB Postgres Advanced Server tools like EFM (EDB Failover Manager), PG Pool, and PG Bouncer.
- Database Security and Compliance:
- Implement security best practices, including role-based access control and encryption.
- Ensure compliance with regulatory and security standards.
- Manage user access and permissions securely.
- Database Cloud Migration:
- Lead cloud migration projects to AWS, GCP, or Azure.
- Design and implement strategies for minimal-downtime migrations.
- Leverage cloud-native features to optimize performance and scalability.
- Automation and Scripting:
- Develop and maintain scripts for database automation tasks using Bash, Python, or SQL.
- Use monitoring tools and write custom scripts to proactively identify issues.
- Collaboration and Documentation:
- Work closely with development teams to optimize database interactions.
- Document database architectures, processes, configurations, and troubleshooting guidelines.
- Provide training and guidance to junior DBAs.
- Database Platforms: EDB PostgreSQL, PostgreSQL, MySQL.
- Tools: pgBackRest, WAL, pgBouncer, PG Pool, PEM, MySQL Workbench, MySQL replication, EFM, and monitoring tools like Zabbix, Nagios, or Prometheus.
- Scripting: Proficiency in SQL, Bash, Python, or other automation languages.
- Cloud Platforms: AWS, GCP, Azure (experience with cloud-specific database services preferred).
- Security: Strong knowledge of database security protocols and compliance standards.
- Operating Systems: Linux (preferably Ubuntu, CentOS, or RHEL) and Windows Server.
- Strong problem-solving and analytical skills.
- Effective communication and teamwork abilities.
- Proactive approach to learning and applying new technologies.
- Occasional on-call availability for emergency troubleshooting and support.
BE OR BTech or MCA or MTech only
Interview Rounds: 2 or 3 Technical rounds
Experience Level: 6 to 10 Years
Required Candidate login to applying this job. Click here to And try again
Login to your account
Postgres SQL EDB
File types supported: .doc, .docx and .pdf | Max file size: 3 MB
or By clicking checkbox, you agree to our and
Employment Type: Full Time, Permanent
Read full job descriptionInnominds Software Interview Questions & Tips
Prepare for Innominds Software roles with real interview advice
Top Innominds Software Interview Questions
Q1. (1) write a list comprehension to print a list from 1 to 10 (2) write a program to check if a given positive integer is a power of two (3) c ... read more
Q2. Python : (1) what is recursion ? Give example ? (2)what are the different data types in python? (3)What is negative indexing in python ? (4) ... read more
Q3. What is a generator ? Have you used it in real time?
What people at Innominds Software are saying
What Innominds Software employees are saying about work life
based on 454 employees
Flexible timing
Monday to Friday
No travel
Day Shift
Innominds Software Benefits
Submitted by Company
Continuous Learning & Development End-to-End Technology Experience Cutting-Edge Tools & Technologies Mentorship & Growth Opportunities Work with Fortune 500 Clients Diversity & Inclusion
Submitted by Employees
View more benefits 
Compare Innominds Software with
Persistent Systems
Compare
LTIMindtree
Compare
Mphasis
Compare
TCS
Compare
Wipro
Compare
Tech Mahindra
Compare
HCLTech
Compare
Infosys
Compare
Cognizant
Compare
3i Infotech
Compare
Sify Technologies
Compare
NeoSOFT
Compare
Microland
Compare
Newgen Software Technologies
Compare
Clover Infotech
Compare
Sonata Software
Compare
Happiest Minds Technologies
Compare
Prodapt
Compare
Test Yantra Software Solutions
Compare
Mastek
Compare
Data Engineer with Python
4-10 Yrs
Hyderabad / Secunderabad, Pune, Bangalore / Bengaluru
Principal Engineer / Technical Lead
10-15 Yrs
Hyderabad / Secunderabad, Pune, Bangalore / Bengaluru
WMS Automation Testing
10-15 Yrs
Hyderabad / Secunderabad, Bangalore / Bengaluru
Java, Springboot, MySQLandAngular (Principal Engineer /Technical Lead)
10-15 Yrs
Hyderabad / Secunderabad
Share an Interview