SQL DBA

Job#: 2005119

Job Description:

Apex Systems is looking to hire a SQL DBA to support one our large DOD clients here in Fayetteville, NC! This position will be on site- must be a USC. If interested in role, please contact Cameron at [email protected]

SQL Database Administrator 
Deliver insights to help our clients turn data into action as a Database Analyst Advisor. Your work will provide transformative solutions to our clients’ big-data obstacles and help advance the mission. Here, you can make a meaningful impact on our clients’ mission and on your career.
 

Responsibilities 

• Will be responsible for the installation, configuration, administration and management of Microsoft SQL Server 2005/2008R2/2012  and Microsoft SQL Reporting Services 2005/2008R2/2012.  

• Must have a strong understanding of database schema object management, data modeling and architecture. 

• Will facilitate, implement, monitor and test database backups and recovery methodologies and processes. 

• Will monitor and optimize the performance of the production SQL server databases. 

• Responsible for database security, integrity, reliability, high availability and disaster recovery solutions 

• Identify and troubleshoot database issues and the ability to analyze, design, build, test and implement solutions. 

• Implement and troubleshoot triggers, views, stored procedures and data integrity constraints. 

• Monitor file system space, database allocation; verify efficient use of disk storage; optimize space allocation; prevent out-of-space situations; and proactively plan for increased capacity and scalability. 

• Participate in non-core business hours monthly patching. 

• Provide 24/7 on-call support on a rotational basis. 

Knowledge, Skills and Abilities 

• 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 replication topologies. 

• Exposure to Resource Governor, Tuning Advisor, SQL Profiler and Windows Reliability and Performance Monitor  

• Should have the ability to work in a dynamic fast paced environment that requires team interaction and coordination across multiple information technology teams. 

• Should have excellent communication skills to include technical writing and the ability to work in a collaborative team. 

• Ability and willingness to continue to expand knowledge and experience; be detail oriented; and prioritize and complete assigned tasks within required deadlines. 

• Exceptional problem solving and decision making capabilities to include troubleshooting technical issues, resolving project issues and challenges, understanding user requirements and developing creative solutions for process improvement. 

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.