Video
No H1
Local
Hybrid
Please Note: Candidates must already be somewhat local to the Mechanicsburg PA area as this job is 100% onsite for first 6-weeks then hybrid (3 days in office/2 days remote).
Jr. SQL DBA - job responsibilities include:
• Designs, develops, and maintains database code objects, including coding for T-SQL, stored procedures and views in cooperation with application developers and in accordance with database standards and best practices.
• Designs, develops, and maintains database code scripts to validate or maintain data external to the application.
• Manages and performs detailed testing of database objects and scripts; performs code reviews.
• Writes and maintains specifications and documentation for database objects and scripts.
• Contributes to the design of the data model for application modifications/enhancements.
• Identifies T-SQL code performance issues and optimizes T-SQL code for performance.
• Participates (with a team of six) in an on-call weekly rotation to provide support for critical systems outside regular working hours.
• Performs lookup value and metadata entry and maintenance to support the application.
• Understands the administration screens and uses the application where appropriate.
• Performs user security change requests using in-house tools and template T-SQL scripts.
• Utilizes knowledge of T-SQL to perform application metadata and security maintenance activities.
• Performs testing of lookup values, metadata modifications, and application security for quality assurance.
• Performs metadata analysis to ensure the case management systems function properly.
• Monitors helpdesk ticket queues and prioritizes tasks based on severity and priority levels.
• Develops and implements data scripts using IDERA Rapid SQL for SAP ASE databases.
• Assists with maintaining procedural documentation for the metadata administration and application security tasks.
• Assists team members and training staff with the collection and implementation of metadata.
Required experience includes:
• 2+ years of SQL DBA experience
• Experience with T-SQL fundamentals.
• Bachelor's degree with an IT-related major or minor; OR Associate's degree with an IT-related major or minor and two years of experience in the IT area.
Location: Mechanicsburg, PA
Posted: Oct. 11, 2024, 4:29 p.m.
Apply Now Company Website