"Alerted.org

Job Description

Provide 1st and 2nd Level Database support for in-house solutions and SQL-based production systems. Proactively check the monitoring systems and

resolve alerts, Incidents, requests, and other requests from Senior DBAs.

Analysis and resolution of performance problems (Memory, CPU, Block of tables, queries) using SSMS and monitoring tools.

Create documentation for internal undocumented processes. Maintain up to date the existing documentation to reflect the current best practices

Create/Modify new/existing SSIS packages depending on the requirements and also must be able to understand the complexity of the code and make changes accordingly to get any business issues resolved.

Ensures optimum performance of these database objects and queries by analyzing to be able to find the root cause of the issues.

Collaborates with project teams in all aspects of product evaluations, design review, data requirements and application development projects.

Recommends and evaluates software and hardware solutions.

Manages, supports and tests the application connectivity to the applicable database(s) and deployment of database application code.

Assists developers in the tuning of SQL statements to reduce the response time for users and reduce the resources used

Provides 24/7 on-call support as needed, solutions and guidance for database related application(s) inquiries, requests and problems.

Compensation Range: $50/hr to $55/hr

Exact compensation may vary based on several factors, including skills, experience, and education.

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, 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 Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .

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/ .

Skills and Requirements

Bachelor's degree required in Information Technology, computer Science or related discipline

8+ years or more relevant experience in SQL Server, including versions 2016 and later required

8+ years or more thorough knowledge of SQL and database development/programming experience required

8+ years or more experience with monitoring and diagnostic tools preferred.

8+ years or more T-SQL and database schema design required.

8+ years or more Strong SSIS development skills.

Outstanding communication, problem-solving and analytical skills.

Understands IT Operations, ITIL, CI/CD and agile methodologies required. Microsoft Azure Database Certifications

Advanced SQL Certifications