We use cookies. Find out more about it here. By continuing to browse this site you are agreeing to our use of cookies.

Job posting has expired

#alert
Back to search results

Staff Database Engineer - Oracle & PostgreSQL database.

Visa
United States, Texas, Austin
August 10, 2022
Company Description

Visa is a world leader in digital payments, facilitating more than 215 billion payments transactions between consumers, merchants, financial institutions and government entities across 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.

When you join Visa, you join a culture of purpose and belonging - where your growth is priority, your identity is embraced, and the work you do matters. We believe that economies that include everyone everywhere, uplift everyone everywhere. Your work will have a direct impact on billions of people around the world - helping unlock financial access to enable the future of money movement.

Join Visa: A Network Working for Everyone.

Job Description

Primarily the architecture, engineering, deployment and support of Oracle & PostgreSQL database.

Support Database Platform Engineering in the architecture, development and deployment of Oracle and PostgreSQL Databases on LUW in high SLA environments. This includes, but is not limited to, advanced to expert engineering and implementation of the following:

  • Manage, support and maintain database technology and infrastructure, adhering to the architectural guidelines and policies.

  • Database administration for off the shelf and internally developed applications, ensure continuous 24x7 operation and availability in support of mission critical business applications and participating in on-call rotation.

  • Install, configure, monitor, upgrade and maintain Oracle and PostgreSQL databases in production and non-production environments.

  • Support local/across the DC failover with High Availability Disaster Recovery environment with Data Guard & Golden Gate for Oracle and Streaming & Logical Replications for PostgreSQL. Participate in Database Maintenance and DR activities.

  • Write/maintain Shell/Python scripts for DB automation.

  • Provide technical expertise and hands-on support in consolidation and migration of databases to new hardware and platforms.

  • Physical implementation of databases, storage structures, high-availability solutions, replication, and disaster recovery solutions.

  • Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of escalated Level 2 and Level3 issues.

  • Regular database capacity planning related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.

  • Work closely with other Infrastructure engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA's and performance targets.

  • Adapt business requirements, model data, and develop database specifications, table and element attributes.

  • Participate in the evaluation, selection and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing.

  • Work well as a team and as an individual with minimal supervision.

This is a hybrid position. Hybrid employees can alternate time between both remote and office. Employees in hybrid roles are expected to work from the office two days a week, Tuesdays and Wednesdays with a general guidepost of being in the office 50% of the time based on business needs.

QualificationsBasic Qualifications:

5 or more years of relevant work experience with a Bachelor's Degree or at least 2 years of work experience with an Advanced degree (e.g. Masters, MBA, JD, MD) or 0 years of work experience with a PhD

Preferred Qualifications:

6 or more years of work experience with a Bachelor's Degree or 4 or more years of relevant experience with an Advanced Degree (e.g. Masters, MBA, JD, MD) or up to 3 years of relevant experience with a PhD

*7 years of relevant IT experience with a Bachelor's Degree or an Advanced Degree e.g. Masters
*5 years of DB Engineering/Administration experience primarily with Oracle and PostgreSQL databases
*Retrieving data. Wait a few seconds and try to cut or copy again.
*Bachelor or Master Degree in Computer Science or related field
*7-10 years of DBA experience managing Oracle & PostgreSQL databases
*4-5 years of experience managing complex bi-directional replication topology
*Strong understanding of Oracle & PostgreSQL database fundamentals and Architecture.
*Strong understanding of Oracle Golden Gate fundamentals
*Strong understanding of Oracle Data Guard fundamentals
*Strong understanding of Oracle & PostgreSQL database security management
*Strong understanding of PostgreSQL streaming and logical replication
*Should have good Troubleshooting and Performance Improving Skills including index creation, query optimization, schema changes etc.
*Good experience with Python/Ruby/Shell scripting and experience in configuration management tools like Ansible
*Configuring PostgreSQL monitoring using Prometheus, Grafana.
*Ability to modify and integrate Open source database and related products and develop solutions to achieve required capabilities for Persistence/DB layer.
*UNIX/Linux platform skills and understanding of operating system, network, storage and security.
*Prior programming experience specially with Microservice architecture will be a plus
*Nice to have: Experience with CI/CD pipeline and code versioning tools such as GitAdditional InformationVisa has adopted a COVID-19 vaccination policy to safeguard the health and well-being of our employees and visitors. As a condition of employment, all employees based in the U.S. are required to be fully vaccinated for COVID-19, unless a reasonable accommodation is approved or as otherwise required by law.

Work Hours: Varies upon the needs of the department.

Travel Requirements: This position requires travel5-10% of the time.

Mental/Physical Requirements: This position will be performed in an office setting. The position will require the incumbent to sit and stand at a desk, communicate in person and by telephone, frequently operate standard office equipment, such as telephones and computers.

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.

Visa will consider for employment qualified applicants with criminal histories in a manner consistent with applicable local law, including the requirements of Article 49 of the San Francisco Police Code.

(web-b98ddf86b-x7kxg)