SQL Server Database Administrator

Summary

Marine Corps Community Services (MCCS) is looking for the best and brightest to join our Team! MCCS is a comprehensive program that supports and enhances the quality of life for Marines their families and others in the Marine Corps Community. We offer a team oriented environment comprised of military personnel civilian employees contractors and volunteers who keep the organization functioning smoothly and effectively.

Duties

Acts as database administrator for a Marine Corps-wide data network supporting administrative point-of-sale and other core business applications utilizing Microsoft SQL and Microsoft Azure cloud database technologies. Duties include installing configuring maintaining patching and upgrading SQL Server enterprise level environments and Azure SQL workloads; evaluating recommending planning and scheduling the upgrade/installation of new database technologies and architectures; and analyzing and planning for anticipated changes in data capacity requirements.

Works with high availability and disaster recovery options such as SQL server clusters database mirroring and log shipping Azure Geo-Replication Azure Failover Groups and hybrid recovery models. Requires knowledge of backups retention policies database restoration recovery models integrity checks DBCC commands Azure automated backup and advanced monitoring.
Performs performance tuning and optimization (PTO) requiring knowledge of indexes and index management. Uses native monitoring and troubleshooting tools including SQL Profiler Azure Monitor Log Analytics and third-party tools such as Toad and Spotlight. Troubleshoots and resolves database problems such issues related to integrity performance blocking and deadlocking replication log shipping connectivity and security issues as well as CPU memory I/O disk space and other resource contention. Creates and uses scripts to meet operational requirements for both on-premises and Azure SQL environments.

Develops and documents SQL systems administration procedures Azure data platform operational standards data policies and cloud database governance practices. Works within established change control processes and coordinates tracks documents and resolves database related incidents change requests and work orders. Implements SQL database and Azure database system security procedures and tools applying information security/information assurance policies principles and best practices as well as database security policy for PCI PII DISA STIG RMF and DoD cloud compliance requirements.
Performs other related duties as assigned. This is a white-collar position where occasional lifting up to 20 lbs. may be required.

Requirements

Conditions of employment

• See Duties and Qualifications

EVALUATIONS:

Qualifications

Four (4) years of work experience in a Microsoft SQL DBA role. Applicable education may be substituted for years of experience.

Certification in Microsoft SQL Server System/Database Administration (i.e. Microsoft Certified IT Professional: Database Administrator (MCITP) or similar per DoD 8570.01-M) is required within six months of employment.
Experience with TOAD for SQL Server windows Server 2019 or later certification considered a plus; Preferred qualifications include hands-on expertise with Windows Clusters RAID SAN configurations security delegation Service Principal Names (SPNs) storage components and cloud database administration including Azure SQL platforms Azure DevOps and hybrid data integration Experience with Security Technical Implementation Guides (STIG) creation compliance implementation remediation and documentation is highly desirable.

Must possess excellent communication and documentation skills.

As an authorized and privileged user of Department of Defense Information Systems must possess or receive Information Assurance awareness by completing the Security CE Certification as a condition of access within six months of employment and thereafter must complete annual Information Assurance awareness training and maintain the Security CE certification.

Additional information

GENERAL INFORMATION: Applicants are assured of equal consideration regardless of race age color religion national origin sex GINA political affiliationmembership or non-membership in an employee organization marital status physical handicap which has no bearing on the ability to perform the duties of the position. This agency provides reasonable accommodations to applicants with disabilities. If you need a reasonable accommodation for any part of the application and hiring process please notify the agency. The decision on granting reasonable accommodation will be on a case-by-case basis.

It is Department of Navy (DON) policy to provide a workplace free of discrimination and retaliation. The DON No Fear Act policy link is provided for your review: part of the employment process Human Resources Division may obtain a Criminal Record Check and/or an Investigative Consumer Report. Employment is contingent upon the successful completion of a National Agency Check and Inquiries (NACI).For all positions requiring access to firearms or ammunition the Federal Government is prohibited from employing individuals in these positions who have ever been convicted of a misdemeanor crime of domestic violence or a felony crime of domestic violence adjudged on or after 27 November 2002. Selectees for such positions must submit a completed DD Form 2760 Qualification to Possess Firearms or Ammunition before a final job offer can be made.

Direct Deposit of total NET pay is mandatory as a condition of employment for all appointments to positions within MCCS.

Required Documents:

*Education/certification certificate(s) if applicable.

*If prior military DD214 Member Copy

*Resume that does not exceed 2 pages

**IMPORTANT: To align with the Merit Hiring Plan Federal Agencies will not accept resumes that exceed two pages. Accordingly the NAF HRO will only consider resumes that are two pages or fewer. Resumes exceeding this limit will not be referred and will be deemed ineligible for consideration.

This activity is a Drug-free workplace. The use of illegal drugs by NAF employees whether on or off duty cannot and will not be tolerated. Federal employees have a right to a safe and secure workplace and Marines sailors and their family members have a right to a reliable and productive Federal workforce.

Involuntarily separated members of the armed forces and eligible family members applying through the Transition Assistance Program must submit a written request/statement (may be obtained from the MCCS Human Resources Office) and present ID card with TA stamped in red on front of card.

INDIVIDUALS SELECTED FROM THIS ANNOUNCEMENT MAY BE CHANGED TO PART-TIME OR FULL-TIME AT MANAGEMENTS DISCRETION WITHOUT FURTHER COMPETITION.

ALL ONLINE APPLICATIONS MUST BE RECEIVED BY 1159PM EASTERN TIME (ET) ON THE CLOSING DATE LISTED IN THE JOB POSTING.

Candidates should be committed to improving the efficiency of the Federal government passionate about the ideals of our American republic and committed to upholding the rule of law and the United States Constitution.

Required Experience:

Unclear Seniority