Provides all activities related to the administration of database schemas and their objects. Projects long-range requirements for database schema administration and design in conjunction with Infrastructure DBAs in the information systems function.

Primary Responsibilities

• Designs, creates, and maintains databases schemas in a client/server environment.
• Conducts quality control and auditing of database schemas in a client/server environment to ensure accurate and appropriate use of data and permissions.
• Advises users on access to various client/server databases.
• Designs, implements, and maintains complex database schema objects with respect to user requirements, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
• Applies knowledge and experience with database technologies, development methodologies, and front-end programming languages (e.g., SQL).
• Performs database programming and supports systems design.

Other Responsibilities

• Performs preventive and corrective maintenance and incident management measures.
• Creates and maintains connections between databases and data sources.
• Gathers and researches user requirements and liaises with developers and other staff to improve applications and establish standards, best practices and procedures with an ability to document, report issues, and provide resolutions.
• Determines high-level database structural requirements by working with business stakeholders and identifying optimal database specifications.
• Translates high-level requirements into database development.
• Supports sequencing diagrams and process flow development, data profiling, data analysis, and logical and physical data modeling.
• Prepares scripts to automate administrative tasks.
• Evaluates the integration of new tools or technologies based on the capabilities of the existing infrastructure.
• Creates advanced tests, develops complex databases, and tunes database performance, reviewing database performance trends and identifying opportunities for improvement.
• Oversees permissions, recovery, security, and monitors data management platform.
• Performs advanced database administration activities including; installation, configuration, monitoring, space management, database backup and recovery, and may design disaster recovery procedures.
• Plans and executes any needed upgrades to the software applications and ensures necessary licensing is maintained.
• Implements procedures to control access and allocation of data and maintain security controls.
• Uses various databases and sources to research system vulnerabilities and potential security attacks.
• Performs capacity planning and projection for future growth.
• May provide mentorship and input into performance appraisals for junior Database Administrators.

Minimum Qualifications

• Bachelor's Degree in a related field of study.

• Five (5) years progressive experience of database query languages such as Oracle, PL SQL, SQL Server, and MS Access.
• Also has at least three years hands-on experience and expertise in Database Schema management.
• Experience also shall include capability to work on various operating systems and additional programming languages.
• Has experience in at least two projects in a large organization responsible for administering, operating, maintaining, and securing a large-scale computer database.

Security/Certification Requirements:

• Sensitivity Level: IT-I - Critical Sensitive
• Clearance Level: Active Secret
• DoD Approved 8570 Baseline Certification: Category IAT Level II
• Must possess IT-II security clearance or have a current National Agency Check with Local Agency Check and Credit Check (NACLC).
• Computing Environment: OCP19

Other Job Specific Skills

• Excellent attention to detail and analytical skills.
• Advanced written and verbal communication skills.
• Ability to multitask and work well under pressure.
• Advanced knowledge of database backup and recovery strategies.
• Experience in developing and maintaining complex database environments.
• Knowledge of Data Warehouse, Big Data constructs, Business Intelligence and end-user displays.
• Ability to work with Developers, System Administrators, Architects, and IT Management to plan and size production systems.
• Extensive experience with DBA productivity and performance tools.
• Familiar with database concepts and technologies in a cloud environment.
• Experience with DoD and Federal Government is strongly desired.
• Advanced knowledge of security network and infrastructure tools, including access control and/or encryption.
• In depth knowledge of troubleshooting skills and out of the box thinking to overcome data obstacles.
• Ability to create and maintain connections between databases and data sources.
• Ability to delegate/split tasks among a team.

EEO Requirements

It is the policy of ASM that an individual's race, color, religion, sex, disability, age, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies.

All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, disability, or age. All decisions on employment are made to abide by the principle of equal employment.

Physical Requirements

The physical requirements described in "Knowledge, Skills and Abilities" above are representative of those which must be met by an employee to successfully perform the primary functions of this job. (For example, "light office duties' or "lifting up to 50 pounds" or "some travel" required.) Reasonable accommodations may be made to enable individuals with qualifying disabilities, who are otherwise qualified, to perform the primary functions.

Disclaimer

The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.