PostgreSQL Database Administrator

Job Description This is a remote positionWe are seeking a highly skilled and experienced PostgreSQL Database Administrator with a strong background in data integration to join our team. The successful candidate will be responsible for the design, implementation, and maintenance of our PostgreSQL databases, ensuring high availability, performance, and security, as well as designing, developing, and implementing data integration solutions using FiveTran and/or HVR. This is a mid-level position requiring excellent problem-solving skills, and the ability to work collaboratively with cross-functional teams.Key Responsibilities:

• Design, implement, and maintain PostgreSQL databases, including database modeling, schema design, and data migration, replication, failover, load balancing, optimize database performance, including query optimization, indexing, and encryption
• Develop and implement database backup and recovery procedures, including point-in-time recovery and disaster recovery
• Troubleshoot database issues, including performance problems, data corruption, and connectivity issues, database security, including access control, and authentication
• Design, develop, and implement data integration solutions using FiveTran/HVR, including the configuration and management of data replication, transformation, loading processes, auditing, and security patches
• Troubleshoot data integration issues and optimize data channel performance, using the FiveTran/HVR integration tool
• Utilize PostgreSQL built-in monitoring and diagnostic tools, auditing and logging capabilities, and maintain procedures and documentation

Required Education, Experience, & Skills 5+ years of experience in data integration, with a focus on FiveTran and/or HVRUS Citizen

Strong understanding of data replication, transformation, and loading concepts

Experience with SQL Server, PostgreSQL, and/or Redshift databases, including:+ SQL programming (e.g. stored procedures, functions, queries)+ Database design and modeling+ Performance tuning and optimization

Familiarity with data replication tools, such as:+ Oracle Goldengate+ Dataiku+ Other data integration platforms (e.g. Talend)

Experience with Linux operating systems, including:+ Basic command-line interface (CLI) skills+ Scripting languages (e.g. Bash, or Python)+ System administration and troubleshooting

Strong problem-solving skills, with the ability to analyze complex data integration issues

Bachelor’s degree in Computer Science, Information Technology, or a related field

Preferred Education, Experience, & Skills Experience with cloud-based data integration platforms (e.g. AWS, GCP, Azure)

Knowledge of data governance, data quality, and data security best practices

Familiarity with agile development methodologies and version control systems (e.g. Git)

Experience with data visualization tools (e.g. Tableau, Power BI)

Pay InformationFull-Time Salary Range: $77814 - $132283Please note: This range is based on our market pay structures. However, individual salaries are determined by a variety of factors including, but not limited to: business considerations, local market conditions, and internal equity, as well as candidate qualifications, such as skills, education, and experience. Employee Benefits: At BAE Systems, we support our employees in all aspects of their life, including their health and financial well-being. Regular employees scheduled to work 20+ hours per week are offered: health, dental, and vision insurance; health savings accounts; a 401(k) savings plan; disability coverage; and life and accident insurance. We also have an employee assistance program, a legal plan, and other perks including discounts on things like home, auto, and pet insurance. Our leave programs include paid time off, paid holidays, as well as other types of leave, including paid parental, military, bereavement, and any applicable federal and state sick leave. Employees may participate in the company recognition program to receive monetary or non-monetary recognition awards. Other incentives may be available based on position level and/or job specifics.About BAE Systems, Inc.BAE Systems, Inc. is the U.S. subsidiary of BAE Systems plc, an international defense, aerospace and security company which delivers a full range of products and services for air, land and naval forces, as well as advanced electronics, security, information technology solutions and customer support services. Improving the future and protecting lives is an ambitious mission, but it’s what we do at BAE Systems. Working here means using your passion and ingenuity where it counts – defending national security with breakthrough technology, superior products, and intelligence solutions. As you develop the latest technology and defend national security, you will continually hone your skills on a team—making a big impact on a global scale. At BAE Systems, you’ll find a rewarding career that truly makes a difference.This position will be posted for at least 5 calendar days. The posting will remain active until the position is filled, or a qualified pool of candidates is identified.

Apply To This Job