Sr. SQL Server DBA

Job Description:

• Seasoned Sr. Database administrator (DBA) with deep experience in managing and maintaining data replication (Qlik replicate) in both Cloud and On-premises environments.

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 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.
• Optional experience with Oracle Golden Gate replication(23AI preferred)
• Experiences with Oracle Veridata comparison tool a plus
• 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 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.

Basic Qualifications for the 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 Power BI.
• Experience with virtualized databases on VMWare.
• Experience with Service NOW and ITIL processes.
• Experience with SDLC processes.
• Certifications a plus.