SQL Server DBA/Engineer (Tier III) with TS/SCI Clearance
Responsible for designing, planning, implementing and administering databases, including security, access, and documentation. 1. Participates in the design, maintenance, enhancement, coding, and administration of relational databases. 2. Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities. 3. 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. 5. 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. 6. Assignments may include design of data dictionaries, database structure and layout, installing, upgrading, and managing database applications. 7. Provides guidance and work leadership to less experienced Analysts, and may have supervisory responsibilities. 8. May serve as technical team or task leader. 9. Stay current on vendors' best security practices in relation to organizational requirements. 10. Maintains current knowledge of relevant technologies as assigned. 11. Participates in special projects as required. Position Duties and Responsibilities The O&S Senior Level SQL Server DBA/Engineer responsibilities will include: * Being a technical resource for SQL related design; performance; security and configuration issues * Provide troubleshooting and problem resolution for MS SQL Server related issues * Developing and maintaining O&S operating procedures for the Compute infrastructure in addition to providing on-the-job training to AIT O&S Tier II personnel * Support both VMware virtualized environments and bare metal installations for databases * Understand NCE-Active IT baseline capabilities; design and objectives * Gain familiarity with current data center infrastructure. * Some interaction with end user to validate business requirements against technical implementation plan * Supporting the Certification and Accreditation process - running SRR; resolving findings; documenting solutions; workarounds or provide justifications for exceptions * Maintain current industry knowledge of relevant concepts; practices and procedures. Education Bachelors Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience. Qualifications 10-15 years of related database analysis and/or administration experience. Skills and Abilities:
- Advanced knowledge of the principles, methods, and techniques used in database development, coding, and design, including business analysis, event modeling, logical and physical database design, data access analysis and design, DBMS optimization, archive and recovery strategy, load strategy design and implementation, security, and change management.Proficiency in the use of one or more specific technologies, depending on job assignment.Professional certification(s) may be required, depending on job assignment.Ability to communicate technical information in a clear and concise manner.