My Shortlist

Your shortlisted jobs will appear here. To view your shortlist, please login or register

DATE ADDED: Mon 24/09/2018

SQL Developer - Digital Video Technology Company

New York, USA


Job Description

SQL Developer

Plainview, Long Island, NY

You will be responsible for interfacing and collaborating with several departments such as Development, Finance, Payment Provider, Project Managers, Customer Support, Executives to understand the requirement and provide the swift, timely and effective solution to satisfy the requirement. You will lead the billing operation team and help prioritize billing operations task with SVP Operation. The position requires maintaining and evolving the CDN log processing via AWS EMR, SPARK, data pipeline and AWS Redshift database.

Billing Operation:

" Payment gateway and processor configuration and verification of various payment methods like Credit Cards, Paypal, Country specific local payment methods and wallet payment methods.
" Manage, maintain, and report on the daily results of billing activity, data, processes and subscription renewals.
" Manage and monitor issues arising with payment service providers.
" Assist Support, NOC, QA and Development team to troubleshoot production payment related issues.
" Work with payment providers to understand and address new requirements/initiatives.
" Customer and billing information import and export.
" Manage monthly financial settlement and CDN / storage reports for Finance month end activities.
" Play integral role to support the Finance month, quarter and year end reporting needs.

CDN Logs processing Operation:

" Design, implement and maintain CDN log big data pipeline for CDN usage billing processing petabytes of raw logs from multiple CDNs.
" Create, validate and reconcile monthly CDN billing reports for all clients.
Work with CDN partners to troubleshoot and resolve CDN log ingestion or reconciliation issues.

Reporting Operation:

" Work with project management and Finance team to understand and implement the ad-hoc or automated custom reporting scheduled tasks.
" Manage, maintain, and report on the daily results of data feed data and processes both internally and externally.
" Work with project management and account management team members in the migration and ETL processes of data between systems.
" Work with platform development team to assure and validate daily datafeed integrity issues.

What you bring to the table:
" 8-10 years of strong experience with SQL, schema design, and DBMS. Must have at least 4 years for MS SQL Server DBMS experience. Candidates without strong SQL experience will NOT be considered.
" Must have 3 years of experience working with payment providers and must have overall payment processing knowledge. Knowledge of wallet payment method is nice to have. Must have
" Must have 5 years of experience of troubleshooting and fixing very critical and sensitive data related issues in production database.
" Must have 3-5 AWS EMR, Data pipeline, Hive, Spark, lambda, EC2 and Redshift experience or equivalent experience in Hadoop Hive or Spark clustered database for big data or big table dealing with at least 5-6 billion rows.
" Must have 3-5 years of experience managing 3-5 members team.
" 5 years of experience with big data integration / modeling software like Talend.
" Experience with some type of scripting language like perl / python is nice to have.
" Strong ability to pickup and learn new skills and concepts.
" Complex problem solving skills.
" Excellent Analytical skills.
" Strong Communication skills.
" Strong Organizational skills
" Ability to work and contribute in a team environment.

Please send me a copy of your resume. I'll give you a call after reviewing your resume.

Due to the large volume of applications we receive, we will only be able to contact selected candidates at this time.

Role: SQL Developer - Digital Video Technology Company
Job Type:
Location: New York,

Apply for this job now.