SQL DBA-Olean, NY - Georgia IT Inc.
Olean, NY
About the Job
Job Title : SQL 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
Source : Georgia IT Inc.