Senior Database Analyst

RESPONSIBILITIES

• Design, implement and maintain highly available and scalable SQL Server databases
• Includes database design, database structure identification, database schema definition, database access privilege management, database query optimization, documentation, database instance upgrades, long-range requirements, operational guidelines, and database protection
• Projects long range requirements for database administration and design in conjunction with other managers in the information systems function
• Designs, implements, and maintains complex databases, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods
• Includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design
• Plans and implements database backups, disaster recovery, and high availability solutions
• Maintains information assurance (IA) security documentation and artifacts for SQL databases 
• Implements applicable STIGS to develop automated and manual checklist results, and develop and execute POA&Ms for any database checklist findings
• Conducts quality control and auditing of databases in a web-based environment to ensure accurate and appropriate use of data
• Applies knowledge and experience with database technologies, development methodologies, and front end/backend programming languages
• Performs database programming and supports systems design
• Develops data-driven automated reports and business intelligence dashboards
• Troubleshoot database-related issues
• Identify and resolve performance bottlenecks, connectivity problems, and data integrity issues
• Advise users on access to various web-based databases
• Stay current with industry trends, best practices, and technologies related to database administration

REQUIRED QUALIFICATIONS

• Active US DoD TOP SECRET clearance.
• Five (5) years progressive experience of database query languages such as Oracle PL/SQL, SQL, SQLite, T-SQL, MS Access
• At least three years of hands-on experience and expertise with MS SQL Server using SSMS, SSRS, SSDT and Visual Studio
• Demonstrated experience implementing applicable DISA STIGs (database and instance)
• Familiarity with applicable technical controls in the Risk Management Framework for SQL databases
• Capability to work on various operating systems (Windows and Linux) and additional programming languages
• Demonstrated experience with at least two projects in a large organization responsible for administering, operating, maintaining, and securing a large-scale computer database
• Sensitivity Level: IT-I – Critical Sensitive 
• 8570 IAT II level certification, i.e. active Security + CE
• Minimum Associate degree in a relevant field
• Active Computing Environment Certification: MS SQL Server 2016, Azure Database Administrator or other relevant certifications 

We are seeking a Database Specialist III to provide technical leadership and support for our customer Defense Threat Reduction Agency (DTRA) at Fort Belvoir, VA.

TekSynap is a fast growing high-tech company that understands both the pace of technology today and the need to have a comprehensive well planned information management environment. “Technology moving at the speed of thought” embodies these principles – the need to nimbly utilize the best that information technology offers to meet the business needs of our Federal Government customers.

We offer our full-time employees a competitive benefits package to include health, dental, vision, 401K, life insurance, short-term and long-term disability plans, vacation time and holidays.

Visit us at www.TekSynap.com.

Apply now to explore jobs with us! 

The safety and health of our employees is of the utmost importance. Employees are required to comply with any contractually mandated Federal COVID-19 requirements. More information can be found here.

COMPETENCIES

• Establish Focus
• Change Management
• Develop Others
• Oral Communication
• Written Communication
• Interpersonal Awareness
• Build Relationships
• Analytical Thinking
• Conceptual Thinking
• Strategic Thinking
• Technical Expertise
• Initiative
• Foster Innovation
• Results Oriented
• Teamwork
• Customer Service

WORK ENVIRONMENT AND PHYSICAL DEMANDS

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of the job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• Location: Fort Belvoir, VA
• Type of environment: Fast paced, deadline-oriented environment
• Noise level: Medium
• Work schedule: Regular daytime shift Monday - Friday. May be requested to work evenings and weekends to meet program and contract needs
• Amount of Travel: 10%