Previous Job
Previous
MS SQL Database Administrator
Ref No.: 17-25073
Location: Phoenix, Arizona
Requirements, Essential Knowledge of:
  • MS SQL databases versions 2012, 2014, 2016
  • Data Modelling
  • SQL language
  • High availability and resiliency architectures
  • Security features and functions including encryption
  • Data Protection
  • Monitoring and alerting functionality

Highly Preferred:
Minimum 10 years hands-on experience in Microsoft SQL:
  • MS Database Architect certification preferable.
  • Good understanding of software virtualization.
  • Developing database solutions and defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
  • Database Design, Data Maintenance, Database Security, Database Management.
  • Importing client data and set up databases based on load and program requirements.
  • Spearheading code review quality assurance and acceptance processes.
  • Designing and implementing custom scripts triggers and stored procedures views and other application database code objects.
  • Maintaining SQL scripts indexes and complex queries for analysis and extraction.
  • Performing quality testing and assurance for SQL servers.
  • Ensuring best practice application to maintain security and integrity of data.
  • Mid-range platform virtualization technologies.
  • Advanced knowledge of high availability systems solutions to include cluster configuration, data replication technologies, failover configurations, backup technologies and IT systems business continuity solutions.
  • Advanced knowledge of Storage Area Network and other third party storage arrays from specific detail about components and software to an overall view of the requirements for storage across the enterprise. Ability to provide capacity planning forecasts for storage and systems component resource planning.
  • Knowledge of network protocols and routing, network, server, and host operating systems.



Regards,
Nehas
703-889-6786
Lancesoft.inc