Careers

LRS Consulting Services is seeking a Database Administrator to support a government customer in Mechanicsburg, PA. This is a 100% onsite direct-hire opportunity for a hands-on database professional who enjoys designing, optimizing, securing, and supporting enterprise database environments. The ideal candidate will bring experience with modern database technologies, Microsoft Azure, SQL development, automation, and Agile delivery practices.

Location: Mechanicsburg, PA (100% Onsite)

Responsibilities

• Design, develop, implement, and maintain databases supporting enterprise applications and mission-critical systems.
• Develop and manage database objects including stored procedures, functions, triggers, views, and other database components.
• Create and maintain logical and physical data models to ensure data integrity and consistency.
• Implement and maintain database security controls, including authentication, authorization, encryption, auditing, and access management.
• Monitor, troubleshoot, and optimize database performance through indexing, query tuning, and system configuration improvements.
• Create and maintain ERDs, data flow diagrams, technical specifications, and database documentation.
• Develop and execute database test plans, including unit, integration, performance, and validation testing.
• Collaborate with application developers, architects, and technical teams to build scalable database solutions.
• Develop and maintain backup, recovery, business continuity, and disaster recovery procedures.
• Perform data migrations, conversions, imports, exports, and ongoing database administration activities.
• Provision, configure, maintain, and decommission database environments.
• Support CI/CD pipeline automation for database deployments and change management activities.
• Maintain version control and support release management processes.
• Support production troubleshooting, root cause analysis, and incident resolution efforts.
• Participate in Agile ceremonies, technical reviews, quality assurance activities, and change control processes.

Qualifications

• Minimum 3+ years of experience in database design, development, administration, and support.
• CompTIA Security+ certification required.
• Experience working with Microsoft Azure.
• Experience participating in Agile development teams and applying Agile principles.
• Experience with one or more of the following:
  • Microsoft SQL Server
  • PostgreSQL
  • Other relational database management systems (RDBMS)
• Strong SQL development experience, including querying, data manipulation, and database administration.
• Experience with:
  • Database performance tuning
  • Query optimization
  • Indexing strategies
  • Backup and recovery procedures
  • Database security and compliance
  • Data migration and conversion
  • Database testing and validation
  • Data modeling and database architecture
• Experience with scripting and automation using PowerShell, Python, Bash, or similar tools.
• Familiarity with Cloud-Native Architectures, Infrastructure as Code (IaC), Configuration as Code (CaC), and Platform as a Service (PaaS).
• Experience using Azure DevOps.
• Strong troubleshooting, analytical, and problem-solving skills.
• Excellent written and verbal communication skills.

In some cases, LRS Consulting uses generative artificial intelligence (“AI”) in support of our hiring processes. LRS takes steps to ensure the use of AI does not result in discrimination based on protected class(es). AI may be used in the hiring process solely in support of the assessment of candidate qualifications. All decisions in the hiring process are made by LRS employees. If AI will be used in the hiring process for the position for which you are applying, you will be notified and will have the opportunity to opt out. If you have any questions, please contact us by clicking here.