Previous Job
Previous
SQL DBA - Olean, NY
Ref No.: 18-02528
Location: Olean, NY, New Jersey
Job Title : SQL DBA
Location : Olean, NY
Position Type : Contract

need local to NY or NJ h1b is fine
  • 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