Data Architect - Phoenix, United States - Saxon Global

    Saxon Global
    Saxon Global Phoenix, United States

    2 weeks ago

    Default job background
    Description
    Job Title - Data Architect

    Location - Phoenix, AZ (Onsite) Need Only Local Candidates

    Client - Coforge


    Required:

    Looking for a profile with the following job description who can contribute his/her 90% of the time for the PL/SQL code development.


    Job description :
    Design, define and maintain databases.

    Understand Database table partitioning procedures.

    Create and maintain stored procedures for data transfer between apps and databases.

    Create complex SQL queries for different ad-hoc reporting and for integration with reporting tools.

    Extensively use SSIS transformations such as Lookup, Derived column, conversion, task, etc.

    have Hands on experience in developing and deploying SSIS and SSRS in different environment.

    Should have experience in data warehousing including business intelligence tools-SQL, SSIS and SSRS.

    Should have used T-SQL objects like Stored Procedures, Triggers, Tables, Views, Index, User Defined Functions, Data integrity, variables, cursor, CTE, joins etc.


    Experience in Performance tuning of Queries and indexing to improve Performance.

    Ensure policies for handling sensitive date (PCI, PII) ethically within the application.

    Should have used T-SQL objects like Stored Procedures, Triggers, Tables, Views, Index, User Defined Functions, Data integrity, variables, cursor, CTE, joins etc.


    Experience in Performance tuning of Queries and indexing to improve Performance.

    Experience on Table Partitioning , Backup and Recovery.

    Proficiency in creating a database from the group up for a brand-new application.

    Ability to design tables and organize data in a manner that maximizes performance, incorporating use of suitable indexes and partitions.


    Knowledge:
    Understanding of Cloud database services. (AWS preferred)

    Deep Knowledge of MSSQL ,Postgresql

    Basic understanding of No-SQL Databases

    Manage the data archives.

    Understanding of the User Interfaces .

    Ensure database / licenses are always up to date.

    Knowledge of MSBI, ETL and Tableau reporting

    Agile methodologies

    Jira