2 jobs found in Jericho

Publishers Clearing House (PCH) is seeking a Senior Mainframe Programmer to join our team in Jericho, NY. Responsibilities include but are not limited to: Work multiple projects concurrently and shift priorities as required to meet business requirements and deadlines. Work with business unit and technical staff to ensure changes are implemented according to specifications. Review problems, understanding the major impacts to technical and business-related areas, and provide basic recommendations and solutions that can be implemented to correct the problem. Provide technical guidance to staff with less experience and mentors peers on assigned systems. Serve as the primary technical expert within a mission critical application(s) / systems, acting as an internal consultant for all tasks in the analysis, design, testing and implementation of assignments. Ensure Change Control and operational procedures are followed for all production related changes. Required Skills/Experience: Bachelors Degree in Computer Science or a related field 5-10 years of experience with COBOL, CICS, JCL/Procs Proven ability in DB2 In-depth experience in design and development of batch database systems Full project life cycle experience in applications handling high data volumes SAS development a plus Strong data analytical skills Publishers Clearing House (PCH), headquartered in Jericho, NY, and with offices in Melville, NYC, Portland, ME, and Boston, MA, is a leading direct-to-consumer company offering a broad range of products, digital entertainment services to consumers as well as customized solutions for advertisers. Our continued success in today’s new digital publishing environment is built on PCH’s unique, free-to-play, chance-to-win value proposition, which enables individually personalized offers based on the trusted first-party relationship we maintain with millions of consumers and is fueled by the excitement of the Publishers Clearing House brand. Join our winning team and apply today This is a Long Island, NY based position. Candidates must reside in the NY tri-state area. PCH is an Equal Opportunity Employer

The Database Administrator will be responsible for collaborating with project delivery teams on analysis and development of key DB-tier stored procedures, SSIS packages, architectural components and/or infrastructure, supporting Online database environments. In addition the Database Administrator will be responsible for the day-to-day operational health, performance, availability and troubleshooting of the database tier, including but not limited to: DTS/SSIS packages, scheduled job monitoring, analyzing query plans, data archiving/pruning, application and load test benchmarks, and data-tier alerts and notifications. Provide database administration support and troubleshooting to multiple IT projects and delivery teams Work with delivery teams to analyze system capacity requirements and needs Assist in analysis, design, development, and implementation of database systems, SSIS packages, and configurations Responsible for ensuring backups of all production and mission-critical data is securely captured and restore capability enabled Work with Infrastructure team to analyze, plan and implement database upgrades Ensure that SQL developers meet the architectural standards Develop technical system documentation Configure, optimize, and support SQL Server or other relational databases Support the operation of existing applications with respect to stored procedures and database optimizations Monitoring performance, analyzing plans and facilitate performance tuning Monitoring scheduled jobs, refine and automate regular processes, track issues, and document changes Provide timely response and resolution of emergency production questions, issues and defects Resolve issues or escalate to manager, if necessary Performs database refreshes across the different environments/tiers (Dev, QA, Staging, Production) Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end Refine and automate regular processes, track issues, and document changes Required Skill/Experience: Bachelors Degree required in Computer Science or a related field 7 years of supporting online highly transactional database systems with knowledge of SQL Server 2012/2016, monitoring tools like solarwinds, New relic 7 years of supporting and managing Microsoft SQL server systems Prior experience working for an ecommerce or financial operation Experience with other relational database systems such as MySQL is preferred Experience setting up and managing clustering services for Windows systems Ability to work on-call hours on a rotational basis Strong communication skills and ability to work collaboratively in an Agile/Scrum environment - provided by Dice