Current jobs related to Database Admin - King of Prussia - Colonial Electric Supply

  • Experienced Oracle Exadata Administrator Wanted

    1 week ago

    King of Prussia, Pennsylvania, United States Syntricate Technologies Full time

    Job Title:Oracle Exadata AdminJob Summary:We are seeking a highly skilled Oracle Exadata administrator to join our team at Syntricate Technologies. The ideal candidate will have experience in creating and managing EXACC instances, deploying databases, and monitoring Oracle Cloud services.Key Responsibilities: Creating and managing EXACC instances Deploying...

  • Compensation Data Analyst

    1 month ago

    King of Prussia, United States Liberty Personnel Services, Inc Full time

    Job DescriptionJob DescriptionCompensation Data Analyst Contract / contract to hire opportunity for a skills Excel Data Analyst. If you have the following, please contact me ASAP!Responsibilities:Calculate year-end bonuses and sales commissions accurately and efficiently.Analyze and interpret complex data sets to identify trends and patterns.Develop and...

  • Paralegal

    2 weeks ago

    King of Prussia, United States Liberty Personnel Services, Inc Full time

    Job DescriptionJob DescriptionOverview:The Paralegal will support attorneys by performing a variety of legal tasks, including legal research, document preparation, and case management.Responsibilities:Legal Research & AnalysisDocument PreparationCase ManagementDiscovery review and summarizationSupport litigation from commencement through trialClient...

  • Cloud Data Engineer

    2 weeks ago

    King of Prussia, Pennsylvania, United States Cyrten Full time

    Cloud Data Engineer - AWS DatabricksCyrten is seeking a highly skilled Cloud Data Engineer to join our team in designing and building large-scale solutions in an enterprise setting. The ideal candidate will have experience with Databricks, AWS, and cloud-based data platforms.Responsibilities:Design and build end-to-end automation to support and maintain...

  • Statistical Programmer

    4 weeks ago

    King of Prussia, Pennsylvania, United States NexPro Technologies Inc Full time

    Job Title: Statistical ProgrammerJob Summary:NexPro Technologies Inc is seeking a highly skilled Statistical Programmer to join our team. As a Statistical Programmer, you will be responsible for preparing study protocols and reports, conducting statistical analysis on clinical trial data, and generating randomization schedules.Key Responsibilities:Assist the...

  • Veterinarian - Relocation provided to Vacaville, California

    1 month ago

    City of Suisun City, United States National Veterinary Associates Full time

    Job DescriptionJob DescriptionRelocation to Call our brand new, start of the art facility home! Vacaville Animal Care Center is seeking an Associate Veterinarian to join our team in Vacaville, CA.Laughter is in the job description! You will quickly notice the warm, welcoming, and positive culture this team has cultivated. We have been a part of the...

  • Veterinarian - Relocation provided to Vacaville, California

    7 days ago

    City of Suisun City, United States National Veterinary Associates Full time

    Job DescriptionJob DescriptionRelocation to Call our brand new, start of the art facility home! Vacaville Animal Care Center is seeking an Associate Veterinarian to join our team in Vacaville, CA.Laughter is in the job description! You will quickly notice the warm, welcoming, and positive culture this team has cultivated. We have been a part of the...

  • Security Service Sales Executive

    1 month ago

    West Chester, Ohio, United States of America Johnson Controls Full time

    What you will do  Reporting within the Johnson Controls security business, directly to a Security Sales Manager, this role’s main focus is to secure Planned Service Agreements with new and existing customers. This role serves as the subject matter expert for video services and digital services, including proactive health, and more. The job...

  • Account Executive I

    2 weeks ago

    Evansville, Indiana, United States of America Johnson Controls Full time

    Build your best future with the Johnson Controls team!  As a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet.  Join a winning team that enables you to build your best future! Our teams are uniquely positioned to support a multitude of industries...

Database Admin

2 months ago

King of Prussia, United States Colonial Electric Supply Full time

Database Administrator (DBA)

King Of Prussia, PA, US | Full-Time, Remote Work (Onsite if Preferred)

Position Overview: We are seeking a skilled and detail-oriented Microsoft SQL Server Database Administrator (DBA) to manage, maintain, and optimize our database systems. The ideal candidate will have a strong background in database management, excellent problem-solving abilities, and a passion for ensuring the performance, integrity, and security of our data. You will be responsible for supervising and developing our Junior DBA / Reporting Engineer. Our environment is primarily MSSQL. No clusters, no Azure instances, no big data. Our largest tables are less than 50 million rows of data. We are in a constant state of change, which means in addition to the new concepts and requirements, there are things that are no longer being used. You will need to monitor table and stored procedure usage, and develop a plan to remove objects that are no longer in use.

You will be working closely with our software developers in order to achieve our business needs. Communication, documentation and diplomacy skills will be used on a daily basis. Our systems are in use 24/7, being able to react to issues outside of the 9 to 5 is essential.

Key Responsibilities:

  • Database Management:
    • Install and upgrade SQL Server installations.
    • Execute backups, restores, recovery models, and database maintenance tasks.
    • Review, approve, implement requests for new tables, stored procedures, triggers, indexes.
  • Performance Tuning and Optimization:
    • Monitor performance and troubleshoot problems to ensure database uptime.
    • Troubleshoot and resolve database integrity issues, blocking and deadlocking issues, connectivity issues, and security issues.
    • Address SQL Server related CPU, memory, I/O, disk space, and other resource contention issues.
    • Optimize SQL queries and database schemas for performance improvements using tools like Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
  • Security Management:
    • Implement and manage company data management and security practices and policies.
    • Ensure data integrity and consistency by implementing database constraints, triggers, and validation checks.
  • Development Support:
    • Assist with schema design, code review, and SQL query tuning.
    • Write and troubleshoot SQL code and designs, including stored procedures, functions, tables, views, triggers, indexes, and constraints.
    • Perform index maintenance and manage log shipping and/or database replication.
  • Reporting and Integration:
    • Develop, deploy, and support SSIS packages.
    • Develop and deploy SSRS reports.
    • Develop, deploy, and support SSAS cubes.
  • Collaboration and Guidance:
    • Provide guidance and support to Application Developers.
    • Work closely with developers, system administrators, and other IT professionals to design and implement database solutions that meet business needs.
  • Documentation:
    • Maintain comprehensive documentation for database configurations, processes, and procedures.
    • Prepare reports on database performance, incidents, and improvements.
Qualifications:
  • Education: Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
  • Experience: Proven experience as a Database Administrator or similar role, with hands-on experience in SQL Server. Familiarity with other database management systems is a plus.
  • Skills:
    • Strong proficiency in SQL and database management.
    • Experience with database backup and recovery techniques.
    • Knowledge of database design and normalization.
    • Understanding of performance tuning and optimization.
    • Experience with Performance Monitor, Redgate, and related tools.
    • Ability to develop, deploy, and support SSIS, SSRS, and SSAS/
  • Soft Skills: Excellent problem-solving abilities, attention to detail, and strong communication skills. Ability to work independently and as part of a team.

Certifications (optional but preferred): DBA certifications (Microsoft Certified Database Administrator, etc.) are a plus.