Ts/Sci Database Administrator

Bailey Information Technology Consultants, Llc. Saint Louis , Missouri 63118

Posted Yesterday

Apply

This Job is not relevant Tell us why

Database Administrator
Location: St. Louis, MO
Clearance:TS/SCI required.Job Description:Bailey Information Technology Consultants has an opening for an experienced Database Administrator (DBA) to manage aspects of Oracle and Postgres databases including installation, configuration, design and data migration within Aeronautical Production Systems. This DBA position is tailored towards a Database developer vs. a Database admin as there will be database functions requiring significant modernization as the system migrates to the cloud. Responsibilities:

Supporting Oracle database migration from on premise to AWS Cloud leveraging RDS managed service.
Supporting the analysis and evaluation of system improvements, optimization, development, and/or maintenance efforts.
- Evaluation will include feasibility studies of Oracle vs Postgres database options across cloud system architectures.
- Evaluation will include Subject Matter Expertise (SME) level input to lead Engineering studies as to pros and cons each of proposed solution.
Supporting the development of long term and short-term requirements for database administration and design.
Supporting the development of data migration strategy and its implementation.
Modifying functions with Oracle to produce additional data outputs.
Modernization of databases to utilize and implement Spatial functionality.
Documentation of database procedures and best practices.
Manage and maintain Oracle databases including migration of version updates.
Maintain and optimize spatial data in Oracle.
Potential to convert Oracle database to PostgreSQL.

Core Qualifications:

Bachelors Degree in a related discipline w/ 4-6 years of relevant experience or Masters Degree in a related discipline w/ 2 years. Additional experience may be considered in lieu of degree.
Experience maintaining operational Oracle databases for mission critical systems.
Experience scripting for views, functions, and queries.
Experience query tuning for database optimization.
Understanding of databases, primarily Oracle and/or other relational and non-relational/NoSQL databases such as PostgreSQL and MongoDB.
Experience with cloud-first, AWS native architectures and RDS managed service in particular
Prior experience using Oracle SQL/PLSQL, and SQL in general.
Previous experience scripting with Bash/Linux shell scripting.

Preferred Qualifications:

Knowledge in complex application integration
AWS certifications, like associates and developer
CompTIA Security+ or equivalent certification
Experience in either software development projects or software integration projects in a service-oriented environment (Cloud, SOA, Web-Services) or virtualization environment.
Experience as a Database Administrator to include tasks such as data migration, data replication, user administration, backup and recovery, performance tuning, issue investigation, issue resolution, and general administration.
Prior experience with migration projects.
Prior experience with Postgres database modernization/maintenance/sustainment.
Prior experience with DoD Aeronautical Datasets
Prior experience with AWS cloud formation templates
Prior experience with configuration management tools and processes.
Prior experience with Oracle Spatial or PostGIS.
Prior experience with JavaScript, Perl, and/or Python scripting.
Team Collaboration tools (Jira, Confluence)
Active TS/SCI with Polygraph

We will be modernizing a very complex Oracle database with numerous functions. We are looking for extensive Oracle manipulation, upgrades, and scripting experience along with any mention of Postgres experience as we will be investigating moving to this database structure as part of a research phase.

Show Full Description

See how you match
to the job

Upload my resume

Download the
LiveCareer app and find
your dream job anywhere

Similar Jobs

View All

Want to see jobs matched to your resume?
Upload One Now!

Ts/Sci Executive Secretary

Bailey Information Technology Consultants, Llc.

Posted Yesterday

VIEW JOBS BIT Consultants is currently seeking an Executive Secretary for an opportunity in the St. Louis, Missouri area.Job Title: Executive SecretaryTS/SCI clearance requiredMinimum Requirements:Experience: Minimum 8 years (Bachelor's Degree) of secretary experience with a minimum 2 year experience working in a senior level officeExperience: Minimum 10 years of secretary experience (Associates' Degree) with minimum 4 years’ experience working in a senior level office.Experience: Minimum 14 years (High Scholl Diploma) of secretary experience with minimum 6 years’ experience working in a senior level office.Required Experience:• Proven experience in the secretary profession directly supporting an office environment with senior leadership personnel serving in the grades of SES/DISL or at the Flag Officer level.• Strong foundational knowledge and understanding of the Department of Defense (DoD) and Intelligence Community (IC).• Strong professionalism with the ability to consistently demonstrate tact and maturity in all situations.• Strong interpersonal and/or soft skills, and office etiquette to:o Facilitate professional relationships and support efficient execution of all office administrative requirements; ando Realize a positive customer oriented service experience by internal/external office personnel, customers, and visitors.• Strong teaming and collaboration skills that foster office unity and cohesiveness in support of completing office administrative requirements.• Capable of independently handling a large, complex workload, effectively coordinating multiple resources, and multi-tasking in a fast paced environment having competing priorities.• Excellent communication skills both verbally and written with the ability to:o Articulate and exchange information (i.e., requirements, actions, needs, status, etc.) in a professional tone and attitude to achieve efficient business rhythms; ando Produce professionally written emails, letters, documents, and other material that is succinct, coherent, uses proper tone, demonstrates proper grammatical use of the English language, and presents proper format/form per established corporate/office guidance.• Exceptional office and work organization skills that facilitates a neat and orderly presentation of the work environment and administrative activities. (Note: Our client has a clean desk policy that requires a clutter free work environment and the proper storage of working papers.)• Understanding of and prior experience in applying office protocol and staffing requirements at the senior leadership level.• Strong analytical skills to anticipate and proactively assist leadership personnel and staff with day-to-day business rhythms and administrative support requirements.• Able to independently apply mature judgment and initiative to determine approach and action to take in both routine and non-routine administrative situations.• Creative and innovative techniques for performing administrative responsibilities that enhances office workflow processes and business rhythms.• Interpret and adapt guidelines with minimal assistance, including unwritten policies, precedents and practices that are not always completely applicable to a changing situation• Strong working knowledge of office information technology (IT) equipment (e.g., copiers, scanners, facsimile machines, computer workstations, phones, teleconference/video teleconference equipment) with the ability to independently operate such equipment in completing administrative tasks.• Strong working knowledge of MS Office software applications (i.e., Word, Excel, PowerPoint, and Outlook: Mail, Calendar, and File Functions) with the ability to independently use these applications to efficiently complete office administrative tasks.• Proven self-starter with the ability to independently and accurately complete all assigned administrative work requirements.• Strong typing skills with the ability to type at a minimum of 45 words per minute (wpm).• Working knowledge of administrative processes and business rhythms.• Knowledge of Military and administrative support requirements at the Flag Officers as an executive officer or staff officer.• Proficient working knowledge of the following corporate applications:1) PeopleSoft2) Defense Travel System (DTS) with knowledge of the Joint Travel Regulation (JTR)3) NCERTS4) Sharepoint• Process improvement planning and implementation.• Establishing and managing office spend plans for travel, supplies and awards.• Administratively supporting the planning, coordination and execution of visits, events, luncheons, and other office functions as required.• Prior experience with presentation techniques and building briefing slides.• Possess a working knowledge of the NGA internal coordination and approval processes.• Working knowledge of Access database• Knowledge of NGA correspondence manual• Working knowledge of NGA’s File Plan requirements• Possess a working level understanding of NGA corporate processes• Experienced in setting up and maintaining office-filing systems (hardcopy and softcopy) using specified format and structure.• Ability to schedule, coordinate, set-up, and operate Video Teleconference (VTC) equipment; and this include teleconferences.Job Type:Full-time

Ts/Sci Corporate Communications

Bailey Information Technology Consultants, Llc.

Posted Yesterday

VIEW JOBS Job title: Corporate CommunicationsLocation: St. Louis, MissouriSecurity Clearance: TS/SCIOverall Assignment Description:The individual shall provide support for the CIO-TES Corporate Communications Branch by applying CIO-TES Communications Specialists assigned to the CIO-TES Chief Information Security Office, and support the corporate communications mission of the CIO and IT Services Directorate. The team works to support the communication needs of CIO-T leadership and the workforce from a corporate perspective and through key mission areas, initiatives and priorities identified by the director and deputy directors of CIO-TES. This support includes the creation, development and implementation of a variety of CIO-TES communication materials and events, to include, senior leader briefings and talking points, news and information articles, graphics and web support, marketing and branding, and events, such as town halls, brown bags, information sessions, etc.Duties include: <li> Support communications projects as aligned to CIO-T five key strategic mission areas of IC ITE/Cloud Migration; Cybersecurity; Mission Evolution and Emerging Capabilities; GEOINT Standards, Architecture and Engineering; workforce development and transformation. Assist CIO-T groups, divisions and offices highlight and publicize related CIO-T mission initiatives and audiences to a variety of audience through a multitude of communications tactics. <li> Develop effective communication strategies, plans and tactics that highlight and promote understanding and awareness of key functional areas of the CIO-T directorate. Research, write, and coordinate news/feature articles or other communiqués, as assigned by CIO-T Strategic Communications Division chief. <li> Develop other communication products, such as briefings, marketing campaigns,, aimed at increasing awareness of milestones and initiatives for a variety of audiences. All products shall be written in accordance with AP Style guidelines and align with CIO-T Communications Strategy. <li> Provide editing support to CIO-T team members and CIO-T subject matter experts on internal and external taskers, reviews, and requests, as directed by CIO-T Communications Division Chief. Maintain the CIO-TQC group mailbox. <li> Follow established timelines, processes and procedures as well as continually look for ways to improve the overall processes, and support to CIO-T communications mission. Create and manage electronic content related to CIO-T Strategy. <li> Communicate with CIO-T and subordinate offices on the status of assignments. Respond to emails requesting the communications support promptly at the request of the Government to provide assistance with communication needs. (CDRL: Reports, Briefings, Evaluations, Technical Assignments, Transition Plan, White Papers etc.) <li> Create communication plans and tactical calendars for assigned communication initiatives Work seamlessly in a team environment, interfacing with internal and external stakeholders at all levels. <li> Plan and execute communications tasks as identified and assigned by the CIO-T Strategic Communications Division chief. </li><li> Assist CIO-TES groups, divisions and offices highlight and publicize related CIO-TES mission initiatives and audiences to a variety of audience through a multitude of communications tactics. Provide editing support to CIO-TES team members and CIO-TES subject matter experts on internal and external taskers, reviews, and requests, as directed by CIO-TESC Division Chief. <li> Develop effective communication strategies, plans and tactics that highlight and promote understanding and awareness of key functional areas of the CIO-TES office. Research, write, and coordinate news/feature articles or other communiqués, as assigned by CIO-TESC Division chief. <li> Maintain the CIO-TES group mailbox. Follow established timelines, processes and procedures as well as continually look for ways to improve the overall processes, and support to CIO-TES communications mission. <li> Create and manage electronic content related to CIO-TES Strategy. Communicate with CIO-TES, subordinate offices and SMEs on the status of assignments. <li> Plan and execute communications tasks as identified and assigned by the CIO-TESC Division Chief. Skills and Experience: Required Possess a bachelor degree in Communication, Journalism, English or relevant experience. <li> Demonstrate advanced skill in oral and interpersonal communication, and writing at collegiate and professional levels, especially news and feature writing. Demonstrated written and oral communication skills with drafting documents and briefings. Demonstrated experience utilizing critical thinking data gathering and analytic skills. <li> Demonstrated experience with AP Style guidelines.Desired </li><li> Demonstrated experience in Communication Management with senior leadership and the remaining organization on a daily basis. Demonstrated proficiency with Microsoft Suite to create required documentation and briefings. Demonstrated experience with SharePoint.

Full Stack Developer

Bailey Information Technology Consultants, Llc.

Posted Yesterday

VIEW JOBS Full Stack Developer Location: St. Louis, MO Clearance: None to start, but the ability to obtain a TS with SCI.Job Description:Bailey Information Technology Consultants has an opening for an experienced full stack software developer to modify existing GOTS code and integrate open source software solutions for display and analysis within Aeronautical Production Systems.Responsibilities:<ul><li style="margin-left:8px">Primary responsibilities will involve using cloud computing expertise to provide the system administration and modification of existing GOTS code to integrate open source software solutions for display in a web application. This role includes API development and database integration for interaction with Redux and React frameworks, using various open source packages for visualization and data filtering and code modifications that shall apply best practices in unit and build testing. </li><li style="margin-left:8px">Applicant must possess an unconscious competence with C#/Java and JavaScript/TypeScript. Other duties include working with PostgreSQL, Entity Framework, Visual Studio and familiarity with JSON APIs. </li><li style="margin-left:8px">This role includes creation and documentation of new and existing functionality within software version control repositories (gitlab) and utilizing DevOps principals and tools to deliver new features within an Agile construct.</li><li style="margin-left:8px">Participate in program Agile software development initiatives (standup, planning, Increment planning) to support innovation and enhancement of custom applications through iteration/functionality testing </li><li style="margin-left:8px">Participate and collaborate with team members to assess tickets to ensure proper testing and delivery of functionality per User Story Acceptance Criteria</li><li style="margin-left:8px">Core Qualifications:</li><li style="margin-left:8px">Experience in either software development projects or software integration projects in a service-oriented environment (Cloud, SOA, Web-Services) or virtualization environment.</li><li style="margin-left:8px">Requires BS degree and 8+ years of prior relevant experience or Masters with 6+ years of prior relevant experience; OR 4 years of related experience.</li><li style="margin-left:8px">Minimum 3 years of experience with modern Javascript and/or C# development framework</li><li style="margin-left:8px">Minimum 3 years of experience with REACT. </li><li style="margin-left:8px">At least 2 years of experience with unit testing, continuous integration tools, and Gitlab version control</li><li style="margin-left:8px">Proactive self-starter demonstrating a positive, willing attitude and excellent oral and written communication skills.</li><li style="margin-left:8px">Organizational Skills: Can plan and prioritize work. Follows tasks to their logical conclusion and makes sure that everything has been done to the right standard. Good attention to detail.<ul><li style="margin-left:8px">Communications: Ability to communicate clearly and efficiently to team members and clients, verbally and in writing. Able to present ideas in a variety of ways depending upon audience and context. </li></ul></li></ul>Preferred Qualifications:<ul><li style="margin-left:8px">At least 3 years of experience with Linux and/or Windows system administration</li></ul><ul><li style="padding: 0; margin: 0;">At least 2 years of experience with DoD Aeronautical Datasets</li><li style="padding: 0; margin: 0;">At least 1 year of experience with AWS cloud formation templates</li><li style="padding: 0; margin: 0;">At least 1 year of experience with Node, NPM, Swashbuckle, REST API, Sass</li><li style="padding: 0; margin: 0;">AWS Solutions or DevOps certification</li><li style="padding: 0; margin: 0;">Team Collaboration tools (Jira, Confluence)</li><li style="padding: 0; margin: 0;">Active TS/SCI with Polygraph</li></ul>

Apply