Job Listing

Lead Database Administrator


Posted: (posted 19012 days ago)View All Jobs
Industry:Business
Type:Full-Time
Location:Aiken, SC (Aiken County)
Company:Creative IT Solutions, LLC
Savannah River Site
Aiken, SC 29803
dnigov.com/Creative%20IT%20Solutions.html

Description:

Overview The Database Administrator is an expert in planning, design, implementation and managing of business-critical enterprise database technologies and cloud databases. They provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. The DBA performs day-to-day administration and operational support of database integrity including collecting and reporting performance data, outage data, review of log files and other monitoring. They participate in continual process improvements, in project planning, coordination and implementation. This position supports the Enterprise Information Services for Department of Energy (DOE) Savannah River Operations Office (DOE-SR) federal government staff and site contractors at the Savannah River Site (SRS) in Aiken SC. Responsibilities - Expert who is aware of all organization data sources - Manage database security roles - Install, configure and maintain SQL instances and security baselines - Install, upgrade and manage database applications (SSRS, SSIS, SSAS) - Diagnose and troubleshoot database errors, including after hours and weekends - Create and update databases and tables - Configure table indexes and relationships - Create and update stored procedures - Create, update, and manage reports, visualizations, and dashboards - Create automation for repeatable database tasks - Create and maintain documentation (Security baselines, Metadata Standards, Entity Relation Diagram (ERD), dataflow diagrams) - Configure and maintain SQL Server monitoring utilities - Monitor and tune performance of database systems - Perform back-up and restore operations - Testing back-ups on a monthly/quarterly frequency - Deploy database change scripts - Create and maintain a data dictionary - Annual database needs assessment - Perform database migrations and upgrades - Experience in SQL Server and Oracle - Work with C-Level/Director level customers in IT/Business to craft their Enterprise Architecture and IT Strategies - Experience leading client specific strategic engagements involving customer/partner teams - Migrate mission critical database environments from one platform to another - Work with high availability, disaster recovery and server tuning strategies including parameters, resources, contention, etc. - Write complex procedural language artifacts: PL/SQL, TSQL PL/PgSQL, stored procedures - Perform Shell/Perl/Python Scripting - Reports to the IT/Cyber Program Manager


Qualifications:

Qualifications - Requires 8 years of experience with BS/BA or 5 years with MS/MA or 3 years with PhD or 12 years of experience in lieu of degrees. - Q level or Top-Secret level security clearance preferred - Experience in SQL Server and Oracle - Experience with C-Level/Director level customers in IT/Business to craft their Enterprise Architecture and IT Strategies - Experience leading client specific strategic engagements involving customer/partner teams - Experience with migrating mission critical database environments from one platform to another - Experience working with high availability, disaster recovery and server tuning strategies including parameters, resources, contention, etc. - Experience in writing complex procedural language artifacts: PL/SQL, TSQL PL/PgSQL, stored procedures - Experience in Shell/Perl/Python Scripting - Industry certs a plus


To Apply:

https://careers-dneda.icims.com/jobs/1130/lead-database-administrator/job


View All Jobs

 Find More Jobs