Database Administrator 3

Job Summary

Database Management & Administration: Create, monitor, and maintain production databases. Direct programmers and analysts to implement changes in database systems. Review and correct database-related programs. Modify database programs to optimize performance (performance tuning). Perform logical and physical data modeling, including designing relational and physical database models. Maintain data dictionary and establish standards for data definitions. Implement and manage database security, backup, recovery, and disaster recovery procedures.

Collaboration & Support: Answer user questions and provide technical assistance. Work closely with coworkers to assess the impact of database changes on systems and costs. Provide support to users, especially regarding EIR Accessibility and assistive technologies. Coordinate with teams to ensure data integrity and control redundancy.

Database Development & Migration: Assist in planning, development, maintenance, and monitoring of integrated database systems. Create test database environments, including necessary libraries and procedures. Migrate data from Oracle to Azure SQL, including converting stored procedures and functions. Support data extraction, transformation, and loading (ETL) into Azure SQL.

Performance Monitoring & Optimization: Monitor database performance, recommend and implement efficiency improvements. Identify and resolve performance bottlenecks. Implement monitoring solutions for database health and metrics. Conduct benchmarking and threshold testing.

Design & Documentation: Participate in the design and conceptual phases of new applications to ensure alignment with database parameters. Create technical and functional design documentation.

Security & Compliance: Execute security, backup, and recovery procedures for hardware and software failures. Ensure compliance with accessibility standards for database interfaces and reporting. Assist with establishing and maintaining database security standards and disaster recovery procedures.

Technology Environment: Work with Full-stack Java applications hosted on cloud platforms (Azure/AWS). Participate in Agile (Scrum) development environments. Involved in activities including database tuning, indexing, customization, transformation, migrations, upgrades, patching, user management, data replication, high availability, and load balancing.

Preferred Skills

• Experience with large-volume databases, high availability, and disaster recovery.
• Knowledge of Azure cloud, DevOps (CI/CD, Git), and Java/J2EE.
• Azure and DBA certifications preferred.