Database Administrator

2 weeks ago

Harrisburg, United States Pennsylvania Legislative Data Processing Center Full time

Title:IBM DB2 Database Administrator

Department: Legislative Data Processing Center, Distributed Systems Department

Reports to:Supervisor, Distributed Systems Department

Location:B48 Main Capitol, Harrisburg, PA

Office Hours: Monday Friday, 8:30am 5:00pm

Job Overview

The Legislative Data Processing Center (LDPC) provides bi-partisan operational and technical support for the Pennsylvania General Assembly.LDPC is seeking candidates for the Database Administrator role, providing oversight and using specialized knowledge and expertise to implement, maintain, monitor, and ensure performance of complex databases. This role is also responsible for critical Windows web and application servers, ensuring constant availability and high performance. Interested individuals should possess excellent technical skills and the ability to provide exceptional customer service.

Duties and Responsibilities

  • Create, develop, and review the physical model created from the logical model, ensuring that the detailed physical design of data structures and IBM DB2 databases complies with standards, guidelines and procedures recommended for all aspects of more complex data modeling, database design, and maintenance.
  • Provide support for application staff and business areas regarding more complex database implementations.
  • Establish automated monitoring mechanisms for space and database availability conditions. Establish best practices for database and application high availability through the use of third party technologies and through the exploitation of various database features.
  • Conduct root cause analysis to identify and resolve problems impacting more complex application and/or database availability and service levels.
  • Contact vendor support when necessary to facilitate application development and client problem resolution with optimum speed and efficiency.
  • Provide after hours and weekend support as required for on call responsibilities, database refreshes, testing, technology upgrades, and other off hour assignments.
  • Participates in establishing and maintaining technical standards, departmental procedures, and other technical documentation as required. Assure compliance to required Corporate standards, procedures, guidelines and processes, including audits.
  • Identify, develop, and provide technology training to the application developers of the organization (formal and informal) regarding database best practices.
  • Participate as assigned in the testing and recommendation of more complex tools and utilities to improve the effectiveness of managing and supporting the database environments.
  • Install, configure, maintain, and monitor web application servers.Test and patch as needed to ensure security and performance.
  • Responsible for maintaining documentation.
  • Assist in execution of business continuity planning, including preparation and execution of regular Disaster Recovery exercises.
  • Share in providing off-hour support as needed, including Session Coverage and monthly patching on weekends.
  • Assist with Data migration efforts in ongoing transition to Workday
  • Additional work duties may be assigned as needed.

Required Skills

  • Excellent attention to detail.Ability to think critically and provide careful, thoughtful analysis to provide a secure, highly available environment.
  • Excellent teamwork and interpersonal skills.
  • Demonstrated experience administrating a large, enterprise-level database (IBM DB2, Microsoft SQL Server, Oracle, etc).
  • Experience administrating Windows 2022 servers.
  • Experience administrating web servers, monitoring IIS.
  • Demonstrate strong analytical and problem-solving skills to accurately and efficiently identify, analyze, troubleshoot, and respond to complex problems while supporting clients and application developers.
  • Practical understanding of IP addressing basics (including DNS and DHCP).
  • Ability to prioritize and complete assignments independently, meet deadlines, and manage multiple changing priorities in a dynamic work environment.
  • Ability to be flexible and react appropriately to changing job assignments, work hours, work environments and work locations.
  • Consistently demonstrates a positive, supportive, and constructive attitude with both internal and external customers/peers in order to provide support.
  • Excellent written and verbal communication.
  • Self-motivated, task-driven, and able to quickly learn new skills.
  • Ability to write technical documentation.
  • Willing to work on weekends and/or evening hours as needed.

Education and Experience

Associates or Bachelors degree in information technology, computer science, or related field, with 2+ years relevant work experience; or satisfactory equivalent work experience in data analytics, database administration, systems administration, or related field.

Working Conditions and Environment

Expected to report to the office during normal business hours (8:30a-5pm).May be required to work beyond normal working hours as defined by the needs of the Center and General Assembly.Regular and punctual on-site attendance is an essential function of this position. This position is eligible for hybrid telework (2 days a week remote).

Compensation

Commensurate with experience.

  • Entry Level starting at $61,748
  • Mid-Level starting at $76,633

  • Database Administrator

    Found in: Appcast US C2 - 2 weeks ago

    Harrisburg, United States Pennsylvania Legislative Data Processing Center Full time

    Title: IBM DB2 Database AdministratorDepartment: Legislative Data Processing Center, Distributed Systems DepartmentReports to: Supervisor, Distributed Systems DepartmentLocation: B48 Main Capitol, Harrisburg, PAOffice Hours: Monday – Friday, 8:30am – 5:00pmJob OverviewThe Legislative Data Processing Center (LDPC) provides bi-partisan operational and...

  • Database Administrator

    Found in: Appcast Linkedin GBL C2 - 3 weeks ago

    Harrisburg, United States Pennsylvania Legislative Data Processing Center Full time

    Title: IBM DB2 Database AdministratorDepartment: Legislative Data Processing Center, Distributed Systems DepartmentReports to: Supervisor, Distributed Systems DepartmentLocation: B48 Main Capitol, Harrisburg, PAOffice Hours: Monday – Friday, 8:30am – 5:00pmJob OverviewThe Legislative Data Processing Center (LDPC) provides bi-partisan operational and...

  • LU- SQL Database Administrator

    2 weeks ago

    Harrisburg, United States Focused HR Solutions LLC Full time

    This position is currently remote, but may be moved to on site in Harrisburg, PA or hybrid in the future. - Candidate must work EST Business Hours ** Our direct client has an opening for SQL Database Administrator position # 709759. This position is for 6-12+ months, with option of extension, and will be worked in remotely at this time (must work EST...

  • Administrative Assistant

    4 days ago

    Harrisburg, United States SENATE OF PENNSYLVANIA Full time

    **Office**: Senate Republican Administrative Services Office **Title**: Administrative Assistant **Classification**: A1 **Salary**: $35,338 **Office Location**: Harrisburg **Office Hours**: 9:00-5:00 **Job description**: Administrative Assistants provide secretarial services to the members of the Republican Caucus and their staff. We provide services...

  • Oracle Developer

    Found in: Lensa US P 2 C2 - 3 hours ago

    Harrisburg, United States Crescens Full time

    Job Title: Oracle Developer Location: Harrisburg PA Duration: 4+ Months*Position will be mostly telework but must be able to commute to Harrisburg offices when needed*Job Description: This support includes, but is not necessarily limited to, the current hardware owned by the agency. This support includes, but is not limited to, the following software...

  • Senior Software Developer

    Found in: Lensa US P 2 C2 - 3 hours ago

    Harrisburg, United States N. Harris Computer Corporation Full time

    Senior Software Developer - R0024117 DESCRIPTION/RESPONSIBILITIES: Senior Software Developer Harris Local Government - Remote Harris Local Government (HLG) is one of the largest divisions within the Harris Computer organization. With 150 employees, 15 product lines and 6 offices across the east coast, HLG is committed to building a culture of doers who...

  • Data Specialist

    Found in: Lensa US P 2 C2 - 2 hours ago

    Harrisburg, United States Crescens Full time

    Job Title : Enterprise Data Office Location: Harrisburg PA Duration: 8+months Type: ContractJob Description: The Enterprise Data Office (EDO) is actively deploying an Enterprise Data Catalog solution across Commonwealth agencies. This position will be responsible for all tasks associated with the successful configuration, connection, and on-going scanning...

  • Business Analyst

    5 days ago

    Harrisburg, United States Pennsylvania Housing Finance Agency Full time

    The Pennsylvania Housing Finance Agency (PHFA) is growing! We have a Full-Time position available for a Business Analyst in our Headquarters Office in Harrisburg PA. **PHFA has a Hybrid work environment which consists of a few days in the office and at home during the pandemic.** **Job Purpose** The Business Analyst I shall be responsible for research and...

  • Surgery Scheduler- Colon Rectal Surgery

    5 hours ago

    Harrisburg, United States UPMC Full time

    **Join our team of Life Changers!** **UPMC is hiring a Full-Time, Surgery** **Scheduler** **to support the Colon Rectal office in Harrisburg.** **Excellent benefits, a pleasant work environment, and friendly team are just a few of our perks. Apply today!** **Shift is Mon.-Fri. between the hours of 7:00am- 5:00pm.** **Purpose:** Coordinate and...

  • Surgery Scheduler- Colon Rectal Surgery

    22 hours ago

    Harrisburg, United States University of Pittsburgh Medical Center Full time

    Join our team of Life Changers! UPMC is hiring a Full-Time, Surgery Scheduler to support the Colon Rectal office in Harrisburg. Excellent benefits, a pleasant work environment, and friendly team are just a few of our perks. Apply today! Shift is Mon.-Fri. between the hours of 7:00am- 5:00pm. Purpose: Coordinate and schedule patients for in-patient and...

  • Lead Application Analyst

    2 weeks ago

    Harrisburg, United States CareerBuilder Full time

    Primary Office Location: 30 Isabella Street. Pittsburgh, Pennsylvania. 15212. Join our team. Make a difference - for us and for your future. This position is primarily responsible for being the Lead Application Analyst for Actimize assigned projects and supports initiatives of high complexity and visibility using expert knowledge of business domain, banking...

  • IT Infrastructure Analyst

    5 days ago

    Harrisburg, United States Marriott Full time

    **Job Number** 24045862 **Job Category** Information Technology **Location** Frederick Data Center, 7300 Crestwood Blvd, Frederick, Maryland, United States **Schedule** Full-Time **Located Remotely?** Y **Relocation?** N **Position Type** Management **JOB SUMMARY** This position is responsible for the primary support, maintenance and system availability of...

  • Functional Analyst

    Found in: Lensa US P 2 C2 - 2 hours ago

    Harrisburg, United States Crescens Full time

    Job title : Functional Analyst / Architect Location: Harrisburg, PA Duration : 9+ months Type : ContractShort Description: Technical Business Analyst - proven experience in implementing complex technical projects with a large user base(300+ users) , providing fundamental technical support and hands on functional support with excellent verbal and written...

  • Senior Program Specialist, Topline Franchise Services

    1 week ago

    Harrisburg, United States Marriott Full time

    **Job Number** 24050850 **Job Category** Administrative **Location** Marriott International HQ, 7750 Wisconsin Avenue, Bethesda, Maryland, United States **Schedule** Full-Time **Located Remotely?** Y **Relocation?** N **Position Type** Management **JOB SUMMARY** Responsible for administering programs, or a portion of programs in support of achieving the...

  • STEAM Scholars

    Found in: Talent US C2 - 3 weeks ago

    Harrisburg, United States The Salvation Army Full time

    Overview : The STEAM Scholars Site Director (SSSD) will have administrative oversight of the STEAM Scholars program and staff with responsibility to lead and coordinate trainings for department staff. This position will plan, develop, write, administer, coordinate, and maintain the 21st CCLC grant-funded program that will serve the PA STEAM Academy...

  • Remote Director of Development and Alumni Relations

    Found in: beBee S US - 3 weeks ago

    Harrisburg, United States The American University of Paris Full time

    The Director of Development and Alumni Relations collaborates with all members of the Development and Alumni Relations team to ensure increased engagement amongst the 23,000+ alumni and other constituents of AUP and garners philanthropic investment in the priorities of AUP. Through organized and purposeful engagement, alumni add value to the existing...

  • Voter Registration Field Director

    7 days ago

    Harrisburg, United States The Outreach Team Full time

    Job DescriptionJob DescriptionField DirectorsThe Outreach Team is a field firm specializing in face-to-face canvassing operations. We fuel the nation's leading progressive groups to raise money and impact critical elections.We are currently seeking Field Directors to join us on an important and exciting campaign to help register voters in Pennsylvania....

  • Sr IT Security Analyst

    2 weeks ago

    Harrisburg, United States Mindteck Full time

    JOB PURPOSE AND SUMMARY This position is responsible for all aspects of information and network security within the Agency, including the administration of applicable security technologies, proactive monitoring of all information technology assets for potential security issues, identity and access management activities, as well as the application of security...

  • Sr IT Security Analyst

    Found in: Lensa US P 2 C2 - 3 hours ago

    Harrisburg, United States Mindteck Full time

    JOB PURPOSE AND SUMMARY This position is responsible for all aspects of information and network security within the Agency, including the administration of applicable security technologies, proactive monitoring of all information technology assets for potential security issues, identity and access management activities, as well as the application of security...

  • Call Center Agent

    Found in: Lensa US P 2 C2 - 1 hour ago

    Harrisburg, United States Dasher Services, Inc. Full time

    Job Title: Call Center Agent Job Summary: Dasher exists to help people live happy, healthy lives. Dasher's values center around providing encouragement, compassion, and support to our fellow team members, and paying those values forward when interacting with our clients and our community. The Call Center Agent provides customer service support specifically...