IT Database Administrator Manager
PricewaterhouseCoopers is the world's largest professional services organization with over 150,000 people in more than 150 countries. We are committed to attracting and retaining the very best human resource assets possible - one of our 'six forces' shaping the future of business.Travel Required: 0-20%Description:
The IT Database Administrator Manager works on problems requiring analysis.
He/she applies comprehensive functional knowledge in problem resolution.
Actively contributes to the development of new methods, procedures, processes
or systems and understand the impact of these changes. Leads functions and/or
projects based on experience and knowledge. May be responsible for decisions
impacting a team and may provide input into the decision making process for
larger decisions. Proposes and defines solutions and standards which may
impact a team or the organization. May supervise/manage staff, a function,
sub-function or area within a large office(s), region/cluster.Primary responsibilities of this role may include:Provide Production & Development Database Administration (DBA) support for
applications and projects. (Oracle, SQL Server)
Adhering to all PwC, US IT and team standards (configuration, security, etc.),
policies (change management, etc.) & procedures as documented in KCurve2,
direct communications, the team file share, etc. These include but are not
limited to change management, independence, established work hours, out of
office, dress code, time & expense reporting, and status (KARE) reporting.
Consistently completing administrative tasks (T&E, KARE Reports, etc.) on-time
and without need for Supervisor follow up.
Installing & upgrading database software.
Performing evaluations of potential tools & utilities.
Automating database tasks via scripting or through the use of tools.
Updating, migrating, and refreshing database environments.
Configuring monitoring and proactively reviewing statistics for errors,
capacity and performance issues.
Tuning and troubleshooting software & database performance issues.
Ensuring database recoverability within the constraints of any application,
project and other requirements.
Providing input to and/or producing metrics reports.
Responding quickly to requests; even if only acknowledging receipt, providing
an estimated time frame and/or gathering additional information.
Participating in Disaster Recovery (DR) planning and testing.
Producing and/or updating documentation and Standard Operating Procedures
(SOPs).
Providing input regarding database standards and best practices for PwC.
Advocating the upgrade of database products to the latest PwC standard versions.
Performing multiple tasks and adjusting to changing priorities and deadlines.
Negotiating deadlines with customers and keeping them informed of changes to
manage their expectations.
Working collaboratively with the project team and involving management only
when necessary.
Informing management of current or projected issues concerning times when
workload might jeopardize the ability to meet deadlines or adversely impact
effectiveness. Working with management and project teams to re-prioritize,
reassign or otherwise address these situations.
Informing management of current or projected periods of time when workload
allows for additional projects, training, time off, etc. Working with
management to determine the most effective use of available time.
Arranging coverage of primary responsibilities during times out of the office.
Developing positive relationships with clients, peers, management, etc.
Taking advantage of opportunities to work with fellow team members to develop
innovative solutions within existing standards.
Openly sharing knowledge, skills and insights with fellow team members and
others.
Seeking out Subject Matter Experts (SMEs) when faced with technical challenges
in order to benefit from their experiences.
Monitoring and performance tuning
Recommend upgrades to software and hardware as it relates to the server and the
client
Installation of patches and enhancements to both clients and servers
Participate in beta testing of new releases
Manage application environment files
Create /maintain system documentationAdditionally, for projects the following is expected:Attending project meetings and/or make sure other team members do.
Tracking current and upcoming tasks and deadlines; being aware of project
initiatives in order to plan as far in advance as possible.
Keeping management informed about all aspects of the project (issues, concerns,
etc.). Identifying and documenting issues/concerns with options (pros & cons)
to project teams.
Keeping other DBAs informed about all aspects of the project so they can
provide fundamental support without notice or additional turnover.
Being aware of project goals and direction, even if they are not
database-related or technical in nature.
Being responsible for writing, coordinating and/or "owning" documentation and
procedures written by the team for a specific initiative.
Planing and designing database architectures.
Daily monitoring of application environment
Performing corrective actions for which you have primary responsibility.
Response to alerts for which you have primary responsibility.
On call support of application environment for have primary responsibility.
Arranging of support of primary responsibilities during times out of the
office.
Completion of all change requests within time frame indicated for environments
you have primary responsibility.
Enforcement of standards on the server you have primary responsibility.
Application availability goal is 100%Education and Other Typical Requirements
Four year degree in any business/ technical area or equivalent experience is
preferred and four plus years relevant work experience. Productivity, initiative, professionalism, customer service attitude, attention to detail and quality, ability to multitask, team focus, strong
interpersonal skills, strong verbal and written communication skills and
adherence to firm and US IT standard operating procedures. Ability to adapt to a rapidly changing environment. Strong skills utilizing Lotus Notes databases and Microsoft Office Suite. Understanding of technology/software relevant to team. Must be willing to work overtime as necessary for day-to-day operations and occasional weekend or after-hours coverage. May be required to carry cell
phone, pager or blackberry. Commitment to professional growth; seeks opportunities for development; expected to share knowledge with others. Ability to develop work approach and project plans to meet client requirements, manage and monitor progress of plan. Familiarity or experience with Project Management skills
REQUIREMENTS
Education Requirement:
Four year degree in any business/ technical area or equivalent experience is
preferredEssential Requirements:
Unique Aspects of the Position, Specialized Knowledge or Skills
Experience working in an Oracle database environment
Prior experience working in a Unix environment
Experience working in an Oracle environment with latest or recent versions of
database software
Experience working in a Unix (Sun Solaris) Server environment
Very familiar with SQL and writing custom scripts to automate tasks
Solid understanding of database backup and recovery strategies
Solid understanding of database performance tuning strategies
Ability to manage several medium to large projects concurrently
Very good interpersonal and team skills
Very good written and oral communication skills
Experience with the following may be required depending on the role: Unix shell or Windows scripting ASP
|