Description: Provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis. Develops relations and/or Object-Oriented databases, database parser software, and database loading software. Project long-range requirements for database administration and design. Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls. The DBE works primarily;
• At the front end of the life-cycle requirements through system acceptance testing and Initial Operation Capability (IOC) • Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts. • Administer and engineer database solutions to enable the efficient SQL licensing posture and a more reliable undercarriage for IT services and OS management software.
• Translates a set of requirements and data into a useable document by creating or recreating ad hoc queries, scripts and macros;
• Updates existing queries, creates new ones to manipulate data into a master file; and builds complex systems using queries, tables, Open Database Connectivity and database storage.
• Manage SQL Databases and perform database performance tuning and backup.
• Follow and improve ELT/ETL data base design patterns, document and provide support. Qualifications: • An Active TS/SCI clearance FS polygraph
• Ten (10) years' experience as a DBE in programs and contracts of similar scope, type and complexity is required.
• Bachelor's degree in a technical discipline from an accredited college or university is required.
• Five (5) years of DBE experience may be substituted for a bachelor's degree.
• The candidate must have IAT level 2 certification to meet DoD 8570 requirement.
• Demonstrated experience with SQL Server Columbia Technology Partners is an Equal Opportunity Employer. We consider applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, or membership in any other group protected by federal, state, or local law. Our EEO policy reflects our commitment to ensure equality and promote diversity and inclusion in the workplace. Our policy applies to all employees, job candidates, contractors, stakeholders, partners, and visitors.