Overview
This position leads support for software and hardware infrastructure related to database technologies at a high level of complexity. Supports database infrastructure for the Bank's sales, service, and corporate support applications through expertise and daily performance monitoring. Implements, upgrades, and tests technical systems. Resolves escalated technical issues reported by users or system alerts. Drives operational excellence and systems efficiency, providing continuous service both through daily activities and through on-call rotation for after hours support. Implements disaster recovery testing and may provide oversight to technical associates or projects.
Responsibilities
Design, implement, and maintain data replication strategies using Qlik replicate across Hybrid environments (AWS, On-prem, and mainframe).
Experience with Qlik Cloud and migration from on-prem Qlik replicate to the cloud.
Design, implement, and support the QLIK ARC(Attunity Replicate Connect) solution. Manage Mainframe replication support with Qlik.
Solid understanding for batch and real-time replication.
Lite ETL for replication and support
Support Monitor and tune performance of databases, replication tasks, and reporting services.
Develop and maintain documentation related to database architecture, configurations, and processes.
Lead troubleshooting efforts and root cause analysis for data and replication related issues.
Participate in upgrades, patching and migrations with the replication tools (Qlik, Golden Gate)
Work closely with data governance, security and compliance teams to ensure data protection and regulatory compliance.
Collaborate with business and technical teams using Qlik replication, light ETL and CDC processes.
This position's responsibilities include daily production support for our database replication environments (Qlik replicate ), Server database administration. The position includes the design, configuration and support in all aspects of our environment for both on-prem and in the cloud.
This position is also responsible for maintaining and managing the standards, documentation, backup and recovery, design and implementation of the physical data storage, virtualization of databases, maintenance, patching, installation, capacity planning, access, security administration (vulnerability assessment and protection of data), performance and availability, data integrity, support of the BI infrastructure technology, and troubleshooting of all assigned database issues.
Qualifications
Bachelor's Degree and 4 years of experience in Database Engineering OR High School Diploma or GED and 8 years of experience in Database Engineering
Preferred Qualifications :
Experience with Oracle Golden Gate replication(23AI preferred)
Experiences with Oracle Veridata comparison tool a plus
Experience with Tableau, QlikView, and PowerBi.
Experience with virtualized databases on VMWare.
Experience with Service NOW and ITIL processes.
Experience with SDLC processes.
Certifications a plus.
Benefits are an integral part of total rewards and First Citizens Bank is committed to providing a competitive, thoughtfully designed and quality benefits program to meet the needs of our associates. More information can be found at https : / / jobs.firstcitizens.com / benefits.
Company Description :
Founded in 1898 and headquartered in Raleigh, N.C., First Citizens Bank serves customers in 18 states and the District of Columbia. For over 100 years, customers have trusted First Citizens with their money … and their futures. Today, First Citizens is the largest family-controlled bank in the nation and the sixth-largest bank franchise headquartered in the Southeast with more than $30 billion in assets. We employ more than 6,000 associates who are focused on helping our customers achieve a lifetime of success. First Citizens operates more than 570 branches in Arizona, California, Colorado, District of Columbia, Florida, Georgia, Kansas, Maryland, New Mexico, Missouri, North Carolina, Oklahoma, Oregon, South Carolina, Tennessee, Texas, Virginia, Washington and West Virginia.
First Citizens Bank. Forever First®. Member FDIC.
Equal Opportunity / Affirmative Action Employer / Minority / Female / Disability / Veteran
If you need special assistance or an accommodation in applying for employment at First Citizens Bank, please contact our Human Resources department.
Database Engineer • Raleigh, NC, US