1 day old

Database Administrator

Norfolk, VA 23510
Apply Now
Apply on the Company Site
Business Group Highlights

Defense

The Defense group supports the Department of Defense (DoD) mission to keep our homeland and its citizens safe. We provide solutions to improve the Nation's defense by providing software, systems engineering, IT, training and logistics and fleet management solutions.

Responsibilities

- Analysis and design of the Unified Data Platform, including data models for various business and operational requirements.

- Install, configure, harden, patch, upgrade, maintain and administer MSSQL 2016 instances

- Implement and administer Microsoft SQL Server databases within a multi-tiered environment.

- Adding or modifying system/user permissions to databases or database servers.

- Perform capacity planning, cluster set up, performance tuning and monitoring.

- Troubleshoot SQL DB slowness, Disk/Memory/CPU utilization and suggest resolutions.

- Analyze processing issues and data anomalies and identifying solutions.

- Work with infrastructure staff to ensure that needed system resources are allocated to the databases and to ensure high availability and optimal performance.

- Troubleshoot query slowness and find optimal indexes and explain plan for slow/heavy queries.

- Schedule and perform regular SQL DB maintenance operations according to workload pattern and usage of the SQL DB.

- Day-to-day operations and database administration of systems supported by the PaaS Operations team.

- Configure and maintain Microsoft SQL DB alerts for various system usage thresholds.

- Perform requested changes, updates and modifications to database structure and data.

- Perform database patches and upgrades without downtime.

- Implementing solutions for Microsoft SQL database backup and recovery infrastructure.

- Monitor/maintain/upgrade Microsoft SQL database and assist application team with performance tuning initiatives and builds.

- Technical support for MSSQL databases including responding to help desk tickets and working with customers to resolve issues

- Research and investigate problems and diagnose and provide resolution or viable solutions for hardware and software issues; appropriately escalate and report recommendations clearly and effectively to management and team

Qualifications

- US citizen - Secret clearance or ability to hold a Secret clearance. - BS 8-10, MS 6-8, PhD 3-5 - At least 5 years of enterprise data architecture experience

- At least 5 years of experience with Microsoft SQL Server

- At least 2years of public cloud (AWS, Azure, or GCP), ETL tools, and metadata repositories

- At least 2years working with high-availability systems

- 2+ years of experience working with automated build and continuous integration systems

- 5+ years of experience with Unix or Linux systems

- 2+ years of experience working with automated build and continuous integration systems

- 2+ years Power BI expertise

- Experience with SQL performance tuning.

- Experience with Postgresql and MongoDB is a plus

- Ability to design, install, configure, and secure Microsoft SQL Server 2016 in an Always On Clustered Mode.

- Strong technical knowledge of data integration tools, data modeling tools, metadata tools, and database design. ETL processes, BI analytics and development strategies.

- Knowledge of Microsoft SQL Server Stack (SSIS, SSRS, SSAS and Power BI)

- At least 3 years of experience with Relational such as Postgres, MySQL and NoSQL Technologies such as or MongoDB and data-warehousing products such as Snowflake or Redshift

About Perspecta

What matters to our nation, is what matters to us. At Perspecta, everything we do, from conducting innovative research to cultivating strong relationships, supports one imperative: ensuring that your work succeeds. Our company was formed to bring a broad array of capabilities to all parts of the public sectorfrom investigative services and IT strategy to systems work and next-generation engineering.

Our promise is simple: never stop solving our nations most complex challenges. And with a workforce of approximately 14,000, more than 48 percent of which is cleared, we have been trusted to just that, as a partner of choice across the entire sector.

Perspecta is an AA/EEO Employer - Minorities/Women/Veterans/Disabled and other protected categories.

Email this job to a friendRefer
Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed




As a government contractor, Perspecta abides by the following provision
PAY TRANSPARENCY NONDISCRIMINATION PROVISION
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Industry

  • Information Technology
Posted: 2020-03-28 Expires: 2020-04-28

With offerings in mission services, digital transformation and enterprise operations, our team of 14,000 engineers, analysts, investigators and architects work tirelessly to create innovative solutions. We have the expertise and experience not only to devise solutions, but to execute on them successfully.

Featured Job

Featured Employer

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Database Administrator

Perspecta
Norfolk, VA 23510

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast