Back to jobs
Job Description
Conduct assessments of existing database structures, integrations, dependencies, and data volumes. Design and implement scalable relational database architectures supporting enterprise applications and cloud modernization initiatives. Collaborate with infrastructure, application development, cloud engineering, cybersecurity, and business teams to ensure successful migrations and integrations. Administer, maintain, monitor, and optimize enterprise SQL databases hosted on Windows and Linux platforms. Administer and optimize PostgreSQL databases hosted in AWS cloud environments. Build, migrate, configure, and maintain databases supporting both on-premise and cloud-hosted systems. Monitor database health, storage utilization, system performance, replication, and availability. Provide ongoing database maintenance, support, troubleshooting, integrity validation, performance assessments, and operational enhancements. Analyze and optimize SQL queries, indexing strategies, and database configurations to improve performance and scalability. Support production deployments, upgrades, patches, releases, and change management activities. Coordinate database installations, upgrades, architecture changes, and issue resolution efforts with System Administrators and technical teams. Support cloud database technologies and modernization initiatives utilizing AWS services including: Amazon RDS Aurora PostgreSQL Amazon EC2 AWS Backup AWS IAM Amazon CloudWatch Amazon S3 Develop and maintain automation processes, scripts, and database operational procedures. Support CI/CD pipeline integration and database deployment automation processes. Participate in Infrastructure as Code (IaC) and cloud automation initiatives. Design, implement, and enforce strong database security structures and access controls. Ensure the confidentiality, integrity, and availability of sensitive criminal justice and operational data. Implement database encryption, auditing, role-based security, and compliance best practices. Develop and maintain database backup, replication, disaster recovery, and continuity of operations plans. Support compliance with CJIS, State, and enterprise security standards. Participate in disaster recovery planning, testing, and operational readiness activities. Lead database design and development efforts based on business and technical requirements. Provide data modeling and database architecture support to development projects. Assist application developers with complex query development, tuning, and troubleshooting. Design, create, install, and manage automated databases, reporting processes, and scheduled report executions. Perform data validation to verify the integrity of data relationships, calculations, interfaces, and reporting outputs. Create and maintain technical documentation including: Database schemas Data dictionaries Operational procedures System interfaces Security structures Interact with and support project managers, technical leads, developers, business analysts, and end users throughout analysis, design, testing, and implementation activities. Participate in architecture reviews and provide recommendations for scalable and reliable database solutions. Support production incident response, root cause analysis, and problem resolution activities. Accommodate work that may need to be performed during evenings, weekends, maintenance windows, or other after-hours operational periods. Perform other duties as assigned.