Database Architect

For more details, please connect with Praveen H at View email address on us.fitly.work or call at View phone number on us.fitly.work .

Direct Client: The New York State Office of Information Technology Services

Program: DTF Modernization

Job Title: Database Architect

Skill Level: Expert

Duration: 30 Months

Location: Albany, New York, 12227

Hours Per Week: 40 Hours

Interview Type: Webcasting

HBITS ID: HBITS-08-14929

Ceipal ID: SNY_SQL929_PH

Scope of Project:

This project is to modernize aging Data Warehouse and Data Analytic systems utilizing new on-premises cloud- and container-based technologies.

Responsibilities:

• Responsible for analysis, design, support, development and reengineering of database structures in Sybase, SQL Server and DB2.

• Provide performance analysis and tuning, troubleshooting, capacity planning, benchmark design.

• Design methodologies for data synchronization from various operational data stores (Mainframe DB2, Windows SQL Server, Sybase on Solaris, DB2 on AIX and OpenShift) to a zLinux DB2 data warehouse.

• Planning, interfacing, and usage between z/OS and LUW DB2 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.

Required/Preferred Skills:

• 84 months experience installing and configuring Sybase and SQL Server.

• 84 months experience monitoring system performance and implementing performance tuning measures for Sybase and SQL Server databases.

• 84 months experience managing and implementing database maintenance (reorgs, statistics, ensuring database is running optimally) in a server environment with Sybase and SQL Server databases.

• 84 months experience documenting system configurations, procedures, and troubleshooting guidelines for Sybase and SQL Server Databases in a server environment.

• 84 months experience applying upgrades and security patches to critical operational databases.

• 84 months experience using ERWin to create and maintain data models.

• 84 months experience with Tableau or Cognos Analytics.

• 84 months experience with data migration and conversion in relational databases.

V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector, Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products. Within Public Sector business unit, we cater IT Professional Services to Federal, State and Local.

We have multiple awards/contracts with 30+ states, including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, NM, VT, and WA.

If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.

Please share my contact information with others working in Information Technology.

Website:

LinkedIn:

Facebook:

Twitter: