Senior Postgresql Database Administrator

• As part of this program multiple applications are impacted with strategic changes across portfolio.
• We are looking for strong DBA to support program with the Postgre SQL experience to join our team of professional engineers across the globe.
• Responsibilities: Google knowledge on Azure, AWS, and Google Cloud technologies.
• Familier on PostgreSQL provision, configuration and management.
• Creating database objects (triggers, indexes, etc.
• ) Monitoring and ensuring database performance in cloud environments.
• Identifying potential issues with the database and resolving them in a timely manner to ensure optimal performance and reliability.
• Ensuring the maintenance of backups and conducting disaster recovery operations in accordance with business requirements and standards.
• Monitoring security and preventing unauthorized access and follow compliance procedures.
• Scheduling server maintenance in accordance with business requirements, after coordinating with all relevant stakeholders to ensure minimal disruption and optimal timing.
• Providing best practice guidance to the development/application/stake holders.
• Resolving production data issues as per given SLA timeline to avoid major incidents.
• Managing tablespaces and roles as per given security standards.
• Developing automation technologies for data loading and data refresh activities.
• Database Migrations between cross platforms (Oracle, MS SQL and DB2) into Multi Cloud (Azure, AWS and GCP) PostgreSQL database technology.
• Ensuring data integrity and managing user access and permissions as per the organization standards.
• Using utilities like PgAdmin4, Azure Data studio and psql for database maintenance.
• Mandatory Skills Description: A minimum of 5 years of experience is required in PostgreSQL database technology, specifically with multi-cloud environments including Azure, AWS, and GCP tenants.
• Proven previous experience as a PostgreSQL DBA or similar role.
• In-depth understanding of database management and security.
• Strong problem-solving and communication skills.
• - Responsible for managing a firm''s PostgreSQL databases in multi-cloud environments (Azure, AWS, and GCP), ensuring smooth operation and functionality to meet business goals.
• Experience in optimizing database performance, managing database issues and backups for point-in-time recovery, disaster recovery, and monitoring security and access management as per business requirements.
• Experience in Multi Cloud tenant(Azure, AWS, and GCP) to provision the PostgreSQL PaaS solution and configure as per security standards.
• Experienced in database migrations across platforms from legacy databases (SQL, Oracle, and DB2) to multi-cloud PostgreSQL PaaS databases.
• Understanding access management to ensure database security.
• This includes controlling who can access the database and to what extent, as well as removing inactive users when necessary.
• Problem-solving is another crucial soft skill.
• Given that troubleshooting is a key responsibility, the candidate must be adept at identifying and addressing potential issues swiftly.
• They should be capable of devising quick and effective solutions to resolve these problems efficiently.
• Effective communication skills are crucial for collaborating with the application team and stakeholders to comprehend business requirements and deliver DBA support during AMS working hours.
• This involves actively engaging with team members and stakeholders to ensure clear understanding and alignment on project goals.
• Additionally, providing timely and efficient DBA support during AMS working hours is essential for maintaining smooth operations and addressing any issues that may arise.
• PostgreSQL DBA (Database Administrator) is responsible for managing and optimizing the PostgreSQL database system on multi-cloud (Azure, AWS, and GCP) tenant and provide support on AMS working hours.
• Nice-to-Have Skills Description: Bachelor''s degree in computer science, Information Technology, or a related field.
• - Multi Cloud (Azure/AWS/GCP) Certified Professional.
• Languages:English: B2 Upper Intermediate

Caderno Nacional