Senior SQL Server DBA (Top Secret) - Remote

Red Cedar Consultancy, LLC; Randolph Air Force Base (TX); Remote; USD 120,000 - 150,000; Full time

Job summary

Red Cedar Consultancy, LLC seeks an experienced Senior Database Administrator (Microsoft SQL Server) to design, implement, administer, and maintain complex databases for federal clients. The role covers performance optimization, security, auditing, quality control, and documentation within client/server environments.

Responsibilities include database design, creation, maintenance, auditing, access control, and integration with systems.

Qualifications

• 5+ years with database query languages and technologies such as Oracle, PL/SQL, SQL Server, and MS Access.
• 3+ years hands-on experience in Relational Database Management Systems (RDBMS).
• Ability to work with various operating systems and additional programming languages.
• DoD-approved 8570 Baseline Certification at IAT Level II.
• Computing Environment Certifications (MC: Azure DBAA, MCSA: SQL 2012/2016 or MC: Azure SEA).
• Meets the DLA CE Information Assurance Role/Function requirement for DBA Admin.
• IT-I Critical Sensitive security clearance or Tier 5 at proposal submission.

Responsibilities

• Perform all activities related to the administration of computerized databases.
• Project long-range requirements for database administration.
• Project long-range database design requirements in coordination with information systems managers.
• Design databases in a client/server environment.
• Create databases in a client/server environment.
• Maintain databases in a client/server environment.
• Conduct database quality control activities.
• Perform database auditing to ensure accurate and appropriate use of data.
• Advise users on access to client/server databases.
• Design, implement, and maintain complex databases.
• Address Job Control Language (JCL) considerations in database design and maintenance.
• Manage database access methods.
• Evaluate and optimize database access times.
• Address device allocation requirements.
• Implement database validation checks.
• Maintain database organization and structure.
• Implement database protection measures.
• Maintain database security.
• Prepare and maintain database documentation.
• Apply statistical methods relevant to database administration.
• Apply knowledge of database technologies and development methodologies.
• Utilize front-end and back-end programming languages, including SQL.
• Perform database programming.
• Support systems design activities.
• Maintain database dictionaries.
• Monitor and enforce database standards and procedures.
• Support database file design.
• Manage database storage considerations.
• Support the integration of systems through database design.

Tools

SQL Server

Oracle

MS Access

Job description

Red Cedar Consultancy, LLC seeks an experienced Senior Database Administrator (Microsoft SQL Server) to design, implement, administer, and maintain complex databases for federal clients. The role covers performance optimization, security, auditing, quality control, and documentation within client/server environments.

Responsibilities include database design, creation, maintenance, auditing, access control, and integration with systems.