Oracle/SQL Server DBA

General Dynamics IT; United States; Remote; USD 84,000 - 114,000; Full time

Benefits offered by this job

Medical plan options

Dental plan options

Vision plan

401(k) with company match

Paid time off

Job summary

General Dynamics IT is seeking a seasoned Database Administrator to manage AAO applications across MS SQL Server, Oracle, PostgreSQL and MySQL. The role emphasizes design, security, backups, and high availability within a fast-paced environment.

Candidates should have 6+ years of DBA experience, US citizenship, and the ability to obtain the necessary clearance. Remote work option is available, with a likely salary range provided by the employer.

Qualifications

• Bachelor's degree and 6+ years of related experience (equivalent experience accepted in lieu of degree).
• 6-8 years Database Administrator experience in MS SQL, Oracle, MySQL or PostgreSQL.
• Experience with MS SQL Availability Groups, DAGs and Oracle Data Guard.
• Proficiency with Oracle SQL, PL/SQL, MS T-SQL and related tools.
• Familiarity with Oracle RMAN, Data Pump, and Data Guard is a plus.

Responsibilities

• Administer and maintain database systems for AAO applications.
• Design, develop and integrate database solutions and ensure security and backups.
• Install, configure, upgrade, migrate, and patch enterprise databases.
• Implement HA and DR architectures and monitor performance.
• Work with networking concepts in a client/server environment.
• Utilize Unix, PowerShell or similar scripting for automation.
• Collaborate with DBAs in a team to troubleshoot complex issues.
• Document processes, procedures and system configurations.

Skills

Microsoft SQL Server

SSMS

SQL Server Reporting Services

Oracle SQL

SQL Standards & T-SQL

Education

Bachelor's degree

Tools

Oracle SQL Developer

TOAD

SQL Server Management Studio

SSRS

Oracle Enterprise Manager

VMware

PowerShell

Job description

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

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%

T elecommuting Options:

Remote

Work Location:

Any Location / Remote

Total Rewards at GDIT:

• Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match.
• To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave.
• GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year.
• Paid leave and paid holidays are prorated based on the employee's date of hire.
• The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees.
• To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available.
• We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

Our Identity Verification Process:

As part of the hiring process, we will ask you to complete an identity verification