Senior Sql Database Administrator
Full time
at Aptonet Inc
in
Online
Posted on September 4, 2024
Job details
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
Apply safely
To stay safe in your job search, information on common scams and to get free expert advice, we recommend that you visit SAFERjobs, a non-profit, joint industry and law enforcement organization working to combat job scams.
