Senior Database Engineer at Base-2 Solutions, LLC
Annapolis Junction, MD
About the Job
Job Description
- 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
- Provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis
- Works primarily at the front end of the lifecycle-requirements through system acceptance testing and Initial Operational Capability (IOC)
- Develops requirements from a project's inception to its conclusion for a particular business and IT subject matter area (i.e., simple to complex systems)
- Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts
- Creates ad hoc queries, scripts, and macros; creates new queries and updates existing ones; builds complex systems using advanced queries and schemas; optimizes data storage and retrieval for speed and efficiency
- Tune relational databases to improve the performance of the database and its components
- 19+Years of Experience with a Bachelor's Degree
- Proficiency in Oracle, MySQL, Postgres, SQL, Server, or MongoDB
- Experience with relational database administration and engineering applications
- Experience with Extract, Translate, and Load (ETL) operations
- TS/SCI Clearance
- Proficiency in scripting languages such as Python or Java
- Advanced SQL skills for querying, data manipulation, and stored procedures
- Experience leveraging AWS to create database snapshots, restore from backups, and migrate data into new databases
- Understanding of ETL (Extract, Transform, Load) process and tools for data migration and transformation
- Knowledge of database design principles, including normalization, indexing, and schema design
Pay & Benefit HighlightsCompensation
- Above market fixed salary or hourly pay.
- Up to $10,000 bonus for each referral.
- Additional bonuses for exceptional performance, assisting with business development and company growth.
- 100% paid premiums for health insurance. Choose from over 80 gold-level medical plans from Aetna, CareFirst, Kaiser and UnitedHealthcare. Choose from PPO, EPO, POS, HMO, and HSA-compatible.
- HSA and FSA options.
- 100% paid premiums for dental insurance.
- 100% paid premiums for vision insurance.
- 100% paid premiums for short-term disability.
- 100% paid premiums for long-term disability.
- 100% paid premiums for accidental death & dismemberment.
- 100% paid premiums for life insurance with a $200,000 max benefit.
- 8% company contribution to 401k with immediate vesting.
- 401k pre-tax and Roth options.
- Up to 20 days of flexible paid time off (PTO).
- 11 days of paid floating holidays.
- Flexible work schedules including flex time and compressed work period.
- Remote work including partial or fully remote (contract and project-dependent).