At Shire, we are proud and grateful to employ military veterans and thank them for their contributions to our company and our country. See where your military experience can play a role at Shire by using our military skills translator job search tool below:
Job Family :
Software Development & Support (Digital)
Travel Required :
None
Clearance Required :
Ability to Obtain Public Trust
What You Will Do :
You will be a part of an application development team, creating database objects, writing T-SQL, ETL, SSIS, SSRS, SSAS tooling, and other products as necessary.
There is a data warehouse and other large databases where data sometimes needs to be moved to support application needs and you will support this . Other times there are smaller application databases which will also need your support.
You will supports performance tuning and helps maintain index and the overall health of the objects in the database.
Develop operations and maintenance support documentation for the SQL Server database.
Fully embrace DevOps culture, eliminate barriers and bridge moats
Monitor and troubleshoot database reliability and performance issues
Develop documentation that overviews the automated data loading processes and procedures
This is a fast-paced environment where troubleshooting and working in a team environment is vital. Using your previous experience and open to thinking outside of the box is important in this environment.
Mentor and coach less experienced developers.
What You Will Need :
BA/ BS Degree. Degree can be substituted with 4 additional years of experience.
4-6 of experience with T-SQL, SSIS, SSRS, SSAS.
Experience with Microsoft SQL Server
Ability to work with a development team to support all database operations and ETL for applications as well as back-office processes.
Experience with Performance tuning of ETL processes with large volumes of data
Proven experience in troubleshooting existing processes
Demonstrated experience prioritizing work and closing out tickets in a timely manner
Deep understanding and experience with Continuous Integration Continuous Delivery
SQL Server database experience and migration.
Experience with Disaster Recovery
Be able to set up High Availability clusters
Ability to manage multiple tasks with varying priorities.
Ability to communicate ideas in a variety of formats.
Experience in Agile development methodology.
Must be a US Citizen or Green card holder and pass govt background investigation.
Strong written and oral communication skills
What Would Be Nice To Have:
Government or large organization experience
Experience in working with Scrum is a plus
Experience with Liquibase and other cloud database tools
The annual salary range for this position is $95,800.00-$143,800.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.
What We Offer:
Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
Benefits include:
Medical, Rx, Dental & Vision Insurance
Personal and Family Sick Time & Company Paid Holidays
Parental Leave
401(k) Retirement Plan
Group Term Life and Travel Assistance
Voluntary Life and AD&D Insurance
Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
Transit and Parking Commuter Benefits
Short-Term & Long-Term Disability
Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
Employee Referral Program
Corporate Sponsored Events & Community Outreach
Care.com annual membership
Employee Assistance Program
Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
Position may be eligible for a discretionary variable incentive bonus
About Guidehouse
Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation.
Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.
If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.
Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.