Junior Database Administrator

JOB PURPOSE

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:
·         Work with the Senior DBA to ensure sound, logical data structure design, integration, administration and management;
·         Review new design specifications to identify impacts on existing database structures;
·         Plan and deploy schema changes;
·         Design and develop triggers and referential integrity constraints to ensure data validity;
·         Develop packages and procedures over tables for validation purposes;
·         Implement security permissions, privileges, standards and guidelines;
·         Install and configure application software over databases;
·         Create test environments and scenarios for unit, systems and interface testing;
·         Plan and execute system conversion, installation and data migration processes;
·         Ensure newly installed applications are functioning correctly;
·         Ensure all quality assurance reviews are completed successfully.
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 including memory and disk utilization;
·         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;
·         Develop and maintain high-quality documentation on the system design and configuration of the assigned environments.
Problem Determination and Resolution:
·         Troubleshoot and identify root causes and resolve 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.
Other Duties
·         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;
·         5 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);
·         Strong experience with and understanding of both ORACLE and MS SQL server (relevant certifications a plus);
·         Experience performing administration on Unix platform;
·         Knowledge of Windows platform;
·         Basic understanding of subsystems;
·         Understanding of data modeling theory and practices;
·         Active TS/SCI clearance with ability to maintain clearance.