SQL Database Administrator

4 weeks ago

oak brook, United States PLS Financial Services, Inc. Full time

Why PLS? Because You Deserve Better ® PLS — which stands for People – Location – Service — is a leading retail provider of financial services. The “P” comes first, because our customers are at the center of everything we do, and we recognize that it’s our exceptional team members who go above and beyond every day. The PLS Group, headquartered in Chicago, is comprised of over 200 financial service centers in 12 states. Through our check cashing stores, we provide consumers with convenient financial products and services to help them manage their day-to-day financial needs. Although many of our customers have banking relationships, we believe that our customers use our financial services because they are convenient, transparent, and frequently more affordable than available traditional alternatives. PLS was founded in 1997 by Bob and Dan Wolfberg, who serve as Co-Presidents.


Position Overview:

We’re looking for a SQL Server Database Administrator SQL DBAs at PLS are responsible for the implementation, configuration, maintenance, and performance of all production database systems, ensuring the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as interpersonal and communication skills. This role will be responsible for the development and sustainment of the SQL Server environments (security, health, and performance), and will require an advanced knowledge of Windows Server OS, SQL Server, and security protocols for hardening the server and SQL environments. The SQL DBA will be heavily involved in auditing all database systems and will act as a technical liaison during project discussions. Must be capable of working independently and collaboratively.


Job Responsibilities:

  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
  • Maintain and test database backup and disaster recovery plans, procedures, and release of database changes according to agreed timescales and costs.
  • Analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Must be an expert in performance tuning.
  • Review and deploy database change scripts provided by third party vendors.
  • Proactively determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Document the company’s database environment.
  • Develop and implement database utilities and automated reporting.
  • Evaluate and recommend new database technologies.
  • Develop and deploy scripts and processes to automate administrative tasks.
  • Assist developers with complex query tuning and schema refinement.
  • Monitor, maintain and report capacity for data, index, log and backup files.
  • Recommend and implement table index and stored procedure changes based on usage patterns.
  • Proactively identify and resolve performance bottlenecks.
  • Proactively tune database queries for optimal performance
  • Identify interdependencies in system and application components.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Participate in an on-call rotation providing after hours on-call support.
  • Evaluate and recommend new database technologies.
  • Develop scripts and process to automate administrative tasks.
  • Monitor and maintain capacity for data, index, log, and backup files.
  • Recommend table index and stored procedure changes based on usage patterns.
  • Monitor database systems and their dependencies for availability.
  • Complete other duties as assigned.


Job Requirements:

  • 5+ years’ experience Microsoft SQL Server working with virtualized database servers via VMware and SAN storage.
  • 5+ Experience with Azure (IAAS, SAAS and PAAS) database solutions
  • 2+ years’ experience with NoSQL database solutions
  • Experience with SQL Server 2014 +
  • Practical experience in monitoring and managing MS SQL databases.
  • Experience tuning a database to provide a high availability service.
  • Proven ability to backup and when necessary, recover, databases.
  • SQL Server HA and / or Windows Clustering experience is mandatory
  • Strong SQL Server performance troubleshooting and tuning skills are necessary.
  • Ability to identify and analyze complex problems and reviewing related information to develop and evaluate options and implement solutions.
  • Ability to proactively identify opportunities for improvement of the computing environment.
  • Ability to understand and create complex SQL scripts as situations require.
  • Experience creating, managing, and monitoring SSIS packages.
  • Experience managing Report Server, SSRS Subscriptions and deployment
  • Must possess the ability to create complete and concise technical documentation.
  • Outstanding verbal, written and visual presentation skills with the ability to interact with all levels of the organization and work in a fast-paced environment.
  • Scripting experience with PowerShell or Python
  • Ability to organize and plan work independently.
  • Ability to work under pressure and in a fast-moving and constantly changing environment.
  • Ability to quickly pivot between Production activities and Development activities as the need arises.


Physical Requirements:

  • Must be able to sit and/or stand for long periods of time.


Benefits:

Benefits for eligible employees include medical/dental/vision, 401k, vacation, opportunities for advancement, on-going training available.


We strive to demonstrate our Core Values in all positions at PLS:

Communication ● Customer Focus ● Integrity and Trust ● Teamwork ● Results


PLS Financial Services is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, marital status, protected veteran status, or any other characteristic protected by law. PLS Financial Services is a drug-free workplace. PLS provides reasonable accommodations to applicants with disabilities. If you need a reasonable accommodation for any part of the application and hiring process, please notify your Recruiter or a member of our Human Resources team talentacquisition@PLS247.com to make arrangements. The decision on granting reasonable accommodation will be made on a case-by-case basis.


For jobs located in the City of Los Angeles, consistent with the requirements of the Fair Chance Initiative for Hiring Ordinance, qualified applicants with criminal histories will be considered for employment.

  • SQL Database Administrator

    4 weeks ago

    oak brook, United States PLS Financial Services, Inc. Full time

    Why PLS? Because You Deserve Better! ® PLS — which stands for People – Location – Service — is a leading retail provider of financial services. The “P” comes first, because our customers are at the center of everything we do, and we recognize that it’s our exceptional team members who go above and beyond every day. The PLS Group, headquartered...

  • SQL Database Administrator

    6 days ago

    Oak Brook, United States Pls Financial Services, Inc. Full time

    Overview Why PLS? Because You Deserve Better! ® PLS - which stands for People - Location - Service - is a leading retail provider of financial services. The "P" comes first, because our customers are at the center of everything we do, and we recognize that it's our exceptional team members who go above and beyond every day. The PLS Group, headquartered in...

  • SQL Database Administrator

    1 month ago

    Oak Brook, United States PLS Financial Services, Inc. Full time

    Why PLS? Because You Deserve Better! ® PLS — which stands for People – Location – Service — is a leading retail provider of financial services. The “P” comes first, because our customers are at the center of everything we do, and we recognize that it’s our exceptional team members who go above and beyond every day. The PLS Group, headquartered...

  • SQL Server Database Administrator

    4 weeks ago

    Oak Brook, Illinois, United States ReaderLink Full time

    Job Title: SQL Server Database AdministratorAbout the Role:We are seeking a highly skilled SQL Server Database Administrator to join our team at ReaderLink. As a key member of our IT Data Administration and Integration team, you will be responsible for the support and maintenance of our databases to ensure the security and integrity of our company data...

  • Database SQL Associate

    4 weeks ago

    Oak Lawn, Illinois, United States Advocate Aurora Health Full time

    Key Responsibilities:At Advocate Aurora Health, we expect our team members to adhere to the highest standards of customer service. As a SQL Database Associate, you will be responsible for performing all job duties under these strict guidelines.Your key responsibilities will include assisting patients and their families in obtaining accurate and relevant...

  • Database Administrator

    4 weeks ago

    Oak Ridge, Tennessee, United States Bechtel Corporation Full time

    Job Summary:In this role, you will be responsible for the day-to-day administration and maintenance of databases and applications. This includes performing installations, backup, and recovery, as well as working closely with managers on database capabilities and problems. You will play a critical role in ensuring databases are available, performing properly,...

  • Business Systems Analyst

    3 weeks ago

    Oak Brook, Illinois, United States JobGet Staffing Full time

    Job Summary: JobGet Staffing is seeking an experienced Business Systems Analyst to join our team. As a Business Systems Analyst, you will be responsible for analyzing programming changes and system enhancements, testing and verifying program changes, and developing system changes using RPGLE and SQL.Key Responsibilities:Analyze programming changes and system...

  • Administrative Support Specialist

    4 weeks ago

    Oak Brook, Illinois, United States CBRE Full time

    About the Role:We are seeking a highly organized and detail-oriented Administrative Support Specialist to join our team at CBRE. As a key member of our office, you will provide general administrative support to our sales professionals, including preparing proposals, presentations, and communications materials.Key Responsibilities:Collect and process...

  • Administrative Support Specialist

    4 weeks ago

    Oak Brook, Illinois, United States CBRE Full time

    About the Role:We are seeking a highly organized and detail-oriented Administrative Support Specialist to join our team at CBRE. As a key member of our office, you will provide general administrative support to our sales professionals, including preparing proposals, presentations, and communications materials.Key Responsibilities:Collect and process...

  • Senior Business Intelligence Analyst

    1 month ago

    Oak Brook, Illinois, United States Radiological Society of North America Full time

    Job OverviewWe are seeking a highly skilled Business Intelligence Quality Assurance Analyst to join our Agile Data Team at the Radiological Society of North America. As a key member of our team, you will be responsible for implementing quality assurance standards for our Agile Data Team in the Agile format.The ideal candidate will have a strong background in...

  • Data Quality Assurance Specialist

    4 weeks ago

    Oak Brook, Illinois, United States Radiological Society of North America Full time

    Job Summary:The Radiological Society of North America is seeking a highly skilled Data Quality Assurance Specialist to join our Agile Data Team. As a key member of our team, you will be responsible for implementing quality assurance standards for our data and reporting systems.Key Responsibilities: Determine business needs critical for quality assurance (QA)...

  • Data Entry Clerk

    4 weeks ago

    Oak Brook, Illinois, United States PSG Global Solutions Careers Full time

    At PSG Global Solutions Careers, we're seeking a skilled Data Entry Clerk to join our team. As a key member of our administrative support team, you'll play a vital role in ensuring the accuracy and efficiency of our data management processes.Enter data into computer systems using a variety of software applications, including databases and spreadsheets.Verify...

  • Application Developer

    4 weeks ago

    oak brook, United States PLS Financial Services, Inc. Full time

    PLS®: People. Location. Service PLS—which stands for People – Location – Service—is a leading retail provider of alternative financial services. The PLS Group, headquartered in Chicago, is comprised of over 200 financial service centers in 12 states. Through our check cashing stores, we provide consumers with convenient financial products and...

  • Application Developer

    6 months ago

    Oak Brook, United States PLS Financial Services, Inc. Full time

    PLS®: People. Location. Service PLS—which stands for People – Location – Service—is a leading retail provider of alternative financial services. The PLS Group, headquartered in Chicago, is comprised of over 200 financial service centers in 12 states. Through our check cashing stores, we provide consumers with convenient financial products and...

  • Business Systems Analyst

    3 weeks ago

    Oak Brook, United States JobGet Staffing Full time

    Title: Business Systems Analyst Department: Platform: CAREPosition Type: Exempt Hours per Week: 40Position SummaryWrites requirements for minor software development items and performs testing, in accordance with Company guidelines, client needs and legislative requirements."Position requires access to Personally Identifiable Information and/or Personal...

  • Data Steward

    1 week ago

    Oak Brook, United States BGSF Full time

    The Data Steward will lead efforts in establishing and executing data management disciplines, including data stewardship, metadata management, data quality, and data lineage. This position is responsible for managing, monitoring, and ensuring the integrity of data throughout the data lifecycle and collaborating with various teams to establish data standards,...

  • Data Steward

    1 week ago

    oak brook, United States BGSF Full time

    The Data Steward will lead efforts in establishing and executing data management disciplines, including data stewardship, metadata management, data quality, and data lineage. This position is responsible for managing, monitoring, and ensuring the integrity of data throughout the data lifecycle and collaborating with various teams to establish data standards,...

  • Software Engineer

    3 weeks ago

    Oak Brook, United States Streamline Healthcare Full time

    About Streamline Healthcare Solutions Here at Streamline, we strive on building lasting and trusting relationships with our clients, and our employees set the bar. Our mission is to build innovative technology solutions that empower people who improve behavioral health and quality of life of those in need. We are a high growth technology company that...

  • EHR Systems Administrator

    4 weeks ago

    Oak Ridge, Tennessee, United States Ridgeview Behavioral Health Services Full time

    Ridgeview Behavioral Health Services is seeking a skilled EHR Systems Administrator to join our team. As a key member of our IT department, you will be responsible for developing and maintaining reports, forms, and custom configurations within our EHR/EMR system.The ideal candidate will have a strong background in SQL, Microsoft SQL Server Management Studio,...

  • Senior Java Developer

    4 weeks ago

    Oak Brook, Illinois, United States Inspira Financial Full time

    Software Development RoleWe are seeking a skilled Senior Java Developer to join our team at Inspira Financial. As a key member of our software development team, you will be responsible for designing, developing, and maintaining scalable software solutions using Java and related technologies.Key ResponsibilitiesDesign and develop efficient and user-friendly...