SQL DBA - Olean, NY

SQL DBAProactively monitor SQL Server performance and eventsTroubleshoot performance issues, connectivity and failuresBackup and restore databases per requirementCreate backup strategy to meet the Recovery Time ObjectivesPeriodically testing backups to ensure it meets the Recovery Time ObjectivesCreate SQL Server Logins and Database Users and configure access to the databasesConfigure and periodically review security settingsCreate maintenance plans and scheduling jobsDesign and create Server objects and database objectsManage alerts and Database MailCreate stored procedures, Functions and TriggersTuning and optimizing queries for performanceCreate queries for database administrationPower shell programmingInstall and configure new SQL ServersCreate database change scripts and migrate changes from SQL Server to SQL ServerImport and Export data between SQL Server and Excel filesWork closely with programmers to ensure Database design and queries meet company standards for readability, reliability and performance