Insight Global is looking for a SQL Developer to join one of our top clients on a full time basis. They will under general direction, formulates and defines system scope and objectives. Devises or modifies procedures to solve highly complex problems considering computer equipment capacity and limitations, operating time and form of desired results. Prepares detailed specifications to write programs. Designs, codes, tests, debugs, documents and maintains those programs. Competent to work on and responsible for nearly all phases of applications systems analysis and programming projects. Regularly provides guidance and training to less experienced analysts/programmers.
Essential Functions:
* Collaborate with analysts, designers, and programmers in conceptualizing and development of new software programs, applications and automated test scripts.
* Perform technical tasks, detailed analyses, and interpretation of technical problems requiring expertise and/or specialized knowledge in a systematic manner; apply subject matter expertise unique to the discipline.
* Exhibit expert understanding of the organization's Systems Development Life Cycle.
* Play a leading role in the definition, development, and documentation of software's requirements, objectives, deliverables, and specifications on a project-by-project basis in collaboration with internal users and departments.
* Play a leading role in defining software development project plans, including scoping, scheduling, and implementation.
* Prepare and/or interpret business, functional, and non-functional requirements; create and maintain user-oriented applications and design specifications.
* Develop, test, document and implement applications according to standards and methodologies.
* Assist with the design, development and testing of automation scripts. Follow automated test script guidelines and research issues in software through testing.
* Design, implement and maintain databases. Follow database standards and integrity controls, analyze information requirements, and develop database specifications.
* Develop stored procedures, functions, triggers, and scripts, including complex SQL queries and other database programming activities.
* Design, model, develop, maintain, and deploy complex data models, and integration solutions, using a variety of tools and ETL processes.
* Utilize best practices for ensuring data integrity, performance, and security.
* Understand the business and technical needs and usage scenarios to effectively model, and make use of, an appropriate DB normality.
* Utilize an established understanding of various software development methodologies and design patterns.
* Debug existing solutions when needed.
* Conduct ongoing performance tuning.
* Assist with establishing standards and practices for stored procedure development, testing, performance, and maintenance.
* Work with leadership to support training and documentation efforts.
* Assist with DR activities, back up, and any risk and compliance related activities.
* Plan, coordinate, and implement security measures to safeguard information resources against accidental or unauthorized modification, destruction, or disclosure.
* Design, run and monitor software functional and performance tests on new and existing programs for the purposes of correcting errors, isolating areas for improvement, and general debugging; administer critical analysis of test results and deliver solutions to problem areas.
* Recommend, schedule, and perform software improvements and upgrades.
* Must be on call during scheduled times and may be required to work for extended periods at night and on weekends in support of conversion, assisting in operational problems, or testing a new program.
* Maintain currency of professional, technical and business skills.
* Utilize established status report, time accounting and collaborative process to provide data for management.
* Exhibit expert understanding of application, data, and integration, plus deep understanding of security, operational, and systems management architectural and design domains.
* Meet with decision makers, systems owners, and end users to define business requirements and systems goals, and identify and resolve business systems issues.
* Ensure compatibility and interoperability of systems.
* Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
* Create and describe system design and models utilizing commonly used industry mechanisms like E-R Diagrams, UML models, flow charts, etc.
* Perform cost-benefit and return on investment analysis for proposed systems to aid management in making implementation decisions.
* Direct research on emerging application development software products, languages, and standards in support of procurement and development efforts.
* Liaise with company's software and hardware suppliers for prompt rectification of any problems or emergencies.
* Take an active role in cross-departmental projects when needed.
* Cultivate and disseminate knowledge of application development best practices; Train, mentor, and provide guidance to junior software development staff.
* Oversee the quality assurance of program logic, data processing, and error resolution.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to
HR@insightglobal.com.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:
https://insightglobal.com/workforce-privacy-policy/ .