Job Directory SQL Database Analyst, Staff

SQL Database Analyst, Staff
Frisco, TX

Companies like
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.


Job Description

What does a great SQL Database Analyst Staff do?

The Biller Solutions Division within Fiserv offers hosted technology solutions for consumer billing and payment to companies of all sizes and industries. Our solutions equip companies with the ability to offer their consumer base electronic paperless billing (e-bills) and electronic payments (one-time, card funded, recurring, registered, ACH funded, etc.) in channels including the company's website, bank or financial institution websites, via the phone or through walk-in locations.

Essential Job Responsibilities:

* You will be proficient in SQL Development and Code, ability to fix SQL Code and Design, including Stored Procedures, functions, tables, and constraints.
* You should have deep understanding and experience of Advanced Stored Procedures, including data flow and logic in stored procedures to bypass issues and optimize as needed.
* Deep understanding of Bi-Di Replication and ability to utilize Redgate to identify Replication Out of Sync Records and fix.
* Understanding of Seed Identity Range and how records are written within a Bi-Di Replication Environment without causing Identity Range conflicts.
* Deep understanding of ETL (Extract, Transform and Load) to troubleshoot and resolve File Loading failures.
* High emphasis on Dev (Code) DBA skills
* Hands on experience with Oracle databases. (85% SQL, 15% Oracle in this position)
* Requires very strong TSQL skillset. Build and debug complex stored procedures and triggers. Proficient with multi-table joins and schema. Build reports on demand.
* Technically proficient with SQL Service Integration Services. Understand data flow and remediate issues. Craft new SSIS reported on demand to process files and reports. Convert DTS packages to SSIS
* SQL Server Reporting services, create new SSRS reports on demand from customers.
* Experience and understanding of 3rd Party Applications such as Redgate, Splunk, and Foglight
* Willing to handle flexible schedule for rotating on call shift that requires nights and weekend coverage (1 out of every 5 weeks)
* Experience working with Vendors, Partners, and Customer IT Teams to resolve high visibility and high priority issues.
* Troubleshoot and resolve Incidents pertaining to Payment Processing, Payment Settlement, Reporting, and Password.
* Apply corrections and adjustments to Database records while adhering to Industry Best Practice methods
* You will communicate progress and any potential problems to manager/project for awareness and/or resolution.

Basic qualifications for consideration:

* High School Diploma or GED Required
* 5+ years of experience in in MS SQL Database Production Support Enterprise Environment
* Hands on experience with Replication and working with dated records to sync.

Preferred qualifications for consideration:

* Bachelor Degree in Information Technology or related discipline
* MS SQL Server DBA Certification is preferred
* Experience working with Redgate
* 2+ years in Financial Services industry - In depth understanding of Payment Industry and Systems, including Controls and Regulatory Compliance preferred.

Who We Are:

Biller Solutions partners with our clients to deliver high quality, competitive, and innovative services that meet their key business objective to provide both comprehensive solutions and choice for their customers in how they view billing information digitally and pay their bills. Our services allow customers to view and/or pay bills through various channels including but not limited to a biller's web site, via a mobile device, utilizing their phone (voice or keypad) to access an IVR (interactive voice response unit), at their bank web site, and by walking into one of over twenty-seven thousand Fiserv agent locations, such as Walmart. Our solutions are geared toward clients in 6 key vertical sectors: utility, telecom, insurance, healthcare, and lending as well as both retail chains and individual agent locations.

Biller Solutions is a fast- paced, results-oriented environment focused on elevating all aspects of our performance to deliver excellence in everything we do and deliver on the core values of Fiserv for our clients and their customers, our associates, and our shareholders.

Fiserv is an Equal Opportunity Employer/Disability/Vet.

Learn more about us.

In a world moving faster than ever before, Fiserv helps clients deliver solutions in step with the way people live and work today - financial services at the speed of life. With 24,000 associates, we help more than 12,000 clients worldwide create and deliver solutions to enable today's consumer to move and manage money with ease, speed and convenience. Our Aspiration is to move money and information in a way that moves the world. As a FORTUNE™ 500 company and one of FORTUNE Magazine World's Most Admired Companies for the sixth consecutive year, we are committed to excellence and purposeful innovation.

We welcome and encourage diversity in our workforce. We are an equal opportunity employer/disability/vet.

In this role, you will be aligned with our Biller Solutions products and services. People want to handle their bills and payments how, when and where they want, seamlessly integrating these tasks into their lives. Our multichannel solutions reach customers via mobile, online banking, biller website, walk-in, IVR and CSR channels.

We welcome and encourage diversity in our workforce. We are an equal opportunity employer/disability/vet.

Explore the possibilities of a career with Fiserv and Find Your Forward with us.

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.