SQL Database Analyst

SECUREVISION, LLC
Springfield, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Springfield, United States of America

Tech stack

Software Documentation
CompTIA Security+
Databases
Database Analysis
Failover
Failover Clustering
Microsoft SQL Server
Windows Server
Oracle
Oracle Applications
Performance Tuning
SQL Databases
SQL Server Agent
Strategies of Testing
Alwayson
Information Technology
Operational Systems
Database Backup

Job description

SecureVision has an immediate need for a SQL database analyst to analyze, design, develop, implement, and support SQL infrastructure deployment and management. The individual will work under limited supervision and perform additional duties as assigned to include, but not limited to:

  • Manages the functionality and efficiency of a group of servers running on one or more operating systems.
  • Maintains the integrity and security of servers and systems.
  • Sets up administrator and service accounts.
  • Maintains system documentation
  • Interacts with users and evaluates vendor products.
  • Develops and monitors policies and standards for allocation related to the use of computing resources.
  • Develops and implements testing strategies and document results.
  • Provides advice on performance tuning and training to end-users.
  • Maintains current knowledge of relevant technologies as assigned.
  • Participates in special projects as required.

Requirements

  • Bachelors Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience
  • 10 + years of related database analysis and/or administration experience.
  • SQL experience required. Oracle database administration a plus.
  • CompTIA Security+ or equivalent recommended.
  • Experience in Oracle or SQL administration/tuning; including knowledge and implementation of database high-availability solutions (Windows Server Failover Clusters, SQL Server Failover Cluster instances, and AlwaysOn Availability groups)
  • Experience in monitoring, creating, and managing SQL server agent alerts
  • Experience with Database backup, restore, migration, and Database snapshot technologies/strategies
  • Knowledge on how to build/maintain efficient database table structures for both transactional and warehouse data
  • Knowledge of Oracle 19c administration and performance tuning

Candidates must hold a TS/SCI

Apply for this position