Database Administrator

About This Role

This role involves supporting an enterprise-level program within a federal environment as an Application Database Administrator. The position focuses on database schema administration, ensuring databases meet user and system requirements, and advising on database access and security.

Responsibilities

• Provide database schema administration, including the design, development, maintenance, security, and auditing of database schemas and objects in client/server environments
• Plan long-term schema requirements in collaboration with Infrastructure DBAs
• Ensure databases meet user and system requirements
• Advise users on database access, permissions, data protection, validation, and security
• Apply database technologies, development methodologies, SQL, and programming skills to support database programming, systems design, and reliable data management
• Troubleshoot database issues
• Optimize SQL queries and database objects
• Support application deployments and system integrations
• Work with developers, system administrators, and business users to resolve database-related issues, implement changes, and maintain reliable application database environments

Requirements

• Knowledge of database schema administration, relational database concepts, SQL, data security, access controls, and client/server database environments
• Skilled in designing, developing, maintaining, auditing, and securing database schemas and objects while ensuring data integrity and appropriate user access
• Ability to analyze user and system requirements, collaborate with Infrastructure DBAs, and develop database solutions that support application and business needs
• Knowledge of application database administration, database performance, backup and recovery, monitoring, and database availability practices
• Skilled in troubleshooting database issues, optimizing SQL queries and database objects, and supporting application deployments and system integrations
• Ability to work with developers, system administrators, and business users to resolve database-related issues, implement changes, and maintain reliable application database environments
• Five years of progressive experience with database query languages and technologies, including Oracle, PL/SQL, SQL Server, and MS Access
• At least three years of hands-on experience and expertise in database schema management
• Experience working with multiple operating systems and programming languages
• Experience supporting at least two projects within a large organization involving the administration, operation, maintenance, and security of large-scale databases

Nice to have:

• OCA or relevant certification