Database Engineer - Sr.Consultant Level - PostgreSQL DBA

Visa is a world leader in payments and technology, with over 259 billion payments transactions flowing safely between consumers, merchants, financial institutions, and government entities in more than 200 countries and territories each year. Our mission is to connect the world through the most innovative, convenient, reliable, and secure payments network, enabling individuals, businesses, and economies to thrive while driven by a common purpose – to uplift everyone, everywhere by being the best way to pay and be paid.

Make an impact with a purpose-driven industry leader. Join us today and experience Life at Visa.

This role is for Database Engineering team. Database Engineering team is part of Platform as a Service (PaaS) division under Operations & Infrastructure org. The team is responsible to architect, design and build highly available and reliable, secure and cost-effective database solutions. The team is responsible for delivering multiple database technologies (both RDBMS and NoSQL) and automated services to provision and manage databases on premise and in public cloud.

The role is for highly experienced database engineer with expertise in PostgreSQL and Oracle DB technologies. The responsibilities include, but are not limited to

• Architect, design and build deployment standards of PostgreSQL and Oracle DB technologies
• Develop and maintain scripts for database automation tasks using Python, Ansible, or similar languages.
• Implement Infrastructure as Code practices using tools like Terraform, Ansible, or CloudFormation.
• Develop and implement robust backup and recovery strategies ensuring databases are protected against data loss and can be recovered in case of failure.
• Maintain comprehensive documentation for database configurations, procedures, and policies.
• Set up and maintain database monitoring tools to ensure database health and performance.
• Troubleshoot and resolve database related issues in a timely manner as part of Level-3 support
• Provide technical influence and subject matter expertise for the database technologies, tackling complex problems and identifying innovative solutions
• Work closely with our development teams to ensure database designs align with application requirements, leading to more efficient and effective application development.
• The role serves as a technical and functional specialist, working independently with guidance only in the most challenging situations.

This is a hybrid position. Expectation of days in office will be confirmed by your Hiring Manager.

Basic Qualifications:

• 10+ years of relevant work experience with a Bachelor’s Degree or at least 8+ years of experience with an Advanced Degree (e.g. Masters, MBA, JD, MD) or 6+ years of work experience with a PhD, OR 10+ years of relevant work experience.

Preferred Qualifications:

• 10 or more years of relevant work experience with a Bachelor Degree or 8 or more relevant years of experience with an Advanced Degree (e.g. Masters, MBA, JD, MD) or 6 or more years of experience with a PhD
• 6+ years of DB Engineering/Administration experience primarily with PostgreSQL and Oracle databases
• 8-10 years of DBE/DBA experience primarily with PostgreSQL and Oracle DB technologies both on premise and public cloud.
• 3+ years of experience managing complex bi-directional replication topology
• Good experience with Python, Ansible and IAC-Terraform scripting
• Experience with public cloud services such as AWS, Google Cloud Platform, or Microsoft Azure
• Strong understanding of PostgreSQL & Oracle database fundamentals and Architecture.
• Strong understanding of PostgreSQL streaming and logical replication and experience with repmgr and pglogical
• Good understanding and experience with Oracle Golden Gate and Oracle Data Guard
• Experience with PostgreSQL tools (e.g. Barman, PgBouncer) and prominent PostgreSQL extensions
• Experience configuring PostgreSQL monitoring using Prometheus, Grafana.
• Knowledge of DevOps tools e.g. GIT, Jenkins
• Should have good Troubleshooting and Performance Improving Skills including index creation, query optimization, change in data model
• Strong Unix/Linux platform skills and understanding of network, storage, tiered application environments and security.
• Good interpersonal skills along with effective communication skills.
• Demonstrate ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs.

Visa is an EEO Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Visa will also consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law.