Lead Database Developer - SQL

Lead Database Developer - SQL

Posted 1 day ago by 1759828913

Apply
Negotiable
Outside
Remote
USA
Apply
Cloud Computing Cloud Technology Computer Science Conditional Formatting Database Design Data Extraction Data Integrity Data Mapping Data Migration Data Warehousing Digital Transformation Extract Transform Load (ETL) File Servers Indexing Information Technology Information Technology Consulting Managed Services Mapping Software Microsoft Azure Microsoft SQL Servers Query Optimisation Relational Database Design Relational Databases Requirements Elicitation Software Development SQL (Programming Language) SQL Server Management Studio Stakeholder Management

Summary: The Lead Database Developer - SQL role involves overseeing data migration projects, including requirements gathering, data mapping, extraction, loading, testing, and troubleshooting. The position requires extensive experience in SQL Server and related technologies, with a focus on optimizing performance and ensuring data integrity. Candidates with local experience in NYC or NJ, particularly in government or education sectors, are preferred. This is a remote position for a duration of over 22 months.

Key Responsibilities:

  • Requirements gathering for data migration projects.
  • Creating data maps outlining relationships between source and target systems.
  • Extracting and preparing data for migration.
  • Loading data into the target system and ensuring proper formatting.
  • Testing migrated data for accuracy and completeness.
  • Troubleshooting issues during the migration process.
  • Documenting the data migration process and results.
  • Optimizing performance of the data migration process.

Key Skills:

  • BS or MS in Computer Science, Information Technology, or related field.
  • 12+ years of experience with database development using SQL Server.
  • Proficiency in SQL Server, T-SQL, query optimization, and relational database design.
  • Understanding of SQL Server features for scalable database solutions.
  • Experience with SQL Replication, Azure SQL Database, and ETL tools.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Role: Lead Database Developer - SQL
NYC 100% Remote
Duration: 22+ Months
Notes: Local to NYC, NJ and government experience (Federal, state, city) will highly preferred.
About Us:
PruTech Solutions is a global technology services organization dedicated to delivering innovative, high-quality solutions in IT consulting, software development, cloud transformation, and managed services. We partner with clients across industries to deliver measurable business outcomes and empower their digital transformation journey.

Role and Responsibilities:

  • Requirements gathering: The data migration developer must work with stakeholders to understand the requirements of the data migration project, including the data that needs to be migrated, the format of the data, and the desired outcome.
  • Data mapping: The developer must create a data map that outlines the relationships between the data in the source and target systems and defines how the data will be transformed and migrated from one system to the other.
  • Data extraction: The developer must extract the data from the source system and prepare it for migration to the target system. This may involve cleaning and transforming the data, as well as handling any data conflicts.
  • Data loading: The developer must load the data into the target system and ensure that the data is properly formatted and integrated with the target system.
  • Data testing: The developer must test the data to ensure that it has been accurately and completely migrated, and that it meets the requirements of the project.
  • Troubleshooting: The developer must resolve any issues that arise during the data migration process, such as data errors or performance issues.
  • Documentation: The developer must document the data migration process, including the data mapping, data extraction and loading processes, and the results of testing and troubleshooting.
  • Performance optimization: The developer must ensure that the data migration process is optimized for performance, and that the target system is able to handle the volume of data being migrated. This may involve optimizing SQL queries or implementing indexing and caching to improve performance.

Skill Sets:
Required
  • BS or MS in Computer Science, Information Technology, or related field
  • Should have hands 12 + years of experience with database development using SQL Server
  • SQL Server, T-SQL, query optimization tools and techniques, data modelling techniques, and relational database design
  • Good understanding of the features available in SQL Server to achieve a scalable database solution.
  • Various database development technologies, such as SQL Server, SQL Replication, Azure SQL Database, Azure Data Warehouse, including SSMS, SSRS, SSIS / or ETL tools, and OLTP/OLAP features.
Nice to Have
  • New York city area (NYC, New Jersey, Conn)
  • Government experience (Federal, state, city)
  • Education experience building applications for higher ed or department of education.

EEOE Clause:
PruTech Solutions is an Equal Opportunity Employer (EEOE). All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.
Apply
Similar Jobs
Loading data...