4416 SQL Database Analyst

Procession Systems
Springfield, United States of America
24 days 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
PostgreSQL
Microsoft SQL Server
Windows Server
MySQL
Oracle
Oracle Applications
Performance Tuning
SQL Databases
SQL Server Agent
Strategies of Testing
Alwayson
Information Technology
Database Backup

Job description

We are looking for a SQL Database Analyst to analyze, design, develop, implement, and support SQL infrastructure deployment and management. The selected individual will work under limited supervision and perform additional duties as assigned.

GENERAL DUTIES:

  • 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
  • 5 + years of related database analysis and/or administration experience.
  • SQL experience required.
  • 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
  • Migration experience with MySQL and PostgresSQL

DESIRED QUALIFICATIONS:

  • Oracle database administration is a plus.
  • CompTIA Security+ or equivalent recommended.

Apply for this position