What are the responsibilities and job description for the C2C Job in USA - Senior SQL Developer - Trenton, New Jersey (Hybrid) position at Analytics Solutions?
Job Details
Job Role - Senior SQL Developer
Location - Trenton, New Jersey (Hybrid 3 Days Onsite Compulsory Per Week)
Worksite address: 55 N. Willow St, Trenton, NJ 08618
*OLTP experience needed, Oracle nice to have
Contract C2C Job
Job Description
We are looking for a SQL Developer to maintain, enhance, design, and administer data dictionaries, as well as physical and logical database models. This position will be full-time and hybrid in Trenton, NJ
What You'll Do
- Maintains, enhances, designs, and administers data dictionaries, as well as physical and logical database models
- Collaborate with different teams both inside and outside of the department to understand and assimilate data
- Design and develop secure data lake systems, migrate data on MS SQL platforms, understand and interpret Oracle scripts, build scalable and secure systems
What You'll Need
Required:
- Strong experience with ETL and migrations, predominantly with MS SQL Server, with some Oracle background
- Familiarity with cloud platforms, particularly Azure and data migration on-prem to cloud Very strong scripting skills necessary.
- Ability to design and develop secure data lake systems, migrate data on MS SQL platforms, understand and interpret Oracle scripts, build scalable and secure systems
- Understanding of legacy architecture, system dependencies and data relationships is key
- Ability to work with disparate teams infrastructure, DBAs, cybersecurity and outside agencies like SSA
- Excellent communication skills written and spoken
- 7 years team management experience
- 7 years of experience with SQL Server 2016 and above
- 7 years T-SQL, Stored Procedures experience
- 7 years DB Troubleshooting, performance and tuning experience
- Oracle Database design in the past.