What are the responsibilities and job description for the Sr. SQL Administrator position at SMS Data Products Group, Inc.?
Overview :
Please make sure you read the following details carefully before making any applications.
SMS is seeking a Sr. SQL Administrator to provide AFRL Rocket Lab with qualified support staff to execute day-to-day operations and maintenance within the NOC. This effort provides support to the network / server infrastructure and equipment within the AFRL Rocket Lab.
As a dynamic systems integrator, SMS offers proven solutions in engineering, operations, cybersecurity, and digital transformation. With expertise in modernizing and optimizing legacy infrastructure and systems, ensuring operational efficiency, and designing, implementing, and managing secure environments, SMS supports business and mission goals with proficiency, quality, and integrity.
SMS has been serving the advanced information technology needs of the federal government since 1976, delivering talented teams and innovative, cost-effective solutions and services to support our customers’ missions for more than 40 years. SMS is headquartered in McLean, Virginia, with offices and on-site operations at customer locations throughout the United States. For additional information on SMS, visit www.sms.com.
Submit your resume today!
Responsibilities :
Assist with the installation, configuration, and maintenance on Microsoft SQL Server 2016 and higher.
Assist in the development and implementation of enterprise database backup, recovery, and failover procedure.
Serve as a liaison for database related queries and technical support between NOC and customers.
Triage Network Operation Center level server ticket utilizing Web Help Desk.
Provide intermediate level network support and troubleshooting.
Provide support, administration, and maintenance for AFRL Rocket Lab specialized information systems.
Daily monitor of network and storage devices.
Monitor and maintain uninterruptible power supply (UPS) devices.
Document the problem with the technical detail(s) within the Web Help Desk ticket.
Qualifications : Required :
Minimum of Five (5) years of MS SQL Server and SQL scripting experience including SQL and T-SQL.
Must satisfy IAT-11 certification requirements (CompTIA Security CE certification)
Experience creating packages, procedures, and functions on SQL.
Ability to create and maintain appropriate documentation.
Favorable current Tier 1 (or higher) or an Interim SECRET (or higher) security clearance
Experience authoring, managing, and deploying solutions using Microsoft Server Manager (MSM).
Experience in data integration and / or knowledge of concepts and strategies and data preparation and curation for data warehousing and / or knowledge of concepts and strategies.
Knowledge in one or more programs languAages e.g., PowerShell, Python, Java, Batch, C , etc.
Preferred :
Preferred : a. Basic Knowledge of Azure, AWS
Familiar with Oracle
SQL Certification e.g., MCSA, MSSQL
SMS is a dynamic systems integrator established in 1976, delivering talented teams and innovative, cost-effective solutions and services to support our customers’ missions for more than 47 years. Our ability to hire and retain quality people in a rapidly evolving IT market is proven through our employee retention rate averaging over 3 years. At SMS, we place a high value on quality of service, customer satisfaction, and best-of-breed policies and practices, resulting in CMMI Level 3 certification and ISO registrations including 9001 : 2015, 20000-1 : 2018, and ISO / IEC 27001 : 2013. SMS is headquartered in McLean, Virginia, with offices and on-site operations at customer locations throughout the United States.
SMS is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Pay : $75,000.00 - $85,000.00 per year
Benefits :Work Location : In person
Salary : $75,000 - $85,000
