Database Administrator

Found in: Appcast Linkedin GBL C2 - 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

Associate’s or Bachelor’s 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

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

  • LU- SQL Database Administrator

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

    15 hours 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...

  • Associate Media Coordinator Biller

    7 days ago

    Harrisburg, United States Abel Personnel Full time

    Job DescriptionJob DescriptionAssociate Media Coordinator BillerHarrisburg Media company looking for a dynamic Administrative Support Coordinator to support our marketing clients and handling the review of invoices, correspondence, project plans and ensuring accuracy of all client accounts with respect to the financials, timelines, and project plans. In...

  • Business Analyst

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

  • Lead Application Analyst

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

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

  • Senior Program Specialist, Topline Franchise Services

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

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

  • Voter Registration Field Director

    3 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

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

  • Marketing and Public Relations Coordinator

    1 week ago

    Harrisburg, United States Dauphin County Library System Full time

    The Marketing & Public Relations Coordinator supports the Community Relations Department team by writing engaging material to promote and inform the community of The Library’s events, materials, resources, and fundraising activities, as well as assists the Marketing & Public Relations Manager in diverse and creative marketing campaigns while providing...

  • Diversion Investigator

    2 days ago

    Harrisburg, United States U.S. Department of Justice Full time

    Summary TOUGH WORK. VITAL MISSION. Challenge yourself! You have the power to help combat drug trafficking. Be a part of DEA! It's tough work, but a vital mission. Whatever your background or expertise, your work at DEA will be tremendously rewarding because it will have a daily impact on national security and the quality of life of all Americans. This job...

  • Remote Director of Development and Alumni Relations

    Found in: beBee jobs US - 1 week ago

    Harrisburg, Pennsylvania, United States The American University of Paris Full time

    The Director of Development and Alumni Relations collaborateswith all members of the Development and Alumni Relations team toensure increased engagement amongst the 23,000+ alumni and otherconstituents of AUP and garners philanthropic investment in thepriorities of AUP.Through organized and purposeful engagement, alumni add value tothe existing resources...

  • Marketing and Public Relations Coordinator

    1 week ago

    Harrisburg, United States Dauphin County Library System Full time

    Job DescriptionJob DescriptionThe Marketing & Public Relations Coordinator supports the Community Relations Department team by writing engaging material to promote and inform the community of The Library’s events, materials, resources, and fundraising activities, as well as assists the Marketing & Public Relations Manager in diverse and creative marketing...

  • Call Center Agent

    1 week ago

    Harrisburg, United States Dasher Full time

    Job DescriptionJob DescriptionSalary: $16.00Job Title: Call Center AgentJob 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...

  • Marketing and Public Relations Coordinator

    45 minutes ago

    Harrisburg, United States Dauphin County Library System Full time

    Job DescriptionJob DescriptionThe Marketing & Public Relations Coordinator supports the Community Relations Department team by writing engaging material to promote and inform the community of The Library’s events, materials, resources, and fundraising activities, as well as assists the Marketing & Public Relations Manager in diverse and creative marketing...

  • Geospatial Analyst

    1 week ago

    Harrisburg, United States Commonwealth of Pennsylvania Full time

    Reference #: 4364487 THE POSITIONAre you adept at collecting, analyzing, and presenting geographic information system (GIS) data? The Pennsylvania Game Commission is looking to hire a Geospatial Analyst to work out of our Harrisburg Headquarters. Get involved with the entire System Development Life Cycle and work closely with the Technical Services and Data...