SQL Database Administrator


  • Maintenance, troubleshooting and problem resolution support for supported MS SQL databases including backup and recovery, database upgrades and technical DBA functions such as table space allocation and management, data storage management, tuning and database management
  • Database Security (administration, monitoring/reviews, recommendations for mitigating risks or requesting)
  • Database connectivity monitoring and troubleshooting issues
  • Database optimization and monitoring
  • Run scripts to update the supported database within an application area
  • Review transaction processing techniques and advises developers as appropriate to maximize performance
  • Responsible for testing of security patches and vendor upgrades
  • Responsible for coordinating customer testing and approval for the implementation of production changes and software/database upgrades
  • Responsible for ensuring database connectivity for all supported MS SQL databases
  • Assist in producing and maintaining technical documentation of enhancements and BC/DR procedures
  • Researches and develops solutions to difficult issues and presents alternatives to management
  • Provide technical support with third-party integration products
  • Reviews literature, consults with experts, and coordinates with vendors to identify appropriate hardware and/or software solutions to complex problems
  • Assists programmers with problem determination and resolution
  • Informs programming staff of any changes in databases that may require system or program modification
  • Responsible for managing single and multi-departmental projects
  • Coordinates project staff, which may cross organizational lines, to successful outcomes
  • Receives direction and reports to a top departmental manager, who is consulted on unusual or complex matters
  • Performs other related duties as assigned

 

Required Knowledge/Skills/Abilities:

  • Any combination of education and experience that would prepare the incumbent to perform the duties of the position at the appropriate level.  Employees would typically have 5 or more years of experience in relational databases.
  • Ability to learn quickly and understand the operations of customer agencies
  • Ability to exercise independent judgment in interpreting and applying procedures to specific cases
  • Ability to deal with management, vendors, and others effectively in situations requiring tact and discretion, persuasion, and working through difficult issues
  • Ability to establish and maintain effective working relationships
  • Ability to develop and write documentation
  • Ability to communicate effectively, both orally and in writing
  • Knowledge of Microsoft Office Suite
  • Knowledge of SQL Server – SSMS, SSIS, SSRS, backup, restore, data connections
  • Knowledge of query language, query building, ELT concepts
  • Knowledge of SQL Server principles and Windows security principles

 

Preferred:

  • Experience with BMC Spotlight
  • Experience with SQL DB implantation and administration within Microsoft Azure
  • Experience with Microsoft Azure Cosmos DB
  • Working knowledge of IaaS and PaaS services within Microsoft Azure
  • Experience with SQL DB implantation and administration on VMware
  • Experience as it relates to SQL databases in an Enterprise Data Warehouse environment

Contact Us!

Name *

Email *

Subject

Message

What we do

RESOURCETEK provides technical staff augmentation, professional recruitment and support services to our partner clients in industry and government. RESOURCETEK has proven experience in providing the highest qualified technical talent in the areas of Engineering, Design, Construction Project Management, Information Technology and other Technical Disciplines.

"I can count on ResourceTek to understand our needs and consistently provide the right people for our projects"


Menu Title