Database Administrator Principal Job at SAIC, Sterling, VA

cW5rWWJNT0RjRnp3SWtUTXZhTlJNcElTQXc9PQ==
  • SAIC
  • Sterling, VA

Job Description

Description

We are seeking a highly skilled and experienced Database Subject Matter Expert (SME) with strong Database Administrator (DBA) capabilities to join our team. The ideal candidate will specialize in PostgreSQL (RDS) and Amazon Redshift , bringing expertise in deployment, administration, query tuning, and database monitoring. This role requires a proactive professional capable of managing database operations, optimizing performance, and supporting application development teams.

Key Responsibilities:

  • Database Administration :
    • Configure and administer managed PostgreSQL and Amazon Redshift instances in the AWS environment.
    • Maintain database security policies, including role-based access control and data encryption.
  • Query Tuning and Optimization :
    • Analyze and optimize SQL queries for performance improvement, particularly on large tables.
    • Work with development teams to review and enhance database-related code.
  • Monitoring and Alerts :
    • Set up and monitor Dynatrace alerts to ensure database reliability and availability.
    • Investigate and resolve performance issues identified through monitoring tools or reported by users.
  • Automation and Deployment :
    • Develop and implement database automation scripts for routine tasks such as deployments, scaling, and maintenance.
    • Assist in Continuous Integration/Continuous Deployment (CI/CD) processes for database updates.
  • System Health and Troubleshooting :
    • Proactively monitor database health and resolve capacity or connectivity issues.
    • Conduct root-cause analysis for database incidents and implement preventive measures.
  • Database Design and Support :
    • Provide input on data modeling and schema design for new and existing applications.
    • Collaborate with developers and data engineers to ensure efficient data access patterns.
  • Documentation and Best Practices :
    • Create and maintain detailed documentation of database environments, procedures, and standards.
    • Enforce database best practices and policies across teams.
  • Training and Guidance :
    • Act as a technical mentor to junior team members.
    • Provide training to application developers and other stakeholders on database-related topics.

Qualifications

Required Skills:

  • Extensive experience with PostgreSQL , including deployment, maintenance, and optimization.
  • Strong knowledge of database tuning, query optimization, and indexing strategies.
  • Experience with database monitoring tools, particularly Dynatrace or similar platforms.
  • Proficiency in scripting languages (e.g., Python, Bash) for database automation.
  • Understanding of cloud database architectures and services, such as AWS RDS and Redshift.
  • Familiarity with CI/CD pipelines and database version control.
  • Excellent troubleshooting and problem-solving skills.

Preferred Skills:

  • Experience with other database systems (e.g., SQL Server) is a plus.
  • Knowledge of ETL pipelines and data warehouse architectures.
  • Familiarity with analytics/modeling tools like Sagemaker.
  • Exposure to data replication and sharding strategies.
  • Experience with DevOps tools like Harness and Kubernetes.
  • Knowledge of government regulatory compliance standards.

Education and Certifications:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience). Nine (9) years or more experience; Master's degree and seven (7) years or more experience; PhD or JD and four (4) years or more experience.
  • Certifications such as AWS Certified Database - Specialty , PostgreSQL DBA Certification , or similar are a plus.

Soft Skills:

  • Strong communication and collaboration skills for working with cross-functional teams.
  • Ability to manage multiple priorities in a fast-paced environment.
  • Attention to detail and a commitment to delivering high-quality results.

Onsite Requirements:

  • 2-4x a month.


SAIC accepts applications on an ongoing basis and there is no deadline.


Covid Policy: SAIC does not require COVID-19 vaccinations or boosters. Customer site vaccination requirements must be followed when work is performed at a customer site.


Job Tags

Similar Jobs

Calamos Investments

Data Science Intern Job at Calamos Investments

 ...Summary: The Data Science Intern will experience a full immersion within our Data Science team and hone their skills by conducting research alongside our Data Scientists. The candidate will have ample opportunity to participate in and contribute to the day-to-day operations... 

Connexa Worx

Entry Level Events Assistant Job at Connexa Worx

 ...Job Description: We are looking for a motivated and organized Entry Level Events Assistant to join our dynamic team. In this role, you will assist in planning, organizing, and executing events that align with our company's goals and vision. This is an excellent opportunity... 

Goel Services, Inc.

Industrial Mechanical Insulation Seamstress/Tailor Job at Goel Services, Inc.

Master Upholsterer / Upholstery - Industrial / Seamstress / Tailor Pay $19-$22per hr - Full Time Benefits PPO Full Family Health Insurance Eye insurance Dental insurance14 paid holidays/PTO days. Requirements Responsibilities include Measurement,...

Balco, Inc.

Fire Protection Engineer Job at Balco, Inc.

 ...Position Summary The Fire Protection Engineer designs and creates systems, products, and procedures that prevent, control, and mitigate the effects of fires through passive fire protection. This role provides technical expertise within the department. Responsibilities... 

Laborintos

EHS Specialist - Fall River Job at Laborintos

 ...The Environmental Health and Safety Specialist (EHS) is responsible for various duties and responsibilities, including: Acting as a subject matter expert in environmental, health, and safety, and effectively communicating with internal and external stakeholders....