Avacend, Inc.

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

Access/SQL DBA

at Avacend, Inc.

Posted: 9/28/2019
Job Reference #: 7767
Keywords:

Job Description

Tracking Code
7767-287
Job Description

Requisition Name : Access/SQL DBA

Duration : 03+ Months

Location: Atlanta, GA 30329

Job Description

Administer, support, and maintain multiple MS SQL databases to ensure their performance, availability, and security for the agency both on prem/Azure. Support legacy database integration with SQL and MS Access tables linked to MS Access front ends

Responsible for ensuring availability and performance of the MS SQL databases that support the various systems.

Understanding of linking SQL with legacy MS Access databases using ODBC connections.

Responsible for troubleshooting and problem solving for MS SQL and MS Access front ends in a multi-user environment.

Proactively monitor the database systems to secure services with minimum downtime.

Responsible for providing trend and usage/capacity analysis to server management team to enable them to make informed decisions regarding resource management/allocation.

Responsible for improvement and maintenance of the databases to include rollout and upgrades.

Administer Microsoft SQL Servers that are on-prem and in Azure.

Proactively address issues to ensure optimum performance. Maintain database integrity, stability and availability.

Design, Setup and Manage replication for the articles across multiple database servers involving multiple publishers and subscribers.

Provide guidance to .Net development teams in data and schema design to ensure proper implementation and utilization of the data structures.

Hands-on experience with MS SQL database running in a Virtual environment running Windows a plus.

Job Location
Atlanta, Georgia, United States
Position Type
Full-Time/Regular