Peraton
Senior AWS SQL Database Administrator
Peraton, Reston, Virginia, United States, 22090
Senior AWS SQL Database Administrator
Job Locations
US
Requisition ID
2024-152359
Position Category
Information Technology
Clearance
Agency Clearance
Responsibilities
We are Hiring! We alre looking to ass a
Senior AWS SQL DBA.
This hired individual will be responsible for the design, implementation, configuration, maintenance, and performance of critical Database RDBMS systems, to ensure the availability and consistent performance customer enterprise applications. This is a "hands-on" position requiring deep technical skills, as well as excellent interpersonal and communication skills.What you will do:Design, Installation, Administration and Maintenance of SQL Server Instances in an On-Premise and multi-cloud environment (Azure and AWS)
Owns the strategic direction for the database topography within the solution offeringCreate Users and assign permissions based on the level of database accessDesign database backup and restore strategyDesign and build High-Availability as part of Disaster Recovery Strategy for the Databases (Failover Clustering, Always On, replication and log shipping) and SAN replicationConfiguring Azure/AWS Services PaaS/IaaS and migrate databases from on premise to Azure/AWSConfigure and maintain Azure SQL instances, Azure SQL Managed Instances and Azure SQL Elastic Pools, MySQL Flex, PostgreSQL FlexData refresh activities from production environments to non-production (development, test, QA, stage) environments and fixing orphan usersTroubleshoot various problems that arise in the day-to-day operations and fix the issuesMonitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning to include index optimizationsDatabase growth vs disk space available, audits, resource monitoring (I/O bottlenecks, memory pressure, CPU use)Monitor backups to ensure they are being performed regularlyRecover the databases to a specific point of timeProvide 24/7 on-call support on rotation basisQualifications
Required Qualifications:Bachelors Degree and 8 years of experience. Additional 4 years of experience maybe accepted in lieu of degree requirement.Must have Microsoft SQL Server DBA experience.Must have Microsoft Azure and Amazon AWS experienceMust have SSIS / SSAS / SSRS experienceExperience with T-SQL and scriptingExperience with backup/restore/migration tools (BCP, DMS, DMA, bacpac)Must be a US CitizenAbility to obtain and maintain a Public Trust Clearance.Preferred Qualifications:Relevant and current industry certifications such as MVP, MCP, MCSA, MCDBA or MCSE are preferredExperience with other Database technologies such as Oracle, MySQL, PostgreSQL, and public cloud offerings such as RDS and Azure SQL is preferredExperience with Firewalls and network IP, ports, TCP, UDR and CIDRExperience with PowerShell and CLIExperience with Linux operating systems, mysqldump, pg_dumpExperience with Microsoft SQL Server Migration Assistant for Oracle (SSMA)Understanding of ITIL principle and processBenefits:At Peraton, our benefits are designed to help keep you at your best beyond the work you do with us daily. We're fully committed to the growth of our employees. From fully comprehensive medical plans to tuition reimbursement, tuition assistance, and fertility treatment, we are there to support you all the way.#LI-ET1Peraton 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
$86,000 - $138,000. This represents the typical salary range for this position based on experience and other factors.
Job Locations
US
Requisition ID
2024-152359
Position Category
Information Technology
Clearance
Agency Clearance
Responsibilities
We are Hiring! We alre looking to ass a
Senior AWS SQL DBA.
This hired individual will be responsible for the design, implementation, configuration, maintenance, and performance of critical Database RDBMS systems, to ensure the availability and consistent performance customer enterprise applications. This is a "hands-on" position requiring deep technical skills, as well as excellent interpersonal and communication skills.What you will do:Design, Installation, Administration and Maintenance of SQL Server Instances in an On-Premise and multi-cloud environment (Azure and AWS)
Owns the strategic direction for the database topography within the solution offeringCreate Users and assign permissions based on the level of database accessDesign database backup and restore strategyDesign and build High-Availability as part of Disaster Recovery Strategy for the Databases (Failover Clustering, Always On, replication and log shipping) and SAN replicationConfiguring Azure/AWS Services PaaS/IaaS and migrate databases from on premise to Azure/AWSConfigure and maintain Azure SQL instances, Azure SQL Managed Instances and Azure SQL Elastic Pools, MySQL Flex, PostgreSQL FlexData refresh activities from production environments to non-production (development, test, QA, stage) environments and fixing orphan usersTroubleshoot various problems that arise in the day-to-day operations and fix the issuesMonitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning to include index optimizationsDatabase growth vs disk space available, audits, resource monitoring (I/O bottlenecks, memory pressure, CPU use)Monitor backups to ensure they are being performed regularlyRecover the databases to a specific point of timeProvide 24/7 on-call support on rotation basisQualifications
Required Qualifications:Bachelors Degree and 8 years of experience. Additional 4 years of experience maybe accepted in lieu of degree requirement.Must have Microsoft SQL Server DBA experience.Must have Microsoft Azure and Amazon AWS experienceMust have SSIS / SSAS / SSRS experienceExperience with T-SQL and scriptingExperience with backup/restore/migration tools (BCP, DMS, DMA, bacpac)Must be a US CitizenAbility to obtain and maintain a Public Trust Clearance.Preferred Qualifications:Relevant and current industry certifications such as MVP, MCP, MCSA, MCDBA or MCSE are preferredExperience with other Database technologies such as Oracle, MySQL, PostgreSQL, and public cloud offerings such as RDS and Azure SQL is preferredExperience with Firewalls and network IP, ports, TCP, UDR and CIDRExperience with PowerShell and CLIExperience with Linux operating systems, mysqldump, pg_dumpExperience with Microsoft SQL Server Migration Assistant for Oracle (SSMA)Understanding of ITIL principle and processBenefits:At Peraton, our benefits are designed to help keep you at your best beyond the work you do with us daily. We're fully committed to the growth of our employees. From fully comprehensive medical plans to tuition reimbursement, tuition assistance, and fertility treatment, we are there to support you all the way.#LI-ET1Peraton 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
$86,000 - $138,000. This represents the typical salary range for this position based on experience and other factors.