Database Administrator
- Full-time
- Job Family Group: Engineering and Technology
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 of Postgres Database and HA Solutions
- Experience with or knowledge of Oracle and DB2 databases
- Experience with High Availability (HA) database design, management, performance analysis and tuning, index maintenance, disaster recovery, and data monitoring like:
- Pglogical Replication, Q-Replication for DB2, Barman, Oracle GoldenGate, Prometheus/Grafana for Monitoring and/or similar technologies
- 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
By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply