Key skills
AWSCloudETLMS SQL ServerOracleSQLAnalyticsRDSSQL ServerVersion ControlCommunicationCollaboration
About this role
Role Overview
- Design, implement, maintain, and optimize operational databases to ensure performance, availability, integrity, and security.
- Develop and maintain database architecture documentation, Standard Operating Procedures (SOPs), data models, data flow diagrams, and engineering guidance for government stakeholders.
- Ensure database environments comply with DISA STIG and SRG requirements, including implementation of access controls, intrusion detection and prevention measures, and data protection safeguards.
- Design and manage database backup, recovery, and disaster recovery strategies to meet defined recovery time objectives (RTO).
- Install, configure, upgrade, and tune database management systems (DBMS) to support evolving program requirements.
- Monitor database performance, transaction activity, and system utilization; respond to performance alerts and outages to maintain system health.
- Implement and support ETL processes for data migration between systems, including legacy and mainframe integrations.
- Manage database user access, roles, and security controls to protect sensitive data.
- Develop, deploy, and maintain SQL DDL and DML scripts to support application deployments, patches, and environment transitions.
- Optimize SQL queries and database structures to improve performance and ensure high availability.
- Support schema design, data model updates, and database changes in collaboration with data architects and application development teams.
- Maintain version control and change tracking for database modifications using approved tools.
- Support database loading, environment management, and transition planning across development, test, staging, and production environments.
- Provide database guidance and technical support to project teams and assist with ad hoc reporting and analytics needs.
- Collate, analyze, and present database performance and operational metrics for internal and external stakeholders.
- Recommend and implement continuous improvements to enhance database reliability, performance, and security.
- Perform additional duties as assigned.
Requirements
- Bachelor’s degree in Computer Science or a related information technology field with seven years of experience administering, managing, and tuning databases.
- Seven years of experience working with Oracle, Microsoft SQL Server, or other relational databases in a cloud environment.
- Hands-on experience implementing and supporting ETL tools and data migration processes.
- Experience using APIs to develop and maintain dashboards and reporting solutions for senior management.
- Experience managing Amazon RDS in AWS environments preferred.
- Experience implementing and using Liquibase or other DevOps tools to manage database changes.
- Strong understanding of data architecture principles, schema standards, database design, implementation, troubleshooting, and maintenance.
- Ability to manage requirement changes throughout the project lifecycle.
- Strong analytical and problem-solving skills.
- Strong written and verbal communication skills with the ability to clearly convey technical requirements to development teams and stakeholders.
- Ability to work independently and collaboratively within cross-functional teams.
- Strong interpersonal skills to interact effectively with team members, customers, vendors, and support personnel.
- U.S. citizenship and fluency in English required.
Tech Stack
- AWS
- Cloud
- ETL
- MS SQL Server
- Oracle
- SQL
Benefits
- Competitive compensation
- Health and Wellness programs
- Income Protection
- Paid Leave
- Retirement