What are the responsibilities and job description for the Database Administrator (DBA) position at Analytical Services & Materials?
(Job ID# ASM25DBA619)
Location: Hampton, Virginia
Job Type: Full-time
Description
AS&M has an exciting opportunity for a Database Administrator (DBA) to join the team in Hampton, Virginia, supporting the Research, Science, and Engineering Services (RSES) contract at NASA Langley Research Center.
The successful candidate will provide HSPD-12/SMART ID credential administration and support to NASA Security and Badge and Pass operations by performing the following tasks.
Responsibilities
- Database administration (PostgreSQL/MySQL/NoSQL/MongoDB)
- Databases in a Linux environment
- Planning of physical database environment. Capacity planning.
- Install, configure, test, monitor, upgrade and tune new & existing postgres/mysql/mongodb instances
- Create and maintain database standards and policies
- Support database design, creation, testing and connectivity
- Manage database availability and performance
- Database design
- Create and optimize tables, indexes, views, and stored procedures
- Design and implement database structures that meet the organization’s needs
- Database maintenance
- Stay on top of database software new releases and affect to applications
- Manage database availability and performance
- Support database design, creation, and testing
- Manage incidents and problems
- Database Security
- Security/integrity controls
- Manage incidents and problems
- Implement and maintain database security measures, including access controls, user authentication, encryption, and auditing as required to protect sensitive data from unauthorized access and potential breaches.
- Database monitoring
- Use monitoring tools to review the performance of the database and server
- Collect performance-related statistics and metrics
- Disaster recovery
- Create regular backups and recovery plans
- Ensure that backups are created and perform recovery procedures to restore lost data
Qualifications
Proof of U.S. Citizenship is required for this position.
Must be able to complete a U.S. government background investigation.
Required Qualifications
- Bachelor’s degree in computer science, Information Technology, or a related field.
- Proven experience as a Database Administrator with at least 5 years of hands-on experience managing and administering PostgreSQL/MySQL databases.
- In-depth knowledge of PostgreSQL database management systems, including installation, configuration, maintenance, and performance optimization.
- Strong command of SQL and database query optimization techniques for PostgreSQL/MySQL.
Preferred Qualifications
- Exposure to DRBD/PCS (High Availability Tools)
- Scripting experience
- Consulting and interfacing with other team members
- Exposure to pgbadger/ nagios /pgadmin /postgis tools and extensions
How to Apply?
Details about our company are available at www.asm-usa.com, and details about job openings at www.asm-usa.com/jobs.
Please e-mail your completed AS&M application and a detailed resume to asmjobs (at) asm-usa.com. Mention the Job ID#.
AS&M application is available at our website: https://www.asm-usa.com/apply.
*** AS&M is an equal opportunity, affirmative action employer ***
Download
