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.
...Hiring semi-truck Owner Operators for Dry Van freight - 90% PAY ! We are seeking an OTR/Regional Owner Operator Semi-Truck Driver with... ...~ Minimum 23 years old. ~ Must own a truck with trailer (no company trucks available). ~ no day cabs, hotshots, box trucks or cargo...
...choosing your own schedule. We are looking for a proficient Web Developer to join our team to train our AI chatbots to code. You will... ...solves the problem. Benefits: This is a full-time or part-time REMOTE position Youll be able to choose which projects...
...The Centers for Advanced Orthopedics Robinwood Division 11110 Medical Campus Rd, Hagerstown, MD 21742, USA Job Title Position: Orthopedic X-Ray Technician/Medical Assistant License Requirements: Radiology technologist license in the State of Maryland Job Details...
...NorthPoint Fresh has what you're looking for! Job Summary: The Warehouse Supervisor organizes and oversees a warehouse department made... ..., safe, and productive onsite operations during your assigned shift. How we put you first: At NorthPoint Fresh we ask a lot...
...Key Responsibilities: Develop, test and maintain backend services and APIs using Node.js and TypeScript. Collaborate with frontend developers and blockchain engineers to ensure seamless integration with smart contracts and web applications. Work with databases...