SQL Database Developer

Tokio Marine Hcc - Kennesaw, GA

Full-time - Mid Level

Kennesaw, GA

1,001-5,000 employees

Insurance Carriers and Related Activities

About the position

The SQL Database Developer at Tokio Marine HCC is responsible for designing, developing, implementing, and maintaining software solutions using SQL Server. This role involves writing and maintaining stored procedures, functions, and queries to assist the organization in accessing and analyzing business data. The developer will also maintain SSAS cubes and create relational and cube reports, ensuring data integrity and performance optimization.

Responsibilities

• Consult with users to identify current business operating procedures and clarify program objectives.
• Design, create, test, and document data models that illustrate relationships between tables and other database objects.
• Create and document constraints that ensure integrity of data.
• Design, create, test, and document queries that are efficient with an emphasis on performance.
• Develop stored procedures, views, and functions.
• Diagnose and tune poorly performing queries.
• Implement transactions when appropriate to ensure data integrity.
• Work with analysts, end users, and other developers to analyze and design solutions that meet business objectives.
• Design, create, test, and document SSIS packages for various ETL processes.
• Design, create, test, and document SSRS reports as needed.

Requirements

• 4 Year / Bachelors Degree in Computer Science or a related field, or equivalent education and/or experience.
• Minimum 5 years database development experience in Microsoft SQL 2012 or above.
• 2 Years relevant and progressive professional experience.
• Excellent written and verbal communication skills with an emphasis on confidentiality.
• Exceptional organizational and analytical skills; ability to manage multiple tasks simultaneously.
• Strong experience with data analysis and T-SQL performance tuning.
• Demonstrated experience with database design and analysis.
• Ability to create SQL Server Integration Services packages.
• Knowledge of SQL transactions and how to utilize them appropriately.
• Experience with SQL Server Reporting Services.
• Basic understanding of SQL Database Administration including backups/restores and performance criteria.

Nice-to-haves

• MCSA: SQL Server 2012/2014 or higher certification.
• Power BI Development experience in Reports, Dashboards, and DAX queries.
• Cloud Database experience, including cloud-native SQL solutions.
• SSAS cube and MDX experience.

Benefits

• 401(k) with 6% match
• Dental insurance
• Disability insurance
• Flexible schedule
• Free parking
• Health insurance
• Generous paid time off (PTO)
• 12 paid company holidays
• Company provided long-term disability and life insurance
• Paid Parental Leave
• Volunteer Time Off
• Opportunities for advancement
• Casual dress
• Modern, comfortable office with free parking