Big Data Postgres Database Administrator/ETL Engineer
Broadridge Financial Solutions, Inc. - Edgewood, NY

This job posting is no longer available on Dice. Find similar jobs: Broadridge Financial Solutions jobs

Big Data Postgres Database AdministrationETL Engineer Broadridge is a leading provider of investor communications and technology-driven solutions to banks, broker-dealers, mutual funds, and corporations globally. Our systems and services include investor communication solutions, securities processing and operations. We are seeking a dynamic self starter for a Big Data Postgres Database Administration and ETL Engineer for an expansion position. The ideal candidate will be experienced with Postgres or similar DBMS administration and have experience supporting data warehouses.

Greenplum technology experience a strong plus. Experience with Informatica ETL solutions and architecture and data modeling required. This position will be working with lead DBAs and ETL Architect to support big data analytic solutions. Performing administration, support, performance monitoring and troubleshooting.

Working with development teams to understand applications and provide guidance for application solutions. This position will be working with teams to provide Enterprise level support and for large scale data loading. This position will also be engaged in support and troubleshooting database performance issues, backup and recovery management and database related applications for big data solutions. Experience with large scale financial analytic environment support a plus Responsibilities Oslash Troubleshooting performance issues using postgres and UNIX level commands to gather data.

Support cron jobs and shell scripts for database maintenance functions Oslash Create and maintain environment documentation Oslash Create and maintain coding and database design best practices documentationOslash On call coverage for 247 support Oslash Standard administration including ID creation, database creation, database maintenanceOslash Adhere to and provide support for change control process Oslash Familiarity with SOX, ISO and other industry standard audit requirements to ensure solutions designed are audit readyOslash Work with development teams to support coding and database designOslash Monitor and maintain backups with retention period clean up Oslash Understanding Big Data solutions and the inherent differences with OLTP solutionsOslash Understanding of HADOOP a plusOslash Support growing Informatica ETL environment including administration of user ids, permission and security. Oslash Install and configure Informatica software and connectors.Oslash Troubleshoot ETL load and database performance issues Qualifications Requirements bull 3-5 years of strong experience as DBA, Postgres a stong plus. bull Experience with Informatica ETL solutions. bull Strong knowledge of database performance tuning and configuration.

Strong knowledge of Informatica performance tuning and configuration. bull Familiarity with SOX, ISO and other industry standard audit requirements. bull Thorough knowledge of data backup, recovery, and rollback planningimplementation. bull Understanding of big data solutions and HADOOP a plus.

Big Data Postgres Database Administrator/ETL Engineer

Dice - 17 months ago - save job - copy to clipboard
About this company
133 reviews
Broadridge is a leading provider of investor communications and technology-driven-solutions to banks, broker-dealers, mutual funds, and...