Jobs via Dice
Expert Database Architect HBITS-07-14379
Join to apply for the
Expert Database Architect HBITS-07-14379
role at
Jobs via Dice
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Tech Valley Talent, is seeking the following. Apply via Dice today!
DURATION: 30 Months LOCATION: Albany, NY - Hybrid
This project is to modernize aging Tax systems into new technologies including CARTS, Correspondence
Qualifications
Database Architect—determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Expert—84+ Months: candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
84 months experience in designing DB2 LUW database structures, stored procedures, and sequence objects for enterprise systems.
84 months experience with application and SQL performance analysis and tuning.
84 months experience with physical database design.
84 months experience writing AIX shell scripts to automate redundant tasks.
84 months experience performing database upgrades for DB2 LUW.
84 months experience creating database standards and procedures.
84 months experience installing, configuring and developing real time replication utilizing IBM Data Replication/Change Data Capture (CDC).
Day-to-Day tasks
Responsible for analysis, support, development, reengineering, and maintenance of all agency databases. Support is required for specific database management systems (DB2 LUW, IDMS, SQL Server), and using specific technologies (Unix scripting, DBI performance tools, ERwin, z/OS, AIX, IBM Data Replication).
Provide performance analysis and tuning, troubleshooting, capacity planning, benchmark design.
Develop a streamlined process for database migrations.
Design methodologies for data synchronization from operational data stores to a data warehouse across multiple database platforms and varied DBMS.
Planning, and interfacing between application databases, data warehouse, Cognos, Identity Insight, and DataStage.
Act as liaison between Data Management, business customers, and application development staff to ensure that recommended performance considerations are included in reviews, designs, development, and implementation of applications.
Create cost effective and timely solutions to strategic business requirements utilizing database structures, application methodologies, and coding techniques.
Seniority Level Mid-Senior level
Employment Type Full-time
Job Function Information Technology
Industries Software Development
TVT is an Information Technology (IT) professional business leader providing IT services to the public sector. Our firm is founded on the values of high integrity, trust, honesty, and commitment. We take pride in providing exceptional value to our clients by supplying and delivering the best IT project-based and hourly talent across the nation. Tech Valley Talent provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type protected by federal, state, or local laws. This policy applies to all terms and conditions of employment.
#J-18808-Ljbffr
Expert Database Architect HBITS-07-14379
role at
Jobs via Dice
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Tech Valley Talent, is seeking the following. Apply via Dice today!
DURATION: 30 Months LOCATION: Albany, NY - Hybrid
This project is to modernize aging Tax systems into new technologies including CARTS, Correspondence
Qualifications
Database Architect—determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Expert—84+ Months: candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
84 months experience in designing DB2 LUW database structures, stored procedures, and sequence objects for enterprise systems.
84 months experience with application and SQL performance analysis and tuning.
84 months experience with physical database design.
84 months experience writing AIX shell scripts to automate redundant tasks.
84 months experience performing database upgrades for DB2 LUW.
84 months experience creating database standards and procedures.
84 months experience installing, configuring and developing real time replication utilizing IBM Data Replication/Change Data Capture (CDC).
Day-to-Day tasks
Responsible for analysis, support, development, reengineering, and maintenance of all agency databases. Support is required for specific database management systems (DB2 LUW, IDMS, SQL Server), and using specific technologies (Unix scripting, DBI performance tools, ERwin, z/OS, AIX, IBM Data Replication).
Provide performance analysis and tuning, troubleshooting, capacity planning, benchmark design.
Develop a streamlined process for database migrations.
Design methodologies for data synchronization from operational data stores to a data warehouse across multiple database platforms and varied DBMS.
Planning, and interfacing between application databases, data warehouse, Cognos, Identity Insight, and DataStage.
Act as liaison between Data Management, business customers, and application development staff to ensure that recommended performance considerations are included in reviews, designs, development, and implementation of applications.
Create cost effective and timely solutions to strategic business requirements utilizing database structures, application methodologies, and coding techniques.
Seniority Level Mid-Senior level
Employment Type Full-time
Job Function Information Technology
Industries Software Development
TVT is an Information Technology (IT) professional business leader providing IT services to the public sector. Our firm is founded on the values of high integrity, trust, honesty, and commitment. We take pride in providing exceptional value to our clients by supplying and delivering the best IT project-based and hourly talent across the nation. Tech Valley Talent provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type protected by federal, state, or local laws. This policy applies to all terms and conditions of employment.
#J-18808-Ljbffr