Database Architect

Leidos is seeking a highly skilled Database Architect to be part of the mission solution and help lead SSAs Digital Modernization Strategy. Join one of our high performing teams responsible for building the next-generation enterprise APIs and modern responsive user interfaces supporting the Social Security Administration (SSA) and their mission to meet the changing needs of the public positively impacting at least 65 million American lives per month. We are a team of forward-looking professionals in need of a strong candidate with these key required skills: Database Architecture experience with AWS snowflake SQL and automation and scripting.

If this sounds like a mission you want to be a part of keep reading!

TEAM CULTURE

Your passion and values might be a good fit for our teams if you answer yes to the following questions:

• Are you looking for a company that puts employees first with a focus on career flexibility and well-being
• Do you enjoy collaborating with colleagues and teammates and believe that the best ideas are fostered in an inclusive environment
• Are you searching for a team with a strong sense of ownership urgency and drive for daily mission success
• Are you comfortable with proactive outward communication and technical leadership
• Do you enjoy being a catalyst solving complex problems and providing innovative solutions
• Do you have the flexibility creativity and resilience to pivot the mission for success
• Do you have the courage to make tough ethical decisions with pride transparency and respect

MENTORSHIP & CAREER GROWTH

Our teams are dedicated to supporting new team members in an environment that celebrates knowledge sharing and mentorship. Experienced team members will be assigned to new hires for one-on-one mentoring collaborative reviews and coaching on customer engagement to help each new hire successfully onboard and demonstrate their skills. Projects and tasks are assigned in a way that leverages your strengths and will help you further develop your skillset.

DAY TO DAY RESPONSIBILITIES

Every position we take is more rewarding when you know the why behind your work makes a difference to support those who need it most. If your passion is enabling life changing service to those around you this is the place for you. Find you passion in a team environment where all members are valued regardless of contractor or employee status.

Find your Why with us and take your place in our Leidos Family!!

• Utilize the AWS database and data processing services including Amazon RDS AuroraDB DynamoDB Redshift ElastiCache EMR and Neptune.
• Configure launch and manage EMR clusters optimizing for performance and cost and integrating with various data sources.
• Architect scalable high-performance and secure database solutions.
• Integrate databases with other AWS services such as Lambda S3 EC2 and Glue.
• Utilize AWS security best practices (IAM encryption VPC security groups) and compliance requirements for data storage.
• Design backup disaster recovery high availability and failover solutions (Multi-AZ read replicas).
• Troubleshoot for AWS related issues and incidents.
• Design implement and manage virtual data warehouses in Snowflake.
• Write complex SQL queries for data analysis transformation and reporting.
• Optimize queries manage caching clustering and leveraging auto-scaling to handle workloads.
• Ensure compliance with SSA security privacy and data management policies.
• Brief management customer team or vendors using written or oral skills at appropriate technical level for audience.
• Provide guidance/support to other junior/mid-level developers.
• All other duties as assigned or directed.

FOUNDATION FOR SUCCESS (Basic Qualifications)

• Bachelors Degree in Computer Science Mathematics Engineering or a related field; Masters or Doctorate degree may substitute for required experience
• 7 years as a Database Architect.
• Experience in AWS database and data processing services including Amazon RDS AuroraDB DynamoDB Redshift ElastiCache EMR and Neptune.
• Knowledgeable in AWS security best practices (IAM encryption VPC security groups) and compliance requirements for data storage.
• Strong troubleshooting skills for AWS related issues and incidents.
• Skilled in optimizing queries managing caching clustering and leveraging auto-scaling to handle workloads.
• Proficient in automation and scripting (CloudFormation Terraform AWS CLI Python Bash PowerShell) for database and workflow management.
• Must be able to obtain and maintain a Public Trust. Contract requirement. (DO NOT REMOVE)

*** Selected candidate must be willing to work on-site in Woodlawn MD 5 days a week.***

FACTORS TO HELP YOU SHINE (Required Skills)

These skills will help you succeed in this position:

• Skilled in both relational and NoSQL database management data modeling normalization and schema design.
• Experienced in configuring launching and managing EMR clusters optimizing for performance and cost and integrating with various data sources.
• Skilled in designing backup disaster recovery high availability and failover solutions (Multi-AZ read replicas).
• Advanced skills in writing complex SQL queries for data analysis transformation and reporting.
• AWS Experience:
  • Proven ability to architect scalable high-performance and secure database solutions with proficiency in query optimization indexing caching and performance tuning using AWS tools.
  • Experienced in integrating databases with other AWS services such as Lambda S3 EC2 and Glue.
  • Adept at securing AWS clusters managing IAM roles implementing encryption and monitoring jobs using AWS tools (CloudWatch CloudTrail).
• Snowflake Experience:
  • Proficient in designing implementing and managing virtual data warehouses in Snowflake with a strong understanding of micro-partitions.
  • Experienced in schema design normalization and building efficient data structures in Snowflake.
  • Familiar with data ingestion transformation and loading using Snowflakes features and integration tools.
  • Knowledgeable in Snowflakes role-based access control data encryption and security best practices.
  • Experienced in integrating Snowflake with BI tools (Tableau Power BI) and using Python for data pipelines and machine learning applications

HOW TO STAND OUT FROM THE CROWD (Desired Skills)

Showcase your knowledge of modern development through the following experience or skills:

• Experience identifying requirements researching options designing and implementing solutions at a leadership level on project work.
• Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
• Understand and apply quality techniques and practices (automated unit testing Test Driven Design/Development performance analysis continuous integration)
• Ability to assist with architectural tactical thinking information solutions and road maps to drive architectural recommendations.
• Detail oriented and committed to consistently completing repetitive production-like tasks on-time and error-free.
• Prior experience working in a federal agency or public sector environment.
• Effective communication skills for working with cross-functional teams including data scientists analysts and business stakeholders.
• Ability to translate technical concepts into non-technical terms for business stakeholders.
• Ability to manage multiple projects prioritize tasks and deliver within deadlines.

At Leidos we deliver innovative solutions through the efforts of our diverse and talented people who are dedicated to our customers success. We empower our teams and contribute to our communities. Everything we do is built on a commitment to do the right thing for our customers our people and our community. Our Mission Vision and Values guide the way we do business. Every position we take is more rewarding when you know the why behind your work makes a difference to support those who need it most. If your passion is enabling life changing service to those around you this is the place for you. Find your passion in a team environment where all members are valued regardless of contractor or employee status. We are excited for you to take your place in our Leidos Family.

Are you an US citizen US resident or Visa candidate and think you might fit We recommend you apply and start the conversation today! Join us in supporting our SSA contracts in Woodlawn Maryland.

If youre looking for comfort keep scrolling. At Leidos we outthink outbuild and outpace the status quo because the mission demands it. Were not hiring followers. Were recruiting the ones who disrupt provoke and refuse to fail. Step 10 is ancient history. Were already at step 30 and moving faster than anyone else dares.

Original Posting:

Pay Range:

The Leidos pay range for this job level is a general guideline onlyand 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.