Job Description :
We are actively looking for a SQL Server DBA with Sybase Exp_Collierville, TN.
Mode: Contract
Duration: 12+ Months
MS SQL- 70-80%
Sybase- 20%
Primary skill-
MSSQL Should have very good understanding about the SQL Server Architecture.
MS SQL Server 2000/2005/2008/2012/2016 standalone/cluster Administration.
SQL Server 2012/2016 Always ON administration.
MS SQL Server standalone/Cluster Installation.
Database Migration/Refreshes.
MS SQL Server Migrations.
Strong knowledge in performance monitoring & tuning in Sql-Servers.
Should be good in maintaining databases by performing regular maintenance of the databases.
Database Mirroring and Database mail configuration.
MS SQL server profiler.
Should have good understanding of new features of SQL Server 2012/2014.
MS SQL server Patch fixes, upgrades.
Good Knowledge of scripting.
Secondary Skill -
Sybase Worked upon ASE 15.0 and above version and experience of working on Replication Server.
Creation of Devices, Databases, Segments.
Backups of databases & logs. User account management
Performing Recovery of suspect databases
Refresh of Databases in replication as well non replication environment.
Transaction log management. Handling of jobs failures.
Troubleshooting Database error and performance Tuning.
Replication Server monitoring and troubleshooting.
Troubleshooting includes check for the replication configuration, threads down, stable device full, RSSD log full, stop and restart threads, repagent and repservers.