Database Architect SME

Leidos is seeking an experienced Database Architect to develop IT strategies to ensure case management systems meet existing and future requirements based on needs and regulations. The Database Architect SME works to design, implement, and maintain a data pipeline and analytical environment using reporting tools, modeling metadata, and building reports and dashboards. The candidate will be responsible for performing tasks relating to Database Management System (DBMS) applications, including definition, design, structure, documentation, upgrades, long-range requirements, operational guidelines, and protection. Duties include database modeling and design, metadata, and repository creation. Additionally, the candidate will use data mapping, data mining, and data transformational analysis tools to design and develop databases. Support duties may include entering and reviewing data within the database, ensuring user data integrity, maintaining database support tools, database tables and dictionaries, recovery and back-up procedures, and making recommendations regarding enhancements and/or improvements.

*This position is contingent upon Leidos being awarded a contract under which the work will be performed.

Primary Responsibilities

• Perform Database administration activities required to install and maintain database management software, design and implement predictive analysis

• Set up, manage, and monitor DB.

• Identify database bottlenecks and provide remediation steps

• Implement database backup solutions

• Design and implement security configuration, including grants, roles, and profiles, perform database security monitoring, and perform database auditing, and implement security standards

• Design, implement, and test enterprise disaster recovery solutions and high availability database solutions, including sharding, partitioning, clustering, and replication.

• Design and implement logical database schemas, including ERD diagramming

• Perform database schema change management, control, and execute code deployments to upper database environments and execute database data movement to satisfy ETL, backup/recovery

• Administer and maintain ETL tools, including Informatica

• Develop technical solutions that require collaboration with internal experts, deep analyses, and understanding of the impact on the end-product/solution.

• Develop solutions to technical problems

Basic Qualifications

• Requires a BS degree and a minimum of 10+ years of prior relevant experience or a Master's with 8 – 10 years of prior relevant experience.

• Ability to be cleared by the US Government via a Minimum Background Investigation (MBI)

• Experience with multiple database types such as SQL, Redis, and MongoDB

• Experience building and integrating at the application and database level

• Experience developing REST/SOAP APIs and messaging protocols, and formats

• Experience with statistical analysis, machine learning, predictive modeling, and/or optimization

• Experience prototyping front-end visualizations utilizing data visualization suites such as Kibana or Splunk

• Familiarity with event-driven finite state machines

• SQL proficiency to include schema design, data definition, and advanced queries

• Experience with MPP data warehouses

• Experience with creating automated data pipelines for complex systems

• Experience with a Linux server management background

• Can prototype visualizations with a lightweight data visualization suite

• Experience maintaining complex databases including MongoDB, Cassandra, and MySQL

• Automating NoSQL day-to-day operational activities (security, index maintenance, backups, disaster recovery, and installation)

• Experience in designing, deploying, and supporting multiple database platform solutions in a multi-zone clustered environment

• Experience in designing and implementing replication, partitioning, and clustering between multiple data centers

Desired Qualifications

• Experience working on projects within the Federal Government, with a focus on an IRS/Treasury environment

• Working with Python, Shell, and PowerShell scripting

• Experience with CI/CD tools including Jenkins, Jira, and Gitc

• Experience working with TLS/SSL, Kerberos, and LDAP integration

• Experience with Informatica

For U.S. Positions: 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.

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.