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

• Manage IDMS databases, ensuring optimal performance, integrity, and security • Perform regular maintenance tasks, including patch updates and configuration changes • Develop and implement effective database backup and recovery strategies • Identify, diagnose, and resolve database issues in a timely manner • Monitor database performance and conduct tuning to optimize efficiency • Work with application developers and system administrators to contribute to database design and system architecture • Ensure databases comply with industry standards and security protocols • Anticipate and plan for future database capacity requirements • Maintain detailed documentation of database configurations, processes, and procedures