Database Architect - InterSources Inc.
Albany, NY
About the Job
Position Title: Database Architect
Location: Albany, NY 12227
Work Hours: Monday-Friday 7am-5pm
Contract Length: 30 months (estimated)
Mandatory Requirements:
Expert with 84+ Months Experience
Desired Requirements:
Responsibilities:
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.
Location: 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 systems
- 84 months experience with application and SQL performance analysis and tuning
- 84 months experience with CICS Design
- 84 months experience with physical database design
- 84 months experience writing shell scripts
- 84 months experience maintaining logical and physical database designs with Erwin
- 84 months experience creating database standards and procedures
- 84 months experience performing database upgrades for DB2 or Oracle
Responsibilities:
- 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.
Source : InterSources Inc.