Returning Candidate?

EITSD - JSP SQL Database Administrator

EITSD - JSP SQL Database Administrator

Job ID 
2017-1722
# of Openings 
1
Job Locations 
US-VA-Crystal City
Clearance Requirement 
S
Education Requirement 
Bachelor's Degree
Certifications 
Security + (or equivalent 8570 cert)
Experience Level 
Senior
8570 Compliant 
IAT 2

More information about this job

Overview

SMS is a fast growing, veteran-owned business that's has supported Federal Government's IT initiatives for over four decades.  We work side-by-side with our Federal clients as a trusted, long-term partner to offer innovative advice and leadership to solve their most pressing and complex problems. We orchestrate people, strategies, technologies and best-of-breed business processes. The SMS advantage in management and technology consulting includes deep domain expertise in complex networking design and unifying communities of interest. 

We have strong capabilities in design & build, planning, governance, quality management, security, analytics, virtualization, operations and business process improvement. For 40 years, SMS has brought customer satisfaction to Federal clients and formed lasting alliances with leading technology companies and talented small businesses to deliver joint, leading-edge, cost-effective services and products. 

Submit your resume today!

Responsibilities

Experienced hands-on knowledge with the following:

  1. SQL Server 2008 R2, 2012, 2014
  2. Performing Patching
  3. STIGing and hardening SQL databases
  4. Performing Backups, restores, and reviewing logs for a SQL environment.
  5. SQL and Windows Clustering and Replication

 

 

Job Description:   This position will be responsible for Microsoft SQL Server database management and administration, to include monitoring, managing, maintenance, performance tuning as well as supporting newly identified projects through involvement during the system inception and design phases.

 

  • Demonstrated experience with Microsoft SQL Server 2008R2, 2012 and 2014
  • Experience and understanding of SQL Server clustering, Availability Group, partitioning and mirroring
  • Implement data security and hardening (groups, roles, privileges, authentication, TDE and auditing)
  • Deploy database change scripts provided by third party vendors and/or internal development staff and executing SQL Queries, stored procedures and other database object using T-SQL.
  • Perform application upgrades as delivered by third party vendors and/or internal development staff.
  • Manage and test backup and recovery plans, ensuring that storage, archiving, backup and recovery procedures are functioning correctly.
  • Develop, implement and maintain in-house documentation for processes, including database feature such for common problem resolution and help ticket fixes.
  • Provide database monitoring, space management, and support.
  • Respond to database related alerts and production problem issues.
  • Demonstrated troubleshooting and performance tuning of Microsoft SQL Server
  • Some knowledge of SQL Server Reporting Services
  • Manage Application and User Accounts logins and security.
  • Fulfill requests and resolve incidents within predefined SLAs
  • Effective communication skills both verbal and written
  • Work effectively as part of a team and independently.
  • Over 5+ years of hands-on SQL Server database support, development and administration responsibilities.

 

Qualifications

 Must have Security+ certification.

 

Clearance

DoD Secret

 

SMS is an Equal Opportunity Employer. 

 

SMS is a veteran-owned network integrator established in 1976.  With an employee retention rate averaging over 5 years, our ability to hire quality people and retain them in a rapidly evolving IT market proves why we are a world-class information technology company. At SMS, we place a high value on quality of service, customer satisfaction, and best-of-breed policies and practices. As a result, SMS is proud to be ISO 9001:2008 Registered and a CMMI Level 3 certified company, ensuring that we continue to meet and exceed the expectations of our customers, partners and employees.