Direct Hire Opportunity - No Sponsorship's
Job DescriptionJob 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.
- 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
Equal Opportunity Employer. All your information will be kept confidential according to EEO guidelines.
Skills Required
- Bachelor's degree in a related field (or equivalent experience)
- 5+ years' experience in a database developer role
- Microsoft SQL Server 2014 or above
- Advanced T-SQL / SQL development and performance tuning
- Experience designing and modeling OLTP and OLAP databases
- Advanced ETL development and SSIS package development
- Experience with SSRS (reporting) and SSAS (analytics/cubes)
- Experience automating processes using SQL Server Agent and job scheduling
- Experience managing SQL code in a source control system and enforcing coding standards
- Familiarity/exposure to business intelligence tools
- Familiarity with RedGate data tools
- Compliance with company Information Security policies
What We Do
Randstad is a global leader in the HR services industry and a Dutch multinational human resource consulting firm. Founded in 1960 and headquartered in Diemen, Netherlands, it provides outsourcing, staffing, consulting, and workforce solutions. The company connects job seekers with employers across various sectors, including finance, technology, healthcare, and manufacturing, helping people secure rewarding jobs and stay relevant in the ever-changing world of work.
