Sr. Database Administrator

4 weeks ago

Warrendale, United States Vector Security and Vector Security Networks Full time
At Vector Security We Think Big, Do the Right Thing, and Make a Difference Every Day If this is how you like to work, wed like to invite you to join our team as a Sr. Database Administrator

We offer great benefits, a competitive salary, and growth opportunities. We think youll find what you want here because what we do matters - to us, our customers, and most of all, our team members.

Location: Warrendale, PA - HYBRID

Summary:

This position is responsible for creating, maintaining, and supporting our backend data sources that support BI analytics, Azure Synapse workspaces and D365 SSRS Reports. This person will be expected to contribute to the overall strategic roadmap including, but not limited to, the architecture for the Azure Data Lake and external pipelines, our Operational Data Store, and oversight to all the data connections in our platform. This position will need to provide advisement and execute database maintenance tasks on existing servers as it relates to replication needs, security, and overall data integrity. This role will also ultimately lead efforts to archive and decommission legacy data and their originating databases.

What You'll Do:

  • Data Strategy and Defining Architecture:
    • As we evolve our overall footprint and platform there is intent to utilize the Azure synapse workspaces, inclusion of Azure data factory as needed, and the overall adoption of the Microsoft Fabric product as it evolves to enable continuous growth in Analytics.
    • This role will play a critical part of researching and recommending growth phases that balance stability with our end-user analytical goals.
    • This will also include a lead role in the designs for our archive strategy for storing legacy data systems.
  • BI Reporting Data View Design:
    • Design and create the data structures and underlying data models required to pull data from multiple sources blending live data feeds with legacy data archives.
    • Creation of Data Lake views and Semantic Models will serve as the single source of truth for all internal and external reports.
    • This responsibility will include creation and tuning of complex SQL queries.
  • SSRS Support, Creation and Maintenance:
    • With the implementation of our D365 footprint there are embedded SSRS Reports, primarily in the financial space, which this role will maintain, enhance and develop new based on business requirements.
    • This role will also inherit installation, configuration and maintenance of existing SQL Server stack including SSRS, SSAS, and SSIS until such platform is superseded.
  • Maintenance of Legacy Systems:
    • During the transition, this role will retain ownership of certain production related tasks regarding Database maintenance and data investigation resulting from support or legal inquiries.
    • This role will work closely with the infrastructure team to maintain stable data environments, including Always on Availability Groups and Mirroring for servers on SQL 2014 and higher and Windows Operating Systems.
    • This role will align with Cyber Team to ensure standard practices, testing, and security principles are being adopted and enforced within database environments.
    • This role will assume a lead role in executing against the above-mentioned data archive and server ramp down activities as our transformation project evolves.
What You'll Need:
  • Education:
    • BS in Computer Science, Data Science or Information Technology preferred, and/or a minimum of 5-7 years in data or report driven role.
  • Knowledge
  • Language Skills:
    • Ability to read and interpret documents, procedure manuals, and safety rules.
  • Mathematics Skills:
    • Ability to add and subtract two-digit numbers and to multiply and divide with 10s and 100s.
  • Reasoning Ability:
    • Ability to apply common sense understanding to carry out instructions in both written form and received through verbal communications.
    • Ability to think analytically to define requirements and translate to final solution design.
    • Ability to accurately understand, spell, and type words and numbers.
  • Technical SQL Experience:
    • SQL Knowledge and experience working with Relational databases, and an ability to read, write and troubleshoot basic SQL Queries.
    • Advanced SQL knowledge and experience with performance tuning.
    • Exposure to any of the D365 modules would be a plus.
  • Work Ethic:
    • This position requires the mind-set to continue to evolve and learn new technologies, as well as organizational and time management skills to thrive in a fast-paced environment.
  • Team Dynamics:
    • This role will require the ability to work independently as well as be able to collaborate in a team environment.
What You'll Get:

In addition to competitive pay, we offer a comprehensive Total Rewards package including:
  • Medical, dental, and vision coverage
  • HSA/FSA programs
  • Company paid life and AD&D insurance.
  • Company paid short- and long-term disability.
  • Voluntary benefit products
  • 401k retirement savings plan after just 60 days
  • 7 Company Holidays, plus 2 Floating holidays of your choice
  • Paid Time Off
  • Tuition reimbursement
  • Employee Assistance Program (EAP)
  • On site gym and cafeteria
  • Free Parking
About Us:

We are the fourth largest security integrator in the country and have proudly been installing innovative security and smart automation solutions in homes and businesses for more than 50 years. Our purpose is to make our world more secure, connected, and empowered, one customer at a time.

Our Values:
  • Win as a team.
  • Do the right thing.
  • Make a difference every day.
  • Get it done
  • Think big.
  • Win as a team.
  • Do the right thing.
  • Make a difference every day.
  • Get it done
  • Think big.


If you share these ideals, we'd love to hear from you

Vector Security is a Drug-Free Workplace

Vector Security is an Equal Opportunity Employer

All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, transgender, national origin, veteran, or disability status.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

  • Sr. Database Administrator

    1 month ago

    Warrendale, United States Vector Security, Inc. Full time

    Job DescriptionJob DescriptionAt Vector Security We Think Big, Do the Right Thing, and Make a Difference Every Day! If this is how you like to work, we’d like to invite you to join our team as a Sr. Database Administrator!We offer great benefits, a competitive salary, and growth opportunities. We think you’ll find what you want here because what we do...

  • Sr. Database Administrator

    3 weeks ago

    Warrendale, United States Vector Security, Inc. Full time

    Job DescriptionJob DescriptionAt Vector Security We Think Big, Do the Right Thing, and Make a Difference Every Day! If this is how you like to work, we’d like to invite you to join our team as a Sr. Database Administrator!We offer great benefits, a competitive salary, and growth opportunities. We think you’ll find what you want here because what we do...

  • Sr. System Administrator

    2 weeks ago

    Warrendale, United States Pyramid Consulting Group Full time

    Skills Required: Experience working with information technology, with a strong background in Windows system administration. The candidate should have a strong understanding of Windows Security to assist in vulnerability remediation (ex: Operating System support for applications, such as File Transfer based applications, Service Account Ownership...

  • Sr. Tax Accountant

    4 weeks ago

    Warrendale, United States OpenArc Full time

    OpenArc - Empowering Your Career. As a leading IT staffing firm, we are dedicated to connecting talented professionals with your ideal opportunities. We are currently seeking a qualified Sr. Tax Accountant to join our client’s organization and contribute to their ongoing success. Responsibilities: • Prepare annual individual and business income tax...

  • Sr. Tax Accountant

    4 weeks ago

    Warrendale, United States OpenArc Full time

    OpenArc - Empowering Your Career. As a leading IT staffing firm, we are dedicated to connecting talented professionals with your ideal opportunities. We are currently seeking a qualified Sr. Tax Accountant to join our client’s organization and contribute to their ongoing success. Responsibilities: • Prepare annual individual and business income tax...

  • Sr. Tax Accountant

    3 weeks ago

    Warrendale, United States OpenArc Full time

    OpenArc - Empowering Your Career. As a leading IT staffing firm, we are dedicated to connecting talented professionals with your ideal opportunities. We are currently seeking a qualified Sr. Tax Accountant to join our client’s organization and contribute to their ongoing success. Apply promptly! A high volume of applicants is expected for the role as...

  • Senior Salesforce Administrator

    2 days ago

    Warrendale, United States Fullsight Full time

    JOB SUMMARY The Senior Salesforce Administrator will be responsible for managing and optimizing our Salesforce instance, be the "face" and the champion of the Sales & Marketing CRM (Customer Relationship Management) platform to the non-technical parts of our organization, de-risks the environment, and builds the guardrails that take the fear of making...

  • Marketing Administrator

    4 weeks ago

    Warrendale, United States Eclipse Construction Management, LP Full time

    Job DescriptionJob DescriptionSalary: For over 50 years, families have come to depend on Eddy Homes to build their dream homes. As a family-owned and operated business, we are privileged to have a hand in the vibrant communities where families work, play, and grow together. We have grown immensely to become a renown builder of luxury homes—estate,...

  • Marketing Administrator

    1 month ago

    Warrendale, United States Eclipse Construction Management, LP Full time

    Job DescriptionJob DescriptionSalary: For over 50 years, families have come to depend on Eddy Homes to build their dream homes. As a family-owned and operated business, we are privileged to have a hand in the vibrant communities where families work, play, and grow together. We have grown immensely to become a renown builder of luxury homes—estate,...

  • Procurement Operations Analyst

    1 month ago

    Warrendale, United States Vector Security, Inc. Full time

    Job DescriptionJob DescriptionAt Vector Security We Think Big, Do the Right Thing, and Make a Difference Every Day! If this is how you like to work, we’d like to invite you to join our team as our Procurement Operations Analyst!We offer great benefits, a competitive salary, and growth opportunities. If you want this to have a HYBRID schedule (in the...

  • Procurement Operations Analyst

    6 days ago

    Warrendale, United States Vector Security, Inc. Full time

    Job DescriptionJob DescriptionAt Vector Security We Think Big, Do the Right Thing, and Make a Difference Every Day! If this is how you like to work, we’d like to invite you to join our team as our Procurement Operations Analyst!We offer great benefits, a competitive salary, and growth opportunities. If you want this to have a HYBRID schedule (in the...

  • Procurement Operations Analyst

    2 weeks ago

    Warrendale, United States Vector Security, Inc. Full time

    Job DescriptionJob DescriptionAt Vector Security We Think Big, Do the Right Thing, and Make a Difference Every Day! If this is how you like to work, we’d like to invite you to join our team as our Procurement Operations Analyst!We offer great benefits, a competitive salary, and growth opportunities. If you want this to have a HYBRID schedule (in the...

  • Procurement Operations Analyst

    5 days ago

    Warrendale, United States Vector Security, Inc. Full time

    Job DescriptionJob DescriptionAt Vector Security We Think Big, Do the Right Thing, and Make a Difference Every Day! If this is how you like to work, we’d like to invite you to join our team as our Procurement Operations Analyst!We offer great benefits, a competitive salary, and growth opportunities. If you want this to have a HYBRID schedule (in the...

  • Office Assistant

    4 weeks ago

    Warrendale, United States AHN Healthcare Full time

    Job Title Office Assistant Location Warrendale, PA, USA Additional Location(s) Employee Type Employee Working Hours Per Week 40 Job Description Summary The Office Assistant is responsible for maintaining all AHN HH & H and keeping it in working order by providing daily support and assistance in the day-to-day operations of the office. This position will...

  • Office Assistant

    3 weeks ago

    Warrendale, Pennsylvania, United States AHN Healthcare Full time

    Job Title Office Assistant Location Warrendale, PA, USA Additional Location(s) Employee Type Employee Working Hours Per Week 40 Job Description Summary The Office Assistant is responsible for maintaining all AHN HH & H and keeping it in working order by providing daily support and assistance in the day-to-day operations of the office. This position will...