Senior Sql Database Administrator

SQL DBA , Tableau and Python developer

100% Remote

Long term 12+ Month

Job Description

Advanced SQL DBA skills with 5-7 yrs. experience to configure manage, maintain databases. Ensure high levels of performance, availability, sustainability, and security.
• Developer and Data Analyst and mining experience with administration skills in object creation such as Tables and Views, user defined functions, indexes, stored procedures, CTE’s, cursors and triggers using SQL.
• Worked on databases creating BD schema and executing SQL queries for validating data in different Databases. (MSSQL, PostgreSQL, MySQL etc.)
• Sound knowledge in creating Reports and Dashboards for Technical /Business analysis or Management using SQL server Reporting Services (SSRS).
• Extensive experience in working with Tableau Desktop, Tableau Server, Tableau Online and Tableau Public in various versions of Tableau.
• Extensive experience in Data visualization and Dashboarding on Tableau
• Generate periodic reporting on a daily, weekly, monthly or custom for technical assessment and management overview along with Trend reports.
• Create various types of charts Pie charts, bar charts, Line charts and other custom charts as needed.
• MS EXCEL: Experience in validating and Analyzing data in worksheets using Sorting, Filtering, VLOOKUP, creating PIVOT tables, Charts.
• Knowledge in at least one popular python libraries ( like NumPy, SciPy, Pandas, and matplotlib)
• Knowledge in at least one popular Python framework (like Django, Flask or Pyramid) is nice to know.
• Knowledge of object-relational mapping (ORM) and familiarity with front-end technologies (like JSON, GraphQL, Powershell etc. is good to know)
• Gather business requirements from stakeholders and develop data models accordingly.
• Intermediate knowledge of Cloud with experience in at least 18-24 months experience in coding and scripting
• Knowledge on Open Policy Agent (OPA) and Rego Language is a plus. Terraform/Ansible,
• Good time-management skills and a Team player

Certifications

Tableau and or SQL Certification is nice to have