@Orchard | A Leading Provider of Technical Workforce Solutions

Database Administrator

Job Title
Database Administrator
Job ID
27380451
Location
Herndon,  VA
Other Location
Description

Job Title   Database Administrator

Job ID  27380451

Location   Newport News,  VA

Other Location    Herndon, VA

Description

Database Administrator

Newport News, VA or Herndon,VA

Secret Clearance required or the ability to obtain and hold a Secret Clearance 

 

Talent Orchard, LLC has been contracted by a top defense firm in their search for a Database Administrator professional for opportunities in Norfolk, VA or Herndon, VA 

 

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 2 years of public cloud (AWS, Azure, or GCP), ETL tools, and metadata repositories

- At least 2 years 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

 

Option 1: Create a New Profile