We are looking an immmediate joiner for Delhi Location(WFO). Job Description: PostgreSQL DBA Job Summary: We are looking for an experienced PostgreSQL Database Administrator (DBA) to lead our database administration and data migration activities, specifically for CRM applications deployed on cloud instances. The ideal candidate will have a strong background in PostgreSQL administration, data migration, and cloud infrastructure, and will play a key role in ensuring database performance, security, and availability during the cloud migration process. Key Responsibilities: · Database Administration: · Manage and maintain PostgreSQL databases across cloud instances, ensuring high availability, performance, and security. · Perform routine database administration tasks such as monitoring, tuning, and backups. · Implement and maintain database clustering, replication, and partitioning strategies to support scalability and performance. · Data Migration: · Lead the data migration process from on-premise CRM applications to cloud-based PostgreSQL instances. · Develop and execute data migration plans, including data mapping, data transformation, and validation strategies. · Ensure data integrity and minimal downtime during migration activities. · Performance Tuning and Optimization: · Monitor database performance and optimize queries, indexing, and schema design to improve performance. · Proactively identify performance bottlenecks and resolve them to ensure smooth database operations. · Implement database monitoring tools and alerts to quickly detect and address issues. · Cloud Instance Management: · Work with cloud platforms (such as GCP, AWS, or Azure) to manage PostgreSQL instances in cloud environments. · Ensure the cloud database environment adheres to security and compliance standards. · Implement best practices for cloud-based database backup, disaster recovery, and high availability. · Security & Compliance: · Implement database security measures, including access controls, encryption, and auditing. · Ensure compliance with industry standards and organizational policies related to data security and privacy. · Collaboration & Documentation: · Collaborate with application teams, DevOps, and cloud engineers to ensure seamless integration between databases and applications. · Document all database configurations, procedures, and migration plans. · Provide technical support and guidance to internal teams regarding database best practices. Skills and Qualifications: · Technical Skills: · 3-5 years of experience working as a PostgreSQL DBA, with strong experience managing databases in cloud environments. · Experience with cloud platforms such as Google Cloud Platform (GCP), AWS, or Azure for managing PostgreSQL databases. · Proficiency in data migration from on-premise databases to cloud instances. · Strong knowledge of database performance tuning, query optimization, and indexing strategies. · Experience with high availability and disaster recovery configurations, such as replication and clustering. · Familiarity with security best practices for databases, including encryption, role-based access control (RBAC), and auditing. · Soft Skills: · Strong problem-solving and analytical skills to diagnose and resolve database-related issues. · Excellent communication skills for collaborating with cross-functional teams. · Ability to work independently and manage multiple tasks in a fast-paced environment. · Certifications (Preferred but not mandatory): · Certified PostgreSQL DBA or similar certifications. · Cloud certifications related to database management, such as AWS Certified Database – Specialty or Google Cloud Professional Database Engineer, are a plus. Education: Bachelor’s degree in Computer Science, Information Technology, or a related field. Relevant certifications in database management or cloud platforms are a plus. Additional Information: Opportunity to lead large-scale data migration projects for CRM applications on cloud infrastructure. Work with cutting-edge cloud technologies and collaborate with cross-functional teams. Show more Show less
As a PostgreSQL Database Administrator (DBA) at our company, you will be responsible for leading database administration and data migration tasks for CRM applications deployed on cloud instances. Your expertise in PostgreSQL administration, data migration, and cloud infrastructure will be essential in ensuring database performance, security, and availability during the cloud migration process. Your responsibilities will include managing and maintaining PostgreSQL databases across cloud instances, implementing database clustering, replication, and partitioning strategies, and performing routine tasks such as monitoring, tuning, and backups. You will also lead the data migration process from on-premise CRM applications to cloud-based PostgreSQL instances, ensuring data integrity and minimal downtime. Monitoring database performance, optimizing queries, and implementing security measures will be crucial aspects of your role. You will work with cloud platforms like Google Cloud Platform (GCP), AWS, or Azure to manage PostgreSQL instances, ensuring compliance with security and industry standards. Collaboration with application teams, DevOps, and cloud engineers is necessary to ensure seamless integration between databases and applications. To excel in this role, you should have 3-5 years of experience as a PostgreSQL DBA, proficiency in data migration to cloud instances, and knowledge of database performance tuning and security best practices. Strong problem-solving skills, excellent communication abilities, and the capacity to work independently in a fast-paced environment are essential. While certifications like Certified PostgreSQL DBA or cloud-related credentials are preferred, a bachelor's degree in Computer Science or Information Technology is required. This position offers the opportunity to lead large-scale data migration projects for CRM applications and work with cutting-edge cloud technologies in a collaborative environment.,
Description Key Responsibilities : Install, configure, and maintain PostgreSQL databases across development, testing, and production environments. Perform regular database backups, restorations, patching, and version upgrades. Ensure database availability, reliability, and scalability. Monitor database performance, identify bottlenecks, and implement tuning strategies. Optimize queries, indexing, memory configuration, and storage utilization. Conduct capacity planning to ensure efficient resource allocation. Design and implement database schemas, tables, views, indexes, and constraints. Support development teams with data modeling, normalization, and SQL best practices. Ensure database architecture meets business requirements for scalability and efficiency. Diagnose and resolve database-related issues, including performance problems, replication failures, and data inconsistencies. Perform root cause analysis and implement preventive actions. Implement and manage PostgreSQL replication solutions (Streaming Replication, Logical Replication, etc.). Ensure high availability (HA), failover readiness, and disaster recovery strategies. Work on backup solutions and maintain DR procedures. Enforce database security policies, user access management, and role-based permissions. Implement encryption, auditing, and compliance controls as required. Regularly review logs, monitor suspicious activity, and maintain security hygiene. Work closely with application, DevOps, and infrastructure teams to support seamless deployments and database interactions. Prepare and maintain documentation for database configurations, processes, and troubleshooting guides. Communicate technical concepts clearly to internal teams. Qualifications Strong experience 3+ Years in PostgreSQL Database Administration, including maintenance, backups, and upgrades. Proficiency in Database Design to support business applications with scalability and efficiency. Ability to perform Troubleshooting and technical issue resolution with databases. Knowledge of Replication techniques for data synchronization and high availability. Familiarity with PostgreSQL systems and related tools is highly desirable. Good analytical and problem-solving skills. Effective communication and collaboration abilities within a team environment. Preferred qualifications include a degree in Computer Science, Information Technology, or a related field, and any relevant database management certifications. (ref:hirist.tech)
As a PostgreSQL Database Administrator, your role involves the installation, configuration, and maintenance of PostgreSQL databases in various environments. You will be responsible for ensuring database availability, reliability, and scalability. Your key responsibilities include: - Installing, configuring, and maintaining PostgreSQL databases in development, testing, and production environments. - Performing regular database backups, restorations, patching, and version upgrades. - Monitoring database performance, identifying bottlenecks, and implementing tuning strategies. - Optimizing queries, indexing, memory configuration, and storage utilization. - Conducting capacity planning for efficient resource allocation. - Designing and implementing database schemas, tables, views, indexes, and constraints. - Supporting development teams with data modeling, normalization, and SQL best practices. - Diagnosing and resolving database-related issues, including performance problems, replication failures, and data inconsistencies. - Implementing and managing PostgreSQL replication solutions for high availability and disaster recovery. - Enforcing database security policies, user access management, and role-based permissions. - Communicating technical concepts clearly to internal teams. Your qualifications for this role include: - Strong experience of 3+ years in PostgreSQL Database Administration, covering maintenance, backups, and upgrades. - Proficiency in Database Design to support business applications effectively. - Ability to troubleshoot and resolve technical issues with databases. - Knowledge of replication techniques for data synchronization and high availability. - Familiarity with PostgreSQL systems and related tools is highly desirable. - Good analytical and problem-solving skills. - Effective communication and collaboration abilities within a team environment. Preferred qualifications include a degree in Computer Science, Information Technology, or a related field, along with relevant database management certifications. Please note that the Job Description is based on the information provided and additional details about the company were not included in the job description.,
As an experienced PostgreSQL Database Administrator (DBA) at our company, your role will involve leading database administration and data migration activities for CRM applications deployed on cloud instances. **Key Responsibilities:** - Manage and maintain PostgreSQL databases across cloud instances to ensure high availability, performance, and security. - Perform routine database administration tasks such as monitoring, tuning, and backups. - Implement and maintain database clustering, replication, and partitioning strategies for scalability and performance. - Lead the data migration process from on-premise CRM applications to cloud-based PostgreSQL instances. - Develop and execute data migration plans, including data mapping, transformation, and validation strategies. - Monitor database performance, optimize queries, indexing, and schema design to improve efficiency. - Work on cloud platforms (such as GCP, AWS, or Azure) to manage PostgreSQL instances in cloud environments. - Implement database security measures, compliance standards, and best practices for backup and disaster recovery. - Collaborate with application teams, DevOps, and cloud engineers for seamless integration and provide technical support. - Document all database configurations, procedures, and migration plans. **Skills And Qualifications:** **Technical Skills:** - 3-5 years of PostgreSQL DBA experience, managing databases in cloud environments. - Proficiency in data migration to cloud instances and performance tuning strategies. - Experience with high availability, disaster recovery configurations, and security best practices. **Soft Skills:** - Strong problem-solving and analytical skills. - Excellent communication skills for collaborating with cross-functional teams. - Ability to work independently and manage multiple tasks efficiently. **Certifications (Preferred But Not Mandatory):** - Certified PostgreSQL DBA or similar certifications. - Cloud certifications related to database management (e.g., AWS Certified Database Specialty) are advantageous. **Education:** - Bachelors degree in Computer Science, Information Technology, or related field. - Relevant certifications in database management or cloud platforms are a plus. In addition to the above, you will have the opportunity to lead large-scale data migration projects for CRM applications on cloud infrastructure and work with cutting-edge cloud technologies while collaborating with cross-functional teams. As an experienced PostgreSQL Database Administrator (DBA) at our company, your role will involve leading database administration and data migration activities for CRM applications deployed on cloud instances. **Key Responsibilities:** - Manage and maintain PostgreSQL databases across cloud instances to ensure high availability, performance, and security. - Perform routine database administration tasks such as monitoring, tuning, and backups. - Implement and maintain database clustering, replication, and partitioning strategies for scalability and performance. - Lead the data migration process from on-premise CRM applications to cloud-based PostgreSQL instances. - Develop and execute data migration plans, including data mapping, transformation, and validation strategies. - Monitor database performance, optimize queries, indexing, and schema design to improve efficiency. - Work on cloud platforms (such as GCP, AWS, or Azure) to manage PostgreSQL instances in cloud environments. - Implement database security measures, compliance standards, and best practices for backup and disaster recovery. - Collaborate with application teams, DevOps, and cloud engineers for seamless integration and provide technical support. - Document all database configurations, procedures, and migration plans. **Skills And Qualifications:** **Technical Skills:** - 3-5 years of PostgreSQL DBA experience, managing databases in cloud environments. - Proficiency in data migration to cloud instances and performance tuning strategies. - Experience with high availability, disaster recovery configurations, and security best practices. **Soft Skills:** - Strong problem-solving and analytical skills. - Excellent communication skills for collaborating with cross-functional teams. - Ability to work independently and manage multiple tasks efficiently. **Certifications (Preferred But Not Mandatory):** - Certified PostgreSQL DBA or similar certifications. - Cloud certifications related to database management (e.g., AWS Certified Database Specialty) are advantageous. **Education:** - Bachelors degree in Computer Science, Information Technology, or related field. - Relevant certifications in database management or cloud platforms are a plus. In addition to the above, you will have the opportunity to lead large-scale data migration projects for CRM applications on cloud infrastructure and work with cutting-edge cloud technologies while collaborating with cross-functional teams.