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