Postgres SQL DBA

Title : Postgres SQL DBA
Terms : 6 month contract to hire
Citizenship: US Citizen or GC holder

Location: Fully onsite in Warrenton, VA

Top Skills: Postgres SQL, willing to work 5 days onsite in Warrenton, at least 15 years of experience plus an Engineering or Math degree

Description of duties:
Position involves database management and engineering services in support of the NAS Aeronautical Information Management Enterprise Service (NAIMES) systems. The primary focus of this position is to assist the 24/7/365 engineering, senior system, and database administration support to include system troubleshooting, equipment replacement, and technology refresh, system preventative/corrective maintenance, and support to the aeronautical information operational services. Duties include:

• Day-to-day operational support to administer and maintain operation databases.
• Installation, configuration, patching and upgrading of database server software and related products.
• Establishing and maintain backup and recovery policies and procedures.
• Implementing and maintaining database security.
• Performing database tuning, performance monitoring and troubleshooting database errors.
• Setting up and maintaining documentation and standards.
• Planning growth and changes (capacity planning).
• Creating and maintaining SQL and PL/SQL queries and shell scripts.
• Finding and debugging malfunctioning programs affecting database integrity.
• Setting and maintaining database standards.
• Managing database access.
• Recommending and implementing emerging database technologies.
• Creating and managing database reports.
• Be available for on-call support as needed.
• Evaluating new database features and making recommendations.
• Sharing knowledge and mentoring other DBAs as needed.
• Performing disaster recovery operations and data backups when required; and
• Suggesting improvements to database capacity, performance, and scalability.

Required skills:

• To meet the clearance requirements for this opportunity, candidates must be a US Citizen or Green Card Holder.
• Ability to pass a US Public Trust background investigation for access to the client site and computing systems.
• Experience with critical operations in a large-scale secure environment
• Experience with web-based applications
• Strong experience as a Senior Level Database Administrator and database related utilities and tools
• Experience and understanding of database technologies (MySQL, MS SQL, Postgres, Oracle)
• Advanced knowledge of database security, backup and recovery, and performance monitoring tools and standards
• Experience and understanding of database design, implementation, troubleshooting and maintenance.
• Ability to perform both database and operating system performance tuning and monitoring.
• At least fifteen years of database administration experience.
• Experience using SQL Query Tools, Oracle, or PostgresSQL, etc.