Ts/Sci Database Administrator

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

Posted Yesterday

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.
icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Ts/Sci Executive Secretary

Bailey Information Technology Consultants, Llc.

Posted Yesterday

VIEW JOBS 1/28/2023 12:00:00 AM 2023-04-28T00:00 <strong>BIT Consultants is currently seeking an Executive Secretary for an opportunity in the St. Louis, Missouri  area.</strong><strong>Job Title: Executive Secretary</strong><strong>TS/SCI clearance required</strong><strong>Minimum Requirements:</strong>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.<strong>Required Experience:</strong>• 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.<b>Job Type:</b>Full-time<br> Bailey Information Technology Consultants, Llc. Saint Louis Missouri

Ts/Sci Database Administrator

Bailey Information Technology Consultants, Llc.