Are you an experienced, passionate pioneer in technology - a solutions builder, a roll-up-your-sleeves technologist who wants a daily collaborative environment, think-tank feel and share new ideas with your colleagues - without the extensive demands of travel? If so, consider an opportunity with our US Delivery Center - we are breaking the mold of a typical Delivery Center.
Our US Delivery Centers have been growing since 2014 with significant, continued growth on the horizon. Interested? Read more about our opportunity below ...
Work you will do/Responsibilities
Support MS SQL database management activities including improving database quality and scripts while developing and deploying DB scripts for data quality, stability, and security systems to support maintenance activities that meet or exceed SLAs. Candidate must have proven expertise skills working with SQL Server Database performance, integrity, and security, our ideal candidate will develop innovative SQL solutions.
Our Systems Engineering team delivers large-scale software applications and integrated systems, and assists clients with architecture design, assessment and optimization, and definition. We develop service-oriented architecture (SOA) and other integration solutions to enable information sharing and management between business partners and disparate processes and systems, and we deliver technology enablement to support CIO services transformation.
Systems Engineering professionals focus on key client issues that impact the core business by maximizing operational value, driving down the cost of quality, and enhancing technology innovation. Our teams deliver a wide range of services, including application architecture design and optimization, application modernization, business process management and solution integration, custom application design and development, and large-scale technology delivery program efforts.
Support the project team with ad-hoc query generation and analysis
Support the PM with project/task scoping by analyzing the client requirements, coming up with approach, tasks, and level of effort
7+ years' experience with native SQL Server tools
Experience in Complex and high-volume data warehouse projects. Experience in AWS RDS Aurora PostgreSQL, Redshift and Oracle Database engines are preferred. Experience with DB2 LUW is a plus.
Experience in database conversion projects and experience in migrating & data conversion using AWS SCT & DMS.
7 Years of experience in working as DBA and 1 years in PostgreSQL preferred.
Analysis of complex Health Information technology, reports and system processes
Support the implementation of large scale System, Web Portal and integration of sub-systems
Support and responding to complex issues impacting the Design Development Implementation (DDI) Team, in the layout, design, and reporting.
Experienced troubleshooting performance and database issues
Experienced with Performance Tuning and Query Optimization
4+ years of experience designing and developing documentation on database designs (i.e., stored procedures, configuration files, tables, views, and functions)
Hands on experience developing small presentations/training and be involved in all aspects of data administration
Execute user/security management
Complete physical/logical database schema and object design; Develop new tables, views, triggers and indexes to support a complex data model and ensure optimal database performance
Document system configuration
Create and document standard operating procedures as pertains to DB maintenance
Create functions and stored procedures to provide custom functionality as per the requirements
CompTIA Security+ certification
Travel up to 10% annually
Travel Requirements Travel up to 20% annually (While 20% of travel is a requirement of the role, due to COVID-19, non-essential travel has been suspended until further notice.)
Limited immigration sponsorship may be available.
Internal Number: 15748136
At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there’s always room to learn. We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast-changing business world. From on-the-job learning experiences to formal development programs at Deloitte University, our professionals have a variety of opportunities to continue to grow throughout their career. At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits.Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture where our people excel and lead healthy, happy lives. Deloitte is led by a purpose: to make an impact that matters. This purpose... defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you’re applying to.