SQL DBA, SR

SQL DBA, SR

Position Location:  Fort Bragg, NC

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/BA (or equivalent experience)

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
  • DoD 8570 compliant for IAT Level II
  • 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

Clearance - TS/SCI (can start with a Secret)

NOTE: To all recruitment and staffing agencies: SOFTACT does not accept agency resumes or soliciting of your services. Please do not
forward resumes to our jobs alias, SOFTACT employees or any other company location. SOFTACT is not responsible for any fees
related to unsolicited resumes or staffing services. Do not attempt to solicit your services. Thank you.

Leave your comments

Post comment as a guest

0
terms and conditions.

Comments