Are you a highly skilled and results-oriented SQL Database Administrator with a passion for optimizing critical systems and driving seamless data integration? Do you thrive in a collaborative environment where your expertise directly impacts the backbone of innovative logistics solutions? If so, this is an exceptional opportunity to join a dynamic and growing organization at the forefront of the 3PL industry.
Benefits:
- 401(k)
- 401(k) 6% Match
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
- Volunteer time off
location: Pittsburgh, Pennsylvania
job type: Permanent
salary: $95,000 - 105,000 per year
work hours: 9am to 5pm
education: Bachelors
responsibilities:
- Serve as a key owner of our SQL Server database environment, encompassing proactive maintenance, performance tuning, and capacity planning.
- Architect and implement robust backup and recovery strategies, ensuring business continuity and data integrity.
- Collaborate closely with application development teams to design, implement, and optimize database integrations for various business applications.
- Proactively identify, troubleshoot, and resolve complex database-related issues with speed and efficiency.
- Lead and execute database migrations, upgrades, and the application of necessary patches.
- Establish and maintain comprehensive documentation for database architecture, configurations, and operational procedures.
- Contribute to the design and implementation of APIs to facilitate seamless data exchange between diverse systems.
- Participate in application development efforts and provide support for data-driven applications.
qualifications:
- 5+ years of proven experience as a SQL Database Administrator, demonstrating a strong understanding of application and API development concepts.
- Deep proficiency in all aspects of SQL Server database management, including creation, maintenance, and optimization.
- Mastery of writing and debugging intricate SQL queries, stored procedures, functions, and triggers.
- Extensive experience in designing and implementing comprehensive backup and restore strategies.
- In-depth knowledge of SQL Server security best practices, including roles, permissions, and encryption.
- Expertise in performance tuning methodologies, including query optimization, index management, and execution plan analysis.
- Solid understanding of database schema design principles, normalization techniques, and partitioning strategies.
- Hands-on experience with high availability solutions such as SQL Server clustering, replication, log shipping, and Always On Availability Groups.
- Proven ability to develop, deploy, and troubleshoot ETL processes using SSIS.
- Experience in building and deploying reports using SSRS.
- Working proficiency in developing, testing, and deploying C# applications using .NET/.NET Core.
skills:
- Exceptional problem-solving and analytical skills with a meticulous attention to detail.
- Outstanding communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders.
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
