Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Database Architect.
United States Jobs Expertini

Urgent! Database Architect Job Opening In Albany New York – Now Hiring i-Link Solutions Inc



Job description

Job Title: Database Architect - Expert

Task ID: HBITS-(phone number removed)

Position Duration: 30 Months

Client: State of NY

Agency: Information Technology Services



Please call (phone number removed) | (phone number removed) | (phone number removed) or email at (url removed)



Description


  • Responsible for analysis, support, development, reengineering, and maintenance of all agency databases.

    Support is required for specific database management systems (DB2 LUW, 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.



Mandatory Qualifications




1
84 months experience in designing DB2 LUW database structures, stored procedures, and sequence objects for enterprise systems.




2
84 months experience with application and SQL performance analysis and tuning


3
84 months experience with physical database design


4
84 months experience writing AIX shell scripts to automate redundant tasks


5
84 months experience writing AIX shell scripts to automate redundant tasks


6
84 months experience writing AIX shell scripts to automate redundant tasks


7
84 months experience installing, configuring and developing real time replication utilizing IBM Data Replication/Change Data Capture (CDC)


Required Documentation
" Re sume

" Copy of Candidate Identification

(i.e., Driver's License/Green Card/Visa and Passport if applicable)

" Any documents referenced in the above Requested Qualifications

(i.e., professional certifications, degrees, etc.)






Disclaimer: i-Link Solutions Inc.

provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws.

We especially invite women, minorities, veterans, and individuals with disabilities to apply.

EEO/AA/M/F/Vet/Disability


Required Skill Profession

Other General



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your Database Architect Potential: Insight & Career Growth Guide