Location: McLean, VA, United States
Date Posted: Mar 13, 2025
Description
Microsoft SQL Server
Azure SQL Database
MySQL
PostgreSQL
Oracle
Design, develop, and maintain custom and non-custom databases to support ITA’s business operations.
Design and implement scalable data storage solutions, ensuring efficient data organization and retrieval in cloud-based environments (e.g., Azure Data Lake, Azure SQL, Synapse Analytics).
Develop and optimize data processing pipelines, leveraging ETL frameworks, batch, and real-time data streaming solutions (e.g., Azure Data Factory, Event Hubs).
Secure, monitor, and enhance data storage and processing workflows, applying best practices in encryption, role-based access control (RBAC), performance tuning, and system health monitoring
Create data decomposition and data flow diagrams, ensuring data integrity and efficiency.
Write and optimize SQL queries, stored procedures, and indexing strategies for performance improvements.
Implement database security best practices, including access controls, encryption, and role-based permissions.
Manage database backups, disaster recovery plans, and high-availability solutions.
Ensure database compliance with ITA’s governance frameworks, security policies, and ITSM standards.
Collaborate with software engineers and system administrators to integrate database solutions with cloud-hosted applications.
Perform patch management, upgrades, and database migrations, including Azure cloud migrations.
Monitor database performance and system health, resolving bottlenecks and optimizing storage
Four or more years of experience in database engineering, administration, and maintenance
Must have hands on experience with Azure Data Services such as Lakehouse Synapse, Data Factory, Data Pipelines, Data Flows. Event Hub, Streams are nice to have
Must have experience developing and troubleshooting Stored Procedures and SQL DDL and DML
Expertise in Microsoft SQL Server, Azure SQL Database. MySQL, PostgreSQL, and Oracle are nice to have
Experience designing scalable and secure database architectures
Strong knowledge of SQL query optimization, indexing, and database performance tuning
Hands-on experience with database security, data encryption, and compliance policies
Experience with database patching and maintenance to ensure system stability.
Ability to develop and enforce database usage standards, policies, and procedures
Microsoft Certified: Azure Data Engineer Associate
(Required)Microsoft Certified: Azure Database Administrator Associate
(Required)Additional certifications in Oracle Database Administration, MySQL, or PostgreSQL are a plus.