Database Administrator

ERT, Inc.; Woodbridge (VA); On-site; USD 90,000 - 140,000; Full time

Job summary

ERT, Inc. in Woodbridge, VA seeks a seasoned database professional to design and maintain scalable database solutions, monitor performance, and patch systems across Linux/Windows and AWS environments.

You will support AWS RDS/Redshift and MySQL, perform performance tuning, manage access permissions, and contribute to documentation and security maintenance. A 24x7 on-call rotation is required.

Qualifications

• Minimum 4 years of experience in database maintenance, patching and recovery.
• Hands-on with AWS RDS, AWS Redshift or MySQL.
• Experience with Oracle, MS SQL Server, PostgreSQL, DynamoDB, and Redshift.
• Server troubleshooting on Linux/Windows/VMware/AWS/Azure.
• Strong knowledge of day-to-day SQL operations and deployments.
• SQL and performance tuning experience.

Responsibilities

• Create and maintain database solutions based on project requirements.
• Monitor database performance for fast data access.
• Troubleshoot performance issues and implement fixes promptly.
• Run tests and validate new solutions before rollout.
• Control access and permissions for customer databases.
• Document data policies, standards, and procedures.
• Perform security maintenance including patches and upgrades.
• Collaborate with storage engineers to manage DB space.
• Support database work involving AWS technologies like RDS/Redshift/MySQL.
• Provide 24x7x365 on-call support as part of rotation.

Skills

AWS Certified Solutions Architect

SQL DBA

RDS

Redshift

MySQL

PostgreSQL

DynamoDB

Oracle

MS SQL Server

Linux/Windows

SQL Performance Tuning

Patching & Maintenance

On-call support

Job description

Job Details

Contract: Full Time W/Benefits Ret Match

Location: US-VA-Woodbridge

Security Clearance: Clearable

Overview / Job Responsibilities

• Creating new database solutions and implementing them properly based on overall project requirements.
• Monitoring overall database performance to ensure end users are receiving the information needed in as little time as possible.
• Troubleshooting performance issues, identifying the problem and promptly fixing it.
• Running tests on the new solution to ensure it functions correctly before fully rolling it out. Testing involves creating test scenarios to immediately identify and correct problems.
• Controlling access and permissions for accessing customer databases including verifying access requests and revoking access as directed by the customer.
• Creating and maintaining all database documentation including documenting data policies and procedures as well as data standards.
• Performing security related maintenance such as security patching, software patching and database upgrades within set maintenance windows.
• Working with storage engineers to expand/reclaim DB space as needed.
• Providing support creating and maintaining databases associated with AWS-specific DB technologies such as RDS, AWS RedShift and MySQL.
• Supporting a 24x7x365 ops team as part of a rotating on-call schedule.

Minimum Qualifications

• Minimum 4 years of experience monitoring, updating/patching, data recovery and general maintenance
• AWS Certified Solutions Architect Associate
• Experience with Oracle, MS SQL Server, MariaDB, PostgreSQL, DynamoDB, and Redshift database technologies; hands-on SQL DBA (not a managerial position)
• Server troubleshooting experience (OS is Linux/Windows/VMware/AWS/Azure)
• Knowledge of day to day SQL database operations, deployments and development
• Extensive database experience with RDS, AWS Redshift or MySQL
• Hands-on experience with database standards and end user applications
• Minimize database downtime and manage parameters to provide fast query responses
• Experience SQL and Performance tuning