Directs the overall 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
Directs fulfillment of requirements from a projects inception to it conclusion
Directs organization of requirements and data into a usable database schema by directing development of ad hoc queries, scripts, macros, updates to existing queries
Directs the development of complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies Level 3
MANDATORY SKILLS: Ten (10) or more years of database engineering experience required. [A Masters degree in a related discipline may substitute for two (2) years of experience]
Bachelors degree in Computer Science, Mathematics, Statistics OR related field
[Twelve (12) years of experience (for a total of twenty-two (22) or more years) may be substituted for a degree.]
DODI 8570.1 Compliance at IAT Level I certification required.
Active Top Secret/Sensitive Compartmented Information (TS/SCI) security clearance required.
U.S. Citizenship required.
Apache Hadoop, PostgresSQL, MYSQL or VMware or Oracle DBMS knowledge
Possess knowledge of SQL Server and its tools including the facets of successfully administering a wide range of simple to highly complex environments.
Experience with data and schema design and engineering
Demonstrated practical experience with data migration from legacy systems to central repositories
Industry standard exchange schema implementation experience (E.g. Cybox or Capec)
Be able to evaluate and install new software releases, patches and system upgrades.
Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage.
Experience supporting technology strategy / roadmap.
Experience with development and execution of database security policies, procedures and auditing-experience with database authentication methods, authorization methods, and data encryption techniques.
Possess good communication skills, both oral and written.
Must work well in a team environment as well as independently.
Must exhibit good time management skills, independent decision making capability; focus on customer service.
Ability to work with the other technical members of the team to administer and support the overall database and applications environment.
OPTIONAL SKILLS: Masters degree preferred.
Experience database engineering support to DHS, DoD or Intelligence Customers
Data Scientist skills and experience
Understanding of Certification and Accreditation (NIST 800-53) processes as they apply to database technologies
Operating system and hardware platform knowledge preferred.
Experience working with large unstructured data sets
Experience with Map/Reduce technologies
Experience with process development and deployment
Trained in Six Sigma Methodology
ITIL knowledge and certification
Cloudera Certified Professional (CCP): Data Scientist
CCDH: Cloudera Certified Developer for Apache Hadoop
CCAH: Cloudera Certified Administrator for Apache Hadoop
CCSHB: Cloudera Certified Specialist in Apache
CSSLP Certified Secure Software Lifecycle Professional
Database specific certifications as appropriate to position
DODI 8570.1 Compliance at IAT Level I certification highly desired.
About Avid Technology Professionals
Avid Technology Professionals, LLC (ATP) is a premiere provider of software and systems engineering, and acquisition program management services for the community. ATP is actively seeking to pursue contract opportunities with other departments and agencies in the federal government, in state governments, and in the commercial sectors. Delivered by seasoned experts in the IT field, ATP solutions adeptly address the IT concerns manifesting in both the federal and commercial sectors.
The ATP Employee Benefits package includes:
* A Supportive and Equitable Working Environment that is both Stimulating and Challenging
* Competitive Hourly Salary
* Unique Employee Success Sharing Program that allows ATP employees to Share in Company's Successes
* Automatic Approved Overtime (as long as contract permits)
* Retirement Pay (401K); 100% company paid, immediately vested with Profit-Sharing Component
* Company Medical Coverage Plans - HMO, Open Access, PPO plans
* Company Dental Plan - widely accepted, comprehensive, and flexible
* Progressive Overtime Policy
* Flexible Spending Account benefit
* Lucrative Referral Bonus Policy
* Holiday Scheduling that Coincides with Government Holidays
* Robust Professional Expenses & Training Program
* Computer Allowance
* Internet Allowance
* Short and Long Term Disability
* Life Insurance