Job Details

ID #15577583
State Arizona
City Tucson
Job type Contract
Salary USD $40 - $45 hr 40 - 45 hr
Source CompuGain Corporation
Showed 2021-06-18
Date 2021-06-17
Deadline 2021-08-16
Category Et cetera
Create resume

Database Administrator - SQL

Arizona, Tucson, 85706 Tucson USA

Vacancy expired!

As per our client need we are unable to work on Corp to Corp for this position, please apply only if you are eligible to work on CompuGain W2 Database Administrator 6+ Months Contract (Possible Fulltime) Tucson, AZ 85706 Primary Responsibilities:

  • Support the provision of SQL database design and development services in support of maintenance, enhancements and modernization of the CMOP facilities. The CMOP software baseline inclusive of the underlying databases are responsible order management, inventory control, fulfillment activities and the interfaces with the equipment on the automation floor.
  • Install and maintain the performance of database servers, to ensure all SQL processes, procedures, and jobs are functioning correctly each day.
  • Test servers each day using SQL Server Management Studio. Correct any problems found during testing during the same production day. Document testing results in the Daily Database Server Report
  • Manage database access for on-site staff and remotely staff IAW authorization approval.
  • Perform backups and recovery operations to meet established Recovery Point Objective.
  • Utilize SQL database and SQL server tools (i.e. Server Analysis Service (SSAS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS)), available monitors, and dashboards to diagnose database issues and apply findings to derive a solutions.
  • Develop tasks, jobs and processes as needed to enhance database performance and apply new features utilizing PowerShell to efficiently and effectively manage and move data between databases as needed.
  • Program using industry standard methods.
  • Develop solutions that integrate with existing VA architecture.
  • Apply expert knowledge of advanced technical principles, theories, and concepts to sustain and enhance the CMOP databases.
  • Be involved in analyses and the investigation of database performance and any blocking issues.
  • Work closely with the customer to identify and address any database issues as they arise.
  • Monitor SQL Agent jobs and processes.
  • Monitor SSIS package executions and report on any errors.
  • Create SSRS reports to monitor health as well as key performance indicators.
Basic Qualifications:Bachelor's degree. 8 years of additional relevant experience may be substituted for the degree.
  • 5 or more years experience of database administration on Microsoft SQL Server databases.
  • High level knowledge of SQL: indexes, normalization, schemas, stored procedures, and triggers
  • Experience with Relational database design
  • Expert T-SQL programming and analysis skills
  • Strong database development skills MS SQL 2016/2019
  • Strong SSIS and ETL skills
  • Experience developing systems in the Microsoft environment using Microsoft s development tools in real-time is required (SSMS, VS, etc.)
  • Proven experience in developing and supporting large development initiatives that are similar in scope and complexity to VA s CMOP
  • Experience with automated unit testing and integration testing
  • Collaborator, self-starter, strategic providing input to technical design to meet project objectives
  • Experience in high transaction OLTP relational databases
  • Ability to work in fast paced environment and deliver results.
Preferred Qualifications:
  • 5 or more years experience of database administration on Microsoft SQL Server databases.
  • Experience with Visual studio 2019
  • Experience with .NET and C#
  • Understanding or experience of development and integration processes in multiple environments.
  • Experience with Microsoft Team Foundation Server (TFS) 2015
  • Experience with Microsoft Teams
  • Ability to adequately document designs, coded solutions and systems.
  • Experience with Mid-Tier Application Servers (IIS)
  • Ideally 2+ years of experience in the field of industrial process automation similar to CMOP or health care industry
  • Experience working in an industrial automation environment similar to CMOP or health care industry
  • Experience with Department of Veterans Affairs within the last two years, to include previous possession of VA PIV card and VA network access
  • Experience working as a contractor for the Federal government.
Thank You,Prohit PabbathisUS Professional ServicesCompuGain12901 Worldgate Drive, Suite 510, Herndon, VA 20170703-454-0340 (Whatsapp Me) | prohit.pabbathis@compugain.com

Vacancy expired!

Subscribe Report job