Deloitte Senior Data Base Administrator in Pittsburgh, Pennsylvania
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 RequirementsTravel 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.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.