Database Administrator

We are seeking a highly skilled and motivated Database Administrator with an active Secret security clearance to join our dynamic team. In this role, you will be responsible for managing, maintaining, and optimizing complex database systems to ensure high availability, security, and performance. Your expertise will support critical operations by implementing robust database solutions, performing performance tuning, and ensuring data integrity across multiple platforms. This position offers an exciting opportunity to work on mission-critical projects that require precision, innovation, and a proactive approach to database management., Stratagen is a HUBZone Certified, General Services Administration (GSA) Schedule holder, small business located in West Virginia. As a U.S. Federal Government contractor, Stratagen provides Information Technology, Analytical, and Program Management Support. Stratagen Consulting specializes in custom IT solutions, IT Operations, System Engineering, Infrastructure Management, Program Budgeting, Master Scheduling, IT Security, System Integration, and Database Administration. Stratagen's leadership team has over 60 years of combined experience and business knowledge in the Federal space. Using industry best practices and best value solutions, the company's mission is to provide the U.S. Government with quality personnel and support to enhance the Nation's efforts for national security and public safety.

Do you have experience in System tuning?, Do you have a Bachelor's degree?, * Active Secret Security Clearance

• 4 Year Degree in Information Technology or related field or equivalent experience
• Minimum 3 years experience
• Database experience of working in different OS platforms like Linux, RHEL and Windows
• Experience in Oracle/Postgres database administration, support, implantation, configuration and upgrade.
• Solid understanding of SQL (writing, optimizing queries, normalization and indexing)
• Experience with backup & recovery (pg_dump, pg_basebackup, PITR)
• Experience in Oracle/Postgres database performance tuning using explain plans and monitoring tools
• Working experience of AWS Cloud Services (Cloud Watch Cloud Trail, EC2) and Databases (Oracle, Aurora & Postgres RDS)
• Strong understanding of postgres schema, user roles, access control and security model.
• Postgres script writing (PL/pgSQL) with loops, conditions and variables
• Performance tuning, hardware replacement, firmware upgrades, and patching to all COTS software products, including operating systems.
• Experience in shell scripting to enhance and update daily monitoring tasks.

3.63.6 out of 5 stars Remote $90,000 - $110,000 a year - Full-time, Pulled from the full job description

• Professional development assistance
• 401(k)
• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance
• Dental insurance, * 401(k)
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Professional development assistance
• Retirement plan
• Vision insurance