Mid-Level SQL Server Database Administrator -52210

Syneren Technologies Corporation
Alexandria, United States of America
29 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Alexandria, United States of America

Tech stack

Microsoft Windows
Cluster Analysis
Computer Security
Databases
Data Warehousing
Database Security
Log Files
Microsoft SQL Server
Powershell
Raw Data
SQL Stored Procedures
SQL Databases
Virtualization Technology
System Availability
Indexer
Data Analytics
Data Management

Job description

We are looking for an eager and passionate Mid-level DBA to join our data management team and develop their skillset while helping us build out and maximize the performance of our customers data warehouse environment alongside a senior DBA. The ideal candidate is someone with an interest in developing, administering, and maintaining a high-performance database environment at the center of a data-driven organization., The Database Administrator will be responsible for providing daily maintenance and support for customer SQL database(s), including backup/restore/validations, writing and evaluating stored procedures and working with developers to implement customer initiatives. Responsibilities will include addressing escalations from the help desk and assisting with project deliverables as required. The position will be based in Alexandria, VA, * Work closely with the database administrator and data engineer to maintain our current environment and facilitate the development and migration of the new data warehouse infrastructure

  • Create databases, tables, views, stored procedures, and functions in response to the needs of the organization and business units
  • Create and maintain indexes, monitor their usage, and tune appropriately
  • Review and optimize SQL queries running against the databases to maximize their performance
  • Monitor and review the database and reporting environment, identify gaps and deficiencies, make recommendations on improvements
  • Monitor the state and functionality of storage infrastructure, such as data and log file sizes, backups, and raw data storage and archival
  • Maintain change management documentation to development and production environments
  • Create and schedule routine database maintenance packages and ensure they are running as expected
  • Identify performance and security optimization opportunities
  • Assists with delivering weekly metrics and stat reporting
  • Administers various SQL Server DBs (versions ranges from SQL 2000 up to SQL 2016), third party-and client developed
  • Reviews stored procedures and tables to ensure optimal performance
  • Ensures the safety and availability of data through backup and recovery/restore procedures
  • Creates stored procedures for recurring tasks
  • Research data issues and proposes/implements preventive actions
  • Assists in implementation and management of database security
  • Assists application developers in their database environments
  • Relies on instructions and pre-established guidelines to perform the functions of the job
  • Performs other duties as assigned/necessary
  • Writes documents and guidelines for tasks/projects as well as update existing documents as necessary

Requirements

Do you have experience in Writing skills?, * 5+ years of hands-on SQL Server experience utilizing DBA skills. Including but not limited to:

  • Installation of SQL Server
  • Upgrading and patching
  • Backup and restore of databases
  • Implementation of best practices
  • Security and login management
  • Troubleshooting via available tools (SQL and Windows error logs, job output, PowerShell, etc.)
  • Basic familiarity with SQL Server indexing and an overview of performance concepts.
  • Strong written and verbal communication skills to build and maintain positive relationships with team members and clients.
  • Interest in and demonstrated ability to pick up on new technology skills, especially with regards to SQL Server concepts (High Availability, Clustering, Virtualization, Performance, etc.)

Active Secret Clearance

IAT II Certification IAW DoD (For DoD IAT Level 2, you must have one of the following certifications - CCNA Security, CySA+, GICSP, GSEC, Security+ CE or CND: EC-Council's Certified Network Defender (CND)) or IAT III.

About the company

About Syneren: Syneren is an award winning, CMMI Level 3 certified, high quality provider of technology solutions for the government as well as commercial sectors. Founded in 2003, we have been broadening our services to cover an array of disciplines, including Hardware and Systems Engineering, Software Development and Testing, IT Systems Support, Cyber Security, Independent Testing and Evaluation and Program Support. Notably our innovative and effective solutions are delivered consistently by a highly qualified staff and management team. Syneren is committed to providing exceptional solutions that meet the client mission needs., Thank you for your interest in Syneren Technologies Corporation. Syneren Technologies Corporation is an Equal Opportunity/Affirmative Action Employer. This business uses E-Verify in its hiring practices to achieve a lawful workforce. E-Verify® is a registered trademark of the U.S. Department of Homeland Security. www.dhs.gov/E-Verify

Apply for this position