Responsibilities
The Defense Commissary Agency provides a worldwide network of commissaries that sell groceries and household supplies at low cost to members of the Armed Services. DeCA operates in a 24 x 7 x 365 mode of operations.
This is 100% telecommute opportunity.
The SQL Server DBA will support will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications.
Installed SQL within the Defense Commissary Agency – MS SQL Server 2012, MS SQL Server 2016, MS SQL Server 2019.
Database Administrator Job Responsibilities:
• Install and maintain the performance of database servers.
• Develop processes for optimizing database security.
• Set and maintain database standards.
• Manage database access.
• Performance tuning of database systems.
• Install, upgrade, and manage database applications.
• Diagnose and troubleshoot database errors.
• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards.
• Create automation for repeating database tasks.
• Attend daily morning staff meetings, and ad hoc meetings.
• Be available for on-call support as needed.
Implements and optimizes the computerized database systems that support the Company’s or client’s ability to function on a daily basis. Implements and maintains smooth operation and physical design of databases. Conducts performance tuning of indexes and databases in general. Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements. Maintains security and integrity controls. Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization. May develop stored procedures and/or triggers. Administers a variety of database systems ,such as Microsoft SQL Server, and other Database Management Systems (DBMS). Develops and enforces database administration and user standards and procedures; audits, modifies, and amends data in systems using SQL commands. Oversees the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple SQL Servers and remote sites. Assists Database Designers/Information System Analysts in the development and creation of SQL and Web-based databases and database systems. Reviews technical designs, reports, documentation, and other materials produced by staff; creates and maintains high-level reporting systems using products such as Crystal Reports; researches and implements new database and online technology.
Qualifications
• BS 10-12, MS 8-10, Phd 5-7
• Active Secret clearance or willing to obtain Interim Secret clearance
• Active CompTIA Security+ certification
• Strong command of SQL and SQL server tools
• Advanced knowledge of database security, backup and recovery, and performance monitoring
standards
• Understanding of relational and dimensional data modeling
• Familiarity with SSAS, SSIS, SSRS
• Experience with SQL server to server network communications using ODBC and OLE
• Familiarity with DISA STIG configuration and documentation processes
• Strong mathematical and statistical knowledge
• Excellent written and verbal communication skills
• Impeccable attention to detail
At Peraton, our benefits are designed to help keep you at your best beyond the work you do with us daily. We’re fully committed to the growth of our employees. From fully comprehensive medical plans to tuition reimbursement, tuition assistance, and fertility treatment, we are there to support you all the way.
Peraton Overview
Peraton drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted and highly differentiated national security solutions and technologies that keep people safe and secure. Peraton serves as a valued partner to essential government agencies across the intelligence, space, cyber, defense, civilian, health, and state and local markets. Every day, our employees do the can’t be done, solving the most daunting challenges facing our customers.
Target Salary Range
$112,000 – $179,000. This represents the typical salary range for this position based on experience and other factors.
EEO
An Equal Opportunity Employer including Disability/Veteran.