Senior SQL Developer Posted Date 16 hours ago(9/20/2024 10:29 AM) Job ID 2024-27253 Category Software Development Location US-Remote About DMI

DMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migration and application development, DMI provides on-site and remote support to clients within governments, healthcare, financial services, transportation, manufacturing, and other critical infrastructure sectors. DMI has grown to over 2,100+ employees globally and has been continually recognized as a Top Workplace in both regional and national categories.

About the Opportunity

DMI, LLC is seeking a Senior SQL Developer to support a Federal Government customer in the DC metro area. This Senior SQL Developer will provide support for an enterprise web-based system.

 

Duties and Responsibilities:

Support the analysis of requirements, design specifications, development, and technical and user documentation of report development through direct interaction with internal and external customers.Develop complex SQL scripts, Stored Procedures, Triggers, Functions, and Views.Troubleshoot a custom web-based application based on customer needs and be responsible for rapid responses to customer requests Perform day-to-day Tier 3 data analysis, and SQL, TSQL, script execution (Inserts, Updates, Deletes).Experience in creating Jobs, Alerts, SQL Mail agents, and schedule DTS/SSIS Packages.Design, implement, and periodically test the database backup and recovery procedures. Perform minimal database administration activities including backup and maintenance of the databases in multiple environmentsMigrating data from various data formats into SQL Server databases using automated import processes (DTS and SSIS packages, etc.).Develops, imports to, and extracts from existing SQL databases.Work with the development team to coordinate the creation and management of reporting structures.Perform activities to help understand business objectives, assumptions, and constraints related to a question/problem where ad-hoc reports can serve as a solution. Support the development, optimization, and enhancement of the SSRS report.Work closely with business analysts and source data experts to develop data requirements.Exceptional knowledge of various tools to troubleshoot issues. SQL Server Profiler, Index Tuning, query executing plans, optimization, statistics, etc. Qualifications

Education and Years of Experience:  

Bachelors in Comp Science or equivalent with a minimum of 86+ experienceHands-on experience in reports development with SQL Server

 

Required and Desired Skills/Certifications: 

Strong Structured Query Language (SQL) skillsFluent in MDX and T-SQL programming language, including stored procedures and user-defined functionsStrong analytical, quantitative, problem solving, and organizational skills; attention to detail; and ability to coordinate multiple tasks, set priorities, and meet deadlines.Seek a self-starter who can work effectively as a member of a team or independently as the assignment requires. Excellent interpersonal skills and a successful track record of collaboration toward achieving objectives expected.Demonstrated ability to perform complex queries, assess data quality, and develop data mappings.Excellent customer service-focused approach in working with internal and external customers

 

Min Citizenship Status Required: Min H1-B

 

Physical Requirements: No Physical requirement needed for this position.

Location: Remote, US

 #LI-SM3

Working at DMI

DMI is a diverse, prosperous, and rewarding place to work. Being part of the DMI family means we care about your wellbeing. We offer a variety of perks and benefits that help meet various interests and needs, while still having the opportunity to work directly with several of our award-winning, Fortune 1000 clients. The following categories make up your DMI wellbeing:

Convenience/Concierge - Virtual visits through health insurance, pet insurance, commuter benefits, discount tickets for movies, travel, and many other items to provide convenience.Development – Annual performance management, continuing education, and tuition assistance, internal job opportunities along with career enrichment and advancement to help each employee with their professional and personal development.Financial – Generous 401k matches both pre-tax and post-tax (ROTH) contributions along with financial wellness education, EAP, Life Insurance and Disability help provide financial stability for each DMI employee.Recognition – Great achievements do not go unnoticed by DMI through Annual Awards ceremony, service anniversaries, peer-to-peer acknowledgment, employee referral bonuses.Wellness – Healthcare benefits, Wellness programs, Flu Shots, Biometric screenings, and several other wellness options.

Employees are valued for their talents and contributions. We all take pride in helping our customers achieve their goals, which in turn contributes to the overall success of the company. The company does and will take affirmative action to employ and advance in employment individuals with disabilities and protected veterans, and to treat qualified individuals without discrimination based on their physical or mental disability or veteran status. DMI is an Equal Opportunity Employer Minority/Female/Veterans/Disability. DMI maintains a drug-free workplace.

 

***************** No Agencies Please *****************

 

Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.

Connect With Us! Not ready to apply? Connect with us for general consideration.