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