Database Developer Jobs in Pennsylvania

INTRODUCTION

Holman is a family-owned, global automotive services organization anchored by our deeply rooted core values and principles that have enabled us to continue Driving What’s Right throughout the last century. Our teams deliver the Holman Experience by treating our customers and each other as we would like to be treated, and creating positive, rewarding relationships all around.

The automotive markets Holman serves include fleet management and leasing; vehicle fabrication and upfitting; component manufacturing and productivity solutions; powertrain distribution and logistics services; commercial and personal insurance and risk management; and retail automotive sales as one of the largest privately owned dealership groups in the United States.

JOB RESPONSIBILITIES:

• Technical Leadership:
• Provide technical guidance and mentorship to the database development team.
• Design, develop, and optimize database systems to meet business requirements.
• Recommends improvements to the database architecture and design to enhance scalability, availability, and security.

• Collaborates with the DevOps team to automate database deployments and integrate with CI/CD pipelines

• Documentation:

• Create and maintain comprehensive documentation for database systems and processes.

• Innovation:

• Stay updated with the latest database technologies and best practices, and implement improvements as needed.

• Database development support: Focus on providing database development support which includes;

• Monitor and optimize database performance, ensuring high availability and reliability. Work closely with software developers, business analysts, and other stakeholders to integrate database solutions with applications
• Perform code reviews to support Database development
• Perform database deployments
• Optimize database queries and stored procedures for maximum efficiency and performance
• Develops complex SQL queries, stored procedures, functions, triggers, and views to support business logic and application functionality
• Performs data modeling, including designing schemas, tables, indexes, and relationships, for both transactional and analytical use cases
• Provides support for troubleshooting and resolving database-related issues reported by application teams

• Works closely with application developers to integrate database systems with applications and ensure efficient data flow

• Azure Cloud Database Management:

• Configures and manages Azure Databases, including automated backups, replication, and high-availability options
• Implements and manages database security, including encryption, access controls, and auditing, to meet industry standards and regulatory requirements.
• Ensures disaster recovery strategies are in place, including point-in-time restore and geo-replication for Azure SQL Database

• Stays current with Azure database services and industry trends, incorporating new features and best practices as appropriate

• General Database support:

• Provides off-hours support when required
• Provides on-site disaster recovery assistance when required
• Perform all other duties and special projects as assigned

EDUCATION AND/OR TRAINING:

- Bachelor’s degree in a related field or equivalent work experience
- Additional education, certifications, or other distinctions are a plus
- Proficient in various desktop tools including MS Office Programs (i.e. Outlook, Excel, Word, PowerPoint, Project, Visio, SharePoint etc.)
- Azure AZ900, DP900, DP-300 training required
- Azure certifications such as Microsoft Certified: Azure Database Administrator Associate or Azure Solutions Architect Expert are highly preferred

RELEVANT WORK EXPERIENCE:

- Minimum 5 years tenure as a Database Administrator Experienced with relational architecture and Data Warehouse
- Minimum 3 years' experience with installing, configuring, and supporting Oracle and/or SQL server database environments
- Experience with Azure SQL database environments.
- Understanding of Azure ecosystem and database services like Azure Blob Storage, Azure Data Lake, Azure Key Vault, etc.
- Must be well versed with database procedures to include: installation, configuration, backup and recovery, performance tuning, and SQL statement tuning
- Experience using ETL tools to document and move data as needed
- Experienced with Linux operating system and shell scripting
- Experienced with Windows Server operating systems
- Experienced with scripting languages and automation tools a plus (AI tools, Infrastructure as Code (IaC), Azure DevOps, PowerShell, and ARM templates)

BENEFITS:

At Holman, your total compensation goes beyond your paycheck. To position you for success and provide a rewarding career and better life for you and your family, Holman is proud to offer you the benefits you deserve; including protection against illness, disability, loss of work, or preparation for retirement. Below is a brief overview of the programs available to full-time employees (programs may vary by country or worker type):

• Health Insurance
• Vision Insurance
• Dental Insurance
• Life and Disability Insurance
• Flexible Spending and Health Savings Accounts
• Employee Assistance Program
• 401(k) plan with Company Match
• Paid Time Off (PTO)
• Paid Holidays, Bereavement, and Jury Duty
• Paid Pregnancy/Parental leave
• Paid Military Leave
• Tuition Reimbursement

We offer competitive wages that are commensurate with job-related skills, experience, relevant education or training, and geographic location, starting in the range of $105,050.00 - $149,700.00 USD annually for full time employees. The annual compensation range is comprised of base pay earnings.

EQUAL OPPORTUNITY EMPLOYMENT AND ACCOMMODATIONS:

Holman provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

If you are a person with a disability needing assistance with the application process, please contact HR@Holman.com

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.