PostgreSQL Database Administrator Principal Job at SAIC, Ashburn, VA

bk1iaXFZbkxYZU9MU2NycmQ2NGNZbDdXekE9PQ==
  • SAIC
  • Ashburn, 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), bringing expertise in deployment, administration, query tuning, and database monitoring. This role is hybrid-remote requiring 2 days on-site per week in Ashburn, VA. This role requires a proactive professional capable of managing database operations, optimizing performance, and supporting application development teams. Responsibilities Database Administration Configure and administer managed PostgreSQL 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. 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 Education and experience REQUIRED: Bachelors degree in computer science, Information Technology, or a related field (or equivalent experience). Nine (9) years or more experience; masters degree and seven (7) years or more experience; PhD or JD and four (4) years or more experience. Must be a U.S. Citizen with the ability to obtain and maintain a public trust security clearance. Certifications such as AWS Certified Database - Specialty, PostgreSQL DBA Certification, or similar are a plus. Required Skills: Must have extensive experience with PostgreSQL, including deployment, maintenance, and optimization. Strong knowledge of database tuning, query optimization, and indexing strategies. Experience with Postgres GIS queries using the PostGIS addon. 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. Familiarity with CI/CD pipelines and database version control. Excellent troubleshooting and problem-solving skills. Preferred Skills: Knowledge of ETL pipelines and data warehouse architecture. Familiarity with analytics/modeling tools. Exposure to data replication and sharding strategies. Knowledge of government regulatory compliance standards. 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. BI Requirement Current holder of a DHS Public Trust clearance or the ability to obtain one. Note: Employment will be contingent upon having/obtaining a DHS Public Trust clearance prior to starting. #J-18808-Ljbffr SAIC

Job Tags

Remote work, 2 days per week,

Similar Jobs

YANCHEWSKI & WARDELL ENTERPRISE INC

Brand Ambassador Job at YANCHEWSKI & WARDELL ENTERPRISE INC

 ...??? Wanted: People Who Can Turn Heads Without Trying ???? Brand Ambassador EcoWater of Southern California Picture this: You walk into...  ...every lead. Freedom. Full-time or part-time, evenings or weekends well work with your schedule. A clear path. Start as an... 

Wingstop

Assistant General Manager Job at Wingstop

 ...The Assistant General Manager is a Manager who has the drive and passion it takes to be a General Manager. AGMs are our GMs of the future. AGMs are essential in helping the General Manager successfully drive results in his/her restaurant, through people development, sales... 

Louis Vuitton

Fashion Stylist Job at Louis Vuitton

The Fashion Stylist at Louis Vuitton in Orlando will serve as a brand ambassador, focusing on Ready-to-Wear collections. Responsibilities include driving sales targets, developing client relationships, and collaborating with key stakeholders on events and product launches... 

Faire

Commercial Counsel (San Francisco) Job at Faire

 ...Independent retailers around the globe are doing more revenue than Walmart and Amazon combined, but individually they are small compared...  ...small businesses everywhere can compete with these big box and ecommerce giants. By supporting the growth of independent businesses,... 

Confidential

Head of Technology Job at Confidential

 ...Head of Technology About the Company Fast-growing online gaming company Industry Gambling & Casinos Type Privately Held About the Role The Company is seeking a Head of Technology to lead the development and delivery of cutting-edge gaming experiences...