What are the responsibilities and job description for the Senior SQL DBA position at Insight Global?
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
Implement and support high availability of databases
Provide and manage SQL Database user access (add, revoke, modify).
Ensures optimum performance of these database objects and queries.
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 rotation support, solutions and guidance for database related application(s) inquiries, requests and problems.
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 : .
Skills and Requirements
Bachelor's degree required in Information Technology, computer Science or related discipline
10 years or more relevant experience in SQL Server, including versions 2012 and later required
10 years or more thorough knowledge of SQL and database development / programming experience required
7 years or more experience with monitoring and diagnostic tools preferred.
5 years or more T-SQL and database schema design required.
Strong SSIS development skills
Outstanding problem-solving and analytical skills.
Demonstrates knowledge of technology concepts for hybrid-cloud, virtualization, server, storage and backup technologies.
Understands IT Operations, ITIL, CI / CD and agile methodologies beginner required. Microsoft Azure Database Certifications
Advanced SQL Certifications null
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 employment opportunity / affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to 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 oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and / or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.
