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.
Basic Qualifications:
-
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.
**Candidate must have an active TS/SCI w/Polygraph
**Candidate must be a US Citizen
Preferred Qualifications:
-
Experience with AWS/C2S services including RDS
-
Demonstrated experience using Spring, Kafka, Elasticsearch, and NiFi.
CABARESTON
Original Posting Date:2024-04-26
While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.
Pay Range:Pay Range $101,400.00 - $183,300.00
The Leidos pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
Top Skills
What We Do
We Are Leidos
For 50 years we have been tackling some of the biggest problems that face our nation and our world.
OUR MISSION
Through our culture of innovation and history of performance, we develop deep customer trust built on integrity and create enduring solutions that improve our world. Leidos is a science and technology solutions leader working to address some of the world’s toughest challenges in the defense, intelligence, homeland security, civil, and healthcare markets. The company’s 43,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Va., Leidos reported annual revenues of approximately $11.09 billion for the fiscal year ended January 3, 2020.
Leidos was cited for the meaningful work employees perform that is challenging, impactful, and aligned with our customers’ missions as reasons professionals want to work and stay at our company. Leidos has also been named to lists including Forbes’ Best Employers for Diversity, Forbes’ America’s Best Employers for Women, Military Times Best for Vets Employers, and Ethisphere Institute’s World's Most Ethical Companies®.
Employees enjoy career enrichment opportunities available through mobility and development and experience rewarding relationships with supportive supervisors and talented colleagues and customers. Employees appreciate our flexible work environment, allowing for and encouraging a true work-life balance. Our professionals are also excited about our Employee Resource Groups, like the newly launched Collaborative Outreach with Remote and Embedded Employees (CORE), which strives to create an environment where every employee, regardless of location, feels fully engaged as a valued employee of Leidos.
Your most important work is ahead.
