• 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.

• Design and Implement Database Solutions: Develop and deploy database solutions that meet business requirements and ensure scalability. • Database Installation and Configuration: Install, configure, and maintain database systems, ensuring they are optimized for performance and reliability. • Ongoing Administration: Perform regular database maintenance tasks, including backups, updates, and patches. • Monitor Database Performance: Continuously monitor database performance and identify areas for improvement. • Optimize Queries and Indexes: Analyze and optimize SQL queries and indexes to enhance database efficiency. • Capacity Planning: Plan and manage database capacity to ensure optimal performance and resource utilization. • Develop and Implement Backup Strategies: Create and maintain comprehensive backup strategies to ensure data protection. • Disaster Recovery Planning: Develop and implement disaster recovery plans to ensure business continuity in case of data loss or system failure. • Regular Testing: Conduct regular tests of backup and recovery procedures to ensure they are effective and reliable. • Ensure Data Security: Implement security measures to protect sensitive data from unauthorized access and breaches. • Compliance with Policies: Ensure database systems comply with data retention, privacy, and security policies. • Manage Access Controls: Configure and manage access controls to ensure that only authorized users have access to the database. • Serve as a subject matter expert (SME) and mentor to junior staff. • Lead Database-related projects and participate in cross-functional initiatives. • Engage with vendors and service providers for support, upgrades, and procurement.