The primary responsibilities of the Database Administrator include:
- Create and manage database user accounts.
- Monitoring the state of the Enterprise Intelligence Information System and taking preventive or corrective actions as required and working with the EA or KM technical teams as required.
- Diagnosing and reporting critical errors.
- Providing first level technical support by analyzing and troubleshooting software and hardware issues.
- Maintains security and integrity controls.
- Reviews database design and integration of systems. Provides backup recovery and make recommendations regarding enhancements and improvements.
- Oversees scheduling of database projects, database and transaction log backups, notifications, and DB replication between multiple SQL Servers.
- Manage and Update Enterprise Intelligence Information System Schema (tables, data elements, indices etc.).
- Manage and Update Integration Services Packages, Application Normalization Packages, Security Packages.
- Reviewing technical designs, reports, documentation etc.
- Active DOD/DSS SECRET security clearance or higher.
- Bachelor’s Degree or Masters in Computer Science or Information Systems.
- At least five (5) to seven (7) years’ experience in database administration.
- Microsoft Certified Solutions Associate (SQL Server 2012 or v12.0/2014 or V13.0/2016).
- Extensive experience with SQL Server Reporting Services and Integration Services.
- Experience with performance tuning and optimizing T-SQL queries and database.
- Familiarity with State Department and the Managing State Projects for Information Technology (MSP-IT) project cycle.
- Familiarity with the Software Development Life Cycle (SDLC).
- Experience with User Interface designs and mockups.
- Previous experience working with Federal Government clients is highly desirable.