What are the responsibilities and job description for the SQL DBA position at Rose International?
Job Description
Description
Role: Senior SQL Server DBA
Duration: June 30, 2024
Location: Malden, MA hybrid, 1 day onsite per week
Interview type: Webcam Interview Only
37.50 hours/week
Complete Description:
The Database Administrator / Developer who will be responsible for the coordination and implementation of data analysis needs and activities relating to the design, implementation and maintenance of SQL server databases.
Responsibilities
• 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.
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
- **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**
Role: Senior SQL Server DBA
Duration: June 30, 2024
Location: Malden, MA hybrid, 1 day onsite per week
Interview type: Webcam Interview Only
37.50 hours/week
Complete Description:
The Database Administrator / Developer who will be responsible for the coordination and implementation of data analysis needs and activities relating to the design, implementation and maintenance of SQL server databases.
Responsibilities
• 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.
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
SQL Developer
Accroid Inc -
Boston, MA
Oracle Database Administrator (DBA)
Kforce Inc -
Boston, MA
^Oracle Application DBA
Accenture -
Boston, MA
