Deloitte Database Engineer Manager in Mechanicsburg, Pennsylvania

Deloitte is one of the leading professional services organizations in the United States, specializing in audit, tax, consulting and financial advisory services with clients in more than 20 industries. We provide powerful business solutions to some of the world s most well-known and respected companies, including more than 75 percent of the Fortune 100.At Deloitte, you can have a rewarding career on every level. In addition to challenging and meaningful work, you ll have the chance to give back to your community, make a positive impact on the environment, participate in a range of diversity and inclusion initiatives, and find the support, coaching, and training it takes to advance your career. Our commitment to individual choice lets you customize aspects of your career path, your educational opportunities and your benefits. And our culture of innovation means your ideas on how to improve our business and your clients will be heard.

JobTitle:DatabaseEngineer Manager

Location:Mechanicsburg, PA

Overview

Deloitteisoneof theleadingprofessionalservicesorganizationsintheUnitedStates,specializinginaudit,tax,consulting,andfinancialadvisoryserviceswithclientsinmorethan20industries.Weprovidepowerfulbusinesssolutionstosomeof theworldsmostwell-knownandrespectedcompanies,includingmorethan75percentoftheFortune100.

AtDeloitte,inadditiontochallengingandmeaningfulwork,youllhavethechancetogivebacktoyourcommunityandmakeapositiveimpactonyourpeers.Ourcommitmenttoindividualchoiceletsyoucustomize aspectsofyourdevelopment.Finally,ourcultureofinnovationmeansyourideasonhowtoimproveourbusinessandyourclientswillbeheard.

Visitwww.deloitte.com/us/careerstolearnmoreaboutourculture,benefitsandopportunities.

DeloitteConsultingLLPisoneof theworldsleadingmanagementconsultingfirmsforexecutablestrategy,operations,technology,andhumancapitaladvisoryservices.Theconsultingpracticeisbuiltaroundintegratedcorecapabilitiespeople,processandtechnologyandindustryexpertisethecapabilitiesneededtohelpourclientstotackletheirmostcomplexchallenges.

SolutionManager,DeloitteConsultingLLP

Ifyou'reinterestedinworkingonmission-criticalsolutions,thenjoiningDeloitteConsultingasaSolutionManagercouldbeyourmostrewardingmove.Theroleprovidesyoutheopportunitytosharpenyour technical,analyticalandbusinessskillswhileworkingasapartofateamcommittedtodeliveringexcellentserviceforclientsaroundtheglobe.Youwilllearnnewskillsthatareindemandbyourclients,gainexpertiseinDeloittesmethodologiesandcontributetoincreasinglycomplexduties.

Inconjunctionwithour otherdeliverycentersaroundtheworld,weofferdevelopmentandsustainmentservicesforourclients,bothpreandpost-implementation.Ourcontinuedgrowthhascreatedtheneedforapplicationdevelopmentandmanagementprofessionalstoprovideservicesinsupportof ourclientssystemsandbusinessprocesses.Successfulcandidateswilldemonstrateboththeirabilitytoworkindependentlyandexperiencemakingdecisionstocompleteassignedresponsibilitiesfromcenterleadership.Weareseekingexceptionalcandidateswhohavethecommitmenttojoinaworld-classclientdeliveryorganizationthatisapartofoneof theworld'spremierconsultingfirms.

Illustrative responsibilities include:

DatabaseDesign

Work closely with Application Architects todesign database structures that properly model related business entities andrelationships, providing operational flexibility and efficient query handling. Designtables, determining the proper amount of referential integrity andnormalization. Designthe database infrastructure solution for high-availability for OLTP databaseand other databases as required. Workclosely with Development and Cloud Services teams to architect a completePostgreSQL solution meeting the business requirements. Exhaustivelyreview current architecture and work closely with internal development team toensure DB design is optimal and implement any changes required. Drivingproactive monitoring/alerting through creation and implementation of moresophisticated tools. EnsureOracle and Microsoft SQL Server databases are operational 24x7 in multipleenvironments. Authorbest practices documentation for other Database Administrators. Administrationof Oracle 11g and 12c databases running on Linux servers and Microsoft SQLServer including, but not limited to backup and restore, database monitoring,database tuning, database cloning and replication, and database patching. Linuxand Windows system administration tasks to support and troubleshoot systemoperations. Workwith various vendor technical support as required. ProvideSQL and technical support (syntax, trace, tuning, etc.) for developmentteammates. Periodicallyprovide 24x7 on-call technical support for mission-critical applications.

SQLsupport

Providehelp to optimized SQL code to support development. Conduct PostgreSQL coding sessions forapplication developers. Rewriteand tune poorly performing SQL code to improve system performance by studyingexecution plans and optimizing the capabilities of the DBMS. Ensurethat all new database code meets company standards for readability, reliabilityand performance Developdatabase solutions by designing proposed system; defining database strategy,architecture, physical structure and functional capabilities Maintaindatabase documentation and relationship diagrams. Whenperformance issues arise, determine the most effective way to increaseperformance including server configuration changes and or index/query changes. Contributeto the overall system design and operational design Workwith the architecture team and application developers to design and implementdatabase strategies Workwith Application team to design a plan for archive and purging with huge table,analyze the database growth provide solution Providesupport and lead the business and technology teams in identifying the data flowassociated with the business flow and guides data provisioning and data captureprocess optimization.

Ifyouareinterestedinaposition,pleasecontactus.Toqualifyfor ourSolutionManagerrole,youshouldpossessthefollowing:

REQUIRED 10years experience administering an RDBMS like Oracle, MySQL, or PostgreSQL. Experiencewith high volume database systems and scalability constraints Experiencewith PostGIS, Slony, pg_queue, pg_bouncer Expertisein SQL, stored procedure programming, query performance tuning, and writingcomplex queries. Knowledgeof security techniques to protect data. Knowledge of solutions for andhigh-availability and scalability. Knowledge about administering multipledatabases in a clustered environment. Knowledgein scripting languages and Unix/Linux scripting. Awarenessof NoSQL solutions and when those tools are preferred over RDBMS. Ableto work on projects independently and in a highly collaborative environment. Ableto prioritize and allocate resources effectively. Ableto independently troubleshoot application issues with vendors' technicalsupport. Self-motivatedto learn additional skills outside of DBA duties, supporting variousapplications as a team player. Strongverbal and written communication skills.

PREFERRED

Bachelor's degree, preferably in ManagementInformation Systems, Computer Science, Software Engineering,or related IT discipline Experience with data visualization tools. Experiencein requirements gathering, documentation, and reporting. Experiencedesigning and implementing solutions using NoSQL technologies. Experiencewith shared and/or distributed databases. Experiencewith row-based encryption approaches. Experienceworking in an Agile environment Experiencewith Openstack environments Demonstrategreat analytic skill. Strongcommunication skills, both written and oral Excellentteamwork and interpersonal skills Typicallyhas 10 or more years consulting and/or industry experience Abilityto manage engagements of greater than average size and complexity Abilityto manage and lead multiple teams and multiple clients with confidence Aptitudefor trouble-shooting and problem-solving Strongtechnical skills including understanding of software development principles Hands-onprogramming experience Abilityto travel up to 15 percent U.S.Citizenship preferred, but not required Abilityand willingness to acquire U.S. Security Clearance preferred, but not required

About Deloitte

As used in this document, Deloitte means Deloitte LLP and its subsidiaries. Please see www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. 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.

Disclaimer: If you are not reviewing this job posting on our Careers site (careers.deloitte.com) or one of our approved job boards we cannot guarantee the validity of this posting. For a list of our current postings, please visit us at careers.deloitte.com.

Category: Management Consulting