Booz Allen Hamilton Database Specialist, Senior in Frederick, Maryland

Database Specialist, SeniorinFrederick, MDatBooz Allen Hamilton Inc.

Date Posted:6/13/2018

ApplyApplyNot ready to Apply?

×Join Our Talent Network

Join us. The world can’t wait.

The Booz Allen Talent Network is your opportunity hub—a chance to learn about what we do, how we do it, and how you can help.

Tell us what interests you. We’ll send you:

  • Job alerts that match your passions

  • Details about relevant upcoming events

  • Information about our work in the news

  • And more

Empower change with us. Start by joining the Network.

Privacy Policy

Cookie Policy

Terms and Conditions

  • {{ err }}

Thanks for joining our Talent Network, {{vm.userName}}

This service is currently unavailable. Please try again at a later time.

*Required

By joining our Talent Network you have not officially applied to a position.

By joining our Talent Network you have not officially applied to a position.

Thanks for joining our Talent Network, {{ vm.userName }}

By joining our Talent Network you have not officially applied to a position. To apply for this position, please click the continue button.

Continue

Redirect in {{vm.counter}}

Share With:

Job Snapshot

  • Employee Type:

Full-Time

  • Location:

Frederick, MD

  • Job Type:

Engineering, Information Technology

  • Experience:

Not Specified

  • Date Posted:

6/13/2018

About Us

At Booz Allen, we harness our collective ingenuity to solve our clients' toughest management and technology problems. We work with governments, Fortune 500 corporations, and not-for-profits around the globe, in industries ranging from defense to health, energy to international development. We believe there is no product, code, or strategy that can create progress-only people can. That's why for more than 100 years we've empowered our team: over 24,000 dreamers, drivers, and doers who work together to change the world.

Job DescriptionJob Number: R0030672

Database Specialist, Senior

Key Role:

Provide multi-vendor database development, administration, and support for at least 40 stand-alone and replicated databases. Maintain responsibility for maintaining the data and application database source code for a suite of legacy Oracle 11g Release 2-based applications until each is either migrated or reached its end of life, including upgrading the 15 stand-alone and replicated databases to Oracle 12c and migrating one MySQL database to PostgreSQL. Provide PostgreSQL technical guidance and support to developers of the migrating applications, including schema and user-defined database objects design and creation and develop scripts and PL/PgSQL programs to audit, monitor, administer, and maintain the database server and databases. Maintain responsibility for securely hardening Oracle, PostgreSQL and SQL Server databases using DoD STIGs, the NIST SP 800-53 security controls, client security policies, and applicable intelligence community (IC) policies. Provide administration and maintenance for one Esri ArcGIS server that supports the client’s geospatial analysis and reporting tasks. Develop or maintain system documentation to support the effective administration, maintenance, security, performance, and availability of the databases and its components. Plan, manage, and evaluate the tasks of at least two database administrators to support the maintenance of the legacy application systems and the development and administration of the replacement systems.

Basic Qualifications:

-10+ years of experience with database administration or database engineering

-8+ years of experience with Oracle 11g Release 2 or higher

-3+ years of experience with database replication, including Oracle Data Guard or PostgreSQL Replication configuration and administration and database security hardening using DoD STIGs, NIST SP 800-53 security controls, and IC directives or standards

-3+ years of experience with UNIX or Linux bash scripting and Esri ArcGIS administration for Server 10.3.1 or higher

-1+ years of experience with PostgreSQL 9.6 and Microsoft SQL Server 2014 or higher

-Experience with designing and developing database schemas and user-defined database objects for RDBMS

-Experience with SQL, Oracle PL/SQL and PostgreSQL PL/PgSQL programming, including designing and creating user-defined database objects, such as tables, indexes, stored procedures, and triggers

-TS/SCI clearance

-MA or MS degree

Additional Qualifications:

-1+ years of experience with Microsoft Transact-SQL (T-SQL) and phpBB bulletin board software version 3.1.9 or higher preferred

-Experience with migrating Oracle 11g databases to Oracle 12c Release 1 or higher

-Experience with data extraction, transformation, and loading (ETL)

-Experience with migrating MySQL data to either Oracle 11g Release 2 or higher or PostgreSQL 9.6 or higher

-Experience with system documentation, including analysis of system installation procedures, a system administration guide, and a Continuity of Operations (COOP) plan

-Experience with the software development life cycle (SDLC) and best practices, including source control, requirements gathering, and configuration management

-Experience with Atlassian products, including Confluence, Bitbucket, and Jira preferred

-Experience with software unit testing, integration testing, and test automation preferred

-Knowledge of Agile-based development preferred

-Knowledge of X.509 certificate-based security preferred

-Knowledge of basic XML or JSON preferred

-Ability to plan, manage, and evaluate the short-and long-term activities of at least one junior database administrator

-Possession of excellent oral and written communication skills to interface with the team and client

-TS/SCI clearance with a polygraph preferred

-Security+ Certification

Clearance:

Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; TS/SCI clearance is required.

We’re an EOE that empowers our people—no matter their race, color, religion, sex, gender identity, sexual orientation, national origin, disability, or veteran status—to fearlessly drive change.