What are the responsibilities and job description for the Junior SQL Administrator position at SMS Data Products Group, Inc.?
Job ID | 2024-4717 | # of Openings | 1 | Clearance Requirement | S | Education Requirement | High School Diploma/GED | Certifications | Security CE | Experience Level | Junior | 8570 Compliant | IAT 2 |
Looking to hire a Jr. 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!
- Assist in the installation of hardware, configuration, and maintenance of NetApp appliances.
- Assist with writing complex queries for application on an RDT&E network.
- 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 fail-over procedure.
- Triage Network Operation Center level server ticket utilizing Web Help Desk.
- Serve as a liaison for database related queries and technical support between NOC and customers.
- Provide basic level hardware, software, network support and troubleshooting.
- Provide support, administration, and maintenance for AFRL Rocket Lab specialized information systems.
- Daily monitor of network and storage devices utilizing Solar Winds Orion software
- Monitor and maintain uninterrupted power supply (UPS) devices.
- Document the problem with the technical detail(s) within the Web Help Desk ticket.
Required:
- A minimum of two (2) years of MS SQL Server and SQL scripting experience including SQL and T-SQL.
- Experience creating packages, procedures, and functions on SQL.
- Experience authoring, managing, and deploying solutions using Microsoft Server Manager (MSM).
- Experience in data integration or knowledge of concepts and strategies and data preparation and curation for data warehousing and/or knowledge of concepts and strategies.
- Ability to create and maintain appropriate documentation and must possess strong analytical and problem-solving skills.
- Must satisfy IAT-11 certification requirements (CompTIA Security CE)
- Knowledge in one or more programs languages e.g., PowerShell, Python, Java, Batch, C , etc.
Preferred:
- SQL Certification e.g., MCSA, MSSQL
- Prior System Administrator experience
- A minimum of two (2) years of experience in Windows system administration and/or technical support
- Knowledge and experience in a Windows OS environment
- Microsoft Certified Professional (or Technology Specialist) certification (or training) for Microsoft Windows 10 (or higher)
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.
SMS is an Equal Opportunity Employer.
SMS is an Equal Opportunity Employer – minorities/females/veterans/individuals with disabilities/sexual orientation/gender identity.