Database Architect

Database ArchitectLocation: Albany, NY 12227 Work Hours: Monday-Friday 7am-5pm Contract Length: 30 months (estimated) Mandatory Requirements: Expert with 84+ Months Experience Desired Requirements:84 months experience in designing DB2 or IDMS database structures for enterprise systems84 months experience with application and SQL performance analysis and tuning84 months experience with CICS Design84 months experience with physical database design84 months experience writing shell scripts84 months experience maintaining logical and physical database designs with Erwin84 months experience creating database standards and procedures84 months experience performing database upgrades for DB2 or OracleResponsibilities:Responsible for expert analysis, support, development, reengineering, and implementation of multiple business applications. Support is required for specific programming languages (COBOL, SQL, and Java), for specific database management systems (DB2 z/OS, DB2 LUW, IDMS, SQL Server), and using specific technologies (MQ Series, CICS, Sort, JCL, VSAM, Unix scripting, DBI performance tools, Erwin, TSO/ISPF, Data Studio, 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, interfacing, and usage 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.About Us: InterSources Inc. is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.