SQL DBA

Position: SQL DBA

Location: San Diego CA (The position is hybrid 3 days a week and 2 days remote. It will be onsite 5 days a week the first 3 weeks and then after that it will be hybrid)

Duration: Contract to hire

Job Description

Responsibilities (95%)

• Design create maintain and manage Enterprise Data Warehouses (EDW) data lakes data marts data mining Operational Data Stores (ODS) Extract Transform Load (ETL) functions and solutions XML indexes TSQL and data manipulation scripts stored procedures views functions and forms.
• Create clear and relevant data dictionaries for all database efforts that include the following information for each functional data element: the logical data element name its definition that describes the meaning and the context of the data element in the system the domain of the data element (the allowable values) the data type length and unit of measure.
• Provide consulting services and technical support for database creation modification testing administration monitoring tuning backup and recovery; provides and clearly communicates about detailed project documentation.
• Ensure maximum use of SQL Server Integration Services (SSIS) and SQL Server reporting Services (SSRS) for the integration and delivery of information.
• Support of technical issues and solutions.
• Develop solutions to technical specifications and business requirements.
• Contribute to business process and workflow mapping.
• Attend stakeholder meetings to include preserving meeting records.