Hello Professional,
Greetings,
Need a Senior SQL DBA Developer
Please share candidate having State Client Experience as well.
Visa – H1b and Eads only
Position: PDE OAIT: TAS3: TAS3 A4 SC2
Location: REMOTE
Client: Commonwealth of PA
Agency: PDE
Interview Type: In-Person
Position ID: 756651
Job Description:
- The General Government Delivery Centre (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 grants, 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 Non-public 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 migration 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
SKILL MATRIX: –
|
Skill
|
Required / Desired
|
Amount of Experience
|
|
Perform database management activities using Microsoft SQL Server 2016/2019
|
Required
|
|
|
Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts
|
Required
|
|
|
Assist with conversions from older SQL versions to current version
|
Required
|
|
|
Assist with database server infrastructure and software analysis and recommendations
|
Required
|
|
|
Help ensure databases are backed up appropriately and can be restored if necessary
|
Required
|
|
|
Maintain database access security and database integrity
|
Required
|
|
Regards,
Himanshu Shukla
Recruitment Associate
Flairsoft Limited
CMMi and ISO 9001 Certified
Office : 614-888-0700 Ext-245
Fax: 614-573-7255
www.flairsoft.net
We Deliver. You Succeed.
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer