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
Understand the source data components and how they integrate with each other which might be both relational and dimensional
Interact with the end-users and business leaders to understand business needs
Provide technical guidance to end-user to best address business functional requirements
Knowledge of Visual Studio 2008 and Team Foundation Server (TFS)
This position REQUIRES applicants to be Those authorized to work in the United States without sponsorship are encouraged to apply.s due to DoD restrictions.
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.
Serves as point of contact with technical peers for the resolution of infrastructure-related issues.
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