CONTRACT DURATION: 6 MONTHS PAY RATE: $ 37.68 PER HR ON W2 WORK TIMING – 8 AM TO 5 PM ( MONDAY TO FRIDAY) LOCATION - SANDY SPRINGS GA 30328
Reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications, and constructions including stored procedures. Familiar with standard concepts, practices, and procedures within a particular field. Relies on limited experience and judgment to plan and accomplish goals. Performs a variety of tasks. Works under general supervision; typically reports to a project leader or manager. A certain degree of creativity and latitude is required.
Required Skills
Strong experience in Database Administration in SQL Server
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. • Expert experience in implementing operational automation.
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
Solid acquaintance with windows server, security delegation, SPNs, storage components.
Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
Solid acquaintance with windows server, security delegation, SPNs, storage components.
Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
Knowledge of 3rd party DBA tools and applications ( e.g redgate, idera, SCOM, Erwin )
Knowledge in a scripting language like Powershell, VBScript, WSH Web Developer
Skills and Qualifications: JavaScript, JQuery, HTML, HTML5, CSS, CSS3, Web Programming Skills, E-Commerce, Teamwork, Verbal Communication, cross-browser compatibility, Web User Interface Design (UI), Security Principles, Object-Oriented Design, Web Services (REST/SOAP), Multimedia Content Development, API's
Required Experience
Microsoft Certified Database Administrator SQL Server 2000 (MCDBA) Certification is a plus
Strong experience in Database Administration in SQL Server
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. • Expert experience in implementing operational automation.
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
Solid acquaintance with windows server, security delegation, SPNs, storage components.
Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
Solid acquaintance with windows server, security delegation, SPNs, storage components.
Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
Knowledge of 3rd party DBA tools and applications ( e.g redgate, idera, SCOM, Erwin )
Knowledge in a scripting language like Powershell, VBScript, WSH Web Developer
Skills and Qualifications: JavaScript, JQuery, HTML, HTML5, CSS, CSS3, Web Programming Skills, E-Commerce, Teamwork, Verbal Communication, cross-browser compatibility, Web User Interface Design (UI), Security Principles, Object-Oriented Design, Web Services (REST/SOAP), Multimedia Content Development, API's