Database Administrator

JOB PURPOSE
 
The Database Administrator is responsible for all aspects of a complex, mission-critical database environment including design, development, implementation, administration, security, monitoring, tuning, backup, migration, and support.

 

DUTIES & RESPONSIBILITIES

 
The DBA performs the following high-level activities within the context of the assigned database environment:
·         Design, development, implementation, advice/consulting
·         Administration, support, management, maintenance
·         Problem determination and resolution
Design/Develop/Implement/Advise:
·         Provide technical expertise and work with applications development teams to ensure sound, logical database/data structure design, integration, administration and management;
·         Review new logical and physical design specifications to identify impacts on enterprise database structures and their accessibility for existing as well as new applications;
·         Provide recommendations on sizing, growth planning and scalability issues;
·         Plan and deploy schema changes;
·         Develop packages and procedures over tables for validation purposes;
·         Develop database triggers and referential integrity constraints to ensure data validity;
·         Create keys and indexes;
·         Implement security permissions, privileges, standards and guidelines;
·         Create database user accounts;
·         Install and configure application software over databases;
·         Create test environments and scenarios for unit, systems and interface testing;
·         Plan and execute system conversion and installation processes;
·         Plan and execute data migration processes;
·         Ensure all quality assurance reviews are completed successfully;
·         Direct production implementation and turnover;
·         Ensure newly installed applications are functioning correctly;
·         Design and implement backup/restore plans;
·         Design and implement disaster recovery plans.
Administer/Support/Manage/Maintain:
·         Manage and optimize database performance, reliability and security;
·         Plan and execute installation of patches, new releases and upgrades of database software;
·         Install, integrate, configure and upgrade developer tools and software;
·         Manage and reorganize database objects across servers to meet requirements and make optimal use of available resources;
·         Monitor memory and disk utilization;
·         Monitor and evaluate database performance including memory utilization and input/output efficiency;
·         Use applicable tools and utilities to tune and optimize database performance;
·         Verify that data validation processes are working properly and replicated data sets are current;
·         Administer database security processes and procedures;
·         Perform sql administration and sql tuning;
·         Perform regularly scheduled backup activities and restore database(s) when required.
Problem Determination and Resolution:
·         Troubleshoot and identify root causes and resolve or advise others on resolving database management hardware/software, data communication and interoperating problems;
·         Apply physical and logical theory of database structures and application design to resolve problems in data integrity and concurrence;
·         Coordinate resolution of synchronization issues related to data sharing, data availability, database maintenance and backup and recovery processes;
·         Perform troubleshooting and resolution of complex database performance problems and issues.
Other Duties:
·         Monitor trends and developments in database management and storage technologies;
·         Consult with vendors and other sources on industry and product direction, functionality and capabilities;
·         Provide back up support to other members of the team;
·         Other related duties as assigned.
 
MINIMUM QUALIFICATIONS:
 
·         Bachelor’s degree from an accredited four-year college or university with a major in management information systems, computer science, business administration, engineering or a closely related field;
·         10 years of progressively responsible experience in the design, development and administration of complex relational databases and the management of rdbms systems (or an equivalent combination of training and experience);
·         Significant experience with and strong understanding of both ORACLE and MS SQL server (relevant certifications a plus);
·         Active TS/SCI clearance.