Job Description
Job Description
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 activit