Sr Principal Analyst, Database

7 days left

Location
Ft Leavenworth, KS
Posted
Jul 13, 2017
Closes
Aug 03, 2017
Hours
Full Time
Responsible for migrating the current database to SQL Server 2014. Maintain continuous database availability. Provide Database & Web Applications recommendations to the government.

 

Daily operation duties

    Implement database clusterDeployment of SSIS packagesThe SMS Archive project – database design and SQL Server Reporting ServicesTech refresh – Data modelling, database development (stored procedures, TFS)
O&M

    Daily checksDatabase backups and restorePerformance monitoring and tuning
Database optimization

    Implement database clustering (Always on Activity Group) pending CR and stand-up of second server in clusterSupport the tech refresh of the application
Security enhancements

    Implement security patches required as discovered by Above Baseline Scan (I think we have this under control now)The SQL Servers need to be STIG. Develop regular security checks on systemReview Change Management Plan, Configuration Management Plan and Patch Management Plan (the plans are pretty much developed) 
 

Additional Duties

 

1. Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.

2. Participates in continuous improvement efforts in enhancing performance and providing increased functionality, including performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, changes, and solutions. 

3. Assignments may include design of data dictionaries, database structure and layout, installing, upgrading, and managing database applications.

4. Stay current on vendors' best security practices in relation to organizational requirements.

5. Maintains current knowledge of relevant technologies as assigned.

6. May provide guidance and work leadership to less-experienced Analysts.

7. Tests designed applications.

8. Coordinates new data development ensuring consistency and integration with existing data warehouse structure. 4. Reviews business requests for data and data usage, researches data sources for new and better data feeds.

9. Participates in the design, maintenance, enhancement, coding, and administration of relational databases.

10. Participates in special projects as required

Education Bachelor’s Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.

 

BA or BS degree in CS or Information systems preferred

Qualifications 10-15 years of related database analysis and/oradministration experience.

 

-Experience with SQL Server Management Studio (SSMS), T-SQL, stored procedures, DMVs, Visual Studio

 

-5+ years of experience operating and maintain SQL Server including performing backups and restores, performance monitoring and configuration management

 

-5+ years of experience with supporting developing and enhancing database applications including database design and development, source control, and code reviews

 

-5+ years of experience supporting and administering secure systems.  Advanced knowledge of security including implementing and documenting government STIGS

 

-4+ years of experience with managing IT task and solution delivery

 

-Maintain DoD 8570.1 workforce security certification requirements

 

-Experience with administering systems in a government environment

 

-5+ years .NET application development

 

The following certifications are required:

Microsoft Certified Solutions Expert (MCSE); Data Platform certification IA/IT certification at Technical Level II per DoD 8570.01-M within 6 months of start date.

 

In addition, must have familiarity with Department of Defense authentication systems (e.g. AKO), data models, terminology, and information security requirements.

 

Active Secret security clearance.

 

As a trusted systems integrator for more than 50 years, General Dynamics Information Technology provides information technology (IT), systems engineering, professional services and simulation and training to customers in the defense, federal civilian government, health, homeland security, intelligence, state and local government and commercial sectors. With approximately 32,000 professionals worldwide, the company delivers IT enterprise solutions, manages large-scale, mission-critical IT programs and provides mission support services. GDIT is an Equal Opportunity/Affirmative Action Employer - Minorities/Females/Protected Veterans/Individuals with Disabilities.