Database Administrator/Engineer

$81,250 - $146,875/Yr

Leidos - Gaithersburg, MD

posted 3 months ago

Full-time - Mid Level
Gaithersburg, MD
5,001-10,000 employees
Professional, Scientific, and Technical Services

About the position

At Leidos, we deliver innovative solutions through the efforts of our diverse and talented people who are dedicated to our customers' success. We empower our teams, contribute to our communities, and operate sustainably. Everything we do is built on a commitment to do the right thing for our customers, our people, and our community. Our Mission, Vision, and Values guide the way we do business. The Digital Modernization Sector at Leidos currently has an opening for a Database Administrator / Engineer to work in our Gaithersburg, MD office. This is an exciting opportunity to use your experience helping the FTC SNS mission. In this mission, we provide database, application software, and security solutions to Federal customers and their greater law enforcement community in the fight against consumer fraud, identity theft, and other do not call violations, supporting their consumer protection mission. The Database Administrator / Engineer will implement and maintain the smooth operation and physical design of databases. This includes reviewing database design and integration of systems, providing backup recovery, and making recommendations regarding enhancements and/or improvements. The role also involves maintaining security and integrity controls, formulating policies, procedures, and standards relating to database management, and monitoring transaction activity and utilization. Responsibilities include database loading, development and management of operational procedures, environment management, database health monitoring, resource planning, database upgrade planning, backup and recovery strategy planning and implementation, and environment transition planning (development, test, stage, production). Additionally, the role requires designing and developing scalable data pipeline processes necessary for collecting, cleansing, enriching, storing, and analyzing large volumes of data to support the program's data-driven initiatives. The candidate will perform database and system administration with SQL Server 2017 or later, MS SQL Reporting Services, SQL Analysis Services, and SQL Integration Services, including Windows 2016 or later with Active Directory, and Linux OS. Ensuring smooth 24x7 operation of production, staging, and test databases, including proactive and reactive responses, is essential. The candidate will also review database design and integration of systems, provide backup recovery, and make recommendations regarding enhancements and/or improvements while maintaining security and integrity controls.

Responsibilities

  • Implements and maintains smooth operation and physical design of databases.
  • Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements.
  • Maintains security and integrity controls.
  • Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
  • Responsibilities include database loading; development and management of operational procedures; environment management; database health monitoring; resource planning; database upgrade planning; backup and recovery strategy planning and implementation; environment transition planning (development, test, stage, production).
  • Designs and develops scalable data pipeline processes necessary for collecting, cleansing, enriching, storing, and analyzing large volumes of data to support program's data driven initiatives.
  • Performs database and system administration with SQL Server 2017 or later, MS SQL Reporting Services, SQL Analysis Services, and SQL Integration Services, including Windows 2016 or later with Active Directory, and Linux OS.
  • Ensures smooth 24x7 operation of production, staging, and test databases, including proactive and reactive responses.

Requirements

  • Bachelor's degree with a minimum of 4 years of experience, or years of professional experience with a related master's degree.
  • Ability to obtain a Public Trust clearance.
  • Strong skills in database design and architecture, including troubleshooting and optimizing database performance, profiling, and tuning SQL queries and stored procedures.
  • Ability to install and configure high-availability SQL servers, manage replication, partitioning, and scaling.
  • Experience in production database administration for SQL Server 2008R2 or later, particularly in web application hosting environments with database sizes over 500 GB.
  • Skilled in managing MS SQL Reporting Services and report development, as well as MS SQL jobs and ETL processes, including SQL Integration Services.
  • Expertise in MS SQL Analysis Services, Cube databases, and MDX queries, along with experience in SQL recovery through log-shipping and backups.
  • Experience with multiple cloud technologies, including AWS and Azure.
  • Familiarity with SQL and NoSQL databases such as DynamoDB, Cosmos DB, Azure SQL, PostgreSQL, and MySQL.
  • Experience with cloud-native Data Lakehouse solutions like Azure Synapse, Databricks, AWS Lakehouse, and Azure Fabric.
  • Proficient with cloud-based data engineering tools such as AWS Glue, Lambda functions, Azure Functions, ADF, and Synapse Pipeline.
  • Scripting skills with PowerShell and AWS/Azure CLIs.
  • Knowledge of cloud scalability, FinOps, and resource utilization control.

Nice-to-haves

  • Troubleshoot server network connectivity and RAID arrays; experience with Amazon Web Services and Azure cloud environments.
  • Manage SQL SSAS, Transparent Data Encryption.
  • Production experience with no-SQL technologies like Solr, Hadoop, Spark, Dynamo DB.
  • Maintain good relationships with Data Management Staff, clearly communicate issues and solutions to all stakeholders.
  • Maintain data security through access management and encryption.
  • Apply patches using an automated tool and manually, minimize system downtime.
  • Monitor availability, tune performance of data processing applications.
  • Participate in Web application troubleshooting.
  • Submit Configuration Change Board requests per LM procedures.
  • Participate in code deployment and configuration management.

Benefits

  • Health insurance
  • 401k
  • Paid holidays
  • Flexible scheduling
  • Professional development
  • Tuition reimbursement
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service