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 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

    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 Database Administrator

    1 week 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 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

    4 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...

  • 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

    1 month 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

    2 days 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...

  • Business Systems Analyst

    4 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

    2 weeks 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

    2 weeks 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...

  • Senior Java Developer

    1 month 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...

  • BOBJ Administrator Business Objects

    1 month ago

    Oak Park Heights, United States mavinsys Full time

    Hello We are from Mavinsys Talent Acquisition team based on One World Trade Centre New York. We are specializing in IT services and staffing majorly in lateral hiring/contract. Below is one of our requirement to fill immediately if youre interested please share your candidature to Job Title: BOBJ Administrator (Business Objects) Location: Oak Park...

  • BOBJ Administrator Business Objects

    4 weeks ago

    Oak Park Heights, United States mavinsys Full time

    Hello We are from Mavinsys Talent Acquisition team based on One World Trade Centre New York. We are specializing in IT services and staffing majorly in lateral hiring/contract. Below is one of our requirement to fill immediately if youre interested please share your candidature to Job Title: BOBJ Administrator (Business Objects) Location: Oak Park...

  • Data Modeler

    4 weeks ago

    Oak Park, United States New York Technology Partners Full time

    Job Title: Senior Data Modeler Preferred Location – Onsite –5909 Omaha Avenue, Oak Park Heights MN Required Skills : Database and SQL, Pstf-SQL Tuning, Logical Data modelling, Data Modelling, Data Build Tool, Snowflake SQL, Physical Data Modelling Job summary We are seeking a highly skilled Senior Data Modeler with 11 to 15 years of experience to join...