• Manage RDBMS and NoSQL solutions • Ensure database performance, scalability, high availability, and disaster recovery across environments deployed on bare-metal servers and virtual machines • Implement and manage replication сhains, partitioning / sharding, backups • Assist development teams in creating, optimizing, and problem solving with RDBMS and NoSQL solutions • Troubleshooting • Drive automation using Terraform, Puppet, and custom tooling for infrastructure and database lifecycle management

• Design, implement, and maintain relational databases (MS SQL Server, Oracle) and cloud-based data warehouse solutions, including Azure Synapse Analytics. • Evaluate, recommend, and configure DBMS products to meet agency or project requirements. • Define database schema, indexing strategies, and data organization to optimize performance and query efficiency. • Collaborate with security teams to configure and enforce data access policies, including row-level security, column-level security, and data masking. • Develop and maintain ETL processes for data ingestion, transformation, and synchronization between multiple systems (e.g., Salesforce, agency-specific applications). • Analyze existing database configurations and schemas, identifying gaps and implementing enhancements to support consistent, high-quality data structures. • Integrate Azure Synapse with other Azure services, including Blob Storage, Data Factory, Analytics Service, Power BI, and SSRS. • Optimize database performance, monitor workloads, and manage resource prioritization to ensure timely reporting and efficient processing. • Execute bulk data cleansing, normalization, and loading operations. • Develop and maintain stored procedures, scripts, and automated jobs to support database operations. • Support ongoing operations and maintenance, including monitoring via Azure Monitor and Log Analytics, ensuring high availability, failover readiness, and performance optimization. • Ensure compliance with federal data management and governance policies, including encryption at rest, redundancy, and disaster recovery planning. • Participate in Agile development processes including sprint planning, code reviews, and backlog grooming.

• Administer, monitor, and maintain PostgreSQL databases (250GB+) in production environments (AWS RDS, Aurora, EC2) • Ensure database availability, performance, and data integrity through proactive monitoring and maintenance • Perform routine database administration tasks including patching, upgrades, vacuuming, reindexing, and statistics management • Execute and manage backup, restore, and disaster recovery procedures, including regular testing of recovery plans • Handle user access management, roles, and database security to ensure compliance with best practices • Perform capacity planning, storage management, and growth forecasting • Troubleshoot database issues, including performance bottlenecks, locking/contention, and failed jobs • Support application teams with query tuning, schema changes, and release deployments • Manage database migrations, upgrades, and change requests with minimal downtime • Maintain documentation for database configurations, standards, and operational procedures • Participate in on-call rotations and provide support for production incidents

• Collaborate with stakeholders to understand business requirements and translate them into robust and scalable database designs. • Design and implement database solutions that optimize performance, reliability, and security. • Define database standards, best practices, and guidelines, and ensure adherence across projects. • Evaluate and recommend database technologies and tools to support business needs and future growth. • Lead database performance tuning and optimization efforts to ensure optimal system performance. • Develop and maintain data models, schemas, and data dictionaries. • Implement data security measures, including access controls, encryption, and data masking. • Provide technical guidance and mentorship to junior database developers and administrators. • Stay current with emerging technologies and industry trends in database management and incorporate them into our architecture as appropriate.