Database Developer

Description: Position Requires a Top Secret (TS/SCI) Clearance with a Polygraph. The Database Engineer in this role will perform high level database engineering and management tasks. This includes leading, data design, data structure identification, database schema definition, data access privilege management, data query optimization, documentation, database instance upgrades, long-range requirements, operational guidelines, and data protection. Primary Responsibilities
• Serve as the high side DB Engineer / Administrator for the API Services Team
• Responsible for ongoing maintenance of existing DB (AWS RDS)
• Identify performance bottlenecks in current DB and implement fixes (short term and long term)
• Optimize all DB queries and updates within microservices and identify best solution for implementation (e.g., stored procedure)
• Define a migration path from the current database to the "to be" database to optimize for workload encountered in production
• Coordinate with Low side team(s) to develop changes in the low side development and test environments and package them to be deployed to the high side environments
• Responsible for performing ETL development activities including, but not limited to, parser development and deployment; data flow management; implementing data lifecycle policies; troubleshooting data access issues; and developing data models. Details: Labor Category: Database Developer Position Level: Level 1 - Subject Matter Expert Salary: Up to $215,000.00 per year Core Hours: 9am to 4pm Location: Reston VA Mandatory Requirements:
• Experience applying expert domain knowledge of database management systems and SQL optimization
• Experience with Dynamo and SQL based DBs
• 5+ years' experience with Postgres, Oracle, MySQL, or other commercial database management system
• Extensive knowledge in writing and optimizing complex SQL statements and stored procedures
• Extensive experience developing extract, load, and transfer software operations for data sets in an AWS environment utilizing NiFi flows.
• Experience negotiating complex scenarios and challenges and devising courses of action to resolve situations with predictable outcomes.
• Experience leading critical objectives where decision making is of utmost concern to the outcome. Candidate must have a Bachelor's degree with 8-12 years of prior relevant experience or a Master's with 6-10 years of prior relevant experience. Optional Requirements:
• Experience with AWS/C2S services including RDS
• Demonstrated experience using Spring, Kafka, Elasticsearch, and NiFi. B4CORP Company Information B4Corp is a small defense contracting company that focuses on providing an optimum environment for mission-focused, highly skilled consultants to support the United States of America's intelligence community and other defense organizations. B4Corp provides a low overhead, highly efficient, high salary environment that allows employees to excel at meeting the client's needs. B4Corp is looking for information technology professionals that have a high sense of personal responsibility, self-motivation, and mission drive. B4Corp's dedication and care for its employees is reflected in our outstanding compensation and benefits package. B4Corp's benefits reflect the company's policy of putting the employees first. B4Corp's maximum flexibility comp / makeup time policy, along with the company's cafeteria-style benefit plan that allows employees to maximize their Benefit Dollars, reflects B4Corp's commitment to its employees. Compensation: Outstanding Salaries Retirement: Full Vanguard 401k Plan - Featuring a full scope of investment options - 100% employer matched contribution up to 6% of employee's salary - Ability to max out 401k savings $57k ($63.5k if over 50) Employees receive B4Corp phantom stock each year (2-year vesting period) Insurance: Medical - United Health Care (UHC) (multiple plan options) Dental - United Concordia (UC) Flex Plan Vision - Vision Service Plan Insurance Co (VSP) Signature Plans Mutual of Omaha short-term disability (60% of salary up to $2,000.00/week) Mutual of Omaha long-term disability (60% of salary up to $10,000.00/month) Mutual of Omaha life insurance ($200,000.00) Employee Referral Bonus: Refer a friend or a coworker and receive $3,000 per year for every year the person works for B4CORP Paid Time Off (PTO): Seven weeks of leave per year (including ten federal holidays) Flexible work schedule with comp time (with customer approval) Tuition and Training: Free CBTNuggets Online Training Account - More than 200 online IT courses on a large variety of topics, including networking, security, virtualization, and the cloud - Cisco, Microsoft, and Google - Virtual Labs Free L inux Academy Online Training Account Internal Tracking -LR-BD-160 If you would like to complete a detailed B4Corp Employment Application, please do so using this form (You only need to fill out this application once for B4Corp or if you have updates to the information.): . This form will help us find you the best position quicker. B4Corp is an EEO and e-Verify employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender/gender identity, sexual orientation or national origin. Please take the time to review and complete these three voluntary identification forms if you choose to do so and email them to .