Application Data Developer

3 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, 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 maintenance
  • Preferred Education: Bachelor Degree
  • Preferred Area of Study: Computer Science
  • Preferred 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

    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

    5 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,...

  • 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....

  • 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,...

  • 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...

  • 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...

  • 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...

  • Web Application Developer

    2 weeks ago

    Raleigh, United States Serigor Inc Full time

    Job 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 and Breeze, will be rewritten...

  • Web Application Developer

    4 weeks ago

    Raleigh, United States Serigor Inc Full time

    Job 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 and Breeze, will be rewritten...

  • Data Pipeline Developer

    4 weeks ago

    Raleigh, United States JSM Consulting Full time

    Required Skills & Experience 7+ years of experience with AWS Services especially Data Pipeline Glue Kinesis Redshift Spectrum In-depth experience with Amazon Redshift working knowledge of S3 data lake environment AWS Certified Database (preferred) Experience in schema design and data modeling Knowledge of compliance frameworks PCI SOX SOC 2 ISO...

  • Data Pipeline Developer

    3 weeks ago

    Raleigh, North Carolina, United States JSM Consulting Full time

    Required Skills & Experience 7+ years of experience with AWS Services especially Data Pipeline Glue Kinesis Redshift Spectrum In-depth experience with Amazon Redshift working knowledge of S3 data lake environment AWS Certified Database (preferred) Experience in schema design and data modeling Knowledge of compliance frameworks PCI SOX SOC 2 ISO 27001 and the...

  • Data Engineer

    1 week ago

    Raleigh, United States Hazen and Sawyer Full time

    Hazen and Sawyer is actively seeking a Data Engineer/BI Developer with a passion for using technology to make a positive impact on public health and the environment. This unique role offers you the chance to collaborate with teams of engineers, planners, and scientists, applying your data engineering expertise to help address complex water-related challenges...

  • CA Gen Applications Developer

    1 week ago

    Raleigh, United States Serigor Inc Full time

    Job Title: CA Gen Applications Developer (Hybrid) Location: Durham NC Duration: 12+ Months Job Description: The client requires the services of a Specialist to provide leadership and perform tasks associated with current operational maintenance and future-state decommissioning of CA Gen applications. The client requires the assistance of a contract resource...

  • CA Gen Applications Developer

    2 days ago

    Raleigh, United States Serigor Inc Full time

    Job Title: CA Gen Applications Developer (Hybrid) Location: Durham NC Duration: 12+ Months Job Description: The client requires the services of a Specialist to provide leadership and perform tasks associated with current operational maintenance and future-state decommissioning of CA Gen applications. The client requires the assistance of a contract resource...

  • CA Gen Applications Developer

    3 weeks ago

    Raleigh, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: CA Gen Applications Developer (Hybrid)Location: Durham NCDuration: 12+ MonthsJob Description:The client requires the services of a Specialist to provide leadership and perform tasks associated with current operational maintenance and future-state decommissioning of CA Gen applications.The client requires the...

  • Data Engineer

    3 weeks ago

    Raleigh, United States LHH Full time

    ***Candidates must be local Raleigh, NC area for a hybrid commute***We are seeking a talented junior-mid level experienced data engineer for a mid-large company in the manufacturing industry. The ideal candidate will be passionate about leveraging data to solve complex problems and drive business value. This role offers the opportunity to work at the...

  • Salesforce Application Administrator

    7 days ago

    Raleigh, United States North Carolina State University Full time

    North Carolina State University was founded in 1887 with the purpose of creating economic, societal and intellectual prosperity for the people of North Carolina. Today NC State is the largest university in North Carolina, with more than 37,000 high-performing students, 9,000 preeminent faculty and staff and 260,000 alumni. NC State is a research-extensive...

  • Data Engineer

    4 weeks ago

    Raleigh, North Carolina, United States Wipro Limited Full time

    Job descriptionabout the role Identify and analyze user requirements. Work closely with IT and Business stakeholders to understand business needs and work collaboratively to deliver solutions Prioritize assign and execute tasks throughout the Data/BI project life cycle. Build BI reports and dashboards based on business requirements Develop/integrate...