SQL Database Administrator


AMS Technologies San Antonio , TX 78201

Posted Today

Clearance Level:Active Top Secret/SCIEducation:Bachelor's Degree with relevant experience
Location:San Antonio, TXTravel: 0 - 10%AMS Technologies has a great career opportunity for aSQL Database Administrator to support the Blu SCI BOSS program in San Antonio TX. The ideal candidate would be responsible for:
  • Administer database services for the Enterprise to include all supported sites and systems. The current database utilized is Structured Query Language (SQL).
  • Operate and check the day-to-day operation of fielded anti-virus databases. Perform system checks, backup, recovery, and load analysis. Build and rebuild replication scheme and troubleshoot systems with other operational functions and application developers.
  • Design build functions to control access to data, enforce data integrity, manage concurrency, and add, modify, and delete functionalities based on customer requirements for upgrading software and support tools as newer versions are released.
  • Convert standard databases to the Enterprise-level database.
  • Manage servers; research and troubleshoot problems by reviewing logs, records, and network configurations.
  • Ensure data is backed up on a daily basis; log all IT and Enterprise problems and resolutions and provide results to the ESMT Government lead and COR in the monthly status report.
  • Ensure all software is properly licensed and notify the AF BluSCI Software Program Manager of unlicensed software on the network 24/7.
  • Identify all issues that may affect Enterprise operations to the COR and upon discovery.
  • Develop publish and maintain AF BluSCI Enterprise SOPs and provide training on existing and new technologies to Government personnel to support patch management methodologies. This is informal office training. Provide process and operations guides within specified time limits.
  • Develop and maintain Enterprise/ESC level SOPs for services managed and maintained.
  • Active Top Secret SCI clearance required
  • Bachelors degree in IT or relevant field and 5-8 years of experience
  • CompTIA Security+ CE
  • SQL Server 2014
  • Able to work independently on specific tasks associated with one or more knowledge areas defined above.
  • Microsoft Certified Solutions Associate (MCSA) or equivalent
  • CompTIA Security+ CE
  • MCSA equivalent within 6 months of employment
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

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
Oracle Database Administrator

General Dynamics

Posted 3 days ago

VIEW JOBS 11/29/2022 12:00:00 AM 2023-02-27T00:00 <p>Responsibilities for this Position</p><p>Oracle Database Administrator</p><p>Job ID: 2022-57292</p><p>USA-TX-San Antonio</p><p>Required Clearance: TS/SCI with Polygraph, obtainable within reasonable time based on requirements</p><p>Posted Date: 10/26/2022</p><p>Category: Information Technology</p><p>Employment Type: Full Time</p><p>Hiring Company: General Dynamics Mission Systems, Inc.</p><p>Basic Qualifications</p><p>Bachelor's degree in computer science, information technology/related discipline is required plus a minimum of 5 years of relevant experience; or Master's degree plus a minimum of 3 years of relevant experience.</p><p>Clearance Requirements:</p><p>This position requires a minimum of an active TS/SCI clearance. Must be willing and able to obtain a polygraph within a reasonable amount of time after hire, with acceptable timing determined by manager. Applicants selected will be subject to a U.S. Government security investigation and must meet eligibility requirements for access to classified information. Due to the nature of work performed within our facilities, U.S. citizenship is required.</p><p>Responsibilities for this Position</p><p>General Dynamics Mission Systems has an immediate opening for an Oracle Database Administrator in the San Antonio, TX area. This position provides an opportunity to further advance the cutting-edge technology that supports some of our nations core defense/intelligence services and systems. General Dynamics Mission Systems employees work closely with esteemed customers to develop solutions that allow them to carry out high-stakes national security missions.</p><p>REPRESENTATIVE DUTIES AND TASKS:</p><ul><li><p>Demonstrate an understanding of PL/SQL constructs (triggers, functions, packages, procedures) and their processing</p></li><li><p>Create, alter, and drop database users</p></li><li><p>Monitor and audit web server and database access</p></li><li><p>Develop and implement a strategy for managing security (roles, privileges, authentication)</p></li><li><p>Perform daily web and database server backups</p></li><li><p>Perform daily server health checks and log findings</p></li><li><p>Allocate and manage physical storage structures (e.g. datafiles, redo logs, control files)</p></li><li><p>Troubleshoot and resolve web and database server issues</p></li><li><p>Troubleshoot and resolve user connection problems</p></li><li><p>Troubleshoot database application issues to include reviewing applicable error logs on both web and database servers</p></li><li><p>Diagnose and resolve locking conflicts</p></li><li><p>Performance tuning</p></li><li><p>Use data dictionary tables and views</p></li><li><p>Demonstrate and understanding of the capabilities of the underlying operating system as it relates to the Oracle database and and/or any supported optional products</p></li><li><p>Perform complete system shutdown and startup as required</p></li><li><p>Track database metrics and provide to management upon request</p></li></ul><p>COMMUNICATION/TEAM BUILDING/ATTITUDE:</p><p>It is critical that the person filling this position be able to complete projects independently and with little or no supervision. However, because of the nature of the DBA position, the ability to effectively communicate ideas and concepts is critical. Also, when the times call for it, working as part of a team is essential to the overall success of our contract. Individuals must be self motivated, eager to learn, and have the ability to take the good with the bad as well as affectively deal with heightened stressful situations.</p><p>KNOWLEDGE SKILLS AND ABILITIES:</p><ul><li><p>Ability to act with little daily instruction on tasks of diverse scope using a seasoned professional understanding of the database administration discipline</p></li><li><p>Exhibits proficient knowledge on database technologies, operating systems, best practices, and industry trends including database design, configuration, tuning, and support</p></li><li><p>Proficient knowledge of SQL and SQL query tuning techniques</p></li><li><p>Proficient experience developing solutions to a variety of challenging problems of broader scope and complexity</p></li><li><p>Prior work experience as a Database Administrator or equivalent planning, designing, implementing, maintaining, and optimizing database systems</p></li><li><p>Has ability to analyze situations, alternatives, proposals, designs, architectures, risks, data, systems, and constructs</p></li><li><p>Proficient understanding of solutions development methodologies (e.g. DevOps, Agile, Software Development Lifecycle, etc.)</p></li><li><p>Solid presentation skills</p></li><li><p>Clear &amp; concise oral &amp; written communication skills</p></li></ul><p>Company Overview</p><p>General Dynamics Mission Systems (GDMS) engineers a diverse portfolio of high technology solutions, products and services that enable customers to successfully execute missions across all domains of operation. With a global team of 12,000+ top professionals, we partner with the best in industry to expand the bounds of innovation in the defense and scientific arenas. Given the nature of our work and who we are, we value trust, honesty, alignment and transparency. We offer highly competitive benefits and pride ourselves in being a great place to work with a shared sense of purpose. You will also enjoy a flexible work environment where contributions are recognized and rewarded. If who we are and what we do resonates with you, we invite you to join our high performance team!</p><p>General Dynamics is an Equal Opportunity/Affirmative Action Employer that is committed to hiring a diverse and talented workforce. EOE/Disability/Veteran</p><br> General Dynamics San Antonio TX

SQL Database Administrator

AMS Technologies