Database Administrator
Herndon, VA

Job Description

TS/

Deadline for resume Submission:6/28/19 12:00 AM

The Client system is an in house developed application that is a Clients partners enterprise system consisting of data from multiple groups and sources. There are large amounts of data ingested in both batch and web services processes. The data is merged together into a large DB repository. The application also provides data retrieval and searches for data via online UI application and via web services. There are multiple user types and roles that are managed and tested/verified to control who can see what. The system is highly audited and must maintain a very high level of security via continuous monitoring and scanning techniques.

The application is architected and designed in a cloud based environment utilizing multiple Area Zones (AZs) and utilizing the cloud concepts and multiple web services in order to support redundancy and maximum up time requirements that are placed on the system.

The application is a highly available large application system supporting about 5,000 active users. The application must maintain a one hour time to repair objective. In addition to the user interface application, there are data ingestion and web services that are supported. The system is used by the one primary Client office and many systems rely on the web services for electronic use cases. The application host a large ORACLE data base using Golden Gate and Data Guard for hosting multiple repositories and supporting HA. The system is written in Java, Groovy/Grails and Spring/boot.

The program is run using an agile methodology with 4 week sprint intervals. These typically result in a 4 week release cycles that may include: new user functionality, bug fixes and/or maintenance and software patches. Depending upon urgency, security or user priority, there are also periodic ad-hoc releases in order to support needs, security needs, bug fixes or patching of software.

Work Requirement:

The Candidate shall perform all necessary duties to create and execute all database administration procedures and functions for several databases installations, across all environments, i.e., Development, Test and Production. The Candidate shall maintain, monitor and ensure the databases are operating at peak performance, and that the replication and backup procedures are operating properly. The Candidate shall maintain availability and integrity of database through multiple access schemes and maintain all RDBMS environments. The Candidate shall monitor relational databases to optimize database performance, resource use, and physical implementations of databases; address a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications. Additionally the Candidate shall install and configure databases for software testing as well as install, maintain and monitor the performance and backup procedures for all databases across all environments. The Candidate shall monitor and manage database backups, logs, and journals; install, maintain, and upgrade database software; restore and recover data as required; and facilitate sharing of common data by overseeing proper key and index management and data dictionary maintenance.

The Candidate shall participate in the full lifecycle of database support. The Candidate shall coordinate with various contractor project teams to provide input during project design and development to ensure that the Client produces quality products and work with contractor Senior Technologists to provide technical guidance to both Staff Project Managers and other contractor applications developers during the development process. The Candidate shall provide advice to contractor applications programmers in the effective use of database languages; advise on troubleshooting, exception processing needs and other data management issues; and design, develop, and review data models using standard diagramming techniques, in conjunction with contractor application development teams. The Candidate shall create the steps, procedures and processes in support of all database administration requirements as well as create logical data models and translate into physical database structures that integrate with existing or proposed database structures.

The Candidate shall provide DBA procedures and support during software installation or configuration changes and releases and create, procure and maintain various database related documents such as manuals and programmers handbooks. The Candidate shall write detailed installation plans, procedures and scripts that address all areas of data base support including installation, monitoring, backup, restore and startup/shut procedures. The Candidate shall document procedures and process in support of installations, configuration, monitoring, and backup/restoring of the databases. The Candidate shall consult with the contractor development and/or requirements team and provide the teams with the proper database procedures and processes in support of each release.

The Candidate shall support, monitor, and maintain all security requirements for databases and database software, such as database security, in preparation for implementation; identifying program deviance from standards, and suggest modifications to ensure compliance; and performing initial debugging procedures by reviewing configuration files, and installation procedures. The Candidate shall investigate customer problems referred by technical support and collaborate with others to evaluate or diagnose problems and recommend possible solutions. As part of the development team, the Candidate shall participate in product design reviews to provide input on functional requirements, product designs, schedules, or potential problems as they relate to the Data Base. The Candidate shall provide expertise and recommendation for all, design, performance and optimization procedures and provide feedback and recommendations to developers, leadership and Staff. The Candidate shall be familiar with the cloud environment and the procedures, services and the design of databases for new applications development or the transition of legacy applications into the cloud. The Candidate shall evaluate and recommend testing and evaluation of new procedures, software and services as needed, as well as provide data entry and data analysis in conjunction with the ability to run complex database queries.

OPTIONAL SKILLS: Demonstrated experience providing Query Optimization guidance and development

Demonstrated experience driving database related projects

Demonstrated experience with the Client or Client's partners and their processes

Demonstrated experience with Data Modeling concept (relational and dimensional)

Demonstrated experience with databases in virtualized environments

Demonstrated experience with the Agile development methodology

Demonstrated experience synching geographically dispersed databases

About Avid Technology Professionals

Avid Technology Professionals, LLC (ATP) is a premiere provider of software and systems engineering, and acquisition program management services for the community. ATP is actively seeking to pursue contract opportunities with other departments and agencies in the federal government, in state governments, and in the commercial sectors. Delivered by seasoned experts in the IT field, ATP solutions adeptly address the IT concerns manifesting in both the federal and commercial sectors.

Employee Benefits

The ATP Employee Benefits package includes:

* A Supportive and Equitable Working Environment that is both Stimulating and Challenging
* Competitive Hourly Salary
* Unique Employee Success Sharing Program that allows ATP employees to Share in Company's Successes
* Automatic Approved Overtime (as long as contract permits)
* Retirement Pay (401K); 100% company paid, immediately vested with Profit-Sharing Component
* Company Medical Coverage Plans - HMO, Open Access, PPO plans
* Company Dental Plan - widely accepted, comprehensive, and flexible
* Progressive Overtime Policy
* Flexible Spending Account benefit
* Lucrative Referral Bonus Policy
* Holiday Scheduling that Coincides with Government Holidays
* Robust Professional Expenses & Training Program
* Computer Allowance
* Internet Allowance
* Short and Long Term Disability
* Life Insurance

On TWITTER

http://ja.twitter.com/AvidTecPros