Previous Job
Previous
SQL Server DBA
Ref No.: 16-12640
Location: Addison, Texas
SQL Server DBA

Job Responsibilities


Create Database objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types, and functions
Suggest Disk Capacity, Processors and Memory based on the Capacity planning
Implement database standards and naming convention for the database objects
Install , Configure , Backup SQL server Databases on Servers
Apply patches and service packs to keep the database at current patch level
Convert the legacy systems data into MS SQL server using DTS packages
Develop SQL scripts for maintaining administration tasks
Tune the SQL queries using SQL profiler

Migration Experience From One Version To Another

Update with latest service packs and security patches
Implement stand by servers and log shipping
Develop stored procedures, triggers for the application
Estimate Table sizes and Record sizes
Maintain proper licenses
Maintain all the SQL documents including installation and data conversion procedures documents
Troubleshoot problems by using SQL server profiler
Solve critical production problems and perform point in time recovery plans