Database Administrator

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

You will execute the following tasks in the database field
    Maintain creation and upgrade scripts for database builds on a variety of database platforms (Oracle, Postgres and DB2) but mainly Postgres database.
    Investigation and trouble-shooting with regard to in-house and customer issues related to database.
   Improve human processes for managing scripts: factors include meeting project deadlines, maintenance of different code branches, support for continuous integration testing and change control
    Reviewing and enforcing best practice in the data model, ensuring system scalability, security, performance and reliability
    Design, build and upkeep of performance and volume testing strategy 
    Communication: consultation with colleagues, aimed at aligning related work and exchanging knowledge, ideas and experiences. Periodically you will provide the responsible manager with progress reports and participate in the developer meetings 
    Support the implementation, troubleshooting, and maintenance of DEV and QA DB systems
    Work directly with business analysts, developers and architects on data modeling, logical physical schema design, SQL query tuning and the application of data related business rules while assisting in troubleshooting, debugging, and issue resolution
   Review and deploy Developer generated code into the test and production system and monitor code deployed for performance or reliability issues
Write custom scripts to automate various daily DBA operations
    Create and maintain database documentation and guidelines for the developers
   Understanding the difference of OLAP and OLTP and the benefits and uses of each
    Refresh DEV and QA databases as necessary 
    Strong understanding of query execution plans and query optimization strategies, including issues related not only to indexing, but also locking, wait types, blocking, and deadlocks
   on call stand-by rotation.

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 2-3 set days a week (determined by leadership/site), with a general guidepost of being in the office 50% or more of the time based on business needs.

Qualifications

Requested experience and knowledge
A relevant bachelors or masters degree and extended experience with or knowledge of the Oracle and DB2 database
Experience with High Availability (HA) database design, management, performance analysis and tuning, index maintenance, disaster recovery, and data monitoring
Excellent verbal and written communication skills in English
Nice to have
Knowledge of other databases (MS SQL Server, MySQL)
Knowledge of version control systems such as Git
Any experience of the following: J2EE, RESTful, XML, JDBC, SQL, Application Servers (Websphere, Jboss, Wildfly, Tomcat), open source frameworks (Spring and Hibernate ORM), Windows, Unix and Eclipse, IntelliJ
Knowledge of mobile payment, smart card and internet technologies
Any database admin certifications


Your personal skills
Learning ability, problem solving ability and planning/organizing skills. You are quality oriented, accurate and a team player. Also good communication skills and a customer oriented attitude will make you the candidate we are looking for.

Additional Information

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.