Skip to main content

This job has expired

SQL Database Administrator

Employer
ASM Research
Location
Chantilly, VA
Closing date
Oct 19, 2019
SQL Database Administrator Chantilly, VA As a SQL Database Admin, you will develop, test, or demonstrate databases for a large Windows .net system on MS SQL Server databases. Perform many related database functions across one or more teams or clients, including designing, implementing and maintaining new databases, backup/recovery and configuration management. Install MS SQL databases and products such as SSRS, SSAS, and SSIS and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance. You will be responsible for proactive monitoring, performance tuning, upgrades, and maintenance to help support the team's SLA of 99.9% system uptime. You will monitor and maintain a backup and recovery solution which includes both nightly backups to ensure zero data loss. You will provides database support by verifying databases associated with network tools and solutions function as required. Responsible for managing the routine operations and maintenance of databases and ensuring their reliable and efficient performance. Focuses on establishing the architecture, design, and security of various databases. Job Responsibilities Performs preventive and corrective maintenance and incident management measures. * Determines database structural requirements by working with business stakeholders, and identifying optimal database specifications. Ensures that database design and system capabilities meet validated user requirements. * Supports sequencing diagrams and process flow development, data profiling, data analysis, and logical and physical data modeling. * Evaluates the integration of new tools or technologies based on the capabilities of the existing infrastructure. * Creates advanced tests, develops complex databases, and tunes database performance, reviewing database performance trends and identifying opportunities for improvement. * Provides complex system maintenance support, ensuring that any system disruptions mandated by an upgrade or patch follow the necessary guidelines and approvals. * Responsible for planning the installation of operating systems, databases, applications, development upgrades, and new releases. * Plans and executes any needed upgrades to the software applications and ensures necessary licensing is maintained. * Establishes standards, controls and procedures to ensure data integrity and security. * Uses various databases and sources to research system vulnerabilities and potential security attacks. * Performs capacity planning and projection for future growth. * May provide supervision and input into performance appraisals for junior Database Administrators. Minimum Qualifications Bachelor's Degree in a related field of study. 5-10 years of related work experience. Minimum of 1 year of SQL DBA experience Minimum of 1 year of experience in shell scripting Minimum of 1 year of experience with SSRS, SSAS, and SSIS Other Job Specific Skills * Excellent attention to detail and analytical skills. * Advanced written and verbal communication skills. * Ability to multitask and work well under pressure. * Advanced knowledge of database backup and recovery strategies. * Experience with DBA productivity and performance tools. * Experience with DoD and Federal Government is strongly desired. * Advanced knowledge of security network and infrastructure tools, including access control and/or encryption. * In depth knowledge of troubleshooting skills and out of the box thinking to overcome data obstacles. * Ability to delegate/split tasks among a team. The main roles for the DBA lead and DBAs are: Overall Production DBs HealthOverall DB architectureSQL Cluster/HA MaintenancePerformance TuningSQL PatchingCapacity PlanningSecurity and AuditingServer User/Role ManagementSQL Upgrades and POCsDaily Server Health ChecksDeadlock/BlockingMajor DB Server Incident/Issue fixReplication, MDR,Linked Server Issues US Citizenship / Green Card Holders only Candidate must be eligible for Public Trust level clearance. #CJPost Req1517 PandoLogic. Keywords: Database Administrator (DBA), Location: Chantilly, VA - 20151

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert