Receive alerts when this company posts new jobs.
at Avacend, Inc.
Requisition Name : Access/SQL DBA
Duration : 03+ Months
Location: Atlanta, GA 30329
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.