Principal Software Engineer (SQL DBA)

JOB TITLE: Principal Software Engineer(SQL DBA)

DEPARTMENT: Software Development

REPORTS TO: Project Manager

PURPOSE:

We are seeking a Principal Software Engineer with 5-7 years of advanced SQL DBA experience to lead our database management efforts. In this role, you will configure, manage, and maintain high-performance databases (MSSQL, PostgreSQL, MySQL), while developing robust reports and dashboards using SQL Server Reporting Services (SSRS) and Tableau. You will also collaborate with stakeholders to gather requirements, create data models, and ensure data integrity. Your expertise in data visualization and analytical reporting will drive business insights and decision-making.

KEY RESPONSIBILTIES:

• Database Management Expertise: Utilize your advanced SQL DBA skills to configure, manage, and maintain databases, ensuring top-notch performance, availability, sustainability, and security.
• Development & Data Analysis: Apply your experience in data mining and development to create and administer SQL objects, including tables, views, user-defined functions, indexes, stored procedures, CTEs, cursors, and triggers across diverse databases (MSSQL, PostgreSQL, MySQL).
• Reporting & Dashboards: Leverage SQL Server Reporting Services (SSRS) to design insightful reports and dashboards for technical and business analysis, facilitating effective decision-making.
• Tableau Proficiency: Bring your extensive experience with Tableau (Desktop, Server, Online, Public) to the table, creating engaging data visualizations and dashboards that tell a compelling story.
• Data Visualization & Reporting: Generate periodic reports (daily, weekly, monthly) along with trend reports, and design various chart types (pie, bar, line, and custom charts) for comprehensive data representation.
• Excel Analysis Skills: Utilize MS Excel for data validation and analysis using techniques such as sorting, filtering, VLOOKUP, and creating pivot tables and charts.
• Python Knowledge: Familiarity with popular Python libraries (NumPy, SciPy, Pandas, Matplotlib) and frameworks (Django, Flask, or Pyramid) is essential for enhancing data processing capabilities.
• Business Collaboration: Gather requirements from stakeholders to develop tailored data models, ensuring alignment with business objectives.
• Cloud & Scripting Experience: Intermediate knowledge of cloud technologies and at least 18-24 months of experience in coding and scripting will be crucial in this role.
• Bonus Skills: Knowledge of Open Policy Agent (OPA) and Rego Language, along with familiarity with Terraform/Ansible, is a plus.

QUALIFICATIONS, SKILLS, AND EXPERIENCE:

• At least bachelor’s degree in Computer Science, Information Technology, Data/Business Analytics or any related discipline.
• 5-7 years in SQL DBA, data analysis, and development.
• Advanced SQL, data visualization, Python programming, and cloud computing knowledge.
• Tableau and/or SQL certification is desirable.
• Strong time-management skills and the ability to work collaboratively in a team-oriented environment.