Microsoft SQL Server Database Administrator

Responsibilities Peraton is looking to add a Mid-Level Microsoft SQL Server Database Administrator with hands-on experience as a production database administrator experienced in AWS EC2 and RDS for SQL Server. The qualified individual will be responsible for meeting service level agreements covering performance, availability, backups, and security for several user groups supporting those application. Location Remote Shift Schedule 8am – 5pm Eastern Standard Time (EST). This position will participate in 24x7 on-call rotations for the production environment. What you will do Install Microsoft SQL Server instances in various configurations Standalone, Windows Failover Cluster, and Availability Groups Cloud hosting (AWS) including SQL Server RDS. Develop, test, deploy and maintain security and audit solutions. Implement Center for Internet Security (CIS) and Safeguard Computer Security Evaluation Matrix (SCSEM) hardening standards. Review NESSUS scans to remediate vulnerabilities and database compliance findings. Schedule, monitor, and validate database backups and restores. Responsible for monitoring metrics collection jobs for performance, availability, and capacity planning though through Datadog. Schedule and apply DB upgrades, patches, and certificates. Follow best practices, work plans, checklists, and defined processes. Proactively support application teams as needed. Participate in project technical reviews. Lead work product reviews. Develop and maintain database support documentation. Responsible of complex database incidents and problems, providing resolutions in a timely manner. Engage SMEs or vendors to resolve more complex incidents as required. Implement customer database change requests. Qualifications Required Qualifications Must be a U.S. Citizen with the ability to obtain and maintain the required Public Trust level clearance. Bachelors Degree and 5 years of experience, an Associates Degree and 7 years of experience, or a High School Diploma or equivalent and 9 years of experience Minimum 5 years Microsoft SQL Server DBA experience including extensive production support required. Experienced in virtualizing Microsoft SQL Server 2019/2022 and Microsoft SQL Server High Availability options (replication - transactional or log shipping and Always On). Experience with SQL Maintenance Plans, SQL Agent jobs, and Ola Hallengren's Maintenance Solutions. Experience with MS Windows Security Domains, Networking, and Group Managed Service Accounts. Experienced in AWS cloud operations supporting databases on EC2 and RDS instances. Experience deploying and maintaining Cloud Native Databases leveraging Infrastructure as Code (Terraform) and CI/CD automation (GitLab and Liquibase) Preferred qualifications Excellent written and verbal communications skills. Ability to independently work remote and collaborate effectively with team members. Experience with transact/SQL language and programming experience/knowledge is a plus. Peraton Overview Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can’t be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we’re keeping people around the world safe and secure. Target Salary Range $80,000 - $128,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual’s experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay. EEO EEO Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.

Back to blog

Other Jobs To Apply

No other job posts for this day.

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...