Senior Database Administrator

Competitive Innovations (CI) is a solution provider to government and industry. Headquartered in Arlington, Virginia, we serve customers with mission critical security and citizen service knowledge worker requirements.

This position supports a collection of cyber security tools and custom applications used to provide cyber monitoring. The Senior DBA assists, defines, and/or oversees database organization, standards, controls, procedures, and documentation. They provide technical consulting in the definition, design, and creation of a database environment. They ensure that documentation is complete and up-to-date and develop and apply procedures for periodic database backup. This senior-level DBA provides technical expertise, working independently and with other engineers as part of a team focused on providing the integration and full lifecycle support for major cyber tools and capabilities. The primary area of responsibility will be building database infrastructures and supporting numerous cybersecurity technical capabilities. The Senior DBA will lead and support the deployment of back-end databases for new security tools. The ideal candidate will have a solid understanding of large scale enterprise IT tools and databases. They will also have experience with cyber security in the domains of security vulnerabilities, networking protocols, virtualization, and information exchange models. Responsibilities require a skilled senior DBA to implement standardized and consistent processes, user training, innovative industry approaches and enhancements to current capabilities.

* Maintains database dictionaries and integration of systems through database design * Maintains and documents shell scripts and batch processes * Develops and applies procedures for periodic database backup * Designs, implements, and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods * Develops applications to help solve database solutions to business problems, data architectures, database management system facilities and capabilities, and the operation and tuning of databases * Provides technical consulting in the definition, design, and creation of a database environment * Assists, defines, and oversees database organizations, standards, controls, procedures, and documentation * Executes processes in SQL and PL SQL for Oracle databases such as stored procedures/functions/packages, database job, materialized view, view, synonyms, and DB link * Analyzes impact on database before making any changes to database * Analyzes data source and creates a data load script * Creates PL/SQL and SQL scripts to apply changes to Oracle database * Performs primary lead support for the database environment

* Minimum of Secret level security clearance * Bachelor's Degree or equivalent years of experience in relevant field * Minimum six (6) years of experience in database administration and enterprise systems lifecycle management, structured system development methodologies (preferably Information Engineering), structured analysis, and/or information systems development or a relevant technical discipline * Experience deploying, maintaining, and optimizing Oracle database infrastructures. * Experience deploying, maintaining, and optimizing Microsoft SQL database infrastructures. * Strong logical/critical thinking abilities, especially analyzing existing database layouts, application architectures, schemas and developing a good understanding of the application model. * 4+ years hands-on Linix/Unix and virtualization experience * Knowledge of Windows Operating Systems, Windows Management Interface (WMI) development, and shell scripting * Extensive experience with VMWare * Experience developing and documenting detailed, technical user guides and hands on training. * Strong understanding of networking fundamentals * Experience developing Standard Operating Procedures (SOPs), job aids, and hands-on training materials. * Desired Qualifications: * Experience deploying, maintaining, and optimizing Microsoft SQL database clusters. * Desired Certifications: Oracle DBA, RHCE, Linux+, VMWare Certified Associate,: MCSE: Data Platform * Proficiency in process automation using multiple scripting and development tools including, but not limited to: Shell scripting, HTML, PowerShell, VBScript Perl, Ruby, or Python * Proficiency with Linux, Unix * Experience in developing test cases for technical certification