Postgres SQL EDB
- Innominds Software
- 6 - 10 years
- Delhi, NCR
- 11 months ago
- Email to a friend
- Report this 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 File types supported: .doc, .docx and .pdf | Max file size: 3 MB
or By clicking checkbox, you agree to our and
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: Innominds SoftwareLocation(s): Delhi, NCR+ View Contact
Keyskills: Performance tuning Automation Linux Database design Postgresql MySQL Disaster recovery Windows RHEL Python
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Innominds Software
Innominds Software Inc., a fast growing Software Product Engineering Services company
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in