SQL Server Database Administrator

Apex Systems; Pennsylvania; Remote; USD 100,000 - 140,000; Full time

Job summary

Apex Systems seeks a Senior Database Administrator responsible for SQL Server environments, conducting performance tuning, database creation, and maintaining access control. This remote position offers 24x7 on-call support and requires significant experience in managing large databases and ensuring availability solutions. Join a team that values innovation and continuous learning with a comprehensive benefits package.

Benefits

Medical, dental, vision insurance

401K with company match

Employee stock purchase program

Health Savings Account

Employee Assistance Program

On-demand training program and certification prep

Qualifications

• 10+ years' experience in SQL Server Database Administration.
• Experience with Always On Availability Groups (AOAG).
• Strong background in SQL Tuning and Performance Tuning.

Responsibilities

• Manage SQL Server Database Administration activities.
• Perform complex relational database management for applications.
• Develop database management skills and mentor junior DBAs.

Skills

SQL Server Administration

Database Performance Tuning

SQL Query Optimization

PowerShell Scripting

Database Security

Disaster Recovery Planning

Education

Bachelor’s Degree in Computer Science

Tools

SQL Server

SSIS

Commvault

Job description

We see you're coming in from Europe. Are you interested in a position with Apex Systems? Send us your information and resume or call us at our Cork office [phone]

Job#: 2077529

Job Description:

Apex Systems is looking for a Senior Database Administrator, who will support administration teams on both SQL Server Production and Development Environments including the troubleshooting and optimization of SQL queries and Stored Procedures. SQL Server DBA will be responsible for the development and maintenance of RDBMS platforms and database objects and with data access control supporting OLTP or analytic software applications on at least one major RDBMS platform. This role will have 24x7 on-call rotation and the SQL Server DBA will need to support on-call weekends.

Title: SQL Server Database Administrator

Location: 100% Remote (EST Hours)

Day to Day

• Assumes sole ownership of SQL Server Database Administration activities including creating databases and data objects and managing database access.
• Assists in evaluating DBA monitoring and productivity tools.
• Performs complex relational database management tasks for both development and production applications.
• Assists in database tuning when applicable.
• Identifies, documents, and tracks all database related performance problems assisting in their resolution.
• Performs tasks to develop database and data object creation scripts and to automate data management alerts.
• Collects data for Database monitoring metrics and reporting.
• Assists in developing, gathering data for and reporting of metrics.
• Develops database management skills and assists with the development of junior DBA’s.
• Works on projects of moderate to high complexity within one or more development environments.
• Works on multiple systems and RDBMS platforms as a project team member.

Requirements

• Bachelor’s Degree in Computer Science or related field of study desired along with 10+ years’ experience in the Administration of SQL Server Databases specializing in both Production & Development environments (extensive experience can replace degree requirement).
• 7+ years, post graduate experience as a SQL Server DBA in a shared services environment (i.e. environment where different teams manage various activities, including server management, database administration, network operations, storage, etc.)
• 7+ years of DBA experience in supporting application development teams in addition to production/operations including strong experience in installations & optimization.
• 5+ years’ experience with writing/authoring and optimizing SQL Queries and Stored Procedures.
• 5+ years of experience with SQL Tuning and Performance Tuning.
• 3+ years’ experience with SSIS for Extract, Transfer, Load (ETL) solutions.
• 2+ years of experience with Always On Availability Groups (AOAG).
• Experience with PowerShell scripting for automation.
• Experience with databases exceeding 30+ Terabytes.
• Experience with Backup/Restore technology such as Commvault or similar.
• Hands-on experience in database administration and T-SQL usage.
• Experience in large databases, supporting OLTP applications, and Replication technologies.
• Database security and auditing.
• Database architecture, including hardware configuration, logical and physical database layouts.
• Database management, monitoring of multiple databases.
• Database performance management and tuning.
• Database fault analysis and resolution.
• Database backup and disaster recovery procedures.

Application Delivery Lead

Apex Systems

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [e-mail] or 844-463-6178.

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Apex Benefits Overview:Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Apex team member can provide.