Search for More Jobs
Forward this job to a friend
Apply by email without Registering
Apply by creating/using account
Please enter your registered email address, and we'll email you a link to reset your password right away.
Department of Health and Human Services
It is assumed that resumes will reflect quality of candidate. Unorganized and unprofessional resumes will be promptly disregarded. Resumes should be no more than 2 pages.
SCOPE OF THE PROJECT:
The position is focused on planning, developing, documenting & exchanging knowledge with onsite team using industry best practices. Typical work... These software solutions will primarily be centered on installing, configuring, and customizing one to many Microsoft SQL Servers. Migrating from SQL 2008 R2 to SQL 2012.
DAILY DUTIES / RESPONSIBILITIES:
Database Administrator will report to the DHHS Software Application Management Team, and will work with DHHS network engineers and technical staff. The position is focused on planning, developing, documenting & exchanging knowledge with onsite team using industry best practices.
Duties and responsibilities of the Database Administrator include performance of the following actions:
establishing the needs of users and monitoring user access and security;
monitoring performance and managing parameters to provide fast query responses to front-end users;
mapping out the conceptual design for a planned database in outline;
considering both back-end organization of data and front-end accessibility for end-users;
refining the logical design so that it can be translated into a specific data model;
further refining the physical design to meet system storage requirements;
installing and testing new versions of the DBMS;
maintaining data standards, experience with database hardening and administration in accordance with CIS, SCAP, NIST or SANS guidelines;
writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata);
controlling access permissions and privileges;
developing, managing and testing back-up and recovery plans;
ensuring that storage, archiving, back-up and recovery procedures are functioning correctly;
working closely with IT project managers, database programmers and Sharepoint developers;
communicating regularly with technical, applications and operational staff to ensure database integrity and security;
commissioning and installing new applications and customising existing applications in order to make them fit for purpose.
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
3+ years of experience in database development and support in MS SQL Server environments.
Expert experience in implementing operational automation.
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
SQL Development ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
Solid acquaintance with windows server, security delegation, SPNs, storage components.
Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
SQL Database Operational support to tech users
Bachelor's degree in Computer Science, Engineering, or equivalent experience required. Years of experience can substitute for formal education
CategoryNameRequiredImportanceLevelLast UsedExperienceAdministrativeTechnical WritingNo3Advanced
Database Platforms failover clusters Yes 1 Expert Currently Using
Database Platforms MS SQL Server 2008 enterprise server Yes 1 Expert Currently Using
Database Platforms MS SQL Server 2008 R2 Yes1 Expert Currently Using
Database Platforms MS SQL Server 2012 Yes 1 Expert Currently Using
Database Platforms SQL Server Analysis Services ( SSAS)Yes1
Database Platforms SQL Server Integration Services (SSIS) Yes 1
Database Platforms SQL Server tools: DMVs Yes 1
Database Platforms SQL Server tools: DTA Yes 1
Database Platforms SQL Server tools: PerfMon Yes 1
Database Platforms SQL Server tools: Profiler Yes 1
Database Platforms SQL Server tools: SAC Yes 1
Database Platforms SQL Server tools: SSCM Yes 1 Exper tCurrently Using
Database Platforms SQL Server tools: SSMS Yes 1
Database Platforms SQL Server tools: system sprocs Yes 1
Development Tools SQL Yes 1
Packaged Applications Business ObjectsNo3 Advanced
Specialties Microsoft Active Directory Yes 2 Advanced Within 6 Months
Apply by creating/using account