Sybase and MS-SQL DBA
Propertyvalue Avenues International, Inc.
Albany, United States of America
2 days ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Albany, United States of America
Tech stack
Microsoft Windows
IBM AIX
Data analysis
Databases
System Configuration
Data Migration
Data Synchronization
Data Warehousing
IBM DB2
Relational Databases
Database Storage Structures
IBM InfoSphere DataStage
Linux
Monitoring of Systems
IBM Cognos Business Intelligence
Mainframes
Microsoft SQL Server
Operational Data Store
Openshift
Operational Databases
Performance Tuning
Service Pack
Software Engineering
Solaris (Operating System)
Tableau
Z/OS
SAP Sybase ASE
Data Management
Software Coding
Job description
- 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 operational data stores 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 z/Linux 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.
Requirements
- 84 months of experience installing and configuring Sybase and SQL Server.
- 84 months of experience monitoring system performance and implementing performance tuning measures for Sybase and SQL Server databases.
- 84 months of experience managing and implementing database maintenance (reorgs, statistics, ensuring the database is running optimally) in a server environment with Sybase and SQL Server databases.
- 84 months of experience documenting system configurations, procedures, and troubleshooting guidelines for Sybase and SQL Server Databases in a server environment.
- 84 months of experience applying upgrades and security patches to critical operational databases.
- 84 months of experience using Erwin to create and maintain data models.
- 84 months of experience with Tableau or Cognos Analytics.
- 84 months of experience with data migration and conversion in relational databases.