Our client is seeking an Intermediate Database Administrator to act as part of a distributed team responsible for all enterprise operational database functionality. The related infrastructure supports core functions such as information acquisition, analysis, storage, and retention for financial, materials, sales, logistics, exploration, environmental, and risk purposes. This is an excellent job opportunity where you can collaborate alongside a team of experienced DBAs.
Duties & Responsibilities
Design, install, monitor, maintain and performance tune production SQL Servers and databases while ensuring high levels of data availability.
Participate in continuous improvement efforts to enhance performance and provide increased functionality of SQL Servers and database environment.
Perform proactive maintenance such as space availability monitoring, activity monitoring, document problems, changes and solutions.
Work with Infrastructure teams on the configuration and deployment of SQL\database servers.
Provide appropriate patching, security updates, and platform upgrade activities as well as routine administration tasks including maintenance, backup, and restore of database account.
Minimum of 3 to 5 years of experience with Database Administration for MSSQL Server
Experience with managing maintenance plans, database backup/recovery and environment refreshes.
Advanced knowledge of debugging and performance tuning SQL queries, stored procedures and indexes.
Advanced knowledge of Microsoft SQL Server Reporting (SSRS), Analysis (SSAS) and Integration Services (SSIS).
Advanced knowledge of MS clustering, SQL Replication, SQL Log Shipping and AlwaysOn.
Experience designing relational database objects such as tables, stored procedures, triggers and DTS/SSIS packages.
Annex Consulting Group is a full service IT and management consulting firm, specializing in staff augmentation contracting, permanent staffing, and outsourced solutions. Candidates must be legally entitled to work in location advertised.
Not interested but know someone who is a fit for this role? Check out the award-winning Annex Referral Program .
Leaders in IT. Advisors in Business. Partners in Solutions.