Senior Database Developer (SQL)

Randstad; Saint Petersburg (FL); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading staffing agency is seeking a Senior Database Developer to manage company data infrastructure and assets in Saint Petersburg, Florida. The role involves planning, designing, and implementing complex data interfaces, as well as developing ETL processes using SQL Server. Candidates should have over 5 years of experience in database development, advanced skills in SQL tuning, and familiarity with business intelligence tools. Ideal applicants will have a Bachelor's degree in a related field and strong technical background.

Qualifications

• 5+ years of experience in a database developer role.
• Advanced SQL development and tuning skills.
• Exposure to business intelligence tools.

Responsibilities

• Manage company data infrastructure and assets.
• Lead the planning, design, and implementation of complex data interfaces.
• Develop enterprise level ETL processes including data validation.

Skills

SQL Server management

ETL processes using SSIS

SQL coding

Performance tuning

Data integrity checks

Education

Bachelor's degree in a related field

Technical coursework in Computer Science

Tools

Microsoft SQL Server 2014 or above

SSIS

SSRS

SSAS

Job description

Direct Hire Opportunity - No Sponsorship's

Job Description

Job Summary: The Senior Database Developer will be responsible for managing company data infrastructure and assets. In this role, the Senior Database Developer leads the planning, design and implementation of complex data interfaces, transformations, and OLTP and OLAP databases. The individual has a strong technical background and substantial experience in managing and administering Microsoft SQL Server infrastructure. The individual will have a deep understanding of database architecture, performance, security, and integrity, data access and table maintenance, developing and administering ETL processes using SSIS and other tools, SQL coding and performance tuning, and proactive monitoring and alerting. The individual will also have experience utilizing and interpreting data models, developing reporting, data marts, analytic cubes, and visualization.

Qualifications

Job Duties:

• Model, develop, and implement transactional, ETL staging, and analysis/reporting databases, data structures, and cubes to satisfy business and technical requirements.
• Develop enterprise level ETL processes that include process logging, data validation, and data integrity checks.
• Automate complex processes using SQL agent jobs, SQL Server Integration Services, etc.
• Ensure accuracy and integrity of data through the development of constraints and validation rules.
• Implement database performance monitoring and tuning.
• Manage SQL code in a source control system.
• Establish and enforce SQL development coding standards and best practices. Lead/participate in SQL code reviews.
• Stay current with database/reporting/Microsoft SQL Server tools and technologies and the direction of the general database industry as a whole.
• Provide technical mentoring and coaching for junior and mid-level database developers and data quality analysts.
• Must read, be familiar, and be compliant with Meridian’s Information Security Manual, as well as additional e-mails, policies, procedures and directives that comprise the overall Information Security policies as they are distributed.
• Additional duties as assigned.

Education, Experience & Knowledge:

• Education: Bachelor’s degree in a related field required. In some cases, substantial, relevant experience may be substituted for this qualification.
• Technical coursework in Computer Science or related field desired.
• Experience/Knowledge: SQL Server 2014 or above, SSIS, SSRS, SSAS.
• Advanced level at modeling both OLTP and OLAP databases.
• Advanced level at developing ETL processes and packages.
• Advanced SQL development and tuning skills.
• Exposure to business intelligence tools.
• Familiarity with RedGate data tools a plus.
• 5 or more years’ experience in a database developer role.

Additional Information

Equal Opportunity Employer. All your information will be kept confidential according to EEO guidelines.