What are the responsibilities and job description for the SQL Developer/DBA position at Pantar Solutions inc?
Job Details
Job Description
We are an Information Technology and Business Consulting firm specializing in Project-based Solutions and Professional Staffing Services. Please have a look at below position which is with our Client and let me know your interest ASAP. I would really appreciate if you could send me your MOST RECENT UPDATED RESUME:
SQL Developer/DBA
Location: Charlotte, NC preferred, open to remote (Has to be able to work in EST)
Duration: 6-month contract w/ potential to hire || Need USC or GC only
Plus if you have: C# Development experience or EFCore exposure, Snowflake, AWS Managed Database
Consultant LinkedIn profile must have been created before 2018
Need 8-10 yrs of IT Exp. Profiles
RESPONSIBILITIES
- 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.
- Deep knowledge and experience in SQL Server and T-SQP with respect to troubleshooting and optimizing queries and stored procedures.
- Provide technical mentoring and coaching for junior and mid-level database developers and data quality analysts.
QUALIFICATIONS
- Bachelor's Degree in Computer Science, CIS, or related field (or equivalent work experience in a related field).
- Overall 5 years of enterprise software development experience with specifics in data warehousing or enterprise operational data marts.
- Database: MS SQL Server 2019.
- Working understanding of cloud development principles and software design patterns.
- Experience with CI\CD, Git, and ADO Pipelines
- Strong Experience with Scrum, Agile Process, Unit Testing using Test Driven Development.
- Continuous learner, process improver.
- Excellent time management skills and ability to work on concurrent assignments with different priorities.
- Excellent communications skills and ability to work collaboratively across several teams.
- C# Development experience or EFCore exposure a plus
- Snowflake experience\knowledge a plus
- AWS Managed Database Experience a plus.