Data Migration SSIS PowerShell Scripting Azure DevOps Written Communication Skills   Requirement id 140645 Job title Specialist Job location in Dauphin County, PA Skills required Database Management, Microsoft SQL Server, System Development Life Cycle, Data Migration SSIS PowerShell Scripting Open Date 04-May-2023 Close Date Job type Contract Duration 2 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Specialist: Database Management, Microsoft SQL Server, System Development Life Cycle, Data Migration SSIS PowerShell Scripting start date : 05/15/2023 End date : 06/30/2023 submission deadline : 04/28/2023 client info : PDE Description : The General Government Delivery Center (GGDC) is seeking a motivated and skilled SQL Server and Database Administrator for all PDE Applications/SQL Servers. This individual will need to work independently as assignments are given as well as in a team setting working with Database Administrators, Developers of various skill levels, and with Networking/Server teams. They will be responsible for Database Support as well as SQL Server Administration. This individual will be primary supporting eGrants, the Consolidated Financial Reporting System (CFRS), Education Data and Calculations (EDC), the Teacher Information Management System (TIMS), the Professional Education Record Management System (PERMS), the Nonpublic Information Management System (NPIS) databases, as well as the CFRS data mart and the PIMS PS Schema used for TIMS/PIMS reporting. This includes designing, implementing, and updating the physical structures as required; migrating, loading, and correcting data as required; monitoring and tuning database performance; ensuring data security and integrity. It also includes assisting with the administration of other databases as assigned. They will also serve as a backup for the chief of the database administration section when required. Responsibilities: • Perform database management activities using Microsoft SQL Server 2016/2019 • Install database software • Analyze, design, and review logical and physical data models • Support the application system development life cycle. • Perform data analysis and correction activities • Load data tables and perform data migrations from one database structure to another • Review and migrate stored procedures; recommend improvements to enhance performance • Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts • Follow and help enforce established PDE database standards. • Monitor database performance and space requirements and give recommendations to improve • Analyze and resolve database performance issues • Assist with conversions from older SQL versions to current version • Maintain database access security and database integrity • Help ensure databases are backed up appropriately and can be restored if necessary • Assist with database server infrastructure and software analysis and recommendations • Conduct work in a team environment • Use strong communication skills; both written and spoken • Determine time estimates and schedule for own work • Use Azure DevOps for source control, manage work items, for documentation versioning, and to report time spent on all assigned work item activities • Complete assigned work activities; Anticipate and resolve issues in a timely manner • Communicate accurate and useful status updates to the Database Administration Section Chief, and to each Application Lead analysts/project managers • Execute all assigned responsibilities with little direct supervision from the Database Administration Section Chief • Represent DBA staff at status meetings and other meetings as requested • Keep current with the features of new database releases and related database products and make recommendations as to their use • Make recommendations on best practices and improvements surrounding database administration practices Previous Experience with Education desired but not required   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 140645 while calling.   Other jobs in PA: Dauphin (1), Dauphin County (3), Downingtown (2), Glen Milla (1), Harribsurg (1), Harrisburg (47), Horsham (6), Malvern (2), Pennsylvania (13), Phila (2), Philadelphia (16), Pittsburgh (1), Radnor (2), Reading (1), Sharon (3), WAYNE (1), West Cheste (1), West Chester (33),    Database Management job openings in other states Jobs List TAX - Jr Software Tester/QA Analyst 2 (727768) Create date: 16-Jan-2024 Hybrid start date :01/29/2024 End date :01/31/2025 submission deadline :1/18/2024 client info : TAX Description : Virginia Tax seeks a qualified person who works well with team with 1- 2 years of experience in the following: .... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) IA-HHS-IDPH-DS3-Desktop Support (701058) Create date: 11-Jan-2023 Onsite Start date :01/30/2023 End Date :01/16/2024 Submission deadline :1/16/2023 Client Info :IDPH-Information Management: Department of Public Health Description : --------------------------------------------- NOTE: ***ONLY SUBMIT CANDIDATES WHO ARE CLEARED and WILLING TO WORK.... (This job is for - job Jobs in IA DesMoines Developer - (in Des Moines, IA)) PR63940-R5793 Customer Support Business Analyst -SP Create date: 23-Aug-2022 Bid URL: https://service.ariba.com/Supplier.aw/ad/collabReqDetail?requestDocId=30000000000000000999486901&anp=Ariba&community=3 Note: Online Submission Submission Deadline: 8/29/2022 Start Date: 9/5/2022 End Date : 6/30/2024 Client: Florida Department of Health (FDOH) Description: PU.... (This job is for - Jobs in FL Tallahassee Analyst - (in Tallahassee, FL)) Doc180103 RFQ 21/22-13 SAP Lead Developer -SP Create date: 25-Oct-2021 Bid URL: http://sourcing.myfloridamarketplace.com/Sourcing/Main/ad/webjumper?passwordadapter=SourcingSupplierUser&username=coolsoft1&itemID=hwfge5.fd&awcharset=UTF-8 Note: Contract Exhibit G - Resume Acknowledgement Form must be submitted. Submission Deadline: 11/3/2021 12:00 PM EST Start Date: 1/1/2022 End Date : 8.... (This job is for - job Jobs in FL Tallahassee Developer - (in Tallahassee, FL)) DHHS IT Enterprise Level DBA Architect/Developer (663152) Create date: 22-Sep-2021 Start Date :09/20/2021 End Date :05/05/2022 Submission Deadline :09/28/2021 Client Info : NCDHHS-AM Note : * Agency Interview Type: Either Webcam Interview or In Person Description : The NC DHHS IT Enterprise Level Database Architect/Developer will provide.... (This job is for - Maintainence Database Admin Jobs in NC Raleigh Developer - (in Raleigh, NC))    Database Management job openings in PA Jobs List Database Admin. -313916 - PDE Database Administrator-PEG Create date: 04-Feb-2013 [Note: Start Date: 01/22/13 End Date: 06/30/13] Description: The DBA will spend approximately 40% of the time managing the eGrants database. This includes updating the physical structure, monitoring and tuning the database for performance, reviewing or writing stored procedures, loading and correcting data as requ.... (This job is for - Sql Server 2000 SQL Server 2005 Jobs in PA Harrisburg Administrator - (in Harrisburg, PA)) (Specialist: Database Management, Microsoft SQL Server, System Development Life Cycle, Data Migration SSIS PowerShell Scripting in Dauphin County, PA)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)