Database Architect

JSM Consulting Inc.; City of Albany (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

JSM Consulting Inc. seeks an experienced Database Administrator to install, configure, and optimize Sybase and SQL Server databases in a NY area environment. Responsibilities include monitoring performance, applying patches, and maintaining data models with ERWin.

Reporting and analytics work may involve Tableau or Cognos Analytics. The ideal candidate has 7+ years in enterprise DB environments, strong documentation practices, and proven data migration experience.

Qualifications

• 7+ years of experience with Sybase and SQL Server installation and configuration.
• Experience monitoring performance and tuning databases.
• Experience managing maintenance tasks and ensuring optimal operation.
• Experience documenting configurations and procedures.
• Experience applying upgrades and security patches.
• Experience using ERWin for data modeling.
• Experience with Tableau or Cognos Analytics.
• Experience data migration and conversion in relational databases.

Responsibilities

• Install and configure Sybase and SQL Server databases.
• Monitor performance and implement tuning measures.
• Manage maintenance tasks and ensure reliability.
• Document configurations, procedures, and troubleshooting steps.
• Apply upgrades and security patches.
• Model data with ERWin.
• Create reports using Tableau or Cognos Analytics.
• Migrate and convert data between relational databases.

Skills

Sybase

SQL Server

Performance tuning

System monitoring

Data modeling

Tools

Sybase

SQL Server

ERWin

Tableau

Cognos Analytics

Job description

• 84 months experience installing and configuring Sybase and SQL Server.
• 84 months experience monitoring system performance and implementing performance tuning measures for Sybase and SQLServer 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 SQLServer 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.