drjobs Database Administrator

Database Administrator

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Harrisburg, PA - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Location: Harrisburg PA
Position Type: Hybrid 1 day per week onsite
Contract Length: 6month Right to Hire

Must be PA resident. Must be a US Citizen or Permanent Resident.

Position Overview:

This role provides technical support for database environments Microsoft SQL Server and PostgreSQL and supports the full system life cycle. This position performs at a moderate level of complexity with a high level of proficiency under general supervision. This position is part of a team of Database Administrators supporting multiple database technologies

Duties:
  • Maintain existing databases by investigating factors such as storage requirements access time input/output frequencies and unusual problems encountered by applications/systems analyst.
  • Perform moderately complex database design tasks related to the establishment of the structure of a database including analysis logical data model review and physical database design.
  • Maintain and manage database structure backup and recovery data propagation (replication) and performance monitoring/tuning.
  • Research recommend and implement new technologies skills and methods to proactively manage databases.
  • Determine table attributes primary and alternate keys for multiple databases.
  • Install and upgrade software to enhance database performance.
  • Monitor database activity and file usage.
  • Troubleshoot root cause of database issues and recommend solutions or workaround.
  • Implement database monitoring procedures to maximize availability and performance of the database.
  • Interact with Agency staff as necessary and appropriate to participate in and/or organize projects that are short/long term.
  • Collaborate with third party vendors to review installation prerequisites database sizing and support database installation of the product.
  • Collaborate with the infrastructure Administration groups to define and request database servers.
  • Database Administrator for projects of varying complexity.
  • Partner with other Information Technology (IT) personnel within the department units functional users and vendors to provide guidance manage project implementation or user support.
  • Participate and/or take a lead role with the infrastructure and database configurations changes and/or upgrades that are moderately complex in nature with a high level of proficiency.
  • Test and ensure that systems and databases are developed and implemented according to all published standards.
Required Skills:
  • Bachelors degree in computer science or related degree and two to five years of experience or any combination of experience training and abilities.
  • Familiar with standby clustering with replication in PostgreSQL
  • Familiar with data warehousing and understanding pg dump restore and managing data warehouse loads specifically for apps moving from DB2 to PostgreSQL.
  • Familiar with SQL Server Reporting Services (SSRS).
  • Familiar with Data Change Request (DCR).
  • Working knowledge and application of database concepts.
  • Competent skills to debug and dig deeply into one specific task to uncover root cause and provide solution(s).
  • Hands on experience with a Database Management System (DBMS).
  • Demonstrated intermediate experience in physical data modeling database design principals programming.
  • Track record analyzing moderately complex information to draw alternative conclusions.
  • Proven ability to learn and support new hardware software and operating systems and apply innovative business solutions.
  • Effective communication skills necessary to make yourself understood when speaking about complex technical subjects.
  • Demonstrated knowledge of development of a data strategy and associated policies.
  • Ability to plan and organize work around multiple responsibilities.

Required Experience:

Senior IC

Employment Type

Full-Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.