SQL Database Administrator

Fayetteville, NC 28314

Posted: 07/15/2019 Industry: Information Technology Job Number: 35996

This position requires a secret clearance
Job Description
Primary Responsibilities
  • Create SSIS packages to load legacy data from Oracle databases into newly created CRM applications
  • Provide support to development team throughout the Software Development Life Cycle (SDLC)
  • Facilitate, implement, monitor and test database backups and recovery methodologies and processes
  • Identify and troubleshoot database issues
  • Implement and troubleshoot triggers, views, stored procedures and data integrity constraints
  • Participate in non-core business hours monthly patching
  • Provide 24/7 on-call support on a rotational basis

Secondary Responsibilities
  • Responsible for the installation, configuration, administration and management of Microsoft SQL Server 2016, SSRS, and SSIS servers
  • Responsible for the installation, configuration, administration and management of Oracle 11g database servers
  • Monitor and optimize the performance of the production SQL Server databases
  • Responsible for database security, integrity, reliability, high availability and disaster recovery solutions
  • Monitor file system space, determine database allocation, and proactively plan for increased capacity and scalability
  • Experience in an Always On environment
Education:
BA/BS
Qualifications:
Knowledge, Skills and Abilities
  • 8+ Years of Experience
  • Expert understanding of Structured Query Language (SQL) and Transact-SQL (T-SQL)
  • Experience with virtual environments (preferably Hyper-V) and SQL clustered environments
  • Experience with SQL Server Integration Services (SSIS) packages
  • Exposure to Resource Governor, Tuning Advisor, SQL Profiler and Windows Reliability and Performance Monitor
  • Ability to work in a dynamic fast paced environment that requires team interaction and coordination
  • Excellent communication skills to including technical writing and the ability to work in a collaborative team environment
  • Ability and willingness to expand knowledge and experience base
  • Ability to be detail oriented and to prioritize and complete assigned tasks within required deadlines
  • Exceptional problem solving and decision making capabilities, including troubleshooting technical issues, successfully resolving project issues and challenges, and developing creative solutions for process improvement and understanding user requirements
  • Strong understanding of database schema objects management, data modeling and architecture
  • Administration and maintenance of Oracle 11g Database Server and Microsoft SQL Server 2016 Database Server
Apply Online
Apply with LinkedIn Apply with Facebook Apply with Twitter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.