Occupation:Database Administrator |
Location:Washington, DC |
Education Level:Bachelor |
Will Relocate:YES |
Description
Summary of Profile A SQL DBA background with experiences in creating, setting and maintain Database Administration scripts. Build, Deploy and Debug custom objects. Flexible and versatile to adopt any new environment and work on any project. * Experience in Data Modeling, Database Design, Development and implementation of Client-Server applications and Database systems using MSSQL 2014/2012/2008R2/2008 * Extensive experience with recovery models, backup and restore functions for MS SQL Server databases. * Excellent Knowledge of creating, setting up and Scheduling jobs and Alerts using SQL Server Agent. * Excellent experience in setting up and configuring Database Mail, notification and alerts. * Excellent knowledge in writing Scripts, Stored Procedures, Triggers, Indexes, Views, and SQL joins using T-SQL. * Expert in DDL and DML, as well as aggregate functions. * Hands on Experience in Monitoring and troubleshooting database issues like Memory, CPU, I/O, Disk utilization, Blocking, Deadlock, Fragmentation and Waits. * Hands on experience in Query Tuning by using SQL Profiler, Trace Statistics, DBCCs, DMV and utilizing execution plans * Experience in using native tools such as Database Engine Tuning Advisor, Index Tuning Wizard, Windows Performance Monitor for Monitoring and Tuning, SQL profiler for MS SQL Server Performance . * Experience in Configuring, monitoring and troubleshooting HA/DR solutions. * Experience in deploying and securing reports and administering and troubleshooting report servers. * Monitored/Secured, automate and change SSIS workflows and configuration. * fast load options, buffer sizes, and checkpoints. * Collaborated with team members on project updates by checking-in and checking-out on TFS. * Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative.
Accomplishments
Highlights:
Keywords
