SQL DEVELOPER

---

POSTING DATE                          :  04-28-2025

POSITION                                      :  SQL Developer

                                                                  Full-time job, 40 hours per week

PAY/SALARY                                : $108,000.00 year

NUMBER OF  OPENINGS    : 1

LOCATION                                     : Inventech Solutions LLC

                                                                  7651 Eldorado Pkwy, Ste 100K

                                                                  McKinney, TX 75070

JOB DUTIES

• Work on Agile methodology by attending sprint planning, retrospective and backlog

grooming meetings along with other teammates.

• Interact with business team and discuss about the functional specifications, high level

requirements and user stories.

• Communicate with architects and other developers to design and develop new

functionalities considering the existing project limitations and performance requirements.

• Perform full system life cycle management activities like analysis, technical requirements,

design, coding, testing and implementation of system and application software.

• Work closely with Product owners to build innovative technologies that are customized to

drive the business and provide ultimate customer experience.

• Design data models and database schemas based on the requirements and develop

appropriate dataflows and data dependencies and ensure stability, reliability, and

performance.

• Compose and execute Mongo DB scripts to insert and update NoSQL database, automating

data changes and reporting.

• Create, maintain, and optimize database objects like indexes, triggers, views, stored

procedures, catalogs, etc.

• Develop both OLTP and data warehousing data models (Kimball environment).

• Refactor existing database objects to support enhancements of system control, diagnostic

and other research subject areas.

• Monitor errors, locks, deadlocks, and other resource utilization, and resolve issues in a

timely manner.

• Design, develop, and implement MS SQL Server SSIS ETL jobs to effectively process

high-volume data sources and meet nightly processing windows.

• Develop and manage Enterprise Data Warehouse/Data Lake processes and policies,

following strategic direction on best practices for holistic Data Architecture.

• Investigate and support new technology initiatives to improve or enhance current database

capabilities and create documentation for database applications and ETL processing.

• Perform integration, initializing, populating, synchronizing, cleansing, mapping, and

transforming bulk data migration on large scale projects with more than 50 million records.

• Work on integration methodologies including HL7, XML, EDI, SFTP, web services, ETL,

SSIS, data warehousing principals and interface engine platforms.

EDUCATION  

Bachelor’s  degree in Computer Science/ IT/IS/Engineering (Any) or closely related field with Five (5) years of experience in the job offered or as an IT Consultant or Analyst or Programmer or Developer or related field.

EXPERIENCE                    

Experience of Five (5) years as SQL Developer or similar role is required.