Job added in hotlist
Applied job
Contract job
90-day-old-job
part-time-job
Recruiter job
Employer job
Expanded search
Apply online not available
View more jobs in Baltimore, MD
View more jobs in Maryland

Job Details

Senior Microsoft SQL Server Database Administrator - Baltimore MD

Company name
Federal Staffing Resources LLC.

Location
Baltimore, MD, United States

Employment Type
Full-Time

Industry
Dba, It, Sql

Posted on
Jun 21,2019

Valid Through
Oct 04,2019

Apply for this job






Profile

Baltimore, MD, USA

Contract

Email Me Similar Jobs

Email Me This Job

Microsoft SQL Server Database Administrator

Database Management Specialist (Senior)

Required Experience:

At least five (5) years of experience with Microsoft SQL Server Database Administration

At least five (5) years of experience with Microsoft SQL programming including troubleshooting and investigating complex database issues

At least one (1) year of experience with Microsoft SQL Server High Availability

Responsibilities:

Ensure servers are current with SQL Server patches and security updates.

Analyze and evaluate the security procedures required for specific mission-critical business systems as defined by security standards.

Perform all database security checks and manage all database securities.

Create and implement plans for system security using a variety of technologies to provide data security and auditing functions for mission critical systems.

Maintain security and integrity of data access policies, standards, and methods by establishing database recovery plans to minimize data losses and system downtime. Develop backup routines for both the database management system software and the stored data.

Develop standardized application security procedures for applications and databases.

Create, maintain, and monitor Always on Availability Groups (AAG) for High Availability.

Maintain SQL Server test environment where upgrades and security patches can be tested.

Perform integration testing, create and restore server imaging, develop and implement plans to roll over enterprise wide systems from testing to production.

Install and upgrade SQL Server and other related software on specified hardware to provide functional capabilities for critical systems.

Create software and database maintenance plans for efficient upgrades and maintenance. Implement the plan and update this regularly.

Provide hardware and software specifications for various systems.

Coordinate database management system interfaces with other data processing units.

Review and approve or reject database designs for new systems.

Configure backup jobs to run on specified schedules.

Restore data files or tables from a previous backup session.

Develop and maintain scripts and perform and monitor backups for mission critical servers.

Work with vendors, developers, users, project managers and back up operators to troubleshoot database connectivity and back up issues.

Prepare and implement disaster recovery plans for various SQL Server based software systems.

Create and properly plan upgrade and migration schedules to minimize impact on production and mission critical systems.

Research, lab test, document and make recommendations to the Manager on new database technologies that could be implemented. Provide recommendations about the migration and upgrade paths for various systems.

Coordinate the installation and implementation of database management system software and related software tools with vendors, data processing staff and system users.

Develop and implement new database management policies, procedures and standards.

Collect data dictionary information on existing Microsoft Access 2003 databases.

Consolidate data from multiple sources (including standalone Microsoft Access databases) onto a centralized Microsoft SQL Server.

Develop and create new database solutions based on business unit requirements.

Conduct random health checks on the databases and prepare performance reports.

Assist System Administrators on database issues/errors and assist users and programmers with SQL queries and tuning.

Perform routine maintenance tasks for proactive monitoring on the database servers such as deleting log files and dump files or correcting errors.

Create repeatable processes to upgrade, test, and maintain databases and software systems. Monitor the systems to provide a minimum level of performance as part of Quality Assurance (QA).

Monitor database performance and make modifications and adjustments to database architecture, storage methods and management system software to fine-tune the database for optimum response time.

Prepare statistical and narrative reports of database management performance, activities and special projects.

Troubleshoot problems related to availability of data to system users, space, database software, data flow, and data storage and data access.

Migrate existing shared Microsoft Access data to Microsoft SQL Server and update existing Microsoft Access Databases to link to new data source.

Create, modify, and troubleshoot reports in Microsoft SQL Server Reporting Services.

Perform other duties as assigned.

Work Hours:

Business Hours Support: TO Contractor shall assign TO Contractor Personnel to support Department business hours (7:30 AM to 5:00 PM), Monday through Friday except for State holidays.

Duties:

Must be capable of providing highly technical expertise and support in the use of DBMS. Must be able to evaluate and recommend available DBMS products to support validated user requirements. Defines file organization, indexing methods, and security procedures for specific user applications. Develops, implements, and maintains database back-up and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.

Education:

A Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or three (3) years of equivalent experience in a related field.

General Experience:

Must have six (6) years of experience in DBMS systems analysis and programming.

Specialized Experience:

At least three (3) years of experience in using current DBMS technologies, application design utilizing various database management systems and experience with DBMS internals.

FSR

is nationwide, award winning, multi-industry workforce solution organization. FSR has grown from providing healthcare professionals to government healthcare facilities to providing talent acquisition, recruiting, and specialized human resources for the private and public sector.

FSR matches talented individuals to organizations to create mutually beneficial, sustainable partnerships. 

We invite you to join our team and grow with us!

FSR is a women-owned, minority, small business based out of Maryland. Ask about our Working Warriors Program. 

FSRpeople.com

FSR (Federal Staffing Resources)

https://fsrpeople.isolvedhire.com

Company info

Federal Staffing Resources LLC.
Website : https://fsrpeople.com/

Company Profile
Federal Staffing Resources is a minority woman-owned small business and a SBA 8(a) program participant. Federal Staffing Resources provides multi-disciplinary single call Professional and Allied Healthcare staffing services. Federal Staffing Resources has demonstrated sensitivity and expert understanding of the military medical environment.

Similar Jobs:
Senior Software Engineer Req #: 218068 Location: Columbia, MD US Job Category: Engineering Minimum Security Clearance: TS/SCI with Polygraph Job Description Job Description: Do you have a passion for innovation? So do we! At LGS o...
\n\nJob Description\nSYNOPSIS:\r\rThis individual will serve as the knowledge expert for all Phoenix Contact products directly associated with the protection, conversion, distribution and monitoring of power circuits primarily use...
Data Analytics SME
Location : Baltimore, MD
Clearance Level Must Currently Possess: No Active Clearance Required Clearance Level Must Be Able to Obtain: No Active Clearance Required Suitability: Public Trust Job Family: Solutions Architect Job Description: GDIT is ...