Database Engineer- Qlik Replicate/ETL

Database Engineer- Qlik

Location: Raleigh, NC, Morristown, NJ, Phoenix, AZ, OR Dallas, TX On site 1 day per week, remote 4 days Job Duration: 12 months- extensions expected

Interview Process: 2 rounds, technical

Start Date: 10/1

Reason for need: Sunsetting Qlik replicate and moving to Qlik cloud

Seasoned Sr. Database administrator (DBA) with deep experience in managing and maintaining data replication platforms, particularly Qlik replicate both Cloud and on-premises environments. The individual should also have hands-on experience with Oracle Goldengate and possess advanced skills in SQL across a range of database technologies. Experience with Microsoft SQL Reporting services (SSRS/SSIS/SSAS) is a plus. This role requires a strong mix of strategic thinking and hands-on execution to ensure high availability, performance, and integrity of enterprise data systems. Qualifications and 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
• 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.
• Experience with Oracle GoldenGate replication (23AI preferred)
• Experiences with Oracle Veridata comparison tool
• Knowledge of replication across multi-heterogeneous databases and across multiple datacenters (on-prem and cloud)
• Collaborate with business and technical teams using Qlik replication, light ETL and CDC processes.

This position's responsibilities include daily production support for the SQL Server database infrastructure. These database platforms are maintained on Windows Server and Linux Operating Systems on both physical and virtual footprints. Virtual servers are managed on V-Sphere using VMWare. 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. Basic Qualifications for position: Associate degree and a minimum of 6 years work experience as a SQL Server DBA in an enterprise data center environment OR High School Diploma or GED and a minimum of 10 years work experience as a SQL Server DBA in an enterprise data center environment. Additional Requirements: Provide oversight, mentoring and leadership to less experienced staff. Provide on-call support for production environment, conduct root cause analysis for issues. Assist development teams with development, testing, tuning and implementation of database applications. Possess experience with virtualization of database platforms and environments. Provide proactive monitoring of the database instances and take preventive steps to ensure high availability and optimal performance. Strong technical abilities, quick study of new technology via on-the-job training, the intellect to resolve complex problems logically and methodically, and good judgment to involve and communicate with vendors, senior level technicians, and management. Ability to be on call 24 x 7 and participate in an on-call rotation. Must demonstrate ability to work in a team-oriented environment and effectively communicate both orally and in writing with peers and customers. Other Preferred Qualifications: 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.