Sr. Database Administrator at McLean

Position Summary

Designs, develops, monitors and maintains complex database management systems and related components underlying business applications. Responsible for end-to-end support, administration and configuration management of databases and the servers they run on.

 

Duties and Responsibilities

Works with customers to design data management, information life-cycle management, infrastructure design and security and data integrity controls.

Develops database documentation, procedures and policies. Works with the system administrator to manage user and application security levels for the database.

Supports applications development teams to ensure data designs will operate efficiently once implemented, including overall database design, helping developers tune queries, assigning proper indexes, and the creation of triggers and stored procedures.

Responsible for the overall configuration management of the database technologies, including initial database installations, upgrades to new product releases and the installation of service packs.

Monitors and analyzes database performance, producing reports and recommendations for improvements as needed.

Investigates database faults, diagnoses bugs, researches complex problems with vendors and works to restore database function during outages.

Manages backup and recovery of the database, including establishing standards and schedules for database backups, developing recovery procedures for each database and ensuring that the backup schedules meet recovery requirements.

May also develop and manage data replication procedures and tools.

Responsible for storage management monitoring, planning for space requirements and adding new storage space as needed.

Conducts technical reviews of systems and databases to provide state-of-the-art support to customers.

Provides guidance to less experienced Database Administrators.

Additional Responsibilities:

Responsible for creation, administration, and maintenance of PeopleSoft HCM databases on Oracle 11g including all middleware.  Must have a strong experience with Oracle database, PeopleSoft, UNIX, and Linux.  Candidate will have 5-7 years of experience.

 Requirements

Education and Experience

Bachelors degree in related discipline plus at least 5 years of directly related experience working with databases or a Masters degree and 3 years of experience. 

In some cases, educational requirements may be adjusted or waived for more than 10 years applicable work experience. Work experience may be adjusted for highly specialized knowledge or uniquely applicable experience for positions involving new technology or labor market shortages as reflected by market survey data.

 

Knowledge, Skills, Abilities
Ability to tailor a system to meet specific organizational needs.

Excellent communication and interpersonal skills.

Maintains a deep understanding of relational principles, general DBA techniques and practices, as well as the ability to understand complicated relationships dictated by the data schema.

Experience or knowledge is required in the following technologies: SQL Server - Transact SQL (authoring procs, type of parameters, use of functions, error handling, transaction statement, table variables and SQL - DB Design, identity columns, relationships, indexes, triggers and constraints.

Additional Requirements:

Must be able to install and configure Oracle 11g in UNIX and Linux environments.
Must have experience in tuning database and SQL statements.
Must have experience with SQL, and PL/SQL.
Must have experience in RMAN for backup and recovery.
Must have experience with ASM.
Must be able to write shell scripts.
Must be able to manage multiple databases with different configurations.
Must have experience with data modeling.
Must have experience with patching and upgrading Oracle.
Must have experience with Tuxedo application server.
Must have experience with Weblogic.
Must be able to install, configure, patch and upgrade PeopleSoft HCM.
Must be familiar with PeopleTools including Application Designer, Data Mover, and Change Assistant.
Must be familiar with PeopleCode, Application Engine, Application Packages, and SQR.
SQL Server & SSIS experience is a plus.
Data Warehousing experience is a plus.
VMware experience a plus.
Functional knowledge of PeopleSoft HCM is a plus.
Must have experience with Oracle Data Guard.
Must have experience with migrating Oracle databases to different architectures.
Must be familiar with cybersecurity concepts.

A security clearance of an appropriate level may be required after employment.

Country: USA, State: Virginia, City: McLean, Company: Alion Science and Technology.