SQL Server DBA - Olean, NY - Georgia IT Inc.

Job Title : SQL Server DBA
Location : Olean, NY
Position Type : Contract
Job Description:
Proactively monitor SQL Server performance and events
· Troubleshoot performance issues, connectivity and failures
· Backup and restore databases per requirement
· Create Backup strategy to meet the Recovery Time Objectives
· Periodically testing backups to ensure it meets the Recovery Time Objectives
· Create SQL Server Logins and Database Users and configure access to the databases
· Configure and periodically review security settings
· Create maintenance plans and scheduling jobs
· Design and create Server objects and database objects
· Manage alerts and Database Mail
· Create stored procedures, Functions and Triggers
· Tuning and optimizing queries for performance
· Create queries for database administration
· Power shell programming
· Install and configure new SQL Servers
· Create database change scripts and migrate changes from SQL Server to SQL Server
· Import and Export data between SQL Server and Excel files
· Work closely with programmers to ensure Database design and queries meet company standards for readability, reliability and performance