CACI International Environment Administrator/SQL Developer in Millington, Tennessee
The MyNavy HR enterprise is modernizing the way it operates to provide improved service delivery to current and future Sailors and their families. The Navy is successfully recruiting, training, and managing its Sailors in today’s demanding operational environment.
Environment Administrator/SQL Developer to join the Navy Personnel and Pay (NP2) team.
Position will be responsible for configuring, staging, and replicating data on a Peoplesoft environment developed for creating training products and demonstration/training purposes.
Key tasks include:
Install/Configure SQL Server versions 2012-2017, including all components and features on Windows Server. Data Mining experience to provide user roles and data subsets specific to training development requirements within Peoplesoft HCM. Experience with Peoplesoft HCM back end work and Peoplesoft HCM administrative applications.
Create deployment specifications based on database requirements documentation
Provision permissions based on least privilege principle
Deploy code to Database Engine, Integration and Reporting Services
Assist developers with query tuning and schema refinement
Analyze, solve, and correct issues in real-time
Refine and automate regular processes, track issues, and document change
Perform scheduled maintenance and support release deployment activities after hours
Strategically plan necessary corrective actions in production in the shortest possible window
5 + years of experience as a SQL Server DBA with:
SQL Server Management Studio and SQL Server Data Tools/Visual Studio
Performance Tuning and Optimization
Backups, restores and recovery models
T-SQL scripting and development, including creating stored procedures, views and user-defined functions
High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Native Maintenance Plan Design
Windows Server versions 2012-2016, including firewall configurations
Storage capacity planning
Software Development Life Cycle
Sense of ownership and pride in your performance and its impact on company's success
Critical thinker and problem-solving skills
Good time-management skills
Great interpersonal and communication skills
Qualifications that are nice to have:
SQL Server 2019
SQL Server Replication
SQL Server Partitioning
SSRS & SSIS Development
Windows Server 2019
Windows Failover Clustering
What we can offer you!
We’ve been named a Best Place to Work by the Washington Post.
Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives.
We offer competitive benefits and learning and development opportunities.
We are mission-oriented and ever vigilant in aligning our solutions with the nation’s highest priorities.
For over 55 years, the principles of CACI’s unique, character-based culture have been the driving force behind our success.
CACI employs a diverse range of talent to create an environment that fuels innovation and fosters continuous improvement and success. At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is proud to provide dynamic careers for employees worldwide. CACI is an Equal Opportunity Employer - Females/Minorities/Protected Veterans/Individuals with Disabilities.