Bachelor's Degree in Business Administration, Computer Science, Mathematics, and Engineering or related field with programming and database systems coursework or equivalent database administration experience.
5+ years as a SQL Database Administrator with progressively higher-level experience leading to a Senior Database Administrator role or equivalent
Experience with all facets of the SQL Server Services group: Database Services, Reporting services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Version 2008 R2 or higher.
Must have Senior SQL Data Warehousing Skills with the ability to gather requirements, architect Data Model, Dictionaries, data flows assisting with analytics and reporting.
Design and implement BI architectures based on the business, data and functional requirement
Develop, maintain, document and manage BI Solutions
Ensure solution designs address performance requirements, reusability, availability, integrity, security challenges, and business functional requirements
Responsible for the full life cycle of all Microsoft SQL data base platforms.
Plans, designs, develops, and maintains SQL databases in development, Quality Assurance, and production environments.
Reviews project requests and guides less experienced DBAs. Provides cost, design, and work estimates.
Designs, recommends and promotes implementation of required database structures.
Develops and applies procedures relating to database and application security.
Monitors access time performs validation checks and uses other methods to monitor and analyze database performance and ensures acceptable performance.
Develops and applies procedures for adhoc and regularly scheduled database backups and configures databases to support individual recovery models.
Provides database restores and advises on long term storage of backups.
Performs security related functions centered on NIST compliance including, automated scan reviews and remediation of vulnerabilities.
Identifies and advocates beneficial change opportunities.
Acts as a technical resource for application and data users, data administrators and others.
Must have advanced knowledge of database design, development, and maintenance practices and principles, with specific experience in Microsoft SQL 2008 R2 and higher.
Must have a strong knowledge of SQL Server database service, Integrations service and Reporting service, and should have a familiarity with SQL Analysis Service.
Must have advanced knowledge in database procedures, tools, and utilities for maintaining and optimizing databases; strong understanding of database structure, application servers, and application infrastructure.
Must be proficient with Microsoft Word, Excel, and Outlook. A familiarity with Oracle administration 11.202 or higher and Oracle Grid a plus.
Understanding and experience implementing NIST security standards is a plus.
DATA SCIENCE TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. DATA SCIENCE TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will DATA SCIENCE TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract