This position is for a Database Administrator supporting the General Government Delivery Center (GGDC). The role involves database management activities using Microsoft SQL Server 2016/2019, including installation, analysis, design, data correction, migration, performance monitoring, security maintenance, backup/recovery, and infrastructure support. This 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.
Location: Washington, District of Columbia, United States
Pennsylvania, United States
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 versions.
- 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.
- Execute all assigned responsibilities with little direct supervision.
- 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.
Required Skills & Certifications:
- Perform database management activities using Microsoft SQL Server 2016/2019 with 2 years of experience.
- Write and use SSIS (SQL Server Integration Services) and PowerShell Scripts with 2 years of experience.
- Assist with conversions from older SQL versions to current version with 2 years of experience.
- Assist with database server infrastructure and software analysis and recommendations with 2 years of experience.
- Help ensure databases are backed up appropriately and can be restored if necessary with 2 years of experience.
- Maintain database access security and database integrity with 2 years of experience.
Preferred Skills & Certifications:
- Not specified.
Special Considerations:
- Contractors are prohibited from taking or using government equipment outside of the United States. Violation results in immediate termination and ineligibility for rehire.
Scheduling:
- Not specified.
...Dairy Farm Herdsman (6193) Location: Pennsylvania JobNumber: 6193 Dairy Farm Herdsman position immediately available on a well established 100+ cow family owned dairy in west central Pennsylvania. Must have experience with mature cattle, new born calves and heifers...
...application takes no more than 5-7 minutes to complete. : Our Nurse Educators experience a unique opportunity to employ their clinical... ...oncology setting. This is a per-diem position, requiring travel regionally and nationally to support customer needs while...
...USA Job Location Type: Remote Job Contract Type: Full-time Job Seniority Level: Entry level Passionate about precision medicine and advancing the healthcare industry? Recent advancements in underlying technology have finally made it possible for...
...FLSA Status: Non-Exempt POSITION SUMMARY: The Ziggi's Coffee Shift Lead is responsible for assisting the General and Assistant... ...focus. Work Environment Works indoors in a standard coffee shop environment. EXPERIENCE & QUALIFICATIONS: Years of Experience...
...About Us: Join our passionate team at PBS campaign, where we are dedicated to making a real difference in the lives of Non Profit agencies. We believe every contribution counts, and as a Donation Drive Agent, you will play a key role in helping us reach our fundraising...