Kyyba
SQL Server DBA
Kyyba, Malden, Massachusetts, us, 02148
Job Description
Data warehouse: Design, build, and implement data warehouse environment Performance Tuning: Review monitoring tools and query execution plans to maintain or increase query efficiency. Also perform root cause analysis on query performance issues Logical database design: Leverage knowledge of database architecture to develop normalized database solutions Database development: Work with application developers to deliver data through the design of stored procedures, functions, and views Work with advanced features of SQL Server 2019 Upgrading older version to supported versions of SQL Server Create database queries, indexes, and stored procedures, some with high level complexity Design complex physical and logical data models Monitoring and troubleshooting SQL jobs, and integration service packages Writing and creating data load scripts and stored procedures; ensuring that data is loaded in a timely manner Working with application developers in the design, tuning, and indexing of tables Requirements
4-7 years of experience with SQL server 2008, 2012, 2014 and 2016, 2017, and 2019 Experience with SSRS, SSIS, and T-SQL Experience working in a VMware environment Sound knowledge of the firewall, networks and Servers Must demonstrate experience managing the set up and upgrades of complex databases, including interfacing with source control in order to generate creation, upgrade, and maintenance scripts Experience creating and optimizing database queries, indexes, stored procedures, functions, triggers, and reports Experience with database planning and design, set-up, maintenance, performance tuning, and partitioning Proficient production support skills with the ability to understand the impact of a problem on overall DB performance. Strong DB management skills incorporating backup and recovery best practices in a high-availability environment. Efficient SQL scripting skills. Working knowledge of Windows O/S systems administration tasks. Ability to work well with customers of varying levels of technical expertise.
About Kyyba: Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence delivering high-quality resources and top-notch recruiting services, enabling businesses to effectively respond to organizational changes and technological advances. At Kyyba, the overall well-being of our employees and their families is important to us. We are proud of our work culture which embodies our core values; incorporating value, passion, excellence, empowerment, and happiness, creates a vibrant and productive atmosphere. We empower our employees with the resources, incentives, and flexibility that they need to support a healthy, balanced, and fulfilling career by providing many valuable benefits and a balanced compensation structure combined with career development. Disclaimer: Kyyba is an Equal Opportunity Employer. Kyyba does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. Minorities / Females / Protected Veterans / Individuals with Disabilities are encouraged to apply. All employment is decided on the basis of qualifications, merit, and business need. Rewards: Medical, dental, vision 401k Term life Voluntary life and disability insurance Optional Pre-paid legal plan Optional Identity theft plan Optional Medical and dependent FSA Work-visa sponsorship Opportunity for advancement Long-term assignment with opportunity for hire by client
SELECT AWARDS
An INC 5000 company for 10 years Corp! Michigan Economic Bright Spots Crain's Detroit Business Top Staffing Service Companies in Detroit TechServe Alliance Excellence Award- IT and Engineering Staffing & Solutions Best of MichBusiness winner in HR Wizards & Partnerships Metro Detroit Elite Category: Recruitment, Selection & Orientation for 101 Best & Brightest 101 Best & Brightest Companies to Work for in Michigan
Data warehouse: Design, build, and implement data warehouse environment Performance Tuning: Review monitoring tools and query execution plans to maintain or increase query efficiency. Also perform root cause analysis on query performance issues Logical database design: Leverage knowledge of database architecture to develop normalized database solutions Database development: Work with application developers to deliver data through the design of stored procedures, functions, and views Work with advanced features of SQL Server 2019 Upgrading older version to supported versions of SQL Server Create database queries, indexes, and stored procedures, some with high level complexity Design complex physical and logical data models Monitoring and troubleshooting SQL jobs, and integration service packages Writing and creating data load scripts and stored procedures; ensuring that data is loaded in a timely manner Working with application developers in the design, tuning, and indexing of tables Requirements
4-7 years of experience with SQL server 2008, 2012, 2014 and 2016, 2017, and 2019 Experience with SSRS, SSIS, and T-SQL Experience working in a VMware environment Sound knowledge of the firewall, networks and Servers Must demonstrate experience managing the set up and upgrades of complex databases, including interfacing with source control in order to generate creation, upgrade, and maintenance scripts Experience creating and optimizing database queries, indexes, stored procedures, functions, triggers, and reports Experience with database planning and design, set-up, maintenance, performance tuning, and partitioning Proficient production support skills with the ability to understand the impact of a problem on overall DB performance. Strong DB management skills incorporating backup and recovery best practices in a high-availability environment. Efficient SQL scripting skills. Working knowledge of Windows O/S systems administration tasks. Ability to work well with customers of varying levels of technical expertise.
About Kyyba: Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence delivering high-quality resources and top-notch recruiting services, enabling businesses to effectively respond to organizational changes and technological advances. At Kyyba, the overall well-being of our employees and their families is important to us. We are proud of our work culture which embodies our core values; incorporating value, passion, excellence, empowerment, and happiness, creates a vibrant and productive atmosphere. We empower our employees with the resources, incentives, and flexibility that they need to support a healthy, balanced, and fulfilling career by providing many valuable benefits and a balanced compensation structure combined with career development. Disclaimer: Kyyba is an Equal Opportunity Employer. Kyyba does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. Minorities / Females / Protected Veterans / Individuals with Disabilities are encouraged to apply. All employment is decided on the basis of qualifications, merit, and business need. Rewards: Medical, dental, vision 401k Term life Voluntary life and disability insurance Optional Pre-paid legal plan Optional Identity theft plan Optional Medical and dependent FSA Work-visa sponsorship Opportunity for advancement Long-term assignment with opportunity for hire by client
SELECT AWARDS
An INC 5000 company for 10 years Corp! Michigan Economic Bright Spots Crain's Detroit Business Top Staffing Service Companies in Detroit TechServe Alliance Excellence Award- IT and Engineering Staffing & Solutions Best of MichBusiness winner in HR Wizards & Partnerships Metro Detroit Elite Category: Recruitment, Selection & Orientation for 101 Best & Brightest 101 Best & Brightest Companies to Work for in Michigan