Type of Requisition:
Regular
Clearance Level Must Currently Possess:
None
Clearance Level Must Be Able to Obtain:
None
Public Trust/Other Required:
NACI (T1)
Job Family:
IT Infrastructure and Operations
Job Qualifications:
Skills:
Microsoft SQL Server, Microsoft SQL Server Management Studio (SSMS), Microsoft SQL Server Reporting Services, Oracle SQL
Certifications:
None
Experience:
6 + years of related experience
US Citizenship Required:
Yes
Job Description:
The Database Administrator will be responsible for the administration and maintenance of database systems implemented in support of AAO applications. The AAO database infrastructure consists of Microsoft SQL Server, Oracle, PostgreSQL and MySQL platforms.
Responsibilities:
- Demonstrates solid knowledge in database design, development and integration principles
- Fundamental knowledge of database administration best practices and techniques
- Experience supporting mission critical database management systems
- Understanding of ANSI Standard SQL constructs for Database Administration
- Experience installing, configuring, upgrading, migrating, provisioning, securing, patching, backing up and recovery of enterprise database systems
- Conceptual knowledge of High Availability (HA) and Disaster Recovery (DR) database architectures
- Good understanding of networking concepts and principles in a client/server database environment
- Experience in Unix, PowerShell or other scripting language
- Must have good communication, presentation, documentation and organizational skills
- Effectively works in a team environment with other DBAs to troubleshoot and resolve complex database problems; demonstrates strong interpersonal skills
- Excellent analytical and problem solving skills
- Ability to work comfortably in a fast-paced environment
- Schedule flexibility is required to support on-call DBA rotation and the ability to respond to trouble tickets within time required by SLAs
Required:
- Bachelor’s degree and 6+ years of experience (equivalent experience accepted in lieu of degree)
- US Citizenship and the ability to obtain the relevant clearance are required
- 6-8 years Database Administrator experience
- Preferred experience with Oracle, MS SQL Server, MySQL or PostgreSQL databases in single instance or clustered configurations
- Experience configuring and supporting MS SQL Availability Groups (AGs), Distributed Availability Groups (DAGs), Oracle Data Guard, and MySQL master-slave replication
- Demonstrated experience using Oracle SQL, PL/SQL, MS T-SQL
- Experience with client tools such as Oracle SQL Developer, TOAD, MS SQL Workbench, SQL Server Management Studio, SQL Server Reporting Services (SSRS) and Oracle Enterprise Manager (OEM) are a plus
- Knowledgeable in configuring Oracle Net Services
- Experience in client/server applications design and development is a plus
- Familiarity and/or experience with Oracle RMAN, DataPump, and Data Guard
- Experience with Red Hat Linux and MS Windows Operating Systems on VMware
- Understanding of database consolidation and virtualization concepts and best practices
The likely salary range for this position is $84,150 - $113,850. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.
Scheduled Weekly Hours:
40
Travel Required:
Less than 10%
Telecommuting Options:
Remote
Work Location:
Any Location / Remote
Additional Work Locations:
