Skip to content

This website uses cookies to provide features and services. By using the site you agree to the use of cookies.Cookie policy.  Close
JobServe
 

Atlanta, Georgia - USD Full Time Posted: Thursday, 15 August 2019
 
 
Job Description

DCA - Access/SQL DBA

Location: Executive Park South NE, Atlanta, GA 30329

Length: 2-month Contract

Pay Rate: $50.00 per hour

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

Responsibilities

  • 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.

Experience with MS SQL Server - Required - 5 Years
Experience with SQL data warehouse - Required - 5 Years
Experience with MS Access front-ends - Required - 5 Years
SQL database (2008 +) administration tasks (installing, maintaining, monitoring, recovering, rebuilding, upgrading, patching and performance tuning) - Required - 5 Years
Experience in database design and development, computer software development, management information systems, web design, info systems - Required - 5 Years
Experience creating and maintaining MS Access tables, queries, forms - Required - 5 Years
Experience with database security concepts, including access, auditing, and encryption - Required - 5 Years
Experience with PowerBI and SSRS is a plus - Nice to have
Bachelor's degree in Computer Science, IT, Engineering, related field - Highly desired
Experience in Microsoft Azure Cloud SQL - Highly desired
Microsoft SQL Server certification(s) is a plus - Highly desired



Atlanta, Georgia, United States of America
IT
USD
Computer Main Stream Corp.
Computer Main Stream Corp.
JS8BA9B94A/745533106
8/15/2019 12:37:34 AM

We strongly recommend that you should never provide your bank account details to an advertiser during the job application process. Should you receive a request of this nature please contact support giving the advertiser's name and job reference.

Other jobs like this

Atlanta, Georgia
USD
Atlanta, Georgia
Atlanta, Georgia
USD
Atlanta, Georgia
USD
Atlanta, Georgia
USD
See more