Application Data Developer

4 weeks ago

Raleigh North Carolina, United States First Citizens Bank Full time
Overview:
 

This position has the responsibilities which include management and monitoring of Netezza and DB2 databases in support of the Enterprise Data Warehouse environment. Test and implement changes/enhancements to the database using SQL scripts. Apply knowledge of database management systems to improve performance, stability and recoverability. Develop, maintain and support Unix shell scripts. Responsible for planning, coordinating and implementing security measures to safeguard the computer database.

*This position is located in Raleigh, NC and will be 3 days in the office and 2 days remote

Responsibilities:
Perform database performance analysis, ongoing maintenance/tuning to ensure maximum performance on Netezza and DB2 UDB systems.

Assist development teams with planning and implementing database changes and query optimization.

Recommend and implement a detailed security design based on minimum necessary privileges required.

Review SQL queries and database design for performance.

Work as part of a project team to coordinate database development and determine project scope and limitations.

Support QA and DEV environments with refresh tasks.

Develop and implement data patches to address incidents and enhancements.

Facilitate implementation of data, script and/or code changes into the production environment.

 

 

Qualifications:
Bachelor's Degree and 4 years of experience in Software application development and maintenance OR High School Diploma or GED and 8 years of experience in Software application development and maintenancePreferred Education: Bachelor DegreePreferred Area of Study: Computer SciencePreferred Area of Experience: Prefer 6 years of combined experience in Netezza and DB2 UDB.

Exposure to mainframe, desktop, and UNIX system support is required.  Support experience will include installation, setup and configuration, and troubleshooting of hardware, software, and network issues.

Expert understanding and application of data warehouse architecture principles; including data warehouse data storage strategy/technique (ODS, EDW, DM, ROLAP, MOLAP, etc.).

Strong shell scripting (ksh) and SQL experience, specifically on DB2 and Netezza.

Expert level experience in administering large databases in mission critical environment.

Must have good understanding of Netezza architecture (grooming, distribution, etc.).

Develop and define administrative and operational standard practices to leverage Netezza performance.

Solid experience in Netezza system configuration and setup with its utilities and tool sets.

Strong knowledge and experience with computer hardware including Servers, Network, SAN technologies, I/O subsystems.

Experience in SDLC and change management process.

Basic project planning and management, strong communication and interpersonal skills, leadership abilities, 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.

Positive attitude, problem solving skills and initiative are important key behaviors.

Banking or financial services industry experience preferred.

  • Application Data Developer

    2 weeks ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: This position has the responsibilities which include management and monitoring of Netezza and DB2 databases in support of the Enterprise Data Warehouse environment. Test and implement changes/enhancements to the database using SQL scripts. Apply knowledge of database management systems to improve performance, stability and recoverability. Develop,...

  • Application Data Developer

    2 weeks ago

    Raleigh, United States First Citizens Bank Full time

    Overview: This position has the responsibilities which include management and monitoring of Netezza and DB2 databases in support of the Enterprise Data Warehouse environment. Test and implement changes/enhancements to the database using SQL scripts. Apply knowledge of database management systems to improve performance, stability and recoverability. Develop,...

  • Application Data Developer

    4 days ago

    Raleigh, United States First Citizens Bank Full time

    OverviewThis position has the responsibilities which include management and monitoring of Netezza and DB2 databases in support of the Enterprise Data Warehouse environment. Test and implement changes/enhancements to the database using SQL scripts. Apply knowledge of database management systems to improve performance, stability and recoverability. Develop,...

  • Application Data Developer

    2 days ago

    Raleigh, United States First Citizens Bank Full time

    OverviewThis position has the responsibilities which include management and monitoring of Netezza and DB2 databases in support of the Enterprise Data Warehouse environment. Test and implement changes/enhancements to the database using SQL scripts. Apply knowledge of database management systems to improve performance, stability and recoverability. Develop,...

  • Application Data Developer

    4 days ago

    Raleigh, United States First Citizens Bank Full time

    Overview This position has the responsibilities which include management and monitoring of Netezza and DB2 databases in support of the Enterprise Data Warehouse environment. Test and implement changes/enhancements to the database using SQL scripts. Apply knowledge of database management systems to improve performance, stability and recoverability. Develop,...

  • Sr Application Developer

    4 weeks ago

    Raleigh, United States Rekrooting Inc Full time

    Senior Application Developer ** This specific position will be involved in creating and refining a Data Mapping utility. Experience with ETL Data Mapping User Interface Design and structured data formats (JSON etc.) is desired.LOCATION Candidate will be remote until contractors are able to return the office. That said we are open to candidates that...

  • Sr Application Developer

    4 weeks ago

    Raleigh, North Carolina, United States Rekrooting Inc Full time

    Senior Application Developer ** This specific position will be involved in creating and refining a Data Mapping utility. Experience with ETL Data Mapping User Interface Design and structured data formats (JSON etc.) is desired.LOCATION Candidate will be remote until contractors are able to return the office. That said we are open to candidates that would be...

  • Developer I

    1 week ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: This is an entry level developer position, in First Citizen's marketing technology development team.  The team is responsible for several key applications and systems including Adobe Experience Manager content management system ((url removed)), multiple marketing and documentation sites build on the Angular framework with a 'headless' content...

  • Enterprise Data Consultant

    3 weeks ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: This position supports initiatives within the Bank that improve enterprise data quality, governance, and analytics. Drives positive change across the Bank through technical innovation and continuous improvement initiatives. Creates and maintains technical documentation related to enterprise data. Provides expert consultation to team members, the...

  • Data Analyst I

    4 weeks ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: This position is responsible for gathering, organizing, and analyzing large data sets using statistical techniques and tools, to ensure data quality, integrity and compliance with applicable laws, regulations, and bank policies that assist management with making informed business decisions. Follows data integrity and consistency standards,...

  • Senior Developer

    6 days ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: The Senior Developer - Robotics is responsible for all phases of data processing system projects, from requirements definition to installation. Leads technical efforts in the development, implementation, and maintenance of complex systems. Develops test plans, software, and procedures that improve processing capabilities. Supports productions...

  • Data Scientist

    4 hours ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: The Business Analytics (BA) team creates analytical solutions that can be deployed to the bank’s sales teams. We partner with sales leaders and business partners to translate business questions into requirements, identify relevant data sources, create business logic and deploy solutions. This position will be focused on providing analytical...

  • Data Analyst III

    7 days ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: Translate data into actionable solutions and promote information- based decisions to drive Enterprise Process Management (EPM)'s initiatives. Work cross-functionally to identify business /process issues and execute the fix. Explore relevant data sources and periodic reports. Create the logic to transform the data into insights. Build, design, and...

  • Lead .NET Developer

    3 weeks ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: Oversee several internally developed applications including NET stand-alone programs and customer facing websites. Be the designated application owner for several applications, maintaining, enhancing, and providing production support of applications supported. Ensure any changes are in accordance with recommended good coding practices, including...

  • Data Quality Analyst

    2 weeks ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: This position performs advanced data analysis to identify factors that affect business profitability, growth, and efficiency. Assesses current practices, collects information and industry trends, and creates specifications to support business operations. Determines improvements or solutions to address identified issues. Prepares technical reports...

  • Enterprise Data Consultant

    4 weeks ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: This position supports initiatives within the Bank that improve enterprise data quality, governance, and analytics. Drives positive change across the Bank through technical innovation and continuous improvement initiatives. Creates and maintains technical documentation related to enterprise data. Provides expert consultation to team members, the...

  • Enterprise Data Consultant

    2 weeks ago

    Raleigh, North Carolina, United States First Citizens Bank Full time

    Overview: This position supports initiatives within the Bank that improve enterprise data quality, governance, and analytics. Drives positive change across the Bank through technical innovation and continuous improvement initiatives. Creates and maintains technical documentation related to enterprise data. Provides expert consultation to team members, the...

  • Hadoop Big Data Developer with Java

    1 day ago

    Carolina, United States IT Allianz Inc Full time

    Job DescriptionJob DescriptionOur Client is seeking a Hadoop Big Data Developer with Java for our contract position with a client located in Charlotte, NC, ideally looking for applicants with a solid background in the Banking and financial services industry and a strong Java, Hadoop / Big Data, Hadoop and Java scripting, Angular 5, React, NodeJS, a...

  • Bank Payment Data Analyst

    3 weeks ago

    Raleigh, North Carolina, United States Global Channel Management, Inc Full time

    Bank Payment Data Analyst needs 2+ years experience Bank Payment Data Analyst requires: Data analysis" or "data analyst" Payment Legal or compliance or Regulatory. Bank Payment Data Analyst duties: Performs advanced data analysis to identify factors that affect business profitability, growth, and efficiency. Assesses current practices, collects...

  • Web Application Developer

    3 weeks ago

    Raleigh, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Web Application Developer (HYBRID)Location: Raleigh, NCDuration: 12+ MonthsJob Description:The primary purpose of this position is to serve as the web application developer on a project to rewrite the user interface of the client ECHO application for the client. The user interface, which was written using Angular JS...