Find Jobs
Find Jobs Near You – Available Work in Your Location
Skip to job details
AS
Associates Systems LLC
Jr. SQL DBA- IAT levell II
Career Insights for SQL Server Database Administrator
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on Pennsylvania data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
A SQL Server Database Administrator administers SQL Server data systems and structures. Uses software applications and structured query language (SQL) procedures to store and organize data, such as an organization's records or financial information. Ensures that users can easily access the information they need and that data are protected from unauthorized access.
$105,166 / year median in Pennsylvania
-10% projected decline
Job Description
Job Requirements Philadelphia, PA Secret Polygraph Unspecified Early Career (2+ yrs experience) Salary not specified Join Premium to unlock estimated salaries Job Description Jr. SQL DBA
- IAT levell II
- Philadelphia, PA Information Technology This is a fulltime hybrid role 50/50 time split on site and WFH.
- Install, configure, administer, and maintain Microsoft SQL Server databases and other Database Management Systems (DBMS).
- Monitor database performance and perform routine maintenance to ensure optimal availability and reliability.
- Conduct database performance tuning, including query optimization and index maintenance.
- Perform and validate database backups, restores, and disaster recovery procedures.
- Monitor transaction logs, database health, storage utilization, and system performance.
- Assist in designing, implementing, and maintaining database security, permissions, and access controls.
- Develop, modify, and troubleshoot SQL queries, stored procedures, views, functions, and triggers.
- Support database replication and synchronization between SQL Servers and remote locations.
- Review database designs and recommend enhancements to improve performance, scalability, and reliability.
- Assist developers and system analysts in creating and maintaining SQL and web-based database applications.
- Maintain technical documentation, database standards, policies, and standard operating procedures (SOPs).
- Audit and update database records using SQL commands while ensuring data accuracy and integrity.
- Support database migration, patching, upgrades, and maintenance activities.
- Participate in database project planning and scheduling.
- Provide technical support for database-related incidents and troubleshoot production issues.
- Assist with Oracle database administration, monitoring, and daily health checks
- Support database backup, recovery, and Data Pump export/import operations
- Monitor database performance and assist with troubleshooting Oracle errors
- Create and maintain database users, roles, and privileges
- Perform schema refreshes between Production, Test, and Development environments
- Monitor tablespace usage, storage growth, and archive logs
- Write and maintain SQL and shell scripts for automation
- Support database security, auditing, and compliance requirements
- Maintain database documentation, SOPs, and operational runbooks
- Work with developers to troubleshoot database-related issues and support application deployments
- Participate in on-call support and maintenance windows as needed Requirements Minimum Qualifications Associate's degree in Computer Science, Information Technology, Information Systems, or a related field.
Desired Skills Microsoft SQL Server Administration SQL Development Database Performance Tuning Index Optimization Backup & Disaster Recovery Database Security & Permissions Stored Procedures & Triggers SQL Server Agent Database Replication Data Integrity Technical Documentation Problem Solving Team Collaboration Benefits:
Medical, Dental, Vision, Short/Long term disability, PTO, Holidays, Life Insurance #CJ group id: 10279492 Apply nowBenefits
- Paid Time Off (PTO)
- Health Insurance
- Dental Insurance
- Vision Insurance