Responsibilities

Monitor the EDW database environment and proactively manage and clean up disk space to maintain adequate capacity, system stability, and performance. Monitor database health, resource utilization, and capacity trends; conduct capacity planning to anticipate future data growth and system load and recommend appropriate scaling strategies.
Support Delivery Readiness Review (DRR) activities and production implementations, including moving approved database code to Production and implementing and troubleshooting Data Definition Language (DDL) scripts using SQL scripting. Ensure database changes are implemented in a controlled manner and properly documented in accordance with established change management procedures.
Develop, document, test, and implement database maintenance plans for scheduled and complex maintenance activities, including Oracle database time zone upgrades and related validation and rollback activities. Apply database software updates and patches in a timely and controlled manner, ensuring compatibility with the EDW environment and minimizing disruption to operations.
Troubleshoot slow-running SQL queries and database performance issues by analyzing execution plans, resource utilization, database waits, and other performance indicators; implement appropriate tuning and corrective actions. Conduct ongoing performance monitoring and tuning to identify and resolve bottlenecks and maintain database responsiveness, efficiency, and reliability.
Process database access requests in accordance with approved security procedures, including granting proxy access, creating database roles, assigning users to roles, and granting required table/object privileges to those roles. Implement and maintain database security controls, including appropriate access controls, encryption, and auditing mechanisms, to protect sensitive data and support compliance with VA and federal data protection requirements.
Perform schema refreshes and table refreshes between EDW environments, including coordinating refresh requirements, validating source and target objects, executing the refresh, resolving errors, and confirming successful completion.
Design and implement database schemas and models that support the efficient storage, retrieval, and analysis of data within the EDW. Ensure database designs align with project data governance and architectural standards.
Develop, maintain, and execute comprehensive database backup and recovery plans to safeguard data against loss or corruption. Conduct disaster recovery testing to validate backup strategies and ensure data can be restored within required recovery objectives.
Support the accuracy, consistency, and integrity of data within the EDW through appropriate database-level validation and integrity controls. Collaborate with data stewards, developers, and project teams to identify and address data quality issues.
Serve as a primary technical resource for database-related issues, providing expert troubleshooting and working with development teams to resolve database challenges associated with application design, implementation, and production operations.
Maintain comprehensive documentation of the database environment, including configurations, operational procedures, maintenance activities, security controls, and change management activities. Generate and communicate database health, performance, capacity, and optimization information as required.
Collaborate with developers, data analysts, project managers, and other project team members to ensure database services effectively support EDW project goals. Communicate database requirements, technical issues, risks, and recommendations effectively to both technical and non-technical stakeholders.

Senior Database Administrator at 9thwayinsignia · LumiJobs

Senior Database Administrator

Responsibilities

Qualification

Required

Preferred

Benefits

Company

9thwayinsignia

More roles at 9thwayinsignia